1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
<?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" => date("d.m.Y H:i:s") ) ) );
exit;
}
$res = $db->query('select termin, uhrzeit from proben where date(STR_TO_DATE(termin, "%d.%m.%Y")) >= (SELECT CURDATE() ) ORDER BY date(STR_TO_DATE(termin, "%d.%m.%Y"));');
$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);
$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"));');
$einsteiger= $res->fetch(PDO::FETCH_ASSOC)['termin'];
$konzert[0]["beschreibung"] = str_replace("<strong>", "**", str_replace("</strong>", "**", $konzert[0]["beschreibung"]));
$output = array("konzert" => $konzert, "proben" => $proben, "einsteiger" => $einsteiger, "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
echo $data;
|
