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

$db = get_db();

// TODO: false === $db
if ( false === $db ) {
	$_SESSION["error"] = "Kann keine Verbindung zur Datenbank herstellen."; 
} else {
	try {
		$res = $db->query('select id, termin, uhrzeit from proben where date(STR_TO_DATE(termin, "%d.%m.%Y")) > (SELECT CURDATE() ) ORDER BY date(STR_TO_DATE(termin, "%d.%m.%Y"));');
		$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);
	} catch( Exception $e ) {
		error_log($e->getMessage());
		$_SESSION["error"] = $e->getMessage();
	}
}