<?php
require_once 'dbconnect.php';  
$con = $con; // DB connection

// Check valid ID
if (!isset($_GET['id'])) {
    die("Invalid Request!");
}

$id = $_GET['id'];

// Fetch record to delete image file
$stmt = $con->prepare("SELECT filename FROM images WHERE id = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
$data = $stmt->get_result()->fetch_assoc();

if (!$data) {
    die("Record Not Found!");
}

$filename = $data['filename'];

// Delete image file
if (file_exists("uploads/" . $filename)) {
    unlink("uploads/" . $filename);
}

// Delete database row
$del = $con->prepare("DELETE FROM images WHERE id = ?");
$del->bind_param("i", $id);

if ($del->execute()) {
    echo "<script>alert('Deleted Successfully!'); window.location='demouploaddisplay.php';</script>";
} else {
    echo "<script>alert('Error deleting record!');</script>";
}

?>
