delete_resource.php

<?php
session_start();
if (!isset($_SESSION['staff'])) {
    header("Location: staff_login.php");
    exit();
}

if (!isset($_GET['id'])) {
    header("Location: staff_resources.php");
    exit();
}

include 'connection.php';

$id = intval($_GET['id']);

// Get the resource to delete file from server
$sql = "SELECT file_path FROM resources WHERE id = ?";
$stmt = $db->prepare($sql);
$stmt->bind_param("i", $id);
$stmt->execute();
$stmt->bind_result($file_path);
$stmt->fetch();
$stmt->close();

// Delete the file from server if exists
if ($file_path && file_exists($file_path)) {
    unlink($file_path);
}

// Delete the resource record from database
$sql = "DELETE FROM resources WHERE id = ?";
$stmt = $db->prepare($sql);
$stmt->bind_param("i", $id);
$stmt->execute();
$stmt->close();

header("Location: staff_resources.php");
exit();
?>