prepare('SELECT name, description, image_url FROM restaurants WHERE id = :id'); $stmt_restaurant->bindParam(':id', $restaurant_id, PDO::PARAM_INT); $stmt_restaurant->execute(); $restaurant = $stmt_restaurant->fetch(PDO::FETCH_ASSOC); if ($restaurant) { $stmt_menu = $pdo->prepare('SELECT id, name, description, price, image_url FROM menu_items WHERE restaurant_id = :id ORDER BY name'); $stmt_menu->bindParam(':id', $restaurant_id, PDO::PARAM_INT); $stmt_menu->execute(); $menu_items = $stmt_menu->fetchAll(PDO::FETCH_ASSOC); } } catch (PDOException $e) { // In a real app, log this error. } } ?> <?php echo $restaurant ? htmlspecialchars($restaurant['name']) : 'Menu'; ?> - MajuroEats

Menu

0): ?>

$ $item['id'], 'name' => $item['name'], 'price' => $item['price']]), ENT_QUOTES, 'UTF-8'); ?>

This restaurant currently has no menu items.

Restaurant not found

Sorry, the restaurant you are looking for does not exist.