<?php
include("connection.php");

// Enable error reporting for development
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

// Get ID from URL
if (isset($_GET['id'])) {
    $id = $_GET['id'];

    // Fetch the record first to get image name (if any)
    $sql = "SELECT * FROM `package` WHERE `id` = '$id'";
    $query = mysqli_query($con, $sql);

    if ($query && mysqli_num_rows($query) > 0) {
        $row = mysqli_fetch_assoc($query);

        

        // Now delete the record from DB
        $sql1 = "DELETE FROM `package` WHERE `id` = '$id'";
        $query1 = mysqli_query($con, $sql1);

        if ($query1) {
            header("Location: viewpackages.php");
            exit();
        } else {
            echo "Failed to delete record: " . mysqli_error($con);
        }
    } else {
        echo "Record not found.";
    }
} else {
    echo "Invalid request. ID is missing.";
}
