<?php
include("connection.php");

// Check if id is passed
if (!isset($_GET['id']) || empty($_GET['id'])) {
    header("Location: viewblog.php");
    exit();
}

$id = (int)$_GET['id'];

// 1. Get blog row to know image name
$sql  = "SELECT `Image` FROM `blog` WHERE `id` = $id";
$query = mysqli_query($con, $sql);

if (!$query || mysqli_num_rows($query) == 0) {
    // No record found
    header("Location: viewblog.php");
    exit();
}

$row = mysqli_fetch_assoc($query);
$imageName = $row['Image'];

// 2. Delete image file if exists
$imagePath = "./assets/images/blog/" . $imageName;
if (!empty($imageName) && file_exists($imagePath)) {
    @unlink($imagePath); // @ to avoid warnings if already deleted
}

// 3. Delete row from database
$deleteSql = "DELETE FROM `blog` WHERE `id` = $id";
$deleteQuery = mysqli_query($con, $deleteSql);

if ($deleteQuery) {
    header("Location: viewblog.php");
    exit();
} else {
    echo "Error deleting blog: " . mysqli_error($con);
}
?>
