📁 File Manager
Editing:
/home/wedigitalindia/www/jaybalajiassociates.com/admin/deleteblog.php
<?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); } ?>
Save
Cancel