<?php
include_once('config.php');
$id = $_GET['id'];

// Retrieve the image name from the database
$query = "SELECT image FROM tbl_gallery WHERE g_id = '{$id}'";
$result = mysqli_query($db, $query);

if ($result && mysqli_num_rows($result) > 0) {
    $row = mysqli_fetch_assoc($result);
    $image = $row['image'];

    $image_path = 'images/gallery/' . $image;

    if (file_exists($image_path)) {
        unlink($image_path);
    }
}

$causeQuery = "DELETE FROM tbl_gallery WHERE g_id = '{$id}'";
$causeResult = mysqli_query($db, $causeQuery) or die("Query Failed");

if ($causeResult) {
    header('location: manage-gallery.php');
} else {
    echo "Failed to delete.";
}

?>