diff options
| author | Horus3 | 2016-03-03 12:15:11 +0100 |
|---|---|---|
| committer | Horus3 | 2016-03-03 12:15:11 +0100 |
| commit | 5ef16cc4a33bad8efb5feb45d78f9843039e8fc3 (patch) | |
| tree | 71fec7561bcf9ac6356141a93e1969ebd40ce9c5 /intern/api/termine.php | |
| parent | 7e967c88d60b821ee22f4d62bc6583d4025f0bad (diff) | |
| download | gospeladlershof.de-5ef16cc4a33bad8efb5feb45d78f9843039e8fc3.tar.gz | |
Bessere Fehlerbehandlung beim JSON erzeugen.
Diffstat (limited to 'intern/api/termine.php')
| -rw-r--r-- | intern/api/termine.php | 19 |
1 files changed, 16 insertions, 3 deletions
diff --git a/intern/api/termine.php b/intern/api/termine.php index 9c9d454..b5ff1db 100644 --- a/intern/api/termine.php +++ b/intern/api/termine.php @@ -1,12 +1,25 @@ <?php +header('Content-Type: application/json'); require_once __DIR__ . '/db.php'; +require_once __DIR__ . '/config.php'; + +$db = get_db(); + +if ( false === $db ) { + echo file_get_contents($json_file); // Liest veralte JSON Datei + error_log (json_encode( array( "error" => true, "reason" => "Can't connect to the database", "build" => time() ) ) ); + exit; +} $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) ); +$output = array("konzert" => $konzert, "proben" => $proben, "build" => time()); +$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 + +echo $file; |
