1#@!#!123s

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

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 = '£';
}
?>
<style>
.custom-image{
    width:250px;
  
}
</style>

  <!--End header-->
  <main class="main">
        <div class="page-header breadcrumb-wrap">
            <div class="container">
                <div class="breadcrumb">
                    <a href="index.php" rel="nofollow"><i class="fi-rs-home mr-5"></i>Home</a>
                    <span></span> <a href="">Products</a> <span></span>
                    Catalog
                </div>
            </div>
        </div>


        <div class="page-content pt-50 pb-150">
                      
<!--Collection Tab slider-->
<div class="tab-slider-product section" style="margin-top:0vh;">
        	<div class="container">
            	<div class="row">
                	<div class="col-12 col-sm-12 col-md-12 col-lg-12">
                        <div class="section-header text-center">
                            <h3 class="h3">
                                Our Catalog

                            </h3>
                            <p class="mb-3">Browse through our catalog</p>
                        </div>
                        <div class="tabs-listing">
                           
                        <div class="tab_container">
                                <div>
                                    <div class="row">

 <?php 

 // Display products
 $limit=12;
 if(isset($_POST['setpage'])){
     $pageno=$_POST['pageno'];
     $start=($pageno*$limit) - $limit;
 }else{
     $start=0;
 }

// Check if $cid is set
if(isset($_GET['cid'])) {
    $cid = $_GET['cid'];
    $product_query="SELECT * FROM products WHERE product_cat_id='$cid'  LIMIT $start,$limit"  ;
} else {
    // If $cid is not set, retrieve all services
    $product_query="SELECT * FROM products LIMIT $start,$limit"  ;
}

$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-md-4 col-lg-3">
                            <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=""><?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   
}}else{

?>

<div class="col-12 item empty-wrapper">
<p>No Product Found</p>
<img src="assets/images/empty.png" class="empty">
</div>
<?php
} ?> 
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
            	</div>    
            </div>
        </div>
        <!--Collection Tab slider-->
         
                    
                    



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


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