connect_error); $connError = $connError ?? ''; $search = trim($_GET['q'] ?? ''); $selectedZone = trim($_GET['zone'] ?? ''); $lat = filter_input(INPUT_GET, 'lat', FILTER_VALIDATE_FLOAT); $lng = filter_input(INPUT_GET, 'lng', FILTER_VALIDATE_FLOAT); $hasLocation = ($lat !== false && $lat !== null && $lng !== false && $lng !== null); $csrfToken = generateCsrfToken(); $currentUserId = (int) ($_SESSION['user_id'] ?? 0); $currentUserName = (string) ($_SESSION['user_name'] ?? ''); $googleLoginConfigured = GOOGLE_CLIENT_ID !== '' && GOOGLE_CLIENT_SECRET !== ''; function e($value): string { return htmlspecialchars((string) $value, ENT_QUOTES | ENT_HTML5, 'UTF-8'); } function money($amount): string { return 'Rs. ' . number_format((float) $amount, 0); } function tableExists($conn, string $table): bool { if (!$conn || $conn->connect_error) { return false; } $safeTable = $conn->real_escape_string($table); $result = $conn->query("SHOW TABLES LIKE '{$safeTable}'"); return $result && $result->num_rows > 0; } function fetchRows($conn, string $query, string $types = '', array $params = []): array { if (!$conn || $conn->connect_error) { return []; } $stmt = $conn->prepare($query); if (!$stmt) { return []; } if ($types !== '' && !empty($params)) { $stmt->bind_param($types, ...$params); } if (!$stmt->execute()) { return []; } $result = $stmt->get_result(); $rows = []; if ($result) { while ($row = $result->fetch_assoc()) { $rows[] = $row; } } return $rows; } function publicUrl(string $path): string { return rtrim(SITE_URL, '/') . '/' . ltrim($path, '/'); } $zones = []; $restaurants = []; $featuredItems = []; $menuCatalog = []; $cuisines = []; $offers = []; $stats = ['restaurants' => 0, 'items' => 0, 'zones' => 0, 'avg_time' => 0]; if ($isConnected && tableExists($conn, 'restaurants')) { $zones = fetchRows( $conn, "SELECT z.id, z.name, COUNT(r.id) AS restaurant_count FROM zones z LEFT JOIN restaurants r ON r.zone_id = z.id AND r.status = 'ACTIVE' WHERE z.is_active = 1 GROUP BY z.id, z.name ORDER BY z.name" ); $cuisines = fetchRows( $conn, "SELECT cuisine, COUNT(*) AS total FROM restaurants WHERE status = 'ACTIVE' AND cuisine IS NOT NULL AND cuisine <> '' GROUP BY cuisine ORDER BY total DESC, cuisine LIMIT 10" ); $where = ["r.status = 'ACTIVE'"]; $types = ''; $params = []; if ($search !== '') { $where[] = "(r.name LIKE ? OR r.cuisine LIKE ? OR r.address_line LIKE ? OR EXISTS ( SELECT 1 FROM menu_items mi WHERE mi.restaurant_id = r.id AND mi.name LIKE ? ))"; $like = '%' . $search . '%'; $types .= 'ssss'; $params[] = $like; $params[] = $like; $params[] = $like; $params[] = $like; } if ($selectedZone !== '') { $where[] = "z.name = ?"; $types .= 's'; $params[] = $selectedZone; } $distanceSql = $hasLocation ? ", (6371 * ACOS(LEAST(1, COS(RADIANS(?)) * COS(RADIANS(r.latitude)) * COS(RADIANS(r.longitude) - RADIANS(?)) + SIN(RADIANS(?)) * SIN(RADIANS(r.latitude))))) AS distance_km" : ", NULL AS distance_km"; $distanceOrder = $hasLocation ? "distance_km ASC," : ""; $restaurantTypes = $hasLocation ? 'ddd' . $types : $types; $restaurantParams = $hasLocation ? array_merge([$lat, $lng, $lat], $params) : $params; $restaurants = fetchRows( $conn, "SELECT r.id, r.name, r.cuisine, r.rating, r.review_count, r.delivery_time_minutes, r.delivery_fee, r.min_order_value, r.packaging_charge, r.image_url, r.image_category, r.is_pure_veg, r.is_online, r.address_line, r.landmark, r.latitude, r.longitude, z.name AS zone_name, c.name AS city_name, COUNT(mi.id) AS menu_count, MIN(mi.price) AS starting_price {$distanceSql} FROM restaurants r LEFT JOIN zones z ON z.id = r.zone_id LEFT JOIN cities c ON c.id = r.city_id LEFT JOIN menu_items mi ON mi.restaurant_id = r.id AND mi.is_available = 1 WHERE " . implode(' AND ', $where) . " GROUP BY r.id, z.name, c.name ORDER BY {$distanceOrder} r.is_online DESC, r.rating DESC, r.delivery_time_minutes ASC LIMIT 24", $restaurantTypes, $restaurantParams ); $featuredItems = fetchRows( $conn, "SELECT mi.id, mi.name, mi.description, mi.price, mi.competitor_price, mi.is_veg, mi.rating, mi.is_bestseller, mi.image_url, mi.image_emoji, mi.preparation_time_minutes, r.id AS restaurant_id, r.name AS restaurant_name, r.delivery_time_minutes, r.delivery_fee FROM menu_items mi JOIN restaurants r ON r.id = mi.restaurant_id WHERE mi.is_available = 1 AND r.status = 'ACTIVE' ORDER BY mi.is_bestseller DESC, mi.rating DESC, mi.created_at DESC LIMIT 12" ); $restaurantIds = array_values(array_unique(array_map('intval', array_column($restaurants, 'id')))); if (!empty($restaurantIds)) { $placeholders = implode(',', array_fill(0, count($restaurantIds), '?')); $menuRows = fetchRows( $conn, "SELECT mi.id, mi.name, mi.description, mi.price, mi.competitor_price, mi.is_veg, mi.rating, mi.is_bestseller, mi.image_url, mi.image_emoji, mi.preparation_time_minutes, r.id AS restaurant_id, r.name AS restaurant_name, r.delivery_time_minutes, r.delivery_fee FROM menu_items mi JOIN restaurants r ON r.id = mi.restaurant_id WHERE mi.is_available = 1 AND r.status = 'ACTIVE' AND r.id IN ({$placeholders}) ORDER BY r.rating DESC, mi.is_bestseller DESC, mi.rating DESC, mi.name", str_repeat('i', count($restaurantIds)), $restaurantIds ); foreach ($menuRows as $row) { $menuCatalog[(int) $row['restaurant_id']][] = $row; } } $offers = fetchRows( $conn, "SELECT r.id, r.name, r.cuisine, r.rating, r.delivery_time_minutes, r.image_url, MIN(mi.price) AS starting_price, COUNT(mi.id) AS menu_count FROM restaurants r LEFT JOIN menu_items mi ON mi.restaurant_id = r.id AND mi.is_available = 1 WHERE r.status = 'ACTIVE' GROUP BY r.id ORDER BY r.rating DESC, menu_count DESC LIMIT 6" ); $statRows = fetchRows( $conn, "SELECT COUNT(DISTINCT r.id) AS restaurants, COUNT(DISTINCT mi.id) AS items, COUNT(DISTINCT z.id) AS zones, ROUND(AVG(r.delivery_time_minutes)) AS avg_time FROM restaurants r LEFT JOIN menu_items mi ON mi.restaurant_id = r.id AND mi.is_available = 1 LEFT JOIN zones z ON z.id = r.zone_id AND z.is_active = 1 WHERE r.status = 'ACTIVE'" ); if (!empty($statRows)) { $stats = array_merge($stats, array_map('intval', $statRows[0])); } } $heroSlides = !empty($offers) ? $offers : array_slice($restaurants, 0, 4); $whatsAppLink = WHATSAPP_NUMBER !== '' ? 'https://wa.me/' . WHATSAPP_NUMBER . '?text=' . rawurlencode('Hi, I want help with my food order.') : ''; $seoDescription = 'Order food online from nearby hotels and restaurants. Browse menus, offers, delivery zones, popular dishes, and secure Razorpay checkout.'; $canonicalUrl = publicUrl('index.php'); $cartItemsJson = json_encode($featuredItems, JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_AMP | JSON_HEX_QUOT); $menuCatalogJson = json_encode($menuCatalog, JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_AMP | JSON_HEX_QUOT); ?> <?php echo e(SITE_NAME); ?> - Hotels, Restaurants, Offers and Online Food Delivery
0): ?> Login

Order from trusted hotels near you.

Discover restaurants, live offers, popular dishes, secure checkout, and delivery zones in one responsive food ordering experience.

View hotels
Active hotels
Menu items
Delivery zones
minAvg delivery

Delivery zones

Choose a service area to narrow restaurants and delivery availability.

Clear filters
All areas $search, 'zone' => $zone['name']], static function ($value) { return $value !== ''; }); $href = 'index.php' . (!empty($query) ? '?' . http_build_query($query) : ''); ?> -

Hotels and restaurants

Live restaurants from the ordering database, sorted by availability, rating, speed, and location when enabled.

Database is not connected.
No restaurants match this search yet.
<?php echo e($restaurant['name']); ?>
Pure veg

min Starts Delivery km

Popular dishes

Add items to cart and checkout through the Razorpay API when keys are configured.

No available dishes found yet.
<?php echo e($item['name']); ?>

min prep

Live offers

Dynamic offer popups use the top hotels and current menu data.

Live order tracking

Your active order will appear here after checkout.

StatusPending
Distance--
Estimated time--

Restaurant

Chat opens when an active order is loaded.
Protected by reCAPTCHA. Checkout requests can verify tokens server-side.
reCAPTCHA site key is not configured yet.