query(" SELECT r.id, r.name, r.description, r.image_url, GROUP_CONCAT(c.name SEPARATOR ', ') as cuisines FROM restaurants r LEFT JOIN restaurant_cuisines rc ON r.id = rc.restaurant_id LEFT JOIN cuisines c ON rc.cuisine_id = c.id WHERE r.is_active = 1 GROUP BY r.id ORDER BY r.id DESC LIMIT 6 "); $featured_restaurants = $stmt->fetchAll(); // Fetch featured cuisines for the filter section $stmt = $pdo->query("SELECT * FROM cuisines ORDER BY name ASC LIMIT 12"); $cuisines = $stmt->fetchAll(); ?>
Browse our extensive list of local restaurants and stores.
Select your favorite dishes and add them to your cart.
Get your food delivered right to your doorstep, fast!