Fügt die PHP API hinzu. Diesmal mit richtigen Umlauten. :)

2 files changed, 20 insertions, 0 deletions

diff --git a/intern/api/db.php b/intern/api/db.php
new file mode 100644
index 0000000..9521148
--- /dev/null
+++ b/intern/api/db.php
@@ -0,0 +1,8 @@
+<?php
+require_once __DIR__ . '/config.php';
+$db = new pdo($dsn, $db_user, $db_passwd);
+$db->exec('SET CHARACTER SET utf8');  
+
+unset($dsn);
+unset($db_user);
+unset($db_passwd);
diff --git a/intern/api/termine.php b/intern/api/termine.php
new file mode 100644
index 0000000..9c9d454
--- /dev/null
+++ b/intern/api/termine.php
@@ -0,0 +1,12 @@
+<?php
+require_once __DIR__ . '/db.php';
+
+$res = $db->query('select termin, uhrzeit from proben where date(STR_TO_DATE(termin, "%d.%m.%Y")) > (SELECT CURDATE() );');
+$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);
+
+$output = array("konzert" => $konzert, "proben" => $proben);
+header('Content-Type: application/json');
+echo( json_encode($output, JSON_PRETTY_PRINT) );
+