/var/www/vhosts/m-auto.co/httpdocs/admin
Edit: /var/www/vhosts/m-auto.co/httpdocs/admin/car_delete.php (2886B)
prepare("SELECT image FROM cars WHERE id = ?");
$stmt_select->bind_param("i", $id);
$stmt_select->execute();
$result = $stmt_select->get_result();
if ($result->num_rows === 1) {
$car = $result->fetch_assoc();
$old_image_to_delete = $car['image'];
// Get all images from car_images table
$images_stmt = $conn->prepare("SELECT image_name FROM car_images WHERE car_id = ?");
$images_stmt->bind_param("i", $id);
$images_stmt->execute();
$images_result = $images_stmt->get_result();
$images_to_delete = [];
while ($img = $images_result->fetch_assoc()) {
$images_to_delete[] = $img['image_name'];
}
$images_stmt->close();
// Start transaction
$conn->begin_transaction();
try {
// Delete from car_images table first (due to foreign key constraint)
$delete_images_stmt = $conn->prepare("DELETE FROM car_images WHERE car_id = ?");
$delete_images_stmt->bind_param("i", $id);
$delete_images_stmt->execute();
$delete_images_stmt->close();
// Now, delete the car record
$stmt_delete = $conn->prepare("DELETE FROM cars WHERE id = ?");
$stmt_delete->bind_param("i", $id);
$stmt_delete->execute();
$stmt_delete->close();
// Commit transaction
$conn->commit();
// If DB deletion is successful, delete all image files
// Delete old image if exists
if (!empty($old_image_to_delete) && file_exists('../uploads/cars/' . $old_image_to_delete)) {
unlink('../uploads/cars/' . $old_image_to_delete);
}
// Delete all images from car_images table
foreach ($images_to_delete as $image_name) {
if (file_exists('../uploads/cars/' . $image_name)) {
unlink('../uploads/cars/' . $image_name);
}
}
header("Location: cars.php?success=تم حذف السيارة وجميع صورها بنجاح");
} catch (Exception $e) {
// Rollback transaction on error
$conn->rollback();
header("Location: cars.php?error=حدث خطأ أثناء الحذف: " . $e->getMessage());
}
} else {
header("Location: cars.php?error=لم يتم العثور على السيارة");
}
$stmt_select->close();
$conn->close();
} else {
header("Location: cars.php");
exit();
}
?>