27 lines
695 B
PHP
27 lines
695 B
PHP
<?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);
|