Merge branch 'master' of git.iamfabulous.de:gospeladlershof.de

1 files changed, 21 insertions, 0 deletions

diff --git a/intern.gospeladlershof.de/code/termine.php b/intern.gospeladlershof.de/code/termine.php
new file mode 100644
index 0000000..3f7aac5
--- /dev/null
+++ b/intern.gospeladlershof.de/code/termine.php
@@ -0,0 +1,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();
+	}
+}