iCare Health and Wellness

iCare Health & Wellness.

Premium Medical Services

Initializing Experience...

Home Hospitals Doctors News Support
// Parse facilities $facilities = []; if (!empty($hospital["key_facilities"])) { $facilities = array_map("trim", explode(",", $hospital["key_facilities"])); } // Initialize default values $doctors = []; $brochures = []; $specialtiesData = []; // Get doctors at this hospital try { $stmt = $db->prepare("SELECT * FROM doctors WHERE hospital_id = ? ORDER BY id DESC"); $stmt->execute([$id]); $doctors = $stmt->fetchAll() ?: []; } catch (Exception $e) { // Table may not exist, use empty array $doctors = []; } // Get active brochures/promos for this hospital along with their active Campaign ID for tracking try { $stmt = $db->prepare(" SELECT b.*, c.id as campaign_id FROM brochures b LEFT JOIN campaigns c ON b.id = c.brochure_id AND c.status = 'Active' WHERE b.hospital_id = ? AND b.is_active = 1 ORDER BY b.created_at DESC "); $stmt->execute([$id]); $brochures = $stmt->fetchAll() ?: []; } catch (Exception $e) { $brochures = []; } // Get hospital specialties try { $stmt = $db->prepare("SELECT * FROM hospital_specialties WHERE hospital_id = ? ORDER BY specialty_name ASC"); $stmt->execute([$id]); $specialtiesData = $stmt->fetchAll() ?: []; } catch (Exception $e) { $specialtiesData = []; } // Get hospital images $images = []; if (!empty($hospital["hero_image_url"])) $images[] = $hospital["hero_image_url"]; if (!empty($hospital["logo_url"])) $images[] = $hospital["logo_url"]; if (empty($images)) $images[] = "https://images.unsplash.com/photo-1586773860418-d3b978b055e0?auto=format&fit=crop&q=80&w=1920"; $pageTitle = htmlspecialchars($hospital["name"]); include __DIR__ . "/../app/Views/layout/header.php"; ?>
Rs Pondok Indah
Verified
General Hospital

Rs Pondok Indah

South Jakarta, Indonesia
Specialists
0
Specialties
0
Capacity
0+ Beds
Emergency
24/7

About Hospital


Contact Hospital

Address
RS PONDOK INDAH, Jalan Taman Duta I, Pondok Indah, Pondok Pinang, Kebayoran Lama, South Jakarta, Special Capital Region of Jakarta, Java, 12310, Indonesia
Location Map
Book Appointment Back to Hospitals