intern.gospeladlershof.de/code/termine.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

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

if ( ! defined("LOGIN_NOT_REQUIRED") || !LOGIN_NOT_REQUIRED ) {
	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();
	}
}