query("SELECT * FROM shops ORDER BY name ASC"); while ($shop = $shopQuery->fetch(PDO::FETCH_ASSOC)) { $shopId = 'shop_' . $shop['id']; $shopsData[$shopId] = [ "name" => htmlspecialchars($shop['name']), "lat" => floatval($shop['lat']), "lng" => floatval($shop['lng']), "products" => [] ]; } $prodQuery = $pdo->query("SELECT shop_id, name, price FROM products ORDER BY price ASC"); while ($product = $prodQuery->fetch(PDO::FETCH_ASSOC)) { $shopId = 'shop_' . $product['shop_id']; if (isset($shopsData[$shopId])) { $shopsData[$shopId]['products'][] = [ "name" => htmlspecialchars($product['name']), "price" => floatval($product['price']) ]; } } ?> QuickFood Marketplace

πŸ›΅ QuickFood Marketplace

1. Select a Shop

2. Menu

3. Delivery Route

πŸ“ The 🟒 Green Marker is the restaurant. Drag the πŸ”΄ Red Marker to your dropoff point.

4. Delivery Information

Basket Subtotal: 0.000 TND
Driving Surcharge (0.00 km): 0.000 TND
Total Due on Delivery: 0.000 TND