<?php
include 'ominterior_db.php';

$id = $_GET['id'];
$query = "SELECT image FROM sub_slider_images WHERE id = $id";
$result = $conn->query($query);
$row = $result->fetch_assoc();

if ($row && !empty($row['image'])) {
    $filePath = "uploads/sub_slider/" . $row['image'];
    if (file_exists($filePath)) {
        unlink($filePath); // delete image file
    }

    // Remove image name from DB
    $conn->query("UPDATE sub_slider_images SET image = '' WHERE id = $id");
}

header("Location: edit-subslider.php?id=$id&img_deleted=1");
exit;
?>