<?php
$currentPageName = "menu";
require_once "models/C.php";
require_once "models/dbcontroller.php";
require_once "models/head.php";
require_once "models/bodytop.php";
require_once "models/navigation.php";
$menu = dbcontroller::getMenu();
?>
<div class="container">
<?php
foreach ($menu_section as $section) {
if (count($menu) != 0) {
echo '<div class="row">';
echo '<div class="box text-center">';
echo '<hr><h2 class="text-center intro-text">' . $section[0] . '</h2><hr>';
echo array_values($menu)[0][$section[1]];
echo '</div>';
echo '</div>';
} else {
echo '<div class="row">';
echo '<div class="box text-center">';
echo '<hr><h2 class="text-center intro-text">' . "Non sono presenti eventi" . '</h2><hr>';
echo array_values($menu)[0][$section[1]];
echo '</div>';
echo '</div>';
}
}
?>
</div>
static function updateMenu($menu_consigliato, $antipasti, $primi, $secondi, $dessert)
{
global $mysqli;
$menu = dbcontroller::getMenu();
$data = date('Y-m-d');
if (count($menu) == 0) {
$value = "";
$stmt = false;
if ($menu_consigliato != "null") {
$stmt = $mysqli->prepare("INSERT INTO lde_menu (menu_consigliato, last_update) VALUES (?,?)");
$value = $menu_consigliato;
} else {
if ($antipasti != "null") {
$stmt = $mysqli->prepare("INSERT INTO lde_menu (antipasti, last_update) VALUES (?,?)");
$value = $antipasti;
} else {
if ($primi != "null") {
$stmt = $mysqli->prepare("INSERT INTO lde_menu (primi, last_update) VALUES (?,?)");
$value = $primi;
} else {
if ($secondi != "null") {
$stmt = $mysqli->prepare("INSERT INTO lde_menu (secondi, last_update) VALUES (?,?)");
$value = $secondi;
} else {
if ($dessert != "null") {
$stmt = $mysqli->prepare("INSERT INTO lde_menu (dessert, last_update) VALUES (?,?)");
$value = $dessert;
}
}
}
}
}
if ($stmt != false) {
$stmt->bind_param("ss", $value, $data);
$stmt->execute();
return true;
} else {
return false;
}
} else {
//esiste gia la riga sul db...va solo aggiornata!
$value = "";
$stmt = false;
if ($menu_consigliato != "null") {
$stmt = $mysqli->prepare("UPDATE lde_menu SET menu_consigliato = (?), last_update = (?)");
$value = $menu_consigliato;
} else {
if ($antipasti != "null") {
$stmt = $mysqli->prepare("UPDATE lde_menu SET antipasti = (?), last_update = (?)");
$value = $antipasti;
} else {
if ($primi != "null") {
$stmt = $mysqli->prepare("UPDATE lde_menu SET primi = (?), last_update = (?)");
$value = $primi;
} else {
if ($secondi != "null") {
$stmt = $mysqli->prepare("UPDATE lde_menu SET secondi = (?), last_update = (?)");
$value = $secondi;
} else {
if ($dessert != "null") {
$stmt = $mysqli->prepare("UPDATE lde_menu SET dessert = (?), last_update = (?)");
$value = $dessert;
}
}
}
}
}
if ($stmt != false) {
$stmt->bind_param("ss", $value, $data);
$stmt->execute();
return true;
} else {
return false;
}
}
}
