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: edit-expense.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');
// Database connection
include 'includes/db.php';

// Fetch expense ID from query string
$expense_id = isset($_GET['id']) ? intval($_GET['id']) : 0;

if ($expense_id == 0) {
    echo "<script>alert('Invalid expense ID.'); window.location.href='expenses.php';</script>";
    exit;
}

// Fetch expense details
$sql = "SELECT remark, amount, expense_date, category FROM expenses WHERE id = $expense_id";
$result = mysqli_query($conn, $sql);

if (!$result || mysqli_num_rows($result) == 0) {
    echo "<script>alert('Expense not found.'); window.location.href='expenses.php';</script>";
    exit;
}

$expense = mysqli_fetch_assoc($result);

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $remark = isset($_POST['remark']) ? mysqli_real_escape_string($conn, $_POST['remark']) : '';
    $amount = isset($_POST['amount']) ? floatval($_POST['amount']) : 0;
    $expense_date = isset($_POST['expense_date']) ? $_POST['expense_date'] : '';
    $category = isset($_POST['category']) ? mysqli_real_escape_string($conn, $_POST['category']) : '';

// Validate inputs
    if ($amount <= 0 || empty($expense_date) || empty($category)) {
        echo "<script>alert('Amount, Date, and Category are required.'); window.location.href='edit-expense.php?id=$expense_id';</script>";
        exit;
    }

// Validate category
    $valid_categories = ['Office Supplies', 'Travel', 'Utilities', 'Marketing', 'Miscellaneous'];
    if (!in_array($category, $valid_categories)) {
        echo "<script>alert('Invalid category selected.'); window.location.href='edit-expense.php?id=$expense_id';</script>";
        exit;
    }

// Update expense
    $sql = "UPDATE expenses SET remark = '$remark', amount = '$amount', expense_date = '$expense_date', category = '$category' WHERE id = $expense_id";
    if (mysqli_query($conn, $sql)) {
        echo "<script>alert('Expense updated successfully.'); window.location.href='expenses.php';</script>";
    } else {
        echo "<script>alert('Error updating expense: " . mysqli_error($conn) . "'); window.location.href='edit-expense.php?id=$expense_id';</script>";
    }
}

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>

<div class="page-wrapper">
            
            <div class="page-content">
                <div class="container-fluid">
                    
                    <?php
                    $page_title = "Edit Expense";
                    $breadcrumb_active = "Edit Expense";
                    ?>
                    <div class="row">
                        <div class="col-sm-12">
                            <div class="page-title-box d-md-flex justify-content-md-between align-items-center">
                                <h4 class="page-title"><?php echo $page_title; ?></h4>
                                <div class="">
                                    <ol class="breadcrumb mb-0">
                                        <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                                        <li class="breadcrumb-item"><a href="expenses.php">Expenses</a></li>
                                        <li class="breadcrumb-item active"><?php echo $breadcrumb_active; ?></li>
                                    </ol>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-header d-flex align-items-center justify-content-between">
                                    <h6 class="card-title mb-0" style="font-weight: bold; font-size: 1.1rem; color: #333;">Edit Expense (EXP-<?php echo $expense_id; ?>)</h6>
                                    <a href="expenses.php" class="btn btn-sm btn-primary">Back to Expenses</a>
                                </div>
                                <div class="card-body">
                                    <form id="expenseForm" action="edit-expense.php?id=<?php echo $expense_id; ?>" method="post" novalidate>
                                        <div class="row g-3">
                                            
                                            <div class="col-md-6">
                                                <label for="remark" class="form-label" style="font-weight: bold; font-size: 1rem;">Remark <span class="text-muted">(optional)</span></label>
                                                <textarea class="form-control" id="remark" name="remark" rows="2" placeholder="e.g., Office Supplies Purchase"><?php echo htmlspecialchars($expense['remark']); ?></textarea>
                                            </div>

<div class="col-md-3">
                                                <label for="amount" class="form-label" style="font-weight: bold; font-size: 1rem;">Amount (₹) <span class="text-danger">*</span></label>
                                                <input type="number" class="form-control" id="amount" name="amount" min="0" step="0.01" value="<?php echo $expense['amount']; ?>" required>
                                                <div class="invalid-feedback">Please enter a valid amount.</div>
                                            </div>

<div class="col-md-3">
                                                <label for="expense_date" class="form-label" style="font-weight: bold; font-size: 1rem;">Date <span class="text-danger">*</span></label>
                                                <input type="date" class="form-control" id="expense_date" name="expense_date" value="<?php echo $expense['expense_date']; ?>" required>
                                                <div class="invalid-feedback">Please select a valid date.</div>
                                            </div>

<div class="col-md-6">
                                                <label for="category" class="form-label" style="font-weight: bold; font-size: 1rem;">Category <span class="text-danger">*</span></label>
                                                <select class="form-control" id="category" name="category" required>
                                                    <option value="" disabled>Select a category</option>
                                                    <option value="Office Supplies" <?php echo $expense['category'] == 'Office Supplies' ? 'selected' : ''; ?>>Office Supplies</option>
                                                    <option value="Travel" <?php echo $expense['category'] == 'Travel' ? 'selected' : ''; ?>>Travel</option>
                                                    <option value="Utilities" <?php echo $expense['category'] == 'Utilities' ? 'selected' : ''; ?>>Utilities</option>
                                                    <option value="Marketing" <?php echo $expense['category'] == 'Marketing' ? 'selected' : ''; ?>>Marketing</option>
                                                    <option value="Miscellaneous" <?php echo $expense['category'] == 'Miscellaneous' ? 'selected' : ''; ?>>Miscellaneous</option>
                                                </select>
                                                <div class="invalid-feedback">Please select a category.</div>
                                            </div>

<div class="col-12 pt-2">
                                                <button type="submit" class="btn btn-primary">Update Expense</button>
                                                <a href="expenses.php" class="btn btn-light">Cancel</a>
                                            </div>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>

</div>

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

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: edit-expense.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation