deleteProduct.php

<?php
// deleteProduct.php
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Headers: Content-Type, Authorization');
header('Access-Control-Allow-Methods: GET');
header('Content-Type: application/json');
header('Access-Control-Allow-Methods: GET, PUT, POST, DELETE, OPTIONS');


// Handle OPTIONS requests for preflight checks
if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
    http_response_code(200);
    exit();
}

header('Content-Type: application/json');
include 'Conx.php'; // Ensure the correct path to your Conx.php file

// Check if the 'id' parameter exists in the query string and is a valid number
if (isset($_GET['id']) && is_numeric($_GET['id'])) {
    $id = (int) $_GET['id'];

    // Update the status to 1 (inactive) instead of deleting
    $query = "UPDATE products SET status = 1 WHERE id = ?";
    $stmt = $conn->prepare($query);
    $stmt->bind_param('i', $id);
    $stmt->execute();

    if ($stmt->affected_rows > 0) {
        echo json_encode(['success' => true, 'message' => 'Product status updated to inactive.']);
    } else {
        echo json_encode(['success' => false, 'message' => 'Product not found or update failed.']);
    }

    $stmt->close();
} else {
    echo json_encode(['success' => false, 'message' => 'Invalid product ID']);
}

$conn->close();
?>