<?php
session_start();
include "dbconnect.php"; // Database connection

// Check if expense id is provided for deletion
if (isset($_GET['id'])) {
    $expense_id = $_GET['id'];

    // Prepare the SQL query to delete the expense
    $sql_delete = "DELETE FROM expenses WHERE id = ?";
    if ($stmt = $con->prepare($sql_delete)) {
        $stmt->bind_param("i", $expense_id);
        if ($stmt->execute()) {
            $_SESSION['message'] = "Expense deleted successfully!";
        } else {
            $_SESSION['error'] = "Failed to delete expense.";
        }
        $stmt->close();
    }
} else {
    $_SESSION['error'] = "No expense ID provided for deletion.";
}

header("Location: expenses_page.php"); // Redirect to the expenses page
exit();
?>
