diff options
Diffstat (limited to 'intern')
| -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 97059a8..3b0658d 100644 --- a/intern/api/termine.php +++ b/intern/api/termine.php @@ -11,11 +11,13 @@ if ( false === $db ) { exit; } -$res = $db->query('select termin, uhrzeit from proben where date(STR_TO_DATE(termin, "%d.%m.%Y")) > (SELECT CURDATE() );'); +$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); +$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, "build" => date("Y-m-d H:i:s")); $data = json_encode($output, JSON_PRETTY_PRINT); |