1#@!#!123s

22527 1#@!#!123s

: / var / www / html / webadmin /

Filename : delete_blog.php

back

<?php
include_once('db.php');

if (isset($_GET['id'])) {
    $id = $_GET['id'];

    // First delete blog banner image if stored on server (optional)
    $stmt = $conn->prepare("SELECT banner FROM blog WHERE id = ?");
    $stmt->execute([$id]);
    $blog = $stmt->fetch(PDO::FETCH_ASSOC);

    if ($blog && file_exists($blog['banner'])) {
        unlink($blog['banner']); // Delete banner image file
    }

    // Delete from database
    $stmt = $conn->prepare("DELETE FROM blog WHERE id = ?");
    $deleted = $stmt->execute([$id]);

    if ($deleted) {
        header("Location: blog.php?msg=deleted"); // replace with your list page
        exit();
    } else {
        echo "Error deleting blog.";
    }
} else {
    echo "Invalid request.";
}
?>