// 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"; ?>