'error', 'message' => 'Database connection failed: ' . mysqli_connect_error()]));
}
// Process only POST requests
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
// Validate required fields
if (empty($_POST['id']) || empty($_POST['title']) || empty($_POST['color'])) {
echo json_encode(["status" => "error", "message" => "Missing required fields."]);
exit;
}
$event_id = intval($_POST['id']); // Ensure ID is an integer
$title = trim($_POST['title']);
$color = trim($_POST['color']);
$dropped = isset($_POST['dropped']) ? intval($_POST['dropped']) : 0; // Default to 0 if not set
// Prepare SQL statement
$stmt = $mysqli->prepare("UPDATE Events SET Title=?, Color=?, dropped=? WHERE Events_ID=?");
if (!$stmt) {
echo json_encode(["status" => "error", "message" => "SQL Error: " . $mysqli->error]);
exit;
}
$stmt->bind_param("ssii", $title, $color, $dropped, $event_id);
// Execute and check result
if ($stmt->execute()) {
echo json_encode(["status" => "success", "message" => "Event updated successfully"]);
} else {
echo json_encode(["status" => "error", "message" => "Failed to update event: " . $stmt->error]);
}
$stmt->close();
}
$mysqli->close(); // Close database connection
?>