diff options
| author | horus | 2017-04-27 22:40:55 +0200 |
|---|---|---|
| committer | horus | 2017-04-27 22:40:55 +0200 |
| commit | 48923f74f8c52a05f2cc2ad9f62a1047e1308c97 (patch) | |
| tree | 28eb3b72421051d9b1d5adbf697119b60594a6a8 /intern/api | |
| parent | f5dd67f91fe90110132f3a728ecf15d8c579405a (diff) | |
| download | gospeladlershof.de-48923f74f8c52a05f2cc2ad9f62a1047e1308c97.tar.gz | |
Der Code, damit der Einsteigertermin in der Datenbank eingetragen wird.
Diffstat (limited to 'intern/api')
| -rw-r--r-- | intern/api/termine.php | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/intern/api/termine.php b/intern/api/termine.php index 8e98390..af78a26 100644 --- a/intern/api/termine.php +++ b/intern/api/termine.php @@ -17,11 +17,13 @@ $res = $db->query('select termin,uhrzeit,beschreibung,anfahrt from konzert order $konzert = $res->fetchAll(PDO::FETCH_ASSOC); $res = $db->query('select nachricht as chorbeschreibung from chor order by id desc limit 1;'); $chorbeschreibung = $res->fetch(PDO::FETCH_ASSOC); +$res = $db->query('SELECT termin FROM proben WHERE einsteiger > 0 AND date(STR_TO_DATE(termin, "%d.%m.%Y")) >= (SELECT CURDATE() ) ORDER BY date(STR_TO_DATE(termin, "%d.%m.%Y"));'); +$einsteigertermin = $res->fetch(PDO::FETCH_ASSOC)['termin']; $konzert[0]["beschreibung"] = str_replace("<strong>", "**", str_replace("</strong>", "**", $konzert[0]["beschreibung"])); #$output = array("konzert" => $konzert, "proben" => $proben, "build" => date("d.m.Y H:i:s")); -$output = array("konzert" => $konzert, "proben" => $proben, "chorbeschreibung" => $chorbeschreibung["chorbeschreibung"], "build" => date("Y-m-d H:i:s")); +$output = array("konzert" => $konzert, "proben" => $proben, "chorbeschreibung" => $chorbeschreibung["chorbeschreibung"], "einsteigertermin" => $einsteigertermin, "build" => date("Y-m-d H:i:s")); $data = json_encode($output, JSON_PRETTY_PRINT); file_put_contents($json_file, $data); // speichert die JSON Datei für den Fall, dass es später Fehler gibt |