'error', 'message' => 'Database connection failed: ' . mysqli_connect_error()]));
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
// Check for required field 'id'
if (!isset($_POST['id'])) {
echo json_encode(['status' => 'error', 'message' => 'Missing event ID.']);
exit;
}
$id = intval($_POST['id']); // Ensure ID is an integer
if ($id <= 0) {
echo json_encode(['status' => 'error', 'message' => 'Invalid event ID.']);
exit;
}
// Prepared statement to delete event
$stmt = $mysqli->prepare("DELETE FROM School_Calendar WHERE Event_ID=?");
$stmt->bind_param("i", $event_id);
if ($stmt->execute()) {
echo json_encode(["status" => "success", "message" => "Event deleted successfully"]);
} else {
echo json_encode(["status" => "error", "message" => "Failed to delete event"]);
}
$stmt->close();
}
?>