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

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

// Fetch existing images
$existing_images_query = "SELECT `imgage` FROM `tbl_product` WHERE p_id = $id";
$existing_images_result = $db->query($existing_images_query);
$existing_images_row = $existing_images_result->fetch_assoc();
    
        $image_fields = ['imgage'];
        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_product` WHERE p_id = $id";
        $causeResult = mysqli_query($db, $causeQuery);
        
        if ($causeResult) {
            header('location: manage-industries.php');
            exit;
        } else {
            echo "Failed to delete the record from tbl_services.";
        }
?>