<?php
// session_start(); // Ensure this is at the top of your file
include('config/db.php');

if (isset($_GET['s_id'])) {
    $s_id = intval($_GET['s_id']);

    // Fetch the current image filename from the database
    $select_service = "SELECT s_image FROM services WHERE s_id = $s_id";
    $select_result = mysqli_query($con, $select_service);
    
    if ($select_result && mysqli_num_rows($select_result) > 0) {
        $select_row = mysqli_fetch_assoc($select_result);
        $image_name = $select_row['s_image'];
        $image_path = "service_image/" . $image_name;

        // Delete the image file if it exists
        if (file_exists($image_path)) {
            unlink($image_path);
        }

        // Delete the record from the database
        $delete_service = "DELETE FROM services WHERE s_id = $s_id";
        $delete_result = mysqli_query($con, $delete_service);

        if ($delete_result) {
            $_SESSION['service_delete'] = "Service deleted successfully!";
        } else {
            $_SESSION['service_delete'] = "Service delete failed!";
        }
    } else {
        $_SESSION['service_delete'] = "Service not found!";
    }

    header('Location: services.php');
    exit;
} else {
    header('Location: services.php');
    exit;
}
?>