📁 File Manager
Editing:
/home/wvl7mof7402e/www/remindyourdata.live/emply/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.0"> <title>Edit Expense</title> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css"> <style> body { font-family: 'Arial', sans-serif; background-color: #f4f7fc; color: #333; } .container { margin-top: 50px; background-color: #ffffff; padding: 30px; border-radius: 8px; box-shadow: 0 4px 10px rgba(0, 0, 0, 0.1); } h3 { color: #4e73df; margin-bottom: 20px; text-align: center; } .form-group label { font-weight: bold; color: #333; } .form-control { border-radius: 8px; border: 1px solid #ccc; transition: border-color 0.3s ease; } .form-control:focus { border-color: #4e73df; box-shadow: 0 0 0 0.2rem rgba(78, 115, 223, 0.25); } .btn-primary { background-color: #4e73df; border-color: #4e73df; border-radius: 8px; padding: 10px 20px; font-weight: bold; } .btn-primary:hover { background-color: #375a8c; border-color: #375a8c; } .alert-danger { background-color: #f8d7da; color: #721c24; border-radius: 5px; padding: 10px; margin-bottom: 20px; } /* Style for Logout Button */ .logout-btn { position: fixed; top: 20px; right: 20px; background-color: #dc3545; color: white; padding: 10px 20px; border-radius: 5px; text-decoration: none; } .logout-btn:hover { background-color: #c82333; } @media (max-width: 576px) { .container { padding: 20px; } h3 { font-size: 1.5rem; } } </style> </head> <body> <!-- Logout Button --> <a href="logout.php" class="logout-btn">Logout</a> <div class="container"> <h3>Edit Expense</h3> <?php if (isset($_SESSION['error'])) { ?> <div class="alert alert-danger"> <?= $_SESSION['error']; ?> <?php unset($_SESSION['error']); ?> </div> <?php } ?> <form method="POST" action="update_expense.php"> <input type="hidden" name="expense_id" value="<?= $expense['id'] ?>"> <div class="form-group mb-3"> <label for="expense_category">Expense Category</label> <select class="form-control" name="expense_category" required> <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> <div class="form-group mb-3"> <label for="amount">Amount (₹)</label> <input type="number" class="form-control" name="amount" value="<?= $expense['amount'] ?>" required> </div> <div class="form-group mb-3"> <label for="date">Date</label> <input type="date" class="form-control" name="date" value="<?= $expense['date'] ?>" required> </div> <div class="form-group mb-3"> <label for="description">Description</label> <textarea class="form-control" name="description" rows="3" required><?= $expense['description'] ?></textarea> </div> <button type="submit" class="btn btn-primary">Update Expense</button> </form> </div> </body> </html>
Save
Cancel