<?php
header('Content-Type: application/json');

$host = "localhost";
$db   = "u318955861_dpsw";
$user = "u318955861_dpsw";
$pass = "Dpsw@100";



$conn = new mysqli($host, $user, $pass, $db);

if($conn->connect_error){
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT id, title, start_date AS start, end_date AS end FROM eventscalendar";
$result = $conn->query($sql);

$data = [];

while($row = $result->fetch_assoc()) {
    $data[] = [
        'id'    => $row['id'],
        'title' => $row['title'],
        'start' => $row['start'],
        'end'   => $row['end']
    ];
}

echo json_encode($data);
$conn->close();
?>