<?php
include_once('config.php');

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

// Fetch existing images
$existing_images_query = "SELECT `img1`, `img2` FROM `tbl_services` WHERE sr_id = $id";
$existing_images_result = $db->query($existing_images_query);
$existing_images_row = $existing_images_result->fetch_assoc();
    
        $image_fields = ['img1', 'img2'];
        foreach ($image_fields as $image_field) {
            if (!empty($existing_images_row[$image_field])) {
                $file_path = 'images/' . $existing_images_row[$image_field];
                if (file_exists($file_path)) {
                    unlink($file_path);
                }
            }
        }
        
        // Delete the record from the database
        $causeQuery = "DELETE FROM `tbl_services` WHERE sr_id = $id";
        $causeResult = mysqli_query($db, $causeQuery);
        
        if ($causeResult) {
            header('location: manage-property.php');
            exit;
        } else {
            echo "Failed to delete the record from tbl_services.";
        }
?>