1#@!#!123s

D7net

: / home3 / encodto1 / public_html / encoadminders /

Filename : crud.php

back

<?php

require('config.php');

if (isset($_POST['delete_gallery'])) {
    $id = intval($_POST['gallery_id']);
    $query = "SELECT `image` FROM `gallery` WHERE `gallery_id`=$id";
    $result = mysqli_query($conn, $query);
    $row = mysqli_fetch_assoc($result);
    $filename = $row['image'];

    $delete_query = "DELETE FROM `gallery` WHERE `gallery_id`=$id";

    if (mysqli_query($conn, $delete_query)) {
        $file_path = "uploads/" . $filename;
        if (file_exists($file_path)) {
            unlink($file_path);
        }
        header("Location: gallery.php");
    } else {
        header("Location: gallery.php?alert=delete_failed");
    }
}

?>