From e5a172ed69f41098719cbe2be3f173b1d3f9ac65 Mon Sep 17 00:00:00 2001
From: Horus3
Date: Wed, 2 Mar 2016 23:27:49 +0100
Subject: Fügt die PHP API hinzu. Diesmal mit richtigen Umlauten. :)

---
 intern/api/db.php      |  8 ++++++++
 intern/api/termine.php | 12 ++++++++++++
 2 files changed, 20 insertions(+)
 create mode 100644 intern/api/db.php
 create mode 100644 intern/api/termine.php

(limited to 'intern/api')

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) );
+
-- 
cgit v1.2.3