1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / jeffautomobileinc.com /
Filename : index.php
back
<?php
session_start();
error_reporting(0);
include('../config/jaconfig.php');
include 'includes/header.php';   
?>
<?php 
$user_id=$_SESSION['userid'];

if (isset($_SESSION['userid'])) {
    $uid = $_SESSION['userid'];

    // Prepare SQL statement to avoid SQL injection
    $stmt = $con->prepare("SELECT * FROM `user_info` WHERE `user_id` = ?");
    $stmt->bind_param('i', $uid); // Bind parameter as integer
    $stmt->execute();
    $result = $stmt->get_result();
    $row = $result->fetch_assoc();
    $first_name = $row['first_name'];
    $currency = $row['currency'];
    $stmt->close();
} else {
    // Default currency if user session is not set
    $currency = '£';
}

// Fallback to pounds if currency is not set or empty
if (empty($currency)) {
    $currency = '£';
}
?>
 
 <main class="main">
        <section class="home-slider position-relative mb-30">
            <div class="container">
                <div class="home-slide-cover mt-30">
                    <div class="hero-slider-1 style-4 dot-style-1 dot-style-1-position-1">
                        <div class="single-hero-slider single-animation-wrap" style="background-image: url(images/1.jpg)">
                            <div class="slider-content">
                                <h1 class="display-2 mb-40 text-white">
                                    Don’t miss amazing<br>
                                    shopping deals
                                </h1>
                                <p class="mb-65 text-white">Amazing deals available when you shop with us</p>
                                <a href="catalog.php" class="btn" type="submit">Shop Now  <i class="icon-long-arrow-right"></i></a>
        
                            </div>
                        </div>
                        <div class="single-hero-slider single-animation-wrap" style="background-image: url(images/2.jpg)">
                            <div class="slider-content">
                                <h1 class="display-2 mb-40 text-white">
                                    Fresh Items<br>
                                    Big discount
                                </h1>
                                <p class="mb-65 text-white">Save up to 50% off on your first order</p>
                                <a href="catalog.php" class="btn" type="submit">Shop Now  <i class="icon-long-arrow-right"></i></a>
                            </div>
                        </div>
                    </div>
                    <div class="slider-arrow hero-slider-1-arrow"></div>
                </div>
            </div>
        </section>
        <!--End hero slider-->
        <section class="popular-categories section-padding">
            <div class="container wow animate__animated animate__fadeIn">
                <div class="section-title">
                    <div class="title">
                        <h3>Featured Categories</h3>
                        <ul class="list-inline nav nav-tabs links">
                        <?php 
                        $cat_query = "SELECT * FROM categories ORDER BY RAND() LIMIT 5";  // Randomize the order
                        $result = mysqli_query($con, $cat_query);
                        if (mysqli_num_rows($result) > 0) {
                            while ($row = mysqli_fetch_array($result)) {
                                // print_r($row);
                                $cat_id = $row['cat_id'];
                                $cat_name = $row['cat_title'];
                                ?>
                                <li class="list-inline-item nav-item">
                                    <a class="nav-link" href="products.php?cid=<?php echo $cat_id; ?>">
                                        <?php echo $cat_name; ?>
                                    </a>
                                </li>
                                <?php 
                            }
                        }
                        ?>							
                        </ul>
                    </div>
                    <div class="slider-arrow slider-arrow-2 flex-right carausel-10-columns-arrow" id="carausel-10-columns-arrows"></div>
                </div>
                <div class="carausel-10-columns-cover position-relative">
                    <div class="carausel-10-columns" id="carausel-10-columns">
                   <?php
$cat_query = "
    SELECT c.cat_id, c.cat_title,c.image, COUNT(p.product_id) AS product_count
    FROM categories c
    LEFT JOIN products p ON c.cat_id = p.product_cat_id
    GROUP BY c.cat_id
    ORDER BY RAND() LIMIT 10";  // Randomize the categories

$result = mysqli_query($con, $cat_query);
if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_array($result)) {
        $cat_id = $row['cat_id'];
        $cat_name = $row['cat_title'];
        $cat_image = $row['image'];
        $product_count = $row['product_count'];
        ?>
        <div class="card-2 bg-9 wow animate__animated animate__fadeInUp" data-wow-delay=".1s">
            <figure class="img-hover-scale overflow-hidden">
                <a href="products.php?cid=<?php echo $cat_id; ?>"><img src="admin/categories/<?php echo $cat_image?>" alt=""></a>
            </figure>
            <h6><a href="products.php?cid=<?php echo $cat_id; ?>"><?php echo $cat_name; ?></a></h6>
            <span><?php echo $product_count; ?> items</span>
        </div>
        <?php
    }
}
?>

                       
                    </div>
                </div>
            </div>
        </section>
        <!--End category slider-->
        <section class="banners mb-25">
            <div class="container">
                <div class="row">
                    <div class="col-lg-4 col-md-6">
                        <div class="banner-img wow animate__animated animate__fadeInUp" data-wow-delay="0">
                            <img src="images/4.jpg" alt="">
                            <div class="banner-text">
                            <h4 class="text-white">
                                Drive in Style &amp;<br>Comfort with Our<br>
                                Luxury Sedans
                            </h4>
                                <a href="catalog.php" class="btn btn-xs">Shop Now <i class="fi-rs-arrow-small-right"></i></a>
                            </div>
                        </div>
                    </div>
                    <div class="col-lg-4 col-md-6">
                        <div class="banner-img wow animate__animated animate__fadeInUp" data-wow-delay=".2s">
                            <img src="images/5.jpg" alt="">
                            <div class="banner-text">
                            <h4 class="text-white">
                            Genuine Car Parts<br>
                            for Every Need
                                </h4>
                                <a href="catalog.php" class="btn btn-xs">Shop Now <i class="fi-rs-arrow-small-right"></i></a>
                            </div>
                        </div>
                    </div>
                    <div class="col-lg-4 d-md-none d-lg-flex">
                        <div class="banner-img mb-sm-0 wow animate__animated animate__fadeInUp" data-wow-delay=".4s">
                            <img src="images/6.jpg" alt="">
                            <div class="banner-text">
                            <h4 class="text-white">
                                Embrace the Future<br>with Electric Cars
                            </h4>
                                <a href="catalog.php" class="btn btn-xs">Shop Now <i class="fi-rs-arrow-small-right"></i></a>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
        <!--End banners-->
        <section class="product-tabs section-padding position-relative">
            <div class="container">
                <div class="section-title style-2 wow animate__animated animate__fadeIn">
                    <h3 style="font-size:20px;">Popular Products</h3>
                    
                </div>
                <!--End nav-tabs-->
                <div class="tab-content" id="myTabContent">
                    <div class="tab-pane fade show active" id="tab-one" role="tabpanel" aria-labelledby="tab-one">
                        <div class="row product-grid-4">

                        <div class="row product-grid-4">
    <?php   
    $now = date('Y-m-d');
    $product_query = "SELECT * FROM `products` WHERE `status`='1' AND `product_tag` = 'LATEST' ORDER BY `product_id` DESC LIMIT 12";
    $result = mysqli_query($con, $product_query);

    // Fetch categories and dealers ahead of time
    $category_query = "SELECT * FROM categories";
    $category_result = mysqli_query($con, $category_query);
    $categories = [];
    while ($cat = mysqli_fetch_assoc($category_result)) {
        $categories[$cat['cat_id']] = $cat['cat_title']; // store category titles by ID
    }

    $dealer_query = "SELECT * FROM dealers";
    $dealer_result = mysqli_query($con, $dealer_query);
    $dealers = [];
    while ($dealer = mysqli_fetch_assoc($dealer_result)) {
        $dealers[$dealer['id']] = $dealer['name']; // store dealer names by ID
    }

    // Loop through products
    if (mysqli_num_rows($result) > 0) {
        while ($row = mysqli_fetch_assoc($result)) {
            $product_id = $row['product_id'];
            $product_cat_id = $row['product_cat_id'];
            $product_brand_id = $row['product_brand_id'];
            $product_title = $row['product_title'];
            $product_price = $row['product_price'];
            $product_desc = $row['product_desc'];
            $product_image = $row['product_image'];
            $product_keywords = $row['product_keywords'];
            $product_tag = $row['product_tag'];
            $product_availability = $row['availability'];
            $dealer_id = $row['dealer_id'];

            // Get the category name
            $category_name = isset($categories[$product_cat_id]) ? $categories[$product_cat_id] : 'Unknown Category';

            // Get the dealer name
            $dealer_name = isset($dealers[$dealer_id]) ? $dealers[$dealer_id] : 'Unknown Dealer';
    ?>
        <div class="col-lg-1-5 col-md-4 col-12 col-sm-6">
            <div class="product-cart-wrap mb-30 wow animate__animated animate__fadeIn" data-wow-delay=".1s">
                <div class="product-img-action-wrap">
                    <div class="product-img product-img-zoom">
                        <a href="product.php?id=<?php echo $product_id; ?>&cid=<?php echo $product_cat_id; ?>">
                            <img class="default-img" src="admin/uploads/<?php echo $product_image; ?>" alt="">
                        </a>
                    </div>
                    <?php if (isset($product_tag)) { ?>
                    <div class="product-badges product-badges-position product-badges-mrg">
                        <span class="hot" style="background:#510cd9;"><?php echo $product_tag; ?></span>
                    </div>
                    <?php } ?>
                </div>
                <div class="product-content-wrap">
                    <div class="product-category">
                        <a href="products.php?cid=<?php echo $product_cat_id; ?>">
                            <?php echo $category_name; ?>
                        </a>
                    </div>
                    <h2><a href="product.php?id=<?php echo $product_id; ?>&cid=<?php echo $product_cat_id; ?>"><?php echo $product_title; ?></a></h2>
                   
                    <?php
                    // Generate a random rating between 1.0 and 5.0 for each product
                    $random_rating = rand(35, 50) / 10; // Generates a random rating between 1.0 and 5.0
                    $rating_width = ($random_rating / 5) * 100; // Calculate the width percentage (out of 5)
                    ?>

<div class="product-rate-cover">
    <div class="product-rate d-inline-block">
        <!-- Dynamically adjust the width of the product rating -->
        <div class="product-rating" style="width: <?php echo $rating_width; ?>%"></div>
    </div>
    <!-- Display the random rating value -->
    <span class="font-small ml-5 text-muted"> (<?php echo number_format($random_rating, 1); ?>)</span>
</div>


                    <div>
                        <span class="font-small text-muted">By
                            <a href="store.php?store=<?php echo $dealer_name; ?>&dealer=<?php echo $dealer_id; ?>">
                                <?php echo $dealer_name; ?>
                            </a>
                        </span>
                    </div>
                    <div class="product-card-bottom">
                        <div class="product-price">
                            <span><?php echo $currency; ?><?php echo number_format($product_price, 2); ?></span>
                            <span class="old-price">
                                <?php 
                                $old_price = $product_price * 1.05;
                                echo $currency . number_format($old_price, 2); 
                                ?>
                            </span>
                        </div>
                        <div class="add-cart">
                        <a class="add" pid='<?php echo $product_id; ?>' id="product"><i class="fi-rs-shopping-cart mr-5"></i>Add </a>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    <?php 
        } 
    } else {
    ?>
        <div class="col-12 item empty-wrapper">
            <p class="home-empty">No products available yet!</p>
            <img src="images/empty.png" class="empty">
        </div>
    <?php 
    }
    ?>
</div>

                        </div>
                        <!--End product-grid-4-->
                    </div>
                    </div>

</section>
        <!--Products Tabs-->
        <section class="section-padding pb-5">
            <div class="container">
                <div class="section-title wow animate__animated animate__fadeIn">
                    <h3 class="">Trending</h3>
                   
                </div>
                <div class="row">
                    <div class="col-lg-3 d-none d-lg-flex wow animate__animated animate__fadeIn">
                        <div class="banner-img style-2">
                            <div class="banner-text">
                                <h2 class="mb-100">Bring nature into your home</h2>
                                <a href="catalog.php" class="btn btn-xs">Shop Now <i class="fi-rs-arrow-small-right"></i></a>
                            </div>
                        </div>
                    </div>
                    <div class="col-lg-9 col-md-12 wow animate__animated animate__fadeIn" data-wow-delay=".4s">
                        <div class="tab-content" id="myTabContent-1">
                            <div class="tab-pane fade show active" id="tab-one-1" role="tabpanel" aria-labelledby="tab-one-1">
                                <div class="carausel-4-columns-cover arrow-center position-relative">
                                    <div class="slider-arrow slider-arrow-2 carausel-4-columns-arrow" id="carausel-4-columns-arrows"></div>
                                    <div class="carausel-4-columns carausel-arrow-center" id="carausel-4-columns">
    <?php   
    $now = date('Y-m-d');
    $product_query = "SELECT * FROM `products` WHERE `status`='1' AND `product_tag` = 'HOT' ORDER BY `product_id` DESC LIMIT 12";
    $result = mysqli_query($con, $product_query);

    // Fetch categories and dealers ahead of time
    $category_query = "SELECT * FROM categories";
    $category_result = mysqli_query($con, $category_query);
    $categories = [];
    while ($cat = mysqli_fetch_assoc($category_result)) {
        $categories[$cat['cat_id']] = $cat['cat_title']; // store category titles by ID
    }

    $dealer_query = "SELECT * FROM dealers";
    $dealer_result = mysqli_query($con, $dealer_query);
    $dealers = [];
    while ($dealer = mysqli_fetch_assoc($dealer_result)) {
        $dealers[$dealer['id']] = $dealer['name']; // store dealer names by ID
    }

    // Loop through products
    if (mysqli_num_rows($result) > 0) {
        while ($row = mysqli_fetch_assoc($result)) {
            $product_id = $row['product_id'];
            $product_cat_id = $row['product_cat_id'];
            $product_brand_id = $row['product_brand_id'];
            $product_title = $row['product_title'];
            $product_price = $row['product_price'];
            $product_desc = $row['product_desc'];
            $product_image = $row['product_image'];
            $product_keywords = $row['product_keywords'];
            $product_tag = $row['product_tag'];
            $product_availability = $row['availability'];
            $dealer_id = $row['dealer_id'];

            // Get the category name
            $category_name = isset($categories[$product_cat_id]) ? $categories[$product_cat_id] : 'Unknown Category';

            // Get the dealer name
            $dealer_name = isset($dealers[$dealer_id]) ? $dealers[$dealer_id] : 'Unknown Dealer';
    ?>   
                                    
                                    <div class="product-cart-wrap">
                                            <div class="product-img-action-wrap">
                                                <div class="product-img product-img-zoom">
                                                    <a href="product.php?id=<?php echo $product_id; ?>&cid=<?php echo $product_cat_id; ?>">
                                                        <img class="default-img" src="admin/uploads/<?php echo $product_image; ?>" alt="">
                                                        <img class="hover-img" src="admin/uploads/<?php echo $product_image; ?>" alt="">
                                                    </a>
                                                </div>
                                                <?php if (isset($product_tag)) { ?>
                                                <div class="product-badges product-badges-position product-badges-mrg">
                                                    <span class="hot" style="background:#510cd9;"><?php echo $product_tag; ?></span>
                                                </div>
                                                <?php } ?>
                                               
                                            </div>
                                            <div class="product-content-wrap">
                                                <div class="product-category">
                                                    <a href="products.php?cid=<?php echo $product_cat_id; ?>"><?php echo $category_name; ?></a>
                                                </div>
                                                <h2><a href="product.php?id=<?php echo $product_id; ?>&cid=<?php echo $product_cat_id; ?>"><?php echo $product_title; ?></a></h2>
                                               
                                                <?php
                                                // Generate a random rating between 1.0 and 5.0 for each product
                                                $random_rating = rand(35, 50) / 10; // Generates a random rating between 1.0 and 5.0
                                                $rating_width = ($random_rating / 5) * 100; // Calculate the width percentage (out of 5)
                                                ?>
                                    
                                                <div class="product-rate-cover">
                                                    <div class="product-rate d-inline-block">
                                                        <!-- Dynamically adjust the width of the product rating -->
                                                        <div class="product-rating" style="width: <?php echo $rating_width; ?>%"></div>
                                                    </div>
                                                    <!-- Display the random rating value -->
                                                    <span class="font-small ml-5 text-muted"> (<?php echo number_format($random_rating, 1); ?>)</span>
                                                </div>
                                                <div>
                                                <span class="font-small text-muted">By
                                                    <a href="store.php?store=<?php echo $dealer_name; ?>&dealer=<?php echo $dealer_id; ?>">
                                                        <?php echo $dealer_name; ?>
                                                    </a>
                                                </span>
                                            </div>
                                            <div class="product-card-bottom">
                                                    <div class="product-price">
                                                        <span><?php echo $currency; ?><?php echo number_format($product_price, 2); ?></span>
                                                        <span class="old-price">
                                                            <?php 
                                                            $old_price = $product_price * 1.05;
                                                            echo $currency . number_format($old_price, 2); 
                                                            ?>
                                                        </span>
                                                    </div>
                                                    <div class="add-cart">
                                                    <a class="add" pid='<?php echo $product_id; ?>' id="product"><i class="fi-rs-shopping-cart mr-5"></i>Add </a>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <!--End product Wrap-->
                                        
                    <?php 
        } 
    } else {
    ?>
        <div class="col-12 item empty-wrapper">
            <p class="home-empty">No products available yet!</p>
            <img src="images/empty.png" class="empty">
        </div>
    <?php 
    }
    ?>      
                                    </div>
                                </div>
                            </div>
                            <!--End tab-pane-->
                            
                    </div>
                    <!--End Col-lg-9-->
                </div>
            </div>
        </section>
       
        <section class="section-padding mb-30">
            <div class="container">
                <div class="row">
                    <div class="col-xl-3 col-lg-4 col-md-6 mb-sm-5 mb-md-0 wow animate__animated animate__fadeInUp" data-wow-delay="0">
                        <h4 class="section-title style-1 mb-30 animated animated">New Products</h4>
                        <div class="product-list-small animated animated">
                        <?php   
    $now = date('Y-m-d');
    $product_query = "SELECT * FROM `products` WHERE `status`='1' AND `product_tag` = 'NEW' ORDER BY `product_id` DESC LIMIT 5";
    $result = mysqli_query($con, $product_query);

    // Fetch categories and dealers ahead of time
    $category_query = "SELECT * FROM categories";
    $category_result = mysqli_query($con, $category_query);
    $categories = [];
    while ($cat = mysqli_fetch_assoc($category_result)) {
        $categories[$cat['cat_id']] = $cat['cat_title']; // store category titles by ID
    }

    $dealer_query = "SELECT * FROM dealers";
    $dealer_result = mysqli_query($con, $dealer_query);
    $dealers = [];
    while ($dealer = mysqli_fetch_assoc($dealer_result)) {
        $dealers[$dealer['id']] = $dealer['name']; // store dealer names by ID
    }

    // Loop through products
    if (mysqli_num_rows($result) > 0) {
        while ($row = mysqli_fetch_assoc($result)) {
            $product_id = $row['product_id'];
            $product_cat_id = $row['product_cat_id'];
            $product_brand_id = $row['product_brand_id'];
            $product_title = $row['product_title'];
            $product_price = $row['product_price'];
            $product_desc = $row['product_desc'];
            $product_image = $row['product_image'];
            $product_keywords = $row['product_keywords'];
            $product_tag = $row['product_tag'];
            $product_availability = $row['availability'];
            $dealer_id = $row['dealer_id'];

            // Get the category name
            $category_name = isset($categories[$product_cat_id]) ? $categories[$product_cat_id] : 'Unknown Category';

            // Get the dealer name
            $dealer_name = isset($dealers[$dealer_id]) ? $dealers[$dealer_id] : 'Unknown Dealer';
    ?> 
                            <article class="row align-items-center hover-up">
                                <figure class="col-md-4 mb-0">
                                    <a href="product.php?id=<?php echo $product_id; ?>&cid=<?php echo $product_cat_id; ?>"><img src="admin/uploads/<?php echo $product_image; ?>" alt=""></a>
                                </figure>
                                <div class="col-md-8 mb-0">
                                    <h6>
                                        <a href="product.php?id=<?php echo $product_id; ?>&cid=<?php echo $product_cat_id; ?>"><?php echo $product_title; ?></a>
                                    </h6>
                                    <div class="product-rate-cover">
                                        <div class="product-rate d-inline-block">
                                            <div class="product-rating" style="width: 90%"></div>
                                        </div>
                                        <span class="font-small ml-5 text-muted"></span>
                                    </div>
                                    <div class="product-price">
                                        <span><?php echo $currency; ?><?php echo number_format($product_price, 2); ?></span>
                                        <span class="old-price">
                                        <?php 
                                            $old_price = $product_price * 1.05;
                                            echo $currency . number_format($old_price, 2); 
                                        ?>
                                        </span>
                                    </div>
                                </div>
                            </article>

                            <?php 
                                    } 
                                } else {
                                ?>
                                    <div class="col-12 item empty-wrapper">
                                        <p class="home-empty">No products available yet!</p>
                                        <img src="images/empty.png" class="empty">
                                    </div>
                                <?php 
                                }
                                ?>
                                        
                           
                        </div>
                    </div>

                    <div class="col-xl-3 col-lg-4 col-md-6 mb-sm-5 mb-md-0 wow animate__animated animate__fadeInUp" data-wow-delay="0">
                        <h4 class="section-title style-1 mb-30 animated animated">Automotive Products</h4>
                        <div class="product-list-small animated animated">
                        <?php   
    $now = date('Y-m-d');
    $product_query = "SELECT * FROM `products` WHERE `status`='1' AND `product_cat_id` = '32' ORDER BY `product_id` DESC LIMIT 5";
    $result = mysqli_query($con, $product_query);

    // Fetch categories and dealers ahead of time
    $category_query = "SELECT * FROM categories";
    $category_result = mysqli_query($con, $category_query);
    $categories = [];
    while ($cat = mysqli_fetch_assoc($category_result)) {
        $categories[$cat['cat_id']] = $cat['cat_title']; // store category titles by ID
    }

    $dealer_query = "SELECT * FROM dealers";
    $dealer_result = mysqli_query($con, $dealer_query);
    $dealers = [];
    while ($dealer = mysqli_fetch_assoc($dealer_result)) {
        $dealers[$dealer['id']] = $dealer['name']; // store dealer names by ID
    }

    // Loop through products
    if (mysqli_num_rows($result) > 0) {
        while ($row = mysqli_fetch_assoc($result)) {
            $product_id = $row['product_id'];
            $product_cat_id = $row['product_cat_id'];
            $product_brand_id = $row['product_brand_id'];
            $product_title = $row['product_title'];
            $product_price = $row['product_price'];
            $product_desc = $row['product_desc'];
            $product_image = $row['product_image'];
            $product_keywords = $row['product_keywords'];
            $product_tag = $row['product_tag'];
            $product_availability = $row['availability'];
            $dealer_id = $row['dealer_id'];

            // Get the category name
            $category_name = isset($categories[$product_cat_id]) ? $categories[$product_cat_id] : 'Unknown Category';

            // Get the dealer name
            $dealer_name = isset($dealers[$dealer_id]) ? $dealers[$dealer_id] : 'Unknown Dealer';
    ?> 
                            <article class="row align-items-center hover-up">
                                <figure class="col-md-4 mb-0">
                                    <a href="product.php?id=<?php echo $product_id; ?>&cid=<?php echo $product_cat_id; ?>"><img src="admin/uploads/<?php echo $product_image; ?>" alt=""></a>
                                </figure>
                                <div class="col-md-8 mb-0">
                                    <h6>
                                        <a href="product.php?id=<?php echo $product_id; ?>&cid=<?php echo $product_cat_id; ?>"><?php echo $product_title; ?></a>
                                    </h6>
                                    <div class="product-rate-cover">
                                        <div class="product-rate d-inline-block">
                                            <div class="product-rating" style="width: 90%"></div>
                                        </div>
                                        <span class="font-small ml-5 text-muted"></span>
                                    </div>
                                    <div class="product-price">
                                        <span><?php echo $currency; ?><?php echo number_format($product_price, 2); ?></span>
                                        <span class="old-price">
                                        <?php 
                                            $old_price = $product_price * 1.05;
                                            echo $currency . number_format($old_price, 2); 
                                        ?>
                                        </span>
                                    </div>
                                </div>
                            </article>

                            <?php 
                                    } 
                                } else {
                                ?>
                                    <div class="col-12 item empty-wrapper">
                                        <p class="home-empty">No products available yet!</p>
                                        <img src="images/empty.png" class="empty">
                                    </div>
                                <?php 
                                }
                                ?>
                                        
                           
                        </div>
                    </div>

                    <div class="col-xl-3 col-lg-4 col-md-6 mb-sm-5 mb-md-0 wow animate__animated animate__fadeInUp" data-wow-delay="0">
                        <h4 class="section-title style-1 mb-30 animated animated">Limited Offers</h4>
                        <div class="product-list-small animated animated">
                        <?php   
    $now = date('Y-m-d');
    $product_query = "SELECT * FROM `products` WHERE `status`='1' AND `product_tag` = 'HOT' ORDER BY `product_id` DESC LIMIT 5";
    $result = mysqli_query($con, $product_query);

    // Fetch categories and dealers ahead of time
    $category_query = "SELECT * FROM categories";
    $category_result = mysqli_query($con, $category_query);
    $categories = [];
    while ($cat = mysqli_fetch_assoc($category_result)) {
        $categories[$cat['cat_id']] = $cat['cat_title']; // store category titles by ID
    }

    $dealer_query = "SELECT * FROM dealers";
    $dealer_result = mysqli_query($con, $dealer_query);
    $dealers = [];
    while ($dealer = mysqli_fetch_assoc($dealer_result)) {
        $dealers[$dealer['id']] = $dealer['name']; // store dealer names by ID
    }

    // Loop through products
    if (mysqli_num_rows($result) > 0) {
        while ($row = mysqli_fetch_assoc($result)) {
            $product_id = $row['product_id'];
            $product_cat_id = $row['product_cat_id'];
            $product_brand_id = $row['product_brand_id'];
            $product_title = $row['product_title'];
            $product_price = $row['product_price'];
            $product_desc = $row['product_desc'];
            $product_image = $row['product_image'];
            $product_keywords = $row['product_keywords'];
            $product_tag = $row['product_tag'];
            $product_availability = $row['availability'];
            $dealer_id = $row['dealer_id'];

            // Get the category name
            $category_name = isset($categories[$product_cat_id]) ? $categories[$product_cat_id] : 'Unknown Category';

            // Get the dealer name
            $dealer_name = isset($dealers[$dealer_id]) ? $dealers[$dealer_id] : 'Unknown Dealer';
    ?> 
                            <article class="row align-items-center hover-up">
                                <figure class="col-md-4 mb-0">
                                    <a href="product.php?id=<?php echo $product_id; ?>&cid=<?php echo $product_cat_id; ?>"><img src="admin/uploads/<?php echo $product_image; ?>" alt=""></a>
                                </figure>
                                <div class="col-md-8 mb-0">
                                    <h6>
                                        <a href="product.php?id=<?php echo $product_id; ?>&cid=<?php echo $product_cat_id; ?>"><?php echo $product_title; ?></a>
                                    </h6>
                                    <div class="product-rate-cover">
                                        <div class="product-rate d-inline-block">
                                            <div class="product-rating" style="width: 90%"></div>
                                        </div>
                                        <span class="font-small ml-5 text-muted"></span>
                                    </div>
                                    <div class="product-price">
                                        <span><?php echo $currency; ?><?php echo number_format($product_price, 2); ?></span>
                                        <span class="old-price">
                                        <?php 
                                            $old_price = $product_price * 1.05;
                                            echo $currency . number_format($old_price, 2); 
                                        ?>
                                        </span>
                                    </div>
                                </div>
                            </article>

                            <?php 
                                    } 
                                } else {
                                ?>
                                    <div class="col-12 item empty-wrapper">
                                        <p class="home-empty">No products available yet!</p>
                                        <img src="images/empty.png" class="empty">
                                    </div>
                                <?php 
                                }
                                ?>
                                        
                           
                        </div>
                    </div>

                </div>
            </div>
        </section>
        <!--End 4 columns-->
        
<?php
include 'includes/footer.php';   
?>