<?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; } } }