✏ 编辑: delete_book.php

<?php
require_once __DIR__ . '/../../db_config.php';
$conn = getDBConnection();

// Check if ID is provided
if (!isset($_GET['id']) || empty($_GET['id'])) {
    header("Location: AddBook.php");
    exit;
}

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

// Get book details including image name
$stmt = $conn->prepare("SELECT book_image FROM books WHERE id = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    
    // Clean image path and delete file
    $imagePath = str_replace('images/books/', '', $row['book_image']);
    $file = __DIR__ . '/../../images/books/' . $imagePath;
    
    if (file_exists($file)) {
        unlink($file);
    }
    
    // Delete record from database
    $stmt->close();
    $deleteStmt = $conn->prepare("DELETE FROM books WHERE id = ?");
    $deleteStmt->bind_param("i", $id);
    $deleteStmt->execute();
    $deleteStmt->close();
} else {
    $stmt->close();
}

$conn->close();

// Redirect back to book listing page
header("Location: AddBook.php");
exit;
?>

[X] 取消