<?php
require_once __DIR__ . '/db.php';

$res = $db->query('select termin, uhrzeit from proben where date(STR_TO_DATE(termin, "%d.%m.%Y")) > (SELECT CURDATE() );');
$proben = $res->fetchAll(PDO::FETCH_ASSOC);
$res = $db->query('select termin,uhrzeit,beschreibung,anfahrt from konzert order by id desc limit 1;');
$konzert = $res->fetchAll(PDO::FETCH_ASSOC);

$output = array("konzert" => $konzert, "proben" => $proben);
header('Content-Type: application/json');
echo( json_encode($output, JSON_PRETTY_PRINT) );