public static function menuIsActive() { if (!Session::getNested('active_menu', 'menu_id')) { // destroy session // Session::destroy(); // // create error message Session::add('feedback_errors', ErrorMessage::get('MENU_NOT_ACTIVE')); // redirect to menu selection screen header('Location: ' . URL_WITH_INDEX_FILE . 'menumanager/managemenus'); exit; } }
} } } ?> </ul> <div class="navbar-form navbar-right"> <?php if (isset($_SESSION['active_menu'])) { ?> <a class="btn btn-primary" href="<?php echo URL_WITH_INDEX_FILE . 'recipes/managerecipes'; ?> " role="button">Active Menu - <?php echo Session::getNested('active_menu', 'menu_name'); ?> </a> <?php } else { ?> <button class="btn btn-danger" type="submit">No Active Menu Selected</button> <?php } ?> <div class="form-group"> <a class="btn btn-danger" href="http://localhost/Learning-MVC/logout.php" role="button">Logout</a> </div> </div>
public function retrieveRecipes() { $statementHandler = Database::getInstance()->prepare("SELECT\n\t\t\t\ta.menu_id, a.recipe_id, b.recipe_name\n\t\t\t FROM \n\t\t\t \tmenus_recipes_added as a\n\t\t\t INNER JOIN \n\t\t\t \trecipes as b\n\t\t\t WHERE \n\t\t\t \ta.menu_id = :menu_id AND\n\t\t\t \ta.recipe_id = b.id AND\n\t\t\t \ta.account_id = :account_id"); $statementHandler->execute(array(':menu_id' => Session::getNested('active_menu', 'menu_id'), ':account_id' => Session::get('account_id'))); return $statementHandler->fetchAll(PDO::FETCH_ASSOC); }