1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / qarkt.com /
Filename : index.php
back
<?php
session_start();
error_reporting(0);
include('../config/qaconfig.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">
            <div class="intro-slider-container mb-5">
                <div class="intro-slider owl-carousel owl-theme owl-nav-inside owl-light" data-toggle="owl" 
                    data-owl-options='{
                        "dots": true,
                        "nav": false, 
                        "responsive": {
                            "1200": {
                                "nav": true,
                                "dots": false
                            }
                        }
                    }'>
                    <div class="intro-slide" style="background-image: url(assets/images/1.jpg);">
                        <div class="container intro-content">
                            <div class="row justify-content-end">
                                <div class="col-auto col-sm-7 col-md-6 col-lg-5">
                                    <h3 class="intro-subtitle" style="color:#fff !important;">
                                    High Performance & Outstanding Technology Combined</h3><!-- End .h3 intro-subtitle -->
                                    <h1 class="intro-title" style="color:#fff;">2016 Atura ILX</h1>
                                     <br>
                                    <a href="catalog.php?cid=7" class="btn btn-primary btn-round">
                                        <span>Shop Now</span>
                                        <i class="icon-long-arrow-right"></i>
                                    </a>
                                </div><!-- End .col-lg-11 offset-lg-1 -->
                            </div><!-- End .row -->
                        </div><!-- End .intro-content -->
                    </div><!-- End .intro-slide -->

                    <div class="intro-slide" style="background-image: url(assets/images/2.jpg);">
                        <div class="container intro-content">
                            <div class="row justify-content-end">
                                <div class="col-auto col-sm-7 col-md-6 col-lg-5">
                                    <h3 class="intro-subtitle" style="color:#fff !imporant;">High Performance & Outstanding Technology Combined</h3><!-- End .h3 intro-subtitle -->
                                    <h1 class="intro-title" style="color:#fff;">2016 Atura ILX </h1><!-- End .intro-title -->
                                        <br>
                                   

                                    <a href="catalog.php?cid=9" class="btn btn-primary btn-round">
                                        <span>Shop More</span>
                                        <i class="icon-long-arrow-right"></i>
                                    </a>
                                </div><!-- End .col-md-6 offset-md-6 -->
                            </div><!-- End .row -->
                        </div><!-- End .intro-content -->
                    </div><!-- End .intro-slide -->

                    
                </div><!-- End .intro-slider owl-carousel owl-simple -->

                <span class="slider-loader"></span><!-- End .slider-loader -->
            </div><!-- End .intro-slider-container -->



            <div class="container">
            <div  class="home-row" > 
                <h2 class="title text-center mb-4">Trending</h2><!-- End .title text-center -->
                <div class="heading-right">
                        <a href="catalog.php?cid=7" class="title-link">View All <i class="icon-long-arrow-right"></i></a>
                   </div>
               </div>
                <div class="cat-blocks-container">
                    <div class="row">
                    <?php   
$now = date('Y-m-d');
$product_query="SELECT * FROM `products` WHERE `status`='1' ORDER BY `product_id` DESC LIMIT 6"  ;
$result=mysqli_query($con,$product_query);

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'];



?>
                        <div class="col-6 col-sm-4 col-lg-2">
                            <a href="product.php?id=<?php echo $product_id; ?>&cid=<?php echo $product_cat_id; ?>" 
                            class="cat-block">
                                <figure>
                                    <span>
                                        <img src="admin/uploads/<?php echo $product_image; ?>"
                                         alt="Product Image" style="max-height:150px;">
                                    </span>
                                </figure>

                                <h3 class="cat-block-title"><?php echo $product_title; ?></h3><!-- End .cat-block-title -->
                            </a>
                        </div><!-- End .col-sm-4 col-lg-2 -->

        <?php 
               }}else{ ?>

<div class="col-12 item empty-wrapper">
<p class="home-empty">No product yet!</p>
<img src="assets/images/empty.png" class="empty">
</div>

<?php }?>
                       
                    </div><!-- End .row -->
                </div><!-- End .cat-blocks-container -->
            </div><!-- End .container -->

            <div class="mb-4"></div><!-- End .mb-4 -->
           
            <div class="container">
            <div  class="home-row" > 
                <h2 class="title text-center mb-4">Trending</h2><!-- End .title text-center -->
                <div class="heading-right">
                        <a href="catalog.php?cid=8" class="title-link">View All <i class="icon-long-arrow-right"></i></a>
                   </div>
               </div>
                <div class="cat-blocks-container">
                    <div class="row">
                    <?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);

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'];



?>
                        <div class="col-6 col-sm-4 col-lg-2">
                            <a href="product.php?id=<?php echo $product_id; ?>&cid=<?php echo $product_cat_id; ?>" 
                            class="cat-block">
                                <figure>
                                    <span>
                                        <img src="admin/uploads/<?php echo $product_image; ?>"
                                         alt="Product Image" style="max-height:150px;">
                                    </span>
                                </figure>

                                <h3 class="cat-block-title"><?php echo $product_title; ?></h3><!-- End .cat-block-title -->
                            </a>
                        </div><!-- End .col-sm-4 col-lg-2 -->

        <?php 
               }}else{ ?>

<div class="col-12 item empty-wrapper">
<p class="home-empty">No product yet!</p>
<img src="assets/images/empty.png" class="empty">
</div>

<?php }?>
                       

                    </div><!-- End .row -->
                </div><!-- End .cat-blocks-container -->
            </div><!-- End .container -->

            <div class="mb-4"></div><!-- End .mb-4 -->

            <div class="container">
            <div  class="home-row" > 
                <h2 class="title text-center mb-4">Just In</h2><!-- End .title text-center -->
                <div class="heading-right">
                        <a href="catalog.php?cid=9" class="title-link">View All <i class="icon-long-arrow-right"></i></a>
                   </div>
               </div>
                <div class="cat-blocks-container">
                    <div class="row">
                    <?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);

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'];



?>
                        <div class="col-6 col-sm-4 col-lg-2">
                            <a href="product.php?id=<?php echo $product_id; ?>&cid=<?php echo $product_cat_id; ?>" 
                            class="cat-block">
                                <figure>
                                    <span>
                                        <img src="admin/uploads/<?php echo $product_image; ?>"
                                         alt="Product Image" style="max-height:150px;">
                                    </span>
                                </figure>

                                <h3 class="cat-block-title"><?php echo $product_title; ?></h3><!-- End .cat-block-title -->
                            </a>
                        </div><!-- End .col-sm-4 col-lg-2 -->

        <?php 
               }}else{ ?>

<div class="col-12 item empty-wrapper">
<p class="home-empty">No product yet!</p>
<img src="assets/images/empty.png" class="empty">
</div>

<?php }?>
                       

                    </div><!-- End .row -->
                </div><!-- End .cat-blocks-container -->
            </div><!-- End .container -->

            <div class="mb-4"></div><!-- End .mb-4 -->

            
            <div class="mb-3"></div><!-- End .mb-5 -->


          

            <div class="container for-you">
                <div class="heading heading-flex mb-3">
                    <div class="heading-left">
                        <h2 class="title">Recommendation For You</h2><!-- End .title -->
                    </div><!-- End .heading-left -->

                   <div class="heading-right">
                        <a href="catalog.php?cid=7" class="title-link">View All <i class="icon-long-arrow-right"></i></a>
                   </div><!-- End .heading-right -->
                </div><!-- End .heading -->

                <div class="products">
                    <div class="row justify-content-center">
                    <?php   
$product_query="SELECT * FROM `products` WHERE `product_tag`='NEW'  ORDER BY `product_id` DESC LIMIT 8"  ;
$result=mysqli_query($con,$product_query);

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_category=['cat_title'];

    $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'];
    $product_old_price=$product_price*1.08;

?>
                        <div class="col-6 col-md-4 col-lg-2">
                            <div class="product product-2">
                                <figure class="product-media" style="background:#fff;">
                                <?php 
                                        if(is_null($product_tag)){
                                            // Code Here
                                         }else{
                                           
                                            ?>
                                    <span class="product-label label-circle label-sale"><?php echo $product_tag; ?></span>
                                        <?php } ?>
                                    <a href="product.php?id=<?php echo $product_id; ?>&cid=<?php echo $product_cat_id; ?>" >
                                        <img src="admin/uploads/<?php echo $product_image; ?>" 
                                      style="max-height:180px;"  alt="<?php echo $product_title; ?>" class="product-image">
                                    </a>
                                  
                                    <div class="product-action">
                                    <?php 
                                        if($product_availability=="In Stock"){
                                            ?>
        <a href="#" class="btn-product btn-cart" title="Add to cart" 
        pid='<?php echo $product_id; ?>' id="product"><span>add to cart</span></a>


                                       <?php
                                         }else{   
                                        ?>
                                           <btn class="btn-product " title="Out of Stock" 
                                           style="color:#ff0000;cursor: not-allowed;width:auto;padding:5px;" disabled
                                           ><span><?php echo $product_availability; ?></span></button>
                                       <?php
                                         }
                                        ?> 


                                    </div><!-- End .product-action -->
                                </figure><!-- End .product-media -->

                                <div class="product-body">
                                    <div class="product-cat">
                                        <a href="#">
                                        <?php 
							 $cat_query="SELECT * FROM categories WHERE cat_id='$product_cat_id' ";
							 $result2=mysqli_query($con,$cat_query);
							
							 if(mysqli_num_rows($result2)>0){
							  while ($row2=mysqli_fetch_array($result2)) {
								// print_r($row);
						 
								$cat_id=$row2['cat_id'];
								$cat_name=$row2['cat_title'];
						 
							?>
					<?php echo $cat_name ?>
							<?php }} ?>
                                        </a>
                                    </div><!-- End .product-cat -->
                                    <h3 class="product-title"><a href="product.html"><?php echo $product_title; ?></a></h3><!-- End .product-title -->
                                    <div class="product-price">
                                        <span class="new-price"><?php echo $currency;?><?php echo $product_price; ?></span>
                                    </div><!-- End .product-price -->
                                   
                                        <!-- End .product-nav -->
                                </div><!-- End .product-body -->
                            </div><!-- End .product -->
                        </div><!-- End .col-sm-6 col-md-4 col-lg-3 -->

                        <?php   
}} ?>  

                    </div><!-- End .row -->
                </div><!-- End .products -->
            </div><!-- End .container -->

            <div class="mb-4"></div><!-- End .mb-4 -->

        



            
            </div><!-- End .icon-boxes-container -->
        </main><!-- End .main -->



        
<?php
include 'includes/footer.php';   
?>