1,
"judul" => "Why PT Hilton Tours Travel is the Best Choice for Flight Ticket Booking",
"tanggal" => "Mei 20, 2026",
"gambar" => "https://plain-apac-prod-public.komododecks.com/202606/18/HEhtS0x0XTMKeOdKGn0B/image.jpg",
"link" => "https://hiltontourstravel.online/news-detail-1.php",
"ringkasan" => "Merencanakan perjalanan menjadi lebih mudah dengan akses ke layanan tiket penerbangan tepercaya yang menawarkan efisiensi tinggi serta biaya bersahabat..."
],
[
"id" => 2,
"judul" => "Enjoy Affordable Flight Ticket Promotions with PT Hilton Tours Travel",
"tanggal" => "Mei 20, 2026",
"gambar" => "https://plain-apac-prod-public.komododecks.com/202606/18/SZf9pVXF1HNVAw4GVOrA/image.jpg",
"link" => "https://hiltontourstravel.online/news-detail-2.php",
"ringkasan" => "Menikmati perjalanan udara kini kian terjangkau dengan berbagai skema promo menarik dari PT Hilton Tours Travel..."
],
[
"id" => 3,
"judul" => "Trusted Domestic and International Flight Ticket Provider",
"tanggal" => "Mei 20, 2026",
"gambar" => "https://plain-apac-prod-public.komododecks.com/202606/18/JRigeS6pa4s6r3fps7to/image.jpg",
"link" => "https://hiltontourstravel.online/news-detail-3.php",
"ringkasan" => "Menemukan opsi akomodasi transportasi udara terbaik adalah kunci dari lancarnya agenda perjalanan Anda. Percayakan bersama PT Hilton Tours Travel..."
]
];
// ==========================================
// KONEKSI DATABASE UTAMA (SINGLE CONNECTION)
// ==========================================
$db_connected = false;
try {
if (!isset($pdo)) {
$host = 'localhost';
$db = 'dreamztr_dreamstravel77'; // Diubah menggunakan DB Dreamz Travel
$user = 'dreamztr_dreamstravel77'; // Diubah menggunakan User Dreamz Travel
$pass = 'Ewl2547@47'; // Password baru
$charset = 'utf8mb4';
$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$options = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
];
$pdo = new PDO($dsn, $user, $pass, $options);
}
$db_connected = true;
} catch (PDOException $e) {
$db_connected = false;
}
// ==========================================
// INTEGRASI DATABASE FOOTER SETTINGS (DARI PANEL ADMIN)
// ==========================================
if ($db_connected) {
try {
$stmt_footer = $pdo->prepare("SELECT * FROM footer_settings WHERE id = 1");
$stmt_footer->execute();
$footer_data = $stmt_footer->fetch();
if ($footer_data) {
$urlFooterLogo = $footer_data['logo_url'];
$footerDesc = $footer_data['description'];
$instagramUrl = $footer_data['instagram_url'];
$facebookUrl = $footer_data['facebook_url'];
$emailAdmin = $footer_data['email_address'];
$nomorTelepon = $footer_data['phone_number'];
$nomorWhatsapp = $footer_data['whatsapp_number'];
$alamatLengkap = $footer_data['address'];
$copyrightText = $footer_data['copyright_text'];
$namaDomain = $footer_data['domain_name'];
}
} catch (PDOException $e) {
// Abaikan error dan gunakan fallback default
}
}
// ==========================================
// INTEGRASI DATABASE NAVBAR & HEADER SETTINGS (DARI PANEL ADMIN)
// ==========================================
$menu_items = [];
if ($db_connected) {
try {
// Ambil data konfigurasi umum header (logo & tombol booking)
$stmt_header = $pdo->prepare("SELECT * FROM header_settings WHERE id = 1");
$stmt_header->execute();
$header_data = $stmt_header->fetch();
if ($header_data) {
$urlHeaderLogo = $header_data['logo_url'];
$headerBtnText = $header_data['button_text'];
$headerBtnUrl = $header_data['button_url'];
}
// Ambil daftar menu navigasi terurut
$stmt_menu = $pdo->query("SELECT * FROM header_menu ORDER BY sort_order ASC, id DESC");
$menu_items = $stmt_menu->fetchAll();
} catch (PDOException $e) {
$menu_items = [];
}
}
// Jika database menu kosong atau koneksi gagal, gunakan menu bawaan/fallback
if (empty($menu_items)) {
$menu_items = [
['label' => 'Home', 'url' => '#'],
['label' => 'About Us', 'url' => 'https://hiltontourstravel.online/about-us.php'],
['label' => 'Domestic Flight', 'url' => 'https://hiltontourstravel.online/domestic-flight.php'],
['label' => 'International Flight', 'url' => 'https://hiltontourstravel.online/international-flight.php'],
['label' => 'News', 'url' => 'https://hiltontourstravel.online/news.php']
];
}
// ==========================================
// INTEGRASI DATABASE SUPPORT WIDGET (DARI PANEL ADMIN)
// ==========================================
if ($db_connected) {
try {
$stmt_support = $pdo->prepare("SELECT * FROM support_settings WHERE id = 1");
$stmt_support->execute();
$support_data = $stmt_support->fetch();
if ($support_data) {
$support_is_active = (int)$support_data['is_active'];
$support_title = $support_data['widget_title'];
$support_subtitle = $support_data['widget_subtitle'];
$support_wa_num = $support_data['whatsapp_number'];
$support_wa_msg = $support_data['whatsapp_message'];
$support_color = $support_data['widget_color'];
$support_position = $support_data['widget_position'];
}
} catch (PDOException $e) {
// Abaikan error dan gunakan fallback default
}
}
// ==========================================
// INTEGRASI DATABASE METADATA / FAVICON & TITLE (DARI PANEL ADMIN)
// ==========================================
if ($db_connected) {
try {
$stmt_meta = $pdo->prepare("SELECT * FROM site_meta_settings WHERE id = 1");
$stmt_meta->execute();
$meta_data = $stmt_meta->fetch();
if ($meta_data) {
$site_title = $meta_data['site_title'];
$favicon_url = $meta_data['favicon_url'];
}
} catch (PDOException $e) {
// Abaikan error dan gunakan fallback default
}
}
// ==========================================
// INTEGRASI DATABASE HEADER SLIDE (DARI PANEL ADMIN)
// ==========================================
$slides_from_db = [];
if ($db_connected) {
try {
$stmt = $pdo->query("SELECT * FROM header_slides ORDER BY sort_order ASC, id DESC");
$slides_from_db = $stmt->fetchAll();
} catch (PDOException $e) {
$slides_from_db = [];
}
}
// Jika database kosong atau koneksi gagal, gunakan gambar slide cadangan/bawaan
if (empty($slides_from_db)) {
$slides_from_db = [
[
"image_url" => $urlSlide1,
"title" => "Promo Slide 1"
],
[
"image_url" => $urlSlide2,
"title" => "Promo Slide 2"
]
];
}
// ==========================================
// INTEGRASI DATABASE ABOUT US (DARI PANEL ADMIN)
// ==========================================
$about_data = null;
if ($db_connected) {
try {
$stmt = $pdo->query("SELECT * FROM about_us WHERE id = 1");
$about_data = $stmt->fetch();
} catch (PDOException $e) {
$about_data = null;
}
}
// Jika database kosong atau koneksi gagal, gunakan data cadangan/bawaan
if (!$about_data) {
$about_data = [
'subtitle' => 'About Us',
'title' => $namaSitus,
'description' => 'PT Hilton Tours Travel adalah agen perjalanan tepercaya yang berdedikasi dalam menyediakan layanan pemesanan tiket pesawat domestik dan internasional. Kami berkomitmen untuk menyajikan solusi perjalanan udara yang nyaman, aman, serta ekonomis bagi perorangan, keluarga, maupun kebutuhan korporasi. Dengan akses ke berbagai pilihan maskapai dari kelas Ekonomi hingga Business Class, kami siap mengantarkan perjalanan Anda ke berbagai destinasi impian.',
'image_url' => $urlAboutImg,
'domestic_label' => 'Domestic Flight',
'international_label' => 'International Flight',
'read_more_url' => 'https://hiltontourstravel.online/about-us.php'
];
}
// ==========================================
// INTEGRASI DATABASE KEUNGGULAN / FEATURES (DARI PANEL ADMIN)
// ==========================================
$features_from_db = [];
if ($db_connected) {
try {
$stmt = $pdo->query("SELECT * FROM features ORDER BY sort_order ASC, id DESC");
$features_from_db = $stmt->fetchAll();
} catch (PDOException $e) {
$features_from_db = [];
}
}
// Jika database kosong atau koneksi gagal, gunakan keunggulan default/cadangan
if (empty($features_from_db)) {
$features_from_db = [
[
"icon" => "fa-solid fa-money-bill-wave",
"title" => "Competitive Flight Prices",
"description" => "Tarif tiket penerbangan bersaing untuk rute domestik maupun mancanegara dilengkapi promo berkala."
],
[
"icon" => "fa-solid fa-user-check",
"title" => "Professional & Fast Service",
"description" => "Layanan pemesanan yang cepat, praktis, serta didukung oleh staf yang ramah dan responsif."
],
[
"icon" => "fa-solid fa-plane-departure",
"title" => "Complete Travel Options",
"description" => "Pilihan rute penerbangan global yang bervariasi dengan dukungan penuh dari berbagai maskapai terkemuka."
]
];
}
// ==========================================
// INTEGRASI DATABASE RUTE PENERBANGAN / FLIGHTS (DARI PANEL ADMIN)
// ==========================================
$domestic_flights_from_db = [];
$international_flights_from_db = [];
if ($db_connected) {
try {
// Tarik data rute domestik
$stmt_dom = $pdo->query("SELECT * FROM flights WHERE flight_type = 'domestic' ORDER BY sort_order ASC, id DESC");
$domestic_flights_from_db = $stmt_dom->fetchAll();
// Tarik data rute internasional
$stmt_int = $pdo->query("SELECT * FROM flights WHERE flight_type = 'international' ORDER BY sort_order ASC, id DESC");
$international_flights_from_db = $stmt_int->fetchAll();
} catch (PDOException $e) {
$domestic_flights_from_db = [];
$international_flights_from_db = [];
}
}
// Jika database kosong atau koneksi gagal, gunakan rute domestik cadangan/bawaan
if (empty($domestic_flights_from_db)) {
$domestic_flights_from_db = [
[
"origin" => "Jakarta",
"destination" => "Denpasar",
"image_url" => "https://www.zephyrsholidays.com/wp-content/uploads/2026/05/Domestic-Flight-Zephyrs-World-Holidays_0000_1-denpasar.jpg",
"price_economy" => "Rp. 1,7 jt",
"price_business" => "Rp. 9,7 jt",
"rating" => "5.0",
"booking_link" => "search.php?search=1&journey_type=one_way&origin=CGK&origin_name=Jakarta+(CGK)&destination=DPS&destination_name=Denpasar+(DPS)&departure_date=" . $defaultDepartureDate . "&adults=1&cabin_class=economy"
],
[
"origin" => "Jakarta",
"destination" => "Surabaya",
"image_url" => "https://www.zephyrsholidays.com/wp-content/uploads/2026/05/Domestic-Flight-Zephyrs-World-Holidays_0001_2-Surabaya.jpg",
"price_economy" => "Rp. 1,6 jt",
"price_business" => "Rp. 9,1 jt",
"rating" => "5.0",
"booking_link" => "search.php?search=1&journey_type=one_way&origin=CGK&origin_name=Jakarta+(CGK)&destination=SUB&destination_name=Surabaya+(SUB)&departure_date=" . $defaultDepartureDate . "&adults=1&cabin_class=economy"
],
[
"origin" => "Jakarta",
"destination" => "Medan",
"image_url" => "https://www.zephyrsholidays.com/wp-content/uploads/2026/05/Domestic-Flight-Zephyrs-World-Holidays_0002_3-Medan.jpg",
"price_economy" => "Rp. 2,9 jt",
"price_business" => "Rp. 9,8 jt",
"rating" => "5.0",
"booking_link" => "search.php?search=1&journey_type=one_way&origin=CGK&origin_name=Jakarta+(CGK)&destination=KNO&destination_name=Medan+(KNO)&departure_date=" . $defaultDepartureDate . "&adults=1&cabin_class=economy"
],
[
"origin" => "Jakarta",
"destination" => "Manado",
"image_url" => "https://www.zephyrsholidays.com/wp-content/uploads/2026/05/Domestic-Flight-Zephyrs-World-Holidays_0003_4-Manado.jpg",
"price_economy" => "Rp. 4,1 jt",
"price_business" => "Rp. 4,1 jt",
"rating" => "5.0",
"booking_link" => "search.php?search=1&journey_type=one_way&origin=CGK&origin_name=Jakarta+(CGK)&destination=MDC&destination_name=Manado+(MDC)&departure_date=" . $defaultDepartureDate . "&adults=1&cabin_class=economy"
]
];
}
// Jika database kosong atau koneksi gagal, gunakan rute internasional cadangan/bawaan
if (empty($international_flights_from_db)) {
$international_flights_from_db = [
[
"destination" => "Malaysia",
"image_url" => "https://www.zephyrsholidays.com/wp-content/uploads/2026/05/International-Flight-Zephyrs-World-Holidays_0000_1-malaysia.jpg",
"flag_svg" => '
',
"price_economy" => "Rp. 2,7 jt",
"price_business" => "Rp. 8,4 jt",
"rating" => "5.0",
"booking_link" => "search.php?search=1&journey_type=one_way&origin=CGK&origin_name=Jakarta+(CGK)&destination=KUL&destination_name=Kuala+Lumpur+(KUL)&departure_date=" . $defaultDepartureDate . "&adults=1&cabin_class=economy"
],
[
"destination" => "Singapore",
"image_url" => "https://www.zephyrsholidays.com/wp-content/uploads/2026/05/International-Flight-Zephyrs-World-Holidays_0001_2-Singapore.jpg",
"flag_svg" => '
',
"price_economy" => "Rp. 3,3 jt",
"price_business" => "Rp. 11,8 jt",
"rating" => "5.0",
"booking_link" => "search.php?search=1&journey_type=one_way&origin=CGK&origin_name=Jakarta+(CGK)&destination=SIN&destination_name=Singapore+(SIN)&departure_date=" . $defaultDepartureDate . "&adults=1&cabin_class=economy"
],
[
"destination" => "Hong Kong",
"image_url" => "https://www.zephyrsholidays.com/wp-content/uploads/2026/05/International-Flight-Zephyrs-World-Holidays_0002_3-Hongkong.jpg",
"flag_svg" => '
',
"price_economy" => "Rp. 4,6 jt",
"price_business" => "Rp. 12,1 jt",
"rating" => "5.0",
"booking_link" => "search.php?search=1&journey_type=one_way&origin=CGK&origin_name=Jakarta+(CGK)&destination=HKG&destination_name=Hong+Kong+(HKG)&departure_date=" . $defaultDepartureDate . "&adults=1&cabin_class=economy"
],
[
"destination" => "Thailand",
"image_url" => "https://www.zephyrsholidays.com/wp-content/uploads/2026/05/International-Flight-Zephyrs-World-Holidays_0003_4-Thailand.jpg",
"flag_svg" => '
',
"price_economy" => "Rp. 3,5 jt",
"price_business" => "Rp. 14,6 jt",
"rating" => "5.0",
"booking_link" => "search.php?search=1&journey_type=one_way&origin=CGK&origin_name=Jakarta+(CGK)&destination=BKK&destination_name=Bangkok+(BKK)&departure_date=" . $defaultDepartureDate . "&adults=1&cabin_class=economy"
]
];
}
// ==========================================
// INTEGRASI DATABASE TRAVEL FAIR DESTINATIONS (DARI PANEL ADMIN)
// ==========================================
$fair_destinations_from_db = [];
if ($db_connected) {
try {
$stmt = $pdo->query("SELECT * FROM fair_destinations ORDER BY sort_order ASC, id DESC");
$fair_destinations_from_db = $stmt->fetchAll();
} catch (PDOException) {
$fair_destinations_from_db = [];
}
}
// Jika database kosong atau koneksi gagal, gunakan destinasi default/cadangan
if (empty($fair_destinations_from_db)) {
$fair_destinations_from_db = [
[
"title" => "Europe",
"image_url" => "https://www.zephyrsholidays.com/wp-content/uploads/2026/05/Sub-header-Negara-Zephyrs-World-Holidays-1-europ.png"
],
[
"title" => "Asia",
"image_url" => "https://www.zephyrsholidays.com/wp-content/uploads/2026/05/Sub-header-Negara-Zephyrs-World-Holidays-2-Asia.png"
],
[
"title" => "America",
"image_url" => "https://www.zephyrsholidays.com/wp-content/uploads/2026/05/Sub-header-Negara-Zephyrs-World-Holidays-3-America.png"
],
[
"title" => "Oceania & NZ",
"image_url" => "https://www.zephyrsholidays.com/wp-content/uploads/2026/05/Sub-header-Negara-Zephyrs-World-Holidays-4.png"
],
[
"title" => "Africa",
"image_url" => "https://www.zephyrsholidays.com/wp-content/uploads/2026/05/Sub-header-Negara-Zephyrs-World-Holidays-5-africa.png"
],
[
"title" => "Pilgrimages",
"image_url" => "https://www.zephyrsholidays.com/wp-content/uploads/2026/05/Sub-header-Negara-Zephyrs-World-Holidays-6.png"
]
];
}
// ==========================================
// INTEGRASI DATABASE BERITA / NEWS (DARI PANEL ADMIN)
// ==========================================
$loaded_news = [];
if ($db_connected) {
try {
$stmt = $pdo->query("SELECT * FROM news ORDER BY id DESC");
$news_from_db = $stmt->fetchAll();
// Memetakan struktur database ke dalam array visual halaman publik
foreach ($news_from_db as $post) {
$loaded_news[] = [
"id" => $post['id'],
"judul" => $post['title'],
"tanggal" => $post['date_published'],
"gambar" => $post['image_url'],
"link" => $post['link'],
"ringkasan" => $post['summary']
];
}
} catch (PDOException $e) {
$loaded_news = [];
}
}
// Jika database berisi artikel aktif, perbarui $daftarArtikel dengan data terbaru dari admin panel
if (!empty($loaded_news)) {
$daftarArtikel = $loaded_news;
}
// ==========================================
// INTEGRASI DATABASE TESTIMONIAL
// ==========================================
$testimonials_from_db = [];
if ($db_connected) {
try {
$stmt = $pdo->query("SELECT * FROM testimonials ORDER BY id DESC");
$testimonials_from_db = $stmt->fetchAll();
} catch (PDOException $e) {
$testimonials_from_db = [];
}
}
// Jika database kosong atau koneksi gagal, gunakan testimoni default/cadangan
if (empty($testimonials_from_db)) {
$testimonials_from_db = [
[
"stars" => 5,
"text" => "PT Hilton Tours Travel memudahkan perjalanan internasional saya dengan tenang tanpa kendala. Harga tiket sangat kompetitif dan layanannya sangat ramah.",
"name" => "Amanda T.",
"location" => "Jakarta"
],
[
"stars" => 5,
"text" => "Saya memesan tiket domestik ke Bali lewat PT Hilton Tours Travel dan mendapatkan harga promo terbaik. Prosesnya cepat, transparan, dan profesional.",
"name" => "Kevin R.",
"location" => "Tangerang"
],
[
"stars" => 5,
"text" => "Saya memesan tiket penerbangan kelas Bisnis dan didukung pelayanan yang responsif dan sangat membantu. Sangat direkomendasikan!",
"name" => "Michael S.",
"location" => "Bekasi"
]
];
}
// ==========================================
// INTEGRASI DATABASE KAMPANYE DISKON (DARI PANEL ADMIN)
// ==========================================
$global_flight_discount = null;
if ($db_connected) {
try {
// Melakukan kueri untuk mengambil diskon global 'ALL' jika aktif
$stmt_disc = $pdo->prepare("SELECT * FROM flight_discounts WHERE airline_code = 'ALL' AND is_active = 1 LIMIT 1");
$stmt_disc->execute();
$global_flight_discount = $stmt_disc->fetch();
} catch (PDOException $e) {
$global_flight_discount = null;
}
}
?>
<?php echo htmlspecialchars($site_title); ?>
Mitra Pemesanan Tiket Penerbangan Domestik Terpercaya Anda
Pemesanan Tiket Internasional Mudah dan Hemat
Masukan asli dan tulus dari para pelanggan kami di seluruh penjuru wilayah.
Rencanakan petualangan Anda hari ini bersama !
Dapatkan promo penerbangan terbaru, tips, serta ulasan destinasi terpopuler.
Konsultasikan kebutuhan rute perjalanan Anda secara gratis bersama sekarang!
![<?php echo htmlspecialchars($testi['name']); ?>](https://www.zephyrsholidays.com/wp-content/uploads/2026/05/User-Testimoni-3-70x70.png)
