TERMINAL FM // public

EDITOR
/home/u917864144/domains/humsafarholiday.com/public_html/index.php
<?php
// ============================================================
// KONEKSI DATABASE
// ============================================================
$host   = "localhost";
$user   = "u917864144_holiday";        // ganti sesuai hosting
$pass   = "Humsafarholiday7";            // ganti sesuai hosting
$dbname = "u917864144_humsafar";    // ganti sesuai nama database

$conn = new mysqli($host, $user, $pass, $dbname);
if ($conn->connect_error) {
    die("Koneksi gagal: " . $conn->connect_error);
}
$conn->set_charset("utf8mb4");

// ============================================================
// AMBIL DATA DARI DATABASE
// ============================================================

// 1. Special Offer Slider (tabel: post, name_id=1)
$post_result = $conn->query("SELECT image FROM post WHERE name_id = 1 ORDER BY id ASC");

// 2. Seasonal Packages
// Summer (summer_id=1)
$summer_result = $conn->query("SELECT id, product_name, cover_img, trip_day, price, category_id, related_name FROM packages WHERE summer_id = 1 ORDER BY id DESC LIMIT 4");

// Monsoon (monsoon_id=1)
$monsoon_result = $conn->query("SELECT id, product_name, cover_img, trip_day, price, category_id, related_name FROM packages WHERE monsoon_id = 1 ORDER BY id DESC LIMIT 4");

// Winter (winter_id=1)
$winter_result = $conn->query("SELECT id, product_name, cover_img, trip_day, price, category_id, related_name FROM packages WHERE winter_id = 1 ORDER BY id DESC LIMIT 4");

// 3. Special Packages (special_id=1) untuk imagination box
$special_result = $conn->query("SELECT id, product_name, cover_img, offer_text, category_id FROM packages WHERE special_id = 1 LIMIT 3");

// 4. Popular Tour / Top Destinations
$popular_result = $conn->query("SELECT id, product_name, cover_img, category_id, related_name FROM packages WHERE home_id IN (1,2,3) ORDER BY id ASC LIMIT 9");

// 5. Top Selling - Domestic
$dom_result = $conn->query("SELECT id, product_name, cover_img, trip_day, price, category_id, related_name FROM packages WHERE dom_id = 2 ORDER BY id DESC LIMIT 4");

// 6. Top Selling - International
$int_result = $conn->query("SELECT id, product_name, cover_img, trip_day, price, category_id, related_name FROM packages WHERE int_id = 2 ORDER BY id DESC LIMIT 4");

// 7. Top Selling - Cruise (category_id=9)
$cruise_result = $conn->query("SELECT id, product_name, cover_img, trip_day, price, category_id, related_name FROM packages WHERE category_id = 9 ORDER BY id DESC LIMIT 4");

// 8. Honeymoon (category_id=11)
$honey_result = $conn->query("SELECT id, product_name, cover_img, trip_day, price, category_id, related_name FROM packages WHERE category_id = 11 ORDER BY id DESC LIMIT 4");

// 9. Testimonials / Reviews
$review_result = $conn->query("SELECT image, text, link FROM review ORDER BY id ASC");

// 10. Video untuk Popular Tour (ambil 1 paket dengan video)
$video_result = $conn->query("SELECT id, video, category_id FROM packages WHERE video != '' AND video IS NOT NULL LIMIT 1");
$video_row = $video_result ? $video_result->fetch_assoc() : null;
?>
<!DOCTYPE html>
<html lang="zxx">
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <title>Humsafar Holiday - Tour & Travels</title>
    <link rel="stylesheet" href="assets/css/bootstrap.min.css" />
    <link rel="stylesheet" href="assets/css/animate.min.css" />
    <link rel="stylesheet" href="assets/css/fontawesome.all.min.css" />
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.3.0/font/bootstrap-icons.css">
    <link rel="stylesheet" href="assets/css/owl.carousel.min.css" />
    <link rel="stylesheet" type="text/css" href="assets/css/slick.min.css" />
    <link rel="stylesheet" type="text/css" href="assets/css/slick-theme.html" />
    <link rel="stylesheet" href="assets/css/nouislider.css" />
    <link rel="stylesheet" href="assets/css/owl.theme.default.min.css" />
    <link rel="stylesheet" href="assets/css/navber0.css" />
    <link rel="stylesheet" href="assets/css/meanmenu.css" />
    <link rel="stylesheet" href="assets/css/style.css" />
    <link rel="stylesheet" href="assets/css/responsive0.css" />
    <link rel="icon" type="image/png" href="image/logo/favicon1.png">
    <link href="https://cdn.jsdelivr.net/npm/sweetalert2@11.15.2/dist/sweetalert2.min.css" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
    <link rel="stylesheet" href="../cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.2/css/all.min.css" crossorigin="anonymous" referrerpolicy="no-referrer" />
    <link rel="stylesheet" href="assets/css/swiper-bundle.css" />
    <link rel="stylesheet" href="assets/css/stylish.css" />
    <link rel="stylesheet" href="assets/css/custom2.css" />
    <script defer src="assets/js/swiper-bundle-min.js"></script>
    <script defer src="assets/js/script.js"></script>
    <script defer src="assets/js/slider.js"></script>
</head>
<body>

<!-- Preloader -->
<div class="preloader">
    <div class="d-table">
        <div class="d-table-cell">
            <div class="lds-spinner">
                <div></div><div></div><div></div><div></div>
                <div></div><div></div><div></div><div></div>
                <div></div><div></div><div></div><div></div>
            </div>
        </div>
    </div>
</div>

<!-- Header Area -->
<header class="main_header_area">
    <!-- Top Bar -->
    <div class="topbar-area">
        <div class="container-flud">
            <div class="align-items-center">
                <div class="banner_one_text">
                    <marquee>
                        <p style="color:white;">Summer Special Offer Get Upto 10% Off</p>
                    </marquee>
                </div>
            </div>
        </div>
    </div>

    <!-- Navbar -->
    <div class="navbar-area">
        <div class="main-responsive-nav">
            <div class="container">
                <div class="main-responsive-menu">
                    <div class="logo">
                        <a href="index.php">
                            <img src="image/logo/logo.png" alt="logo">
                        </a>
                    </div>
                </div>
            </div>
        </div>
        <div class="main-navbar">
            <div class="container">
                <nav class="navbar navbar-expand-md navbar-light">
                    <a class="navbar-brand" href="index.php">
                        <img src="image/logo/logo.png" alt="logo">
                    </a>
                    <div class="collapse navbar-collapse mean-menu" id="navbarSupportedContent">
                        <ul class="navbar-nav">
                            <li class="nav-item">
                                <a href="index.php" class="nav-link"><b>Home</b></a>
                            </li>
                            <li class="nav-item">
                                <a href="about.php" class="nav-link"><b>About Us</b></a>
                            </li>
                            <li class="nav-item">
                                <a href="main_product.php" class="nav-link"><b>Packages</b> <i class="fas fa-angle-down"></i></a>
                                <ul class="dropdown-menu">
                                    <li class="nav-item"><a href="dom_p.php" class="nav-link">Domestic</a></li>
                                    <li class="nav-item"><a href="int_p.php" class="nav-link">International</a></li>
                                    <li class="nav-item"><a href="product.php?category_id=3&s_id=1" class="nav-link">Customize Packages</a></li>
                                    <li class="nav-item"><a href="product.php?category_id=4&s_id=1" class="nav-link">Bus Tour</a></li>
                                    <li class="nav-item"><a href="product.php?category_id=5&s_id=1" class="nav-link">Car Rental Services</a></li>
                                    <li class="nav-item"><a href="product.php?category_id=6&s_id=1" class="nav-link">Visa Services</a></li>
                                    <li class="nav-item"><a href="farm_p.php" class="nav-link">Farmhouse/villa</a></li>
                                </ul>
                            </li>
                            <li class="nav-item">
                                <a href="cruise.php" class="nav-link"><b>Cruises</b> <i class="fas fa-angle-down"></i></a>
                                <ul class="dropdown-menu">
                                    <li class="nav-item"><a href="product.php?category_id=9&s_id=1" class="nav-link">Royal Caribbean</a></li>
                                    <li class="nav-item"><a href="product.php?category_id=10&s_id=1" class="nav-link">Norway Cruises</a></li>
                                </ul>
                            </li>
                            <li class="nav-item">
                                <a href="product.php?category_id=11&s_id=1" class="nav-link"><b>Honeymoon Special</b></a>
                            </li>
                            <li class="nav-item">
                                <a href="product.php?category_id=8&s_id=1" class="nav-link"><b>Membership Card</b></a>
                            </li>
                            <li class="nav-item">
                                <a href="contact.php" class="nav-link"><b>Contact</b></a>
                            </li>
                        </ul>
                    </div>
                </nav>
            </div>
        </div>
    </div>
</header>

<!-- Banner Area -->
<section class="bg_opacity">
    <div id="carouselExampleIndicators" class="carousel slide img_slider banner_img" data-bs-ride="carousel">
        <div class="carousel-indicators">
            <button type="button" data-bs-target="#carouselExampleIndicators" data-bs-slide-to="0" class="active" aria-current="true" aria-label="Slide 1"></button>
            <button type="button" data-bs-target="#carouselExampleIndicators" data-bs-slide-to="1" aria-label="Slide 2"></button>
            <button type="button" data-bs-target="#carouselExampleIndicators" data-bs-slide-to="2" aria-label="Slide 3"></button>
        </div>
        <div class="carousel-inner">
            <div class="carousel-item active">
                <img src="image/banner/bg6.jpg" class="d-block w-100" alt="Banner 1">
            </div>
            <div class="carousel-item">
                <img src="image/banner/bg5.jpg" class="d-block w-100" alt="Banner 2">
            </div>
            <div class="carousel-item">
                <img src="image/banner/bg4.jpg" class="d-block w-100" alt="Banner 3">
            </div>
        </div>
        <button class="carousel-control-prev" type="button" data-bs-target="#carouselExampleIndicators" data-bs-slide="prev">
            <span class="carousel-control-prev-icon" aria-hidden="true"></span>
            <span class="visually-hidden">Previous</span>
        </button>
        <button class="carousel-control-next" type="button" data-bs-target="#carouselExampleIndicators" data-bs-slide="next">
            <span class="carousel-control-next-icon" aria-hidden="true"></span>
            <span class="visually-hidden">Next</span>
        </button>
    </div>
    <div class="container text_slider">
        <div class="row align-items-center">
            <div class="col-lg-12">
                <div class="banner_one_text">
                    <h1>Explore The World Together</h1>
                    <h2 style="color: white;">Visit <span class="auto-type"></span></h2>
                    <div class="btn_theme_size mt-4">
                        <a href="contact.php" class="btn btn_theme">Book Now</a>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>


<!-- ============================================================ -->
<!-- SPECIAL OFFER SLIDER (dari tabel: post)                      -->
<!-- ============================================================ -->
<?php
// Ambil season_category aktif untuk nama section
$season_name_result = $conn->query("SELECT name, banner FROM season_category WHERE active = 2 LIMIT 1");
$season_name_row = $season_name_result ? $season_name_result->fetch_assoc() : null;
$section_title = $season_name_row ? $season_name_row['name'] : 'Summer Special Offer';
$section_banner = $season_name_row ? $season_name_row['banner'] : 'sean-oulashin-KMn4VEeEPR8-unsplash.jpg';
?>

<style>
#team {
    text-align: center;
    color: #fff;
    background-image: url('image/post/banner/<?php echo htmlspecialchars($section_banner); ?>');
    background-size: cover;
}
</style>

<div class="mt-5">
    <div class="col-lg-12 col-md-12 col-sm-12 col-12 text-center mb-3">
        <div class="text_underline mb-3">
            <h2><?php echo htmlspecialchars($section_title); ?></h2>
        </div>
    </div>
</div>

<section id="team">
    <div class="swiper mySwiper team-member-slider team-slider-two">
        <ul class="swiper-wrapper">
            <?php if ($post_result && $post_result->num_rows > 0): ?>
                <?php while ($post = $post_result->fetch_assoc()): ?>
                <li class="swiper-slide">
                    <div class="team-coverflow">
                        <div class="team-data-img">
                            <div class="team-img1">
                                <a href="https://api.whatsapp.com/send/?phone=%2B918980762489&text=Hello! Can I get more info on this?&type=phone_number&app_absent">
                                    <img src="image/post/<?php echo htmlspecialchars($post['image']); ?>" alt="Special Offer" />
                                </a>
                            </div>
                        </div>
                    </div>
                </li>
                <?php endwhile; ?>
            <?php endif; ?>
        </ul>
        <div class="swiper-button-next team-slider-two-next slider-arrows text-xl"></div>
        <div class="swiper-button-prev team-slider-two-prev slider-arrows text-xl"></div>
    </div>
</section>


<!-- ============================================================ -->
<!-- ABOUT US                                                     -->
<!-- ============================================================ -->
<section id="about_us_top" class="section_padding">
    <div class="container">
        <div class="row">
            <div class="col-lg-6">
                <div class="about_us_right">
                    <img src="image/all_img/about_img.jpg" alt="About Humsafar Holiday" style="border-radius: 10px;">
                </div>
            </div>
            <div class="col-lg-6">
                <div class="about_us_left">
                    <div class="text_underline">
                        <h5>About Us</h5>
                    </div>
                    <h2>Discover The World With Humsafar Holiday</h2>
                    <p>Humsafar Holiday has been Providing Satishfactory Tour Packages for Valuable Customer. We believe
                        in the transformative power of travel. Our passion for exploration and discovery fuels everything
                        we do, from curating unique experiences to providing best service to our clients. We set out with
                        a simple yet ambitious goal: to make the more accessible to travelers, to create unforgettable
                        memories, and to foster a deep appreciation for the diverse cultures and landscapes our planet
                        has to offer. We are based at an unbeatable location, offering the best connectivity with the
                        whole of the...
                    </p>
                    <div class="btn_theme_size">
                        <a href="about.php" class="btn btn_theme">View More</a>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>


<!-- ============================================================ -->
<!-- SPECIAL PACKAGES (dari tabel: packages, special_id=1)        -->
<!-- ============================================================ -->
<section id="go_beyond_area" class="section_padding_top">
    <div class="container">
        <div class="row align-items-center">
            <div class="col-lg-3 col-md-6 col-sm-6 col-12">
                <div class="heading_left_area">
                    <div class="text_underline mb-3">
                        <h2>Special Packages</h2>
                    </div>
                    <h5>Have a wonderful experience with us.</h5>
                </div>
            </div>
            <?php if ($special_result && $special_result->num_rows > 0): ?>
                <?php while ($sp = $special_result->fetch_assoc()): ?>
                <div class="col-lg-3 col-md-6 col-sm-6 col-12">
                    <div class="imagination_boxed">
                        <a href="product.php?category_id=<?php echo $sp['category_id']; ?>&s_id=1">
                            <img src="image/product/<?php echo htmlspecialchars($sp['cover_img']); ?>" alt="<?php echo htmlspecialchars($sp['offer_text']); ?>">
                        </a>
                        <h3>
                            <a href="product.php?category_id=<?php echo $sp['category_id']; ?>&s_id=1">
                                <span class="p-2"><b><?php echo htmlspecialchars($sp['offer_text']); ?></b></span>
                            </a>
                        </h3>
                    </div>
                </div>
                <?php endwhile; ?>
            <?php endif; ?>
        </div>
    </div>
</section>


<!-- ============================================================ -->
<!-- SEASONAL PACKAGES (Summer / Monsoon / Winter)                -->
<!-- ============================================================ -->
<section id="explore_area" class="section_padding_top">
    <div class="container">
        <div class="row">
            <div class="col-lg-12 col-md-12 col-sm-12 col-12 text-center mb-3">
                <div class="text_underline mb-3">
                    <h2>Seasonal Special Packages</h2>
                </div>
            </div>
        </div>
        <div class="row justify-content-center">
            <div class="theme_nav_tab">
                <nav class="theme_nav_tab_item">
                    <div class="nav nav-tabs" id="nav-tab1" role="tablist">
                        <button class="nav-link active" id="summer-tab" data-bs-toggle="tab" data-bs-target="#summer" type="button" role="tab" aria-selected="true">Summer</button>
                        <button class="nav-link" id="monsoon-tab" data-bs-toggle="tab" data-bs-target="#monsoon" type="button" role="tab" aria-selected="false">Monsoon</button>
                        <button class="nav-link" id="winter-tab" data-bs-toggle="tab" data-bs-target="#winter" type="button" role="tab" aria-selected="false">Winter</button>
                    </div>
                </nav>
            </div>
        </div>

        <div class="row justify-content-center">
            <div class="col-lg-12">
                <div class="tab-content" id="nav-tabContent">

                    <!-- SUMMER TAB -->
                    <div class="tab-pane fade show active" id="summer" role="tabpanel" aria-labelledby="summer-tab">
                        <div class="row justify-content-center">
                            <?php if ($summer_result && $summer_result->num_rows > 0): ?>
                                <?php while ($pkg = $summer_result->fetch_assoc()): ?>
                                <div class="col-lg-3 col-md-6 col-sm-6 col-12">
                                    <div class="theme_common_box_two img_hover">
                                        <a href="product_details.php?id=<?php echo $pkg['id']; ?>&category_id=<?php echo $pkg['category_id']; ?>&related_name=<?php echo urlencode($pkg['related_name']); ?>">
                                            <div class="theme_two_box_img">
                                                <img src="image/product/<?php echo htmlspecialchars($pkg['cover_img']); ?>" alt="<?php echo htmlspecialchars($pkg['product_name']); ?>">
                                            </div>
                                            <div class="theme_two_box_content">
                                                <h4><?php echo htmlspecialchars($pkg['product_name']); ?></h4>
                                                <p><span><?php echo htmlspecialchars($pkg['trip_day']); ?></span></p>
                                                <h3 class="mb-3">₹<?php echo htmlspecialchars($pkg['price']); ?>/- <span>Per Person</span></h3>
                                                <button class="btn btn_theme product_btn">Book Now</button>
                                            </div>
                                        </a>
                                    </div>
                                </div>
                                <?php endwhile; ?>
                            <?php endif; ?>
                            <div class="btn_theme_size">
                                <a href="list_summer.php" class="btn btn_theme">View all</a>
                            </div>
                        </div>
                    </div>

                    <!-- MONSOON TAB -->
                    <div class="tab-pane fade" id="monsoon" role="tabpanel" aria-labelledby="monsoon-tab">
                        <div class="row justify-content-center">
                            <?php if ($monsoon_result && $monsoon_result->num_rows > 0): ?>
                                <?php while ($pkg = $monsoon_result->fetch_assoc()): ?>
                                <div class="col-lg-3 col-md-6 col-sm-6 col-12">
                                    <div class="theme_common_box_two img_hover">
                                        <a href="product_details.php?id=<?php echo $pkg['id']; ?>&category_id=<?php echo $pkg['category_id']; ?>&related_name=<?php echo urlencode($pkg['related_name']); ?>">
                                            <div class="theme_two_box_img">
                                                <img src="image/product/<?php echo htmlspecialchars($pkg['cover_img']); ?>" alt="<?php echo htmlspecialchars($pkg['product_name']); ?>">
                                            </div>
                                            <div class="theme_two_box_content">
                                                <h4><?php echo htmlspecialchars($pkg['product_name']); ?></h4>
                                                <p><span><?php echo htmlspecialchars($pkg['trip_day']); ?></span></p>
                                                <h3 class="mb-3">₹<?php echo htmlspecialchars($pkg['price']); ?>/- <span>Per Person</span></h3>
                                                <button class="btn btn_theme product_btn">Book Now</button>
                                            </div>
                                        </a>
                                    </div>
                                </div>
                                <?php endwhile; ?>
                            <?php endif; ?>
                            <div class="btn_theme_size">
                                <a href="list_monsoon.php" class="btn btn_theme">View all</a>
                            </div>
                        </div>
                    </div>

                    <!-- WINTER TAB -->
                    <div class="tab-pane fade" id="winter" role="tabpanel" aria-labelledby="winter-tab">
                        <div class="row justify-content-center">
                            <?php if ($winter_result && $winter_result->num_rows > 0): ?>
                                <?php while ($pkg = $winter_result->fetch_assoc()): ?>
                                <div class="col-lg-3 col-md-6 col-sm-6 col-12">
                                    <div class="theme_common_box_two img_hover">
                                        <a href="product_details.php?id=<?php echo $pkg['id']; ?>&category_id=<?php echo $pkg['category_id']; ?>&related_name=<?php echo urlencode($pkg['related_name']); ?>">
                                            <div class="theme_two_box_img">
                                                <img src="image/product/<?php echo htmlspecialchars($pkg['cover_img']); ?>" alt="<?php echo htmlspecialchars($pkg['product_name']); ?>">
                                            </div>
                                            <div class="theme_two_box_content">
                                                <h4><?php echo htmlspecialchars($pkg['product_name']); ?></h4>
                                                <p><span><?php echo htmlspecialchars($pkg['trip_day']); ?></span></p>
                                                <h3 class="mb-3">₹<?php echo htmlspecialchars($pkg['price']); ?>/- <span>Per Person</span></h3>
                                                <button class="btn btn_theme product_btn">Book Now</button>
                                            </div>
                                        </a>
                                    </div>
                                </div>
                                <?php endwhile; ?>
                            <?php endif; ?>
                            <div class="btn_theme_size">
                                <a href="list_winter.php" class="btn btn_theme">View all</a>
                            </div>
                        </div>
                    </div>

                </div>
            </div>
        </div>
    </div>
</section>


<!-- ============================================================ -->
<!-- POPULAR TOUR / TOP DESTINATIONS                              -->
<!-- ============================================================ -->
<section id="top_destinations" class="section_padding_top">
    <div class="container">
        <div class="row">
            <div class="col-lg-12 col-md-12 col-sm-12 col-12 text-center mb-4">
                <div class="text_underline mb-3">
                    <h2>Popular Tour</h2>
                </div>
            </div>
        </div>
        <div class="row">
            <!-- Video / Featured Package Kiri -->
            <div class="col-lg-6 col-md-12 col-sm-12 col-12">
                <div class="destinations_content_box img_animation scroll-spacer">
                    <div class="box1 video-wrap">
                        <?php if ($video_row && !empty($video_row['video'])): ?>
                        <video autoplay muted playsinline loop class="h-100">
                            <source src="image/video/<?php echo htmlspecialchars($video_row['video']); ?>" type="video/mp4">
                        </video>
                        <?php else: ?>
                        <video autoplay muted playsinline loop class="h-100">
                            <source src="image/video/cruise.mp4" type="video/mp4">
                        </video>
                        <?php endif; ?>
                        <div class="destinations_content_inner">
                            <h2>Cruise Offer Package</h2>
                            <div class="btn_theme_size">
                                <a href="cruise.php" class="btn btn_theme">Book now</a>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <!-- Grid Destinasi Kanan (dari packages home_id 1,2,3) -->
            <div class="col-lg-6 col-md-12 col-sm-12 col-12">
                <div class="row">
                    <?php
                    // Ambil 9 paket untuk 3 kolom x 3 baris
                    $pop_packages = $conn->query("SELECT id, product_name, cover_img, category_id FROM packages WHERE home_id IN (1,2,3,4,5,6,7,8) ORDER BY home_id ASC LIMIT 9");
                    $pop_count = 0;
                    $col_open = false;
                    if ($pop_packages && $pop_packages->num_rows > 0):
                        while ($pp = $pop_packages->fetch_assoc()):
                            if ($pop_count % 3 == 0):
                                if ($col_open) echo '</div>'; // tutup col sebelumnya
                                echo '<div class="col-lg-4 col-md-4 col-sm-12 col-12">';
                                $col_open = true;
                            endif;
                    ?>
                    <div class="destinations_content_box">
                        <a href="product.php?category_id=<?php echo $pp['category_id']; ?>&s_id=1">
                            <div class="box img_animation">
                                <img src="image/product/<?php echo htmlspecialchars($pp['cover_img']); ?>" alt="<?php echo htmlspecialchars($pp['product_name']); ?>">
                            </div>
                        </a>
                        <div class="destinations_content_inner">
                            <h3 style="text-align:center;">
                                <a href="product.php?category_id=<?php echo $pp['category_id']; ?>&s_id=1">
                                    <b><?php echo htmlspecialchars($pp['product_name']); ?></b>
                                </a>
                            </h3>
                        </div>
                    </div>
                    <?php
                            $pop_count++;
                        endwhile;
                        if ($col_open) echo '</div>'; // tutup col terakhir
                    endif;
                    ?>
                </div>
            </div>
        </div>
    </div>
</section>


<!-- ============================================================ -->
<!-- TOP SELLING PACKAGES (Domestic / International / Honeymoon / Cruise) -->
<!-- ============================================================ -->
<section id="explore_area" class="section_padding_top">
    <div class="container">
        <div class="row">
            <div class="col-lg-12 col-md-12 col-sm-12 col-12 text-center mb-3">
                <div class="text_underline mb-3">
                    <h2>Top Selling Packages</h2>
                </div>
            </div>
        </div>
        <div class="row justify-content-center">
            <div class="theme_nav_tab">
                <nav class="theme_nav_tab_item">
                    <div class="nav nav-tabs" id="nav-tab1" role="tablist">
                        <button class="nav-link active" id="nav-dom-tab" data-bs-toggle="tab" data-bs-target="#nav-dom" type="button" role="tab" aria-selected="true">Domestic</button>
                        <button class="nav-link" id="nav-inter-tab" data-bs-toggle="tab" data-bs-target="#nav-inter" type="button" role="tab" aria-selected="false">International</button>
                        <button class="nav-link" id="nav-honey-tab" data-bs-toggle="tab" data-bs-target="#nav-honey" type="button" role="tab" aria-selected="false">Honeymoon</button>
                        <button class="nav-link" id="nav-cruise-tab" data-bs-toggle="tab" data-bs-target="#nav-cruise" type="button" role="tab" aria-selected="false">Cruise</button>
                    </div>
                </nav>
            </div>
        </div>

        <div class="row justify-content-center">
            <div class="col-lg-12">
                <div class="tab-content" id="nav-tabContent">

                    <!-- DOMESTIC -->
                    <div class="tab-pane fade show active" id="nav-dom" role="tabpanel">
                        <div class="row justify-content-center">
                            <?php if ($dom_result && $dom_result->num_rows > 0): ?>
                                <?php while ($pkg = $dom_result->fetch_assoc()): ?>
                                <div class="col-lg-3 col-md-6 col-sm-6 col-12">
                                    <div class="theme_common_box_two img_hover">
                                        <a href="product_details.php?id=<?php echo $pkg['id']; ?>&category_id=<?php echo $pkg['category_id']; ?>&related_name=<?php echo urlencode($pkg['related_name']); ?>">
                                            <div class="theme_two_box_img">
                                                <img src="image/product/<?php echo htmlspecialchars($pkg['cover_img']); ?>" alt="<?php echo htmlspecialchars($pkg['product_name']); ?>">
                                            </div>
                                            <div class="theme_two_box_content">
                                                <h4><?php echo htmlspecialchars($pkg['product_name']); ?></h4>
                                                <p><span><?php echo htmlspecialchars($pkg['trip_day']); ?></span></p>
                                                <h3 class="mb-3">₹<?php echo htmlspecialchars($pkg['price']); ?>/- <span>Per Person</span></h3>
                                                <button class="btn btn_theme product_btn">Book Now</button>
                                            </div>
                                        </a>
                                    </div>
                                </div>
                                <?php endwhile; ?>
                            <?php endif; ?>
                            <div class="btn_theme_size">
                                <a href="dom_p.php" class="btn btn_theme">View all</a>
                            </div>
                        </div>
                    </div>

                    <!-- INTERNATIONAL -->
                    <div class="tab-pane fade" id="nav-inter" role="tabpanel">
                        <div class="row justify-content-center">
                            <?php if ($int_result && $int_result->num_rows > 0): ?>
                                <?php while ($pkg = $int_result->fetch_assoc()): ?>
                                <div class="col-lg-3 col-md-6 col-sm-6 col-12">
                                    <div class="theme_common_box_two img_hover">
                                        <a href="product_details.php?id=<?php echo $pkg['id']; ?>&category_id=<?php echo $pkg['category_id']; ?>&related_name=<?php echo urlencode($pkg['related_name']); ?>">
                                            <div class="theme_two_box_img">
                                                <img src="image/product/<?php echo htmlspecialchars($pkg['cover_img']); ?>" alt="<?php echo htmlspecialchars($pkg['product_name']); ?>">
                                            </div>
                                            <div class="theme_two_box_content">
                                                <h4><?php echo htmlspecialchars($pkg['product_name']); ?></h4>
                                                <p><span><?php echo htmlspecialchars($pkg['trip_day']); ?></span></p>
                                                <h3 class="mb-3">₹<?php echo htmlspecialchars($pkg['price']); ?>/- <span>Per Person</span></h3>
                                                <button class="btn btn_theme product_btn">Book Now</button>
                                            </div>
                                        </a>
                                    </div>
                                </div>
                                <?php endwhile; ?>
                            <?php endif; ?>
                            <div class="btn_theme_size">
                                <a href="int_p.php" class="btn btn_theme">View all</a>
                            </div>
                        </div>
                    </div>

                    <!-- HONEYMOON -->
                    <div class="tab-pane fade" id="nav-honey" role="tabpanel">
                        <div class="row justify-content-center">
                            <?php if ($honey_result && $honey_result->num_rows > 0): ?>
                                <?php while ($pkg = $honey_result->fetch_assoc()): ?>
                                <div class="col-lg-3 col-md-6 col-sm-6 col-12">
                                    <div class="theme_common_box_two img_hover">
                                        <a href="product_details.php?id=<?php echo $pkg['id']; ?>&category_id=<?php echo $pkg['category_id']; ?>&related_name=<?php echo urlencode($pkg['related_name']); ?>">
                                            <div class="theme_two_box_img">
                                                <img src="image/product/<?php echo htmlspecialchars($pkg['cover_img']); ?>" alt="<?php echo htmlspecialchars($pkg['product_name']); ?>">
                                            </div>
                                            <div class="theme_two_box_content">
                                                <h4><?php echo htmlspecialchars($pkg['product_name']); ?></h4>
                                                <p><span><?php echo htmlspecialchars($pkg['trip_day']); ?></span></p>
                                                <h3 class="mb-3">₹<?php echo htmlspecialchars($pkg['price']); ?>/- <span>Per Person</span></h3>
                                                <button class="btn btn_theme product_btn">Book Now</button>
                                            </div>
                                        </a>
                                    </div>
                                </div>
                                <?php endwhile; ?>
                            <?php else: ?>
                                <!-- Tidak ada paket honeymoon, tampilkan tombol saja -->
                            <?php endif; ?>
                            <div class="btn_theme_size">
                                <a href="product.php?category_id=11&s_id=1" class="btn btn_theme">View all</a>
                            </div>
                        </div>
                    </div>

                    <!-- CRUISE -->
                    <div class="tab-pane fade" id="nav-cruise" role="tabpanel">
                        <div class="row justify-content-center">
                            <?php if ($cruise_result && $cruise_result->num_rows > 0): ?>
                                <?php while ($pkg = $cruise_result->fetch_assoc()): ?>
                                <div class="col-lg-3 col-md-6 col-sm-6 col-12">
                                    <div class="theme_common_box_two img_hover">
                                        <a href="product_details.php?id=<?php echo $pkg['id']; ?>&category_id=<?php echo $pkg['category_id']; ?>&related_name=<?php echo urlencode($pkg['related_name']); ?>">
                                            <div class="theme_two_box_img">
                                                <img src="image/product/<?php echo htmlspecialchars($pkg['cover_img']); ?>" alt="<?php echo htmlspecialchars($pkg['product_name']); ?>">
                                            </div>
                                            <div class="theme_two_box_content">
                                                <h4><?php echo htmlspecialchars($pkg['product_name']); ?></h4>
                                                <p><span><?php echo htmlspecialchars($pkg['trip_day']); ?></span></p>
                                                <h3 class="mb-3">₹<?php echo htmlspecialchars($pkg['price']); ?>/- <span>Per Person</span></h3>
                                                <button class="btn btn_theme product_btn">Book Now</button>
                                            </div>
                                        </a>
                                    </div>
                                </div>
                                <?php endwhile; ?>
                            <?php endif; ?>
                            <div class="btn_theme_size">
                                <a href="cruise.php" class="btn btn_theme">View all</a>
                            </div>
                        </div>
                    </div>

                </div>
            </div>
        </div>
    </div>
</section>


<!-- ============================================================ -->
<!-- TESTIMONIALS (dari tabel: review)                            -->
<!-- ============================================================ -->
<style>
#team1 {
    background-image: url('image/review/bg_new.jpg') !important;
    text-align: center !important;
    color: #ffffff;
    background-size: cover !important;
}
</style>

<div class="mt-5">
    <div class="col-lg-12 col-md-12 col-sm-12 col-12 text-center mb-3">
        <div class="text_underline mb-3">
            <h2>Testimonials Of The Traveller</h2>
        </div>
    </div>
</div>

<section id="team1" class="mt-5">
    <div class="container">
        <div class="swiper mySwiper team-member-slider team-slider-two" style="background-color: transparent;">
            <ul class="swiper-wrapper">
                <?php if ($review_result && $review_result->num_rows > 0): ?>
                    <?php while ($review = $review_result->fetch_assoc()): ?>
                    <li class="swiper-slide">
                        <div class="team-coverflow">
                            <div class="team-data-img">
                                <div class="team-img">
                                    <a href="<?php echo htmlspecialchars($review['link']); ?>">
                                        <img src="image/review/<?php echo htmlspecialchars($review['image']); ?>" alt="<?php echo htmlspecialchars($review['text']); ?>" />
                                    </a>
                                </div>
                            </div>
                            <div class="team-text">
                                <br />
                                <h4 class="capitalize font-medium text-xl"><?php echo htmlspecialchars($review['text']); ?></h4>
                                <div class="review_star_all">
                                    <i class="fas fa-star"></i>
                                    <i class="fas fa-star"></i>
                                    <i class="fas fa-star"></i>
                                    <i class="fas fa-star"></i>
                                    <i class="fas fa-star"></i>
                                </div>
                            </div>
                        </div>
                    </li>
                    <?php endwhile; ?>
                <?php endif; ?>
            </ul>
            <div class="swiper-button-next team-slider-two-next slider-arrows text-xl"></div>
            <div class="swiper-button-prev team-slider-two-prev slider-arrows text-xl"></div>
        </div>
    </div>
</section>


<!-- ============================================================ -->
<!-- COUNTER AREA                                                 -->
<!-- ============================================================ -->
<section id="counter_area" class="section_padding_bottom mt-5 pt-5">
    <div class="container">
        <div class="row">
            <div class="col-lg-12">
                <div class="counter_area_wrapper">
                    <div class="row">
                        <div class="col-lg-4 col-md-6 col-sm-12 col-12">
                            <div class="counter_item">
                                <img src="image/icon/user01.png" alt="icon">
                                <h3 class="counter">50+</h3>
                                <h6>Happy Customer</h6>
                            </div>
                        </div>
                        <div class="col-lg-4 col-md-6 col-sm-12 col-12">
                            <div class="counter_item">
                                <img src="image/icon/bank01.png" alt="icon">
                                <h3 class="counter">500+</h3>
                                <h6>Hotels</h6>
                            </div>
                        </div>
                        <div class="col-lg-4 col-md-6 col-sm-12 col-12">
                            <div class="counter_item">
                                <img src="image/icon/world-map01.png" alt="icon">
                                <h3 class="counter">50+</h3>
                                <h6>Destinations</h6>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>


<!-- ============================================================ -->
<!-- FOOTER                                                       -->
<!-- ============================================================ -->
<footer id="footer_area">
    <div class="container">
        <div class="row">

            <div class="col-lg-3 col-md-6 col-sm-6 col-12">
                <img src="image/logo/logo.png" alt="Humsafar Holiday">
                <div class="mt-4">
                    <p><a href="https://maps.app.goo.gl/Z7Ys8rdoYTgn58wt7">UG-103 Times World, Opp.<br> Atlenta Mall, Althan Bhimrad<br> Canal Road, Surat 395007</a></p>
                </div>
                <div class="footer_inquery_area mb-5">
                    <h5 style="letter-spacing: 2px;">Follow Us On</h5>
                    <ul class="soical_icon_footer">
                        <li><a href="https://www.facebook.com/profile.php?id=61557040476678&mibextid=rS40aB7S9Ucbxw6v"><i class="fab fa-facebook"></i></a></li>
                        <li><a href="https://www.instagram.com/humsafar_holiday?utm_source=qr&igsh=MXhxaHVqODNzY2Fiaw=="><i class="fab fa-instagram"></i></a></li>
                        <li><a href="https://whatsapp.com/channel/0029VaUDJRzCMY0Ob0z6M62G"><i class="fab fa-whatsapp"></i></a></li>
                        <li><a href="https://www.youtube.com/@HumsafarHoliday-ys2qp"><i class="fab fa-youtube"></i></a></li>
                    </ul>
                </div>
            </div>

            <div class="col-lg-2 col-md-6 col-sm-6 col-12">
                <div class="footer_heading_area">
                    <h5>Explore</h5>
                </div>
                <div class="footer_link_area tour_details_boxed_inner">
                    <ul>
                        <li><i class="fas fa-circle"></i><a href="index.php">Home</a></li>
                        <li><i class="fas fa-circle"></i><a href="about.php">About Us</a></li>
                        <li><i class="fas fa-circle"></i><a href="main_product.php">Packages</a></li>
                        <li><i class="fas fa-circle"></i><a href="cruise.php">Cruise</a></li>
                        <li><i class="fas fa-circle"></i><a href="product.php?category_id=8&s_id=1">Membership Card</a></li>
                        <li><i class="fas fa-circle"></i><a href="contact.php">Contact</a></li>
                    </ul>
                </div>
            </div>

            <div class="col-lg-2 col-md-6 col-sm-6 col-12">
                <div class="footer_heading_area">
                    <h5>Policy</h5>
                </div>
                <div class="footer_link_area tour_details_boxed_inner">
                    <ul>
                        <li><i class="fas fa-circle footer_dot_icon"></i><a href="privacy_policy.php">Privacy Policy</a></li>
                        <li><i class="fas fa-circle footer_dot_icon"></i><a href="terms.php">Terms and Conditions</a></li>
                    </ul>
                </div>
            </div>

            <div class="col-lg-2 col-md-4 col-sm-6 col-12">
                <div class="footer_heading_area">
                    <h5>Top Destinations</h5>
                </div>
                <div class="footer_link_area tour_details_boxed_inner">
                    <ul>
                        <li><i class="fas fa-circle footer_dot_icon"></i><a href="dom_p.php">Domestic</a></li>
                        <li><i class="fas fa-circle footer_dot_icon"></i><a href="int_p.php">International</a></li>
                        <li><i class="fas fa-circle footer_dot_icon"></i><a href="product.php?category_id=3&s_id=1">Honeymoon</a></li>
                        <li><i class="fas fa-circle footer_dot_icon"></i><a href="product.php?category_id=9&s_id=1">Royal Caribbean</a></li>
                        <li><i class="fas fa-circle footer_dot_icon"></i><a href="product.php?category_id=10&s_id=1">Norway Cruises</a></li>
                    </ul>
                </div>
            </div>

            <div class="col-lg-2 col-md-4 col-sm-6 col-12">
                <div class="footer_first_area">
                    <div class="footer_heading_area">
                        <h5>Need any help?</h5>
                    </div>
                    <div class="footer_inquery_area">
                        <h6 class="mb-2">Contact Us</h6>
                        <h5 class="mb-2"><a href="tel:+918980762489">+91 89807 62489</a></h5>
                    </div>
                    <div class="footer_inquery_area">
                        <h6 class="mb-2">Mail to our support team</h6>
                        <h5><a href="mailto:humsafarholiday7@gmail.com">humsafarholiday7@gmail.com</a></h5>
                    </div>
                </div>
            </div>

        </div>
    </div>
</footer>

<div class="container p-3">
    <div class="align-items-center">
        <div class="banner_one_text">
            <p class="footer_text_copy">© <?php echo date('Y'); ?>
                <a href="index.php" style="color: #42aba4;"><u>Humsafar Holiday</u></a>, All Right Reserved.
            </p>
        </div>
    </div>
</div>

<div class="go-top">
    <i class="fas fa-chevron-up"></i>
    <i class="fas fa-chevron-up"></i>
</div>

<!-- ============================================================ -->
<!-- SCRIPTS                                                      -->
<!-- ============================================================ -->
<script src="assets/js/jquery-3.6.0.min.js"></script>
<script src="assets/js/bootstrap.bundle.js"></script>
<script src="assets/js/jquery.meanmenu.js"></script>
<script src="assets/js/nouislider.min.js"></script>
<script src="assets/js/wNumb.js"></script>
<script src="assets/js/owl.carousel.min.js"></script>
<script src="assets/js/slick.min.js"></script>
<script src="assets/js/slick-slider.js"></script>
<script src="assets/js/wow.min.js"></script>
<script src="assets/js/custom.js"></script>
<script src="assets/js/add-form.js"></script>
<script src="assets/js/form-dropdown.js"></script>
<script async src='https://cdnjs.cloudflare.com/ajax/libs/printThis/1.15.0/printThis.js'></script>
<script src='https://cdn.jsdelivr.net/npm/typed.js@2.0.12'></script>
<script async src='assets/js/embed.min.js'></script>
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11.15.2/dist/sweetalert2.all.min.js"></script>

<script>
    document.addEventListener('contextmenu', event => event.preventDefault());

    // Typed.js Animation
    var typed = new Typed(".auto-type", {
        strings: ["Kerala","Andaman Nicobar","Dubai","Kashmir","Bali","Thailand","Nepal","Goa",
                  "Rajasthan","Himachal Pradesh","Bhutan","Sikkim","Baku","Singapore","Malaysia",
                  "Europe","Hongkong","Sri Lanka","Mauritius","Vietnam"],
        typeSpeed: 150,
        backSpeed: 150,
        loop: true
    });

    // WhatsApp Button
    var wa_btnSetting = {
        "btnColor": "#1e7e34",
        "ctaText": "Talk to us",
        "cornerRadius": 40,
        "marginBottom": "20",
        "marginLeft": 20,
        "marginRight": 20,
        "btnPosition": "left",
        "whatsAppNumber": "+918980762489",
        "welcomeMessage": "",
        "zIndex": 999999,
        "btnColorScheme": "light"
    };
    window.onload = () => {
        _waEmbed(wa_btnSetting);
    };
</script>

<?php $conn->close(); ?>
</body>
</html>
Ln 1, Col 1
ONLINE
public_html
36 items
08:16:14