blob: 3f7aac5988e1cd8d6546b35f04d52bcf25a40c6b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
<?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();
}
}
|
