📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/remindyourdata.live/admin/edit_expense.php
<?php session_start(); include "dbconnect.php"; // Check if ID is provided for editing if (isset($_GET['id'])) { $expense_id = $_GET['id']; // Fetch the expense details from the database $sql = "SELECT * FROM expenses WHERE id = ?"; if ($stmt = $con->prepare($sql)) { $stmt->bind_param("i", $expense_id); $stmt->execute(); $result = $stmt->get_result(); $expense = $result->fetch_assoc(); } } else { $_SESSION['error'] = "No expense ID provided for editing."; header("Location: expenses_page.php"); exit(); } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1" /> <title>Edit Expense</title> <!-- Bootstrap CSS --> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet" /> <!-- Bootstrap Icons --> <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.css" rel="stylesheet" /> <style> body { font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; min-height: 100vh; margin: 0; background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); color: #333; } .container { max-width: 520px; background: #fff; margin: 60px auto 40px; padding: 30px 25px; border-radius: 15px; box-shadow: 0 8px 25px rgba(0,0,0,0.15); } h3 { color: #764ba2; font-weight: 700; margin-bottom: 30px; text-align: center; } .form-label { font-weight: 600; color: #4a3c84; } .input-group-text { background-color: #764ba2; color: #fff; border: none; border-top-left-radius: 5px; border-bottom-left-radius: 5px; font-size: 1.2rem; } .form-control { border-radius: 0 5px 5px 0; border: 1px solid #ccc; transition: border-color 0.3s ease, box-shadow 0.3s ease; } .form-control:focus { border-color: #764ba2; box-shadow: 0 0 8px #764ba2; outline: none; } select.form-select { border-radius: 0 5px 5px 0; border: 1px solid #ccc; transition: border-color 0.3s ease, box-shadow 0.3s ease; } select.form-select:focus { border-color: #764ba2; box-shadow: 0 0 8px #764ba2; outline: none; } .btn-primary { background-color: #764ba2; border-color: #764ba2; border-radius: 8px; font-weight: 700; display: flex; align-items: center; justify-content: center; gap: 8px; padding: 12px 0; width: 100%; font-size: 1.1rem; transition: background-color 0.3s ease; } .btn-primary:hover { background-color: #5e379d; border-color: #5e379d; } .alert-danger { background-color: #f8d7da; color: #721c24; border-radius: 10px; padding: 12px 15px; margin-bottom: 20px; text-align: center; font-weight: 600; box-shadow: 0 2px 6px rgba(0,0,0,0.1); display: flex; align-items: center; justify-content: center; gap: 10px; } /* Logout button */ .logout-btn { position: fixed; top: 20px; right: 20px; background-color: #d90429; color: white; padding: 10px 20px; border-radius: 8px; font-weight: 600; text-decoration: none; box-shadow: 0 3px 8px rgba(0,0,0,0.3); transition: background-color 0.3s ease; display: flex; align-items: center; gap: 6px; z-index: 1050; } .logout-btn:hover { background-color: #b1031f; text-decoration: none; color: white; } /* Responsive */ @media (max-width: 575.98px) { .container { margin: 40px 15px 30px; padding: 25px 20px; } h3 { font-size: 1.5rem; } .logout-btn { top: 10px; right: 10px; padding: 8px 14px; font-size: 0.9rem; } } </style> </head> <body> <!-- Logout Button --> <a href="logout.php" class="logout-btn" title="Logout"> <i class="bi bi-box-arrow-right"></i> Logout </a> <div class="container"> <h3><i class="bi bi-pencil-square"></i> Edit Expense</h3> <?php if (isset($_SESSION['error'])): ?> <div class="alert alert-danger"> <i class="bi bi-exclamation-triangle-fill"></i> <?= htmlspecialchars($_SESSION['error']) ?> <?php unset($_SESSION['error']); ?> </div> <?php endif; ?> <form method="POST" action="update_expense.php" novalidate> <input type="hidden" name="expense_id" value="<?= htmlspecialchars($expense['id']) ?>" /> <!-- Expense Category --> <label for="expense_category" class="form-label">Expense Category</label> <div class="input-group mb-3"> <span class="input-group-text"><i class="bi bi-tags-fill"></i></span> <select class="form-select" id="expense_category" name="expense_category" required> <option value="" disabled>Select Category</option> <option value="office_rent" <?= ($expense['expense_category'] == 'office_rent') ? 'selected' : '' ?>>Office Rent</option> <option value="employee_salaries" <?= ($expense['expense_category'] == 'employee_salaries') ? 'selected' : '' ?>>Employee Salaries</option> <option value="utilities" <?= ($expense['expense_category'] == 'utilities') ? 'selected' : '' ?>>Utilities</option> <option value="office_supplies" <?= ($expense['expense_category'] == 'office_supplies') ? 'selected' : '' ?>>Office Supplies</option> <option value="software_subscriptions" <?= ($expense['expense_category'] == 'software_subscriptions') ? 'selected' : '' ?>>Software/Subscriptions</option> <option value="miscellaneous" <?= ($expense['expense_category'] == 'miscellaneous') ? 'selected' : '' ?>>Miscellaneous</option> <option value="other" <?= ($expense['expense_category'] == 'other') ? 'selected' : '' ?>>Other</option> </select> <div class="invalid-feedback"> Please select a category. </div> </div> <!-- Amount --> <label for="amount" class="form-label">Amount (₹)</label> <div class="input-group mb-3"> <span class="input-group-text"><i class="bi bi-currency-rupee"></i></span> <input type="number" class="form-control" id="amount" name="amount" min="0.01" step="0.01" value="<?= htmlspecialchars($expense['amount']) ?>" required placeholder="Enter amount" /> <div class="invalid-feedback"> Please enter a valid amount. </div> </div> <!-- Date --> <label for="date" class="form-label">Date</label> <div class="input-group mb-3"> <span class="input-group-text"><i class="bi bi-calendar-event-fill"></i></span> <input type="date" class="form-control" id="date" name="date" value="<?= htmlspecialchars($expense['date']) ?>" required /> <div class="invalid-feedback"> Please select a date. </div> </div> <!-- Description --> <label for="description" class="form-label">Description</label> <div class="input-group mb-4"> <span class="input-group-text align-items-start pt-2"><i class="bi bi-card-text"></i></span> <textarea class="form-control" id="description" name="description" rows="3" required placeholder="Enter description"><?= htmlspecialchars($expense['description']) ?></textarea> <div class="invalid-feedback"> Please enter a description. </div> </div> <button type="submit" class="btn btn-primary" aria-label="Update Expense"> <i class="bi bi-check-lg"></i> Update Expense </button> </form> </div> <!-- Bootstrap Bundle JS --> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script> <!-- Bootstrap form validation script --> <script> (() => { 'use strict' const forms = document.querySelectorAll('form') Array.from(forms).forEach(form => { form.addEventListener('submit', event => { if (!form.checkValidity()) { event.preventDefault() event.stopPropagation() } form.classList.add('was-validated') }, false) }) })() </script> </body> </html>
Save
Cancel