blob: 2761e73de085d54d7a617734288c9e69d421243d (
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, einsteiger 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();
}
}
|
