'error', 'message' => 'Database connection failed: ' . mysqli_connect_error()]));
}
// PHP to fetch events from the database
$query = "SELECT id,title,description,start,end,color FROM Events";
$result = $mysqli->query($query);
$events = [];
if ($result) {
while ($row = $result->fetch_assoc()) {
$events[] = array(
'id' => $row['id'],
'title' => $row['title'],
'description' => $row['description'],
'start' => $row['start'],
'end' => $row['end'],
'color' => $row['color']
);
}
var_dump($events); // Before echoing JSON
echo json_encode($events);
} else {
echo json_encode(['status' => 'error', 'message' => 'Query failed: ' . $mysqli->error]);
}
?>