<?php
require_once('include/headscript.php');

$conn = mysqli_connect($servername, $username, $password, $dbname);

if (!$conn) {
    die(json_encode(['error' => 'Connessione al database fallita']));
}

// Query per ottenere tutte le classi disponibili
$sql = "SELECT id, servicename, day, time FROM classes ORDER BY servicename, day, time";
$result = mysqli_query($conn, $sql);

$classes = [];
while ($row = mysqli_fetch_assoc($result)) {
    $classes[] = [
        'id' => $row['id'],
        'servicename' => $row['servicename'],
        'day' => $row['day'],
        'time' => $row['time']
    ];
}

mysqli_close($conn);
header('Content-Type: application/json');
echo json_encode($classes);