<?php
// Database connection
$host = "localhost";
$username = "root";
$password = "";
$dbname = "job_portal";

$conn = new mysqli($host, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Validate ID
$id = isset($_GET['id']) ? (int)$_GET['id'] : 0;
if ($id <= 0) {
    die("❌ Invalid ID.");
}

// Delete query
$sql = "DELETE FROM memberships WHERE id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $id);

if ($stmt->execute()) {
    echo "<script>
            alert('✅ Record deleted successfully!');
            window.location.href = 'display.php';
          </script>";
} else {
    echo "❌ Error deleting record: " . $stmt->error;
}

$stmt->close();
$conn->close();
?>
