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("", "**", str_replace("", "**", $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;