Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/selvaganapathi

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: manage-finance.php

<?php
// Enable error logging instead of displaying errors
ini_set('display_errors', 0);
ini_set('log_errors', 1);
ini_set('error_log', '/home/u329947844/domains/hifi11.in/public_html/finance/error_log');
// Start session for flash messages and finance_id
session_start();

// Include database connection
include 'includes/db.php';

// Fetch finance records
$sql = "SELECT id, finance_name, description, created_at, pin FROM finance ORDER BY created_at DESC";
$result = mysqli_query($conn, $sql);

// Check for errors in the query
if (!$result) {
    $_SESSION['error'] = "Error fetching data: " . mysqli_error($conn);
    mysqli_close($conn);
    header("Location: manage-finance.php");
    exit;
}

// Store results in an array
$finances = [];
while ($row = mysqli_fetch_assoc($result)) {
    $finances[] = $row;
}
mysqli_free_result($result);

// Close the database connection
mysqli_close($conn);
?>

<!DOCTYPE html>
<html lang="en" dir="ltr" data-startbar="dark" data-bs-theme="light">
<?php include 'includes/head.php'; ?>

<div class="startbar d-print-none">
        <?php include 'includes/leftbar-tab-menu.php'; ?> 
        <?php include 'includes/leftbar.php'; ?>
        <div class="startbar-overlay d-print-none"></div>

<?php if (isset($_SESSION['success'])): ?>
                        <div class="alert alert-success alert-dismissible fade show" role="alert">
                            <strong>Success!</strong> <?php echo $_SESSION['success']; ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                        <?php unset($_SESSION['success']); ?>
                    <?php endif; ?>
                    <?php if (isset($_SESSION['error'])): ?>
                        <div class="alert alert-danger alert-dismissible fade show" role="alert">
                            <strong>Error!</strong> <?php echo $_SESSION['error']; ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                        <?php unset($_SESSION['error']); ?>
                    <?php endif; ?>

<div class="row align-items-center mb-3">
                        <div class="col">
                            <h3 class="mb-0">Manage Finance</h3>
                            <small class="text-muted">Manage and update finance details with ease.</small>
                        </div>
                        <div class="col-auto d-flex gap-2">
                            <a href="add-finance.php" class="btn btn-primary">
                                <i class="iconoir-plus me-1"></i> Add New Finance
                            </a>
                        </div>
                    </div>

<div class="d-block d-lg-none mb-4">
                        <div class="row">
                            <div class="col-6 mb-3">
                                <div class="card bg-primary text-white">
                                    <div class="card-body p-3 text-center">
                                        <h5 class="mb-0"><?php echo count($finances); ?></h5>
                                        <small>Total Finance</small>
                                    </div>
                                </div>
                            </div>
                            <div class="col-6 mb-3">
                                <div class="card bg-success text-white">
                                    <div class="card-body p-3 text-center">
                                        <h5 class="mb-0"><?php echo count($finances); ?></h5>
                                        <small>Active</small>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="d-block d-lg-none">
                        <?php if (empty($finances)): ?>
                            <div class="card">
                                <div class="card-body text-center py-5">
                                    <i class="fas fa-building fa-3x text-muted mb-3"></i>
                                    <h5 class="text-muted">No Finance Found</h5>
                                    <p class="text-muted mb-4">No finance companies have been added yet.</p>
                                    <a href="add-finance.php" class="btn btn-primary">
                                        <i class="iconoir-plus me-1"></i> Add Your First Finance
                                    </a>
                                </div>
                            </div>
                        <?php else: ?>
                            <div class="row">
                                <?php foreach ($finances as $row): ?>
                                    <div class="col-12 mb-3">
                                        <div class="card finance-card">
                                            <div class="card-body">
                                                <div class="d-flex justify-content-between align-items-start mb-2">
                                                    <div>
                                                        <span class="badge bg-primary">FIN-<?php echo $row['id']; ?></span>
                                                    </div>
                                                    <div class="text-end">
                                                        <small class="text-muted">
                                                            <?php 
                                                            $created_date = new DateTime($row['created_at']);
                                                            echo $created_date->format('M j, Y');
                                                            ?>
                                                        </small>
                                                    </div>
                                                </div>
                                                
                                                <h6 class="card-title mb-2 text-primary"><?php echo htmlspecialchars($row['finance_name']); ?></h6>
                                                
                                                <?php if (!empty($row['description']) && $row['description'] !== 'N/A'): ?>
                                                    <p class="card-text small text-muted mb-3">
                                                        <i class="fas fa-info-circle me-1"></i>
                                                        <?php echo htmlspecialchars($row['description']); ?>
                                                    </p>
                                                <?php endif; ?>
                                                
                                                <div class="d-flex justify-content-between align-items-center">
                                                    <small class="text-muted">
                                                        PIN: <?php echo $row['pin'] ? htmlspecialchars($row['pin']) : 'Not set'; ?>
                                                    </small>
                                                    <a href="edit-finance.php?id=<?php echo $row['id']; ?>" class="btn btn-sm btn-primary">
                                                        <i class="las la-edit me-1"></i> Edit
                                                    </a>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                <?php endforeach; ?>
                            </div>
                        <?php endif; ?>
                    </div>

<div class="d-none d-lg-block">
                        <div class="card">
                            <div class="card-header">
                                <h4 class="card-title mb-0">Finance List</h4>
                                <small class="text-muted">Showing <?php echo count($finances); ?> finance companies</small>
                            </div>
                            <div class="card-body">
                                <?php if (empty($finances)): ?>
                                    <div class="alert alert-info" role="alert">
                                        No finance records found.
                                    </div>
                                <?php else: ?>
                                    <div class="table-responsive">
                                        <table id="tblFinance" class="table table-striped table-bordered align-middle w-100">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>#ID</th>
                                                    <th>Finance Name</th>
                                                    <th>Description</th>
                                                    <th>PIN</th>
                                                    <th>Created At</th>
                                                    <th class="text-end">Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php foreach ($finances as $row): ?>
                                                    <tr data-json='{
                                                        "id": <?php echo $row['id']; ?>,
                                                        "finance_name": "<?php echo htmlspecialchars($row['finance_name']); ?>",
                                                        "description": "<?php echo htmlspecialchars($row['description'] ?? ''); ?>",
                                                        "pin": "<?php echo htmlspecialchars($row['pin'] ?? ''); ?>",
                                                        "created_at": "<?php echo $row['created_at']; ?>"
                                                    }'>
                                                        <td><?php echo "FIN-" . $row['id']; ?></td>
                                                        <td><?php echo htmlspecialchars($row['finance_name']); ?></td>
                                                        <td><?php echo htmlspecialchars($row['description'] ?? 'N/A'); ?></td>
                                                        <td><?php echo $row['pin'] ? htmlspecialchars($row['pin']) : 'Not set'; ?></td>
                                                        <td><?php echo $row['created_at']; ?></td>
                                                        <td class="text-end">
                                                            <a href="edit-finance.php?id=<?php echo $row['id']; ?>" class="btn btn-sm btn-soft-primary">
                                                                <i class="las la-edit"></i>
                                                            </a>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>

</div>

<?php include 'includes/rightbar.php'; ?>
                <?php include 'includes/footer.php'; ?>
            </div>
            
        </div>

<?php include 'includes/scripts.php'; ?>

<link rel="stylesheet" href="https://cdn.datatables.net/1.13.8/css/dataTables.bootstrap5.min.css">
        <script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
        <script src="https://cdn.datatables.net/1.13.8/js/jquery.dataTables.min.js"></script>
        <script src="https://cdn.datatables.net/1.13.8/js/dataTables.bootstrap5.min.js"></script>

// Add click handler for mobile cards to show more details if needed
            document.addEventListener('DOMContentLoaded', function() {
                const financeCards = document.querySelectorAll('.finance-card');
                financeCards.forEach(card => {
                    card.addEventListener('click', function(e) {
                        // Prevent navigation if clicking on edit button
                        if (e.target.closest('a')) {
                            return;
                        }
                        // You can add expand/collapse functionality here if needed
                        const financeName = this.querySelector('.card-title').textContent;
                        console.log('Clicked on:', financeName);
                    });
                });
            });
        </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-finance.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation