File "deletegallerycontroller.php"

Full Path: /home/u593703731/domains/anandinternationalschool.com/public_html/controller/deletegallerycontroller.php
File size: 1.13 KB
MIME-type: text/x-php
Charset: utf-8

<?php
include "../admin/includes/conn.php";

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

    $sql = "SELECT images, medias FROM gallerys WHERE id = $id";
    $res = mysqli_query($conn, $sql);
    if ($res && mysqli_num_rows($res) > 0) {
        $row = mysqli_fetch_assoc($res);

        $images = json_decode($row['images'], true);
        $medias = json_decode($row['medias'], true);

        if ($images) {
            foreach ($images as $img) {
                if (file_exists("assets/uploads/$img")) unlink("assets/uploads/$img");
            }
        }
        if ($medias) {
            foreach ($medias as $media) {
                if (file_exists("assets/uploads/$media")) unlink("assets/uploads/$media");
            }
        }
        $delSql = "DELETE FROM gallerys WHERE id = $id";
        if (mysqli_query($conn, $delSql)) {
           header("Location: ../admin/index.php?page=gallery");
            exit;
        } else {
            echo "Error deleting record: " . mysqli_error($conn);
        }
    } else {
        echo "Record not found!";
    }
} else {
    echo "Invalid ID!";
}
?>