diamond_delete.php

<?php
// diamond_delete.php
include 'config.php';

// Check if user is logged in
if (!isset($_SESSION["loggedin"]) || $_SESSION["loggedin"] !== true) {
    header("location: index.php");
    exit;
}

// Check if ID parameter is set
if (isset($_GET["id"]) && !empty(trim($_GET["id"]))) {
    // Prepare a delete statement
    $sql = "DELETE FROM diamonds WHERE id = ?";

    if ($stmt = $conn->prepare($sql)) {
        $stmt->bind_param("i", $param_id);
        $param_id = trim($_GET["id"]);

        if ($stmt->execute()) {
            // Redirect to landing page on success
            header("location: diamond_master.php");
            exit();
        } else {
            echo "Oops! Something went wrong. Please try again later.";
        }
    }

    $stmt->close();
    $conn->close();
} else {
    // Redirect if ID is missing
    header("location: diamond_master.php");
    exit();
}
?>