session_start(); include "conn.php"; if (isset($_SESSION['search_trigger'])) { $searchData = $_SESSION['search_trigger']; unset($_SESSION['search_trigger']); } $query = "SELECT * FROM districts WHERE id = 2"; $stmt = $conn->prepare($query); $stmt->execute(); $result = $stmt->get_result(); $district = $result->fetch_assoc(); $transport_routes = array(); if (!empty($district['transportation_routes'])) { $routes_data = json_decode($district['transportation_routes'], true); if (is_array($routes_data)) { foreach ($routes_data as $route) { $transport_type = $route['type']; if (!isset($transport_routes[$transport_type])) { $transport_routes[$transport_type] = array(); } $transport_routes[$transport_type][] = array( 'name' => $route['name'], 'link' => $route['link'], 'description' => $route['description'] ?? '' ); } } } function convertToEmbedURL($googleMapsLink) { if (strpos($googleMapsLink, 'goo.gl/maps') !== false || strpos($googleMapsLink, 'google.com/maps') !== false) { return str_replace("maps/place/", "maps/embed?pb=", $googleMapsLink); } return $googleMapsLink; } $nearby_places = []; if (!empty($district['nearby_places'])) { $decoded = json_decode($district['nearby_places'], true); $nearby_places = is_array($decoded) ? $decoded : []; } $detail_images = array_filter(explode(',', $district['image_detail'] ?? '')); $social_links = array_filter(array_map('trim', explode("\n", $district['social_media'] ?? ''))); $hours = []; if (!empty($district['hours'])) { $lines = explode("\n", $district['hours']); foreach ($lines as $line) { if (strpos($line, ':') !== false) { list($day, $times) = explode(':', $line, 2); $hours[trim($day)] = array_map('trim', explode(',', $times)); } } } ?> - Iloilo City Districts

About

📜 History & Culture

🏛ī¸ Historical Background

🎭 Cultural Information
💡 Did You Know?
No fun facts available for this district.
🏛ī¸ Historical Background

🎭 Cultural Information
💡 Did You Know?
No fun facts available for this district.

ℹī¸ District Information

Visitor Details
💡 Facts

🧑‍🤝‍🧑 Population:

đŸ—ēī¸ Area:

🏘ī¸ Barangays:

📮 Zip Code:

📅 Established:

Visitor Details
💡 Facts

🧑‍🤝‍🧑 Population:

đŸ—ēī¸ Area:

🏘ī¸ Barangays:

📮 Zip Code:

📅 Established:

📞 Additional Information

📍 Location & Directions

Map not available
đŸ—ēī¸ Nearby Places
No nearby places listed.
🔗 Links
🚗 Transportation Information
Jeepney

Click to see available routes

No routes available
Bus

Click to see available routes

No routes available
Taxi

Click to see available routes

No routes available
Tricycle

Click to see available routes

No routes available