error); } // Afhaalmenus $datumPrev = ""; $sql = " SELECT datum, titel, text, prijs FROM Menus WHERE publish = 1 ORDER BY datum ASC, volgorde ASC"; $stmt = $mysqli->prepare($sql); $stmt->execute(); $stmt->bind_result($datum, $titel, $text, $prijs); $days_arr = array(); while($stmt->fetch()){ if($datum != $datumPrev){ $day_arr = array(); $menus_arr = array(); $day_arr['datum'] = $datum; $day_arr['menus'] = $menus_arr; array_push($days_arr, $day_arr); } $menu_arr = array(); $menu_arr['titel'] = $titel; $menu_arr['text'] = nl2br($text); $menu_arr['prijs'] = $prijs; array_push($days_arr[count($days_arr)-1]['menus'], $menu_arr); $datumPrev = $datum; } $stmt->close(); $colLeft_str = ''; $colRight_str = ''; // datum $dagen = array("", "Maandag", "Dinsdag", "Woensdag", "Donderdag", "Vrijdag", "Zaterdag", "Zondag"); $maanden = array("", "januari", "februari", "maart", "april", "mei", "juni", "juli", "augustus", "september", "oktober", "november", "december"); for($daysCount=0; $daysCount < count($days_arr); $daysCount++){ // datum $datum = $days_arr[$daysCount]["datum"]; $dayName = $dagen[date("N", strtotime($datum))]; $dayNum = date("j", strtotime($datum)); $monthName = $maanden[date("n", strtotime($datum))]; //$year = date("Y", strtotime($datum)); $datumFormat = strtoupper($dayName." ".$dayNum." ".$monthName); $dayMod = '
'.$datumFormat.'
'; // menus $menus_arr = $days_arr[$daysCount]['menus']; for($menuCount=0; $menuCount < count($menus_arr); $menuCount++){ $titel = $menus_arr[$menuCount]['titel']; $text = $menus_arr[$menuCount]['text']; $prijs = $menus_arr[$menuCount]['prijs']; if(empty($prijs)){ $prijs = " "; } $dayMod .= '

'.$titel.'

'.$text.'

'.$prijs.'
'; } $dayMod .= '
'; if($daysCount %2 == 0){ $colLeft_str .= $dayMod; } else { $colRight_str .= $dayMod; } } ?> O!life
KOK-AAN-HUIS CATERING SUPERFOOD AFHAALMENU'S WEBSHOP
CONTACT

De waarheid zit in de eenvoud.

BEKIJK DE AFHAALMENU'S
prepare($sql); $stmt->execute(); $stmt->bind_result($titel, $txt1, $txt2); $stmt->fetch(); $stmt->close(); ?>
MENU

prepare($sql); $stmt->execute(); $stmt->store_result(); $numNews = $stmt->num_rows; $stmt->bind_result($titel, $text); if($numNews > 0){ ?>
fetch()){ ?>

prepare($sql); $stmt->execute(); $stmt->bind_result($titel, $txt1, $txt2); $stmt->fetch(); $stmt->close(); ?>
MENU

prepare($sql); $stmt->execute(); $stmt->bind_result($titel, $txt1, $txt2); $stmt->fetch(); $stmt->close(); ?>
MENU

prepare($sql); $stmt->execute(); $stmt->bind_result($titel, $txt1, $txt2); $stmt->fetch(); $stmt->close(); ?>
MENU

BEZOEK DE WEBSHOP
prepare($sql); $stmt->execute(); $stmt->bind_result($titel, $txt1, $txt2); $stmt->fetch(); $stmt->close(); ?>
MENU

Afhalen tussen 17 en 19 uur, tenzij anders afgesproken. Op=op.

Afval: Breng je je eigen dozen of flessen mee, of recycleer je de gebruikte O!life-dozen, krijg je via een puntenkaart kortingen of lekkere extra's!

prepare($sql); $stmt->execute(); $stmt->bind_result($titel, $txt1, $txt2); $stmt->fetch(); $stmt->close(); ?>