connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$list = array();
// Kalenderwoche bekommen
$kw = getStartAndEndDate(date("Y"),date("W"));
//nummer des heutinge Wochentages bekommen
$dayNo=date("N");
//prüfen ob es wochenende ist
if($dayNo<6){
$sql = 'SELECT * FROM `mittagstisches` INNER JOIN posts ON mittagstisches.post_id=posts.id WHERE date BETWEEN "'.$kw[0].'" and "'.$kw[1].'" ORDER BY date ASC';
$result = $conn->query($sql);
$currentDay = "";
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
array_push($list,$row);
}
$weekNamesSet=false;
$arr = array();
foreach ($list as $key => $item) {
$arr[$item['date']][$key] = $item;
}
ksort($arr, SORT_NUMERIC);
foreach($arr as $v){
foreach($v as $a){
if(!$weekNamesSet){
echo menuCard($a["date"]);
// print_r($a);
$weekNamesSet=true;
}
//print_r($a);
echo gerichtWrap($a["name"],$a["description"],$a["price"]);
}
echo '
';
$weekNamesSet=false;
}
} else {
echo '
Das Tagesessen wurde noch nicht erstellt.
';
}
}else{
echo '
Wochenende
Das Tagesessen wird nur von Montag bis Freitag angeboten.
';
}
//-------------------------------------------------------------------------------
//gets the start/end date of the week
function getStartAndEndDate($year, $week)
{
return [
(new DateTime())->setISODate($year, $week)->format('Y-m-d'), //start date
(new DateTime())->setISODate($year, $week, 5)->format('Y-m-d') //end date
];
}
//returns the german weekday names
function getWeekday($day){
$wochentage = array("Sonntag", "Montag", "Dienstag", "Mittwoch", "Donnerstag", "Freitag", "Samstag");
$zeit = strtotime($day);
return $wochentage[date("w", $zeit)];
}
function gerichtWrap($name,$desc,$price){
return '
