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/venus

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: Expence.php

<?php
// Expence.php
// Updated to use includes/db.php (MySQLi)

session_start();

// Optional: Authentication check
/*
if (!isset($_SESSION['user_id'])) {
    header('Location: login.php');
    exit();
}
*/

// Include DB connection
require_once 'includes/db.php';  // <-- Your db.php with MySQLi connection

// Handle Add Expense
$message = '';
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_expense'])) {
    $title        = trim($_POST['title'] ?? '');
    $amount       = floatval($_POST['amount'] ?? 0);
    $category     = $_POST['category'] ?? 'misc';
    $expense_date = $_POST['expense_date'] ?? date('Y-m-d');
    $notes        = trim($_POST['notes'] ?? '');

$errors = [];
    if (empty($title)) $errors[] = "Expense title is required.";
    if ($amount <= 0) $errors[] = "Valid amount is required.";
    if (empty($expense_date)) $errors[] = "Date is required.";

if (empty($errors)) {
        $title        = mysqli_real_escape_string($conn, $title);
        $category     = mysqli_real_escape_string($conn, $category);
        $expense_date = mysqli_real_escape_string($conn, $expense_date);
        $notes        = mysqli_real_escape_string($conn, $notes);

$sql = "INSERT INTO expenses (title, amount, category, expense_date, notes, created_at)
                VALUES ('$title', $amount, '$category', '$expense_date', '$notes', NOW())";

if (mysqli_query($conn, $sql)) {
            $message = '<div class="alert alert-success">Expense added successfully!</div>';
            $_POST = []; // Clear form
        } else {
            $message = '<div class="alert alert-danger">Error: ' . mysqli_error($conn) . '</div>';
        }
    } else {
        $message = '<div class="alert alert-danger"><ul><li>' . implode('</li><li>', $errors) . '</li></ul></div>';
    }
}

// Fetch all expenses
$sql = "SELECT * FROM expenses ORDER BY expense_date DESC, id DESC";
$result = mysqli_query($conn, $sql);
$expenses = mysqli_fetch_all($result, MYSQLI_ASSOC);

// Calculate totals
$total_result = mysqli_query($conn, "SELECT SUM(amount) as total FROM expenses");
$total_row = mysqli_fetch_assoc($total_result);
$total_expenses = $total_row['total'] ?? 0;

$monthly_sql = "
    SELECT SUM(amount) as monthly_total 
    FROM expenses 
    WHERE MONTH(expense_date) = MONTH(CURRENT_DATE()) 
      AND YEAR(expense_date) = YEAR(CURRENT_DATE())
";
$monthly_result = mysqli_query($conn, $monthly_sql);
$monthly_row = mysqli_fetch_assoc($monthly_result);
$monthly_expenses = $monthly_row['monthly_total'] ?? 0;
?>
<!doctype html>
<html lang="en">
<?php include('includes/head.php')?>
<body data-sidebar="dark">

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">
    <?php include('includes/topbar.php')?>
    
    <div class="vertical-menu">
        <div data-simplebar class="h-100">
            <?php include('includes/sidebar.php')?>
        </div>
    </div>

<div class="main-content">
        <div class="page-content">
            <div class="container-fluid">

<div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                            <h4 class="mb-sm-0 font-size-18">Expense Management</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
                                    <li class="breadcrumb-item active">Expenses</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-md-6 col-xl-3">
                        <div class="card text-center">
                            <div class="card-body">
                                <h3 class="text-danger mt-2">₹<?php echo number_format($total_expenses, 2); ?></h3>
                                <p class="text-muted">Total Expenses</p>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-6 col-xl-3">
                        <div class="card text-center">
                            <div class="card-body">
                                <h3 class="text-warning mt-2">₹<?php echo number_format($monthly_expenses, 2); ?></h3>
                                <p class="text-muted">This Month</p>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-6 col-xl-3">
                        <div class="card text-center">
                            <div class="card-body">
                                <h3 class="text-info mt-2"><?php echo count($expenses); ?></h3>
                                <p class="text-muted">Total Records</p>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-6 col-xl-3">
                        <div class="card text-center">
                            <div class="card-body">
                                <button type="button" class="btn btn-primary waves-effect waves-light" data-bs-toggle="modal" data-bs-target="#addExpenseModal">
                                    <i class="dripicons-plus me-1"></i> Add Expense
                                </button>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Recent Expenses</h4>
                                <?php echo $message; ?>

<div class="table-responsive">
                                    <table class="table table-centered table-nowrap mb-0">
                                        <thead class="table-light">
                                            <tr>
                                                <th>#</th>
                                                <th>Date</th>
                                                <th>Title</th>
                                                <th>Category</th>
                                                <th>Amount</th>
                                                <th>Notes</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php if (empty($expenses)): ?>
                                                <tr>
                                                    <td colspan="7" class="text-center text-muted">No expenses recorded yet.</td>
                                                </tr>
                                            <?php else: ?>
                                                <?php foreach ($expenses as $index => $exp): ?>
                                                    <tr>
                                                        <td><?php echo $index + 1; ?></td>
                                                        <td><?php echo date('d M, Y', strtotime($exp['expense_date'])); ?></td>
                                                        <td><?php echo htmlspecialchars($exp['title']); ?></td>
                                                        <td>
                                                            <span class="badge badge-soft-<?php
                                                                echo $exp['category'] === 'software' ? 'info' :
                                                                     ($exp['category'] === 'marketing' ? 'warning' :
                                                                     ($exp['category'] === 'salary' ? 'primary' :
                                                                     ($exp['category'] === 'office' ? 'secondary' :
                                                                     ($exp['category'] === 'hosting' ? 'success' : 'dark'))));
                                                            ?>">
                                                                <?php echo ucfirst($exp['category']); ?>
                                                            </span>
                                                        </td>
                                                        <td>₹<?php echo number_format($exp['amount'], 2); ?></td>
                                                        <td>
                                                            <small class="text-muted">
                                                                <?php echo $exp['notes'] ? htmlspecialchars(substr($exp['notes'], 0, 50)) . (strlen($exp['notes']) > 50 ? '...' : '') : '-'; ?>
                                                            </small>
                                                        </td>
                                                        <td>
                                                            <a href="Expence.php?delete=<?php echo $exp['id']; ?>" 
                                                               class="btn btn-sm btn-outline-danger waves-effect waves-light"
                                                               onclick="return confirm('Delete this expense? This cannot be undone.');">
                                                                <i class="dripicons-trash"></i>
                                                            </a>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

</div> 
        </div>

<?php include('includes/footer.php')?>
    </div>
    
</div>

<div class="modal fade" id="addExpenseModal" tabindex="-1" aria-labelledby="addExpenseModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <form method="POST">
                <div class="modal-header">
                    <h5 class="modal-title" id="addExpenseModalLabel">Add New Expense</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Expense Title <span class="text-danger">*</span></label>
                                <input type="text" name="title" class="form-control" placeholder="e.g., Adobe Subscription" required>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Amount (₹) <span class="text-danger">*</span></label>
                                <input type="number" step="0.01" name="amount" class="form-control" placeholder="1299.00" required>
                            </div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Category</label>
                                <select name="category" class="form-select">
                                    <option value="software">Software License</option>
                                    <option value="marketing">Marketing & Ads</option>
                                    <option value="salary">Salary</option>
                                    <option value="office">Office Supplies</option>
                                    <option value="hosting">EB Bill</option>
                                    <option value="misc" selected>Miscellaneous</option>
                                </select>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Date <span class="text-danger">*</span></label>
                                <input type="date" name="expense_date" class="form-control" value="<?php echo date('Y-m-d'); ?>" required>
                            </div>
                        </div>
                    </div>

<div class="mb-3">
                        <label class="form-label">Notes (Optional)</label>
                        <textarea name="notes" class="form-control" rows="3" placeholder="Details, invoice number, etc."></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="add_expense" class="btn btn-primary">Save Expense</button>
                </div>
            </form>
        </div>
    </div>
</div>

<?php
if (isset($_GET['delete'])) {
    $id = (int)$_GET['delete'];
    $id = mysqli_real_escape_string($conn, $id);
    $delete_sql = "DELETE FROM expenses WHERE id = '$id'";
    if (mysqli_query($conn, $delete_sql)) {
        header("Location: Expence.php");
        exit();
    } else {
        $message = '<div class="alert alert-danger">Delete failed: ' . mysqli_error($conn) . '</div>';
    }
}
?>

<?php include('includes/rightbar.php')?>

<?php include('includes/scripts.php')?>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Expence.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation