diff options
Diffstat (limited to 'intern')
| -rw-r--r-- | intern/api/db.php | 8 | ||||
| -rw-r--r-- | intern/api/termine.php | 12 |
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) ); + |