FM / admin

/var/www/vhosts/m-auto.co/httpdocs/admin/

/var/www/vhosts/m-auto.co/httpdocs/admin

Name	Size	Mode	Actions
assets/	-	0755	rm
includes/	-	0755	rm
7-6-2026.zip	10206	0644	edit dl rm
about_edit.php	3899	0644	edit dl rm
about_process.php	1367	0644	edit dl rm
auth.php	684	0644	edit dl rm
bookings.php	5367	0644	edit dl rm
booking_delete.php	924	0644	edit dl rm
branches.php	2470	0644	edit dl rm
branch_delete.php	1290	0644	edit dl rm
branch_form.php	4694	0644	edit dl rm
branch_process.php	1233	0644	edit dl rm
brands.php	2578	0644	edit dl rm
brand_delete.php	1327	0644	edit dl rm
brand_form.php	2369	0644	edit dl rm
brand_process.php	1660	0644	edit dl rm
cars.php	6946	0644	edit dl rm
car_delete.php	2886	0644	edit dl rm
car_form.php	40348	0644	edit dl rm
car_image_actions.php	5142	0644	edit dl rm
car_process.php	10426	0644	edit dl rm
categories.php	2167	0644	edit dl rm
category_delete.php	746	0644	edit dl rm
category_form.php	1607	0644	edit dl rm
category_process.php	943	0644	edit dl rm
dashboard.php	4965	0644	edit dl rm
index.php	2713	0644	edit dl rm
login_process.php	1532	0644	edit dl rm
logout.php	100	0644	edit dl rm
news.php	3448	0644	edit dl rm
news_delete.php	771	0644	edit dl rm
news_form.php	6769	0644	edit dl rm
news_process.php	2527	0644	edit dl rm
offers.php	2810	0644	edit dl rm
offer_delete.php	1327	0644	edit dl rm
offer_form.php	4573	0644	edit dl rm
offer_process.php	2115	0644	edit dl rm
settings.php	5217	0644	edit dl rm
settings_process.php	692	0644	edit dl rm
slider.php	3529	0644	edit dl rm
slider_delete.php	1345	0644	edit dl rm
slider_form.php	4529	0644	edit dl rm
slider_process.php	1983	0644	edit dl rm
themes.php	4703	0644	edit dl rm
theme_delete.php	1332	0644	edit dl rm
theme_form.php	1522	0644	edit dl rm
theme_process.php	1785	0644	edit dl rm
users.php	4480	0644	edit dl rm
user_delete.php	1055	0644	edit dl rm
user_form.php	5463	0644	edit dl rm
user_process.php	3193	0644	edit dl rm
videos.php	4942	0644	edit dl rm
video_delete.php	1717	0644	edit dl rm
video_form.php	7181	0644	edit dl rm
video_process.php	3336	0644	edit dl rm

Edit: /var/www/vhosts/m-auto.co/httpdocs/admin/car_delete.php (2886B)

<?php
include 'auth.php';
require_permission('cars_delete');
include '../includes/db.php';

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

// First, get all images for this car to delete the files from server
    $stmt_select = $conn->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();
}
?>

cmd: