<?php
session_start(); 
include("includes/db.php");
include("functions/functions.php");
?>

<?php   include("includes/header.php"); ?>

	<div id="content">
		<div class="container"><!--container start -->
			<div class="col-md-12"><!--col-md-12 start -->
				<ul class="breadcrumb">
					<li><a href="index.php">Home</a></li>
					<li>Shop</li>
				</ul>
			</div><!--col-md-12 end -->
			<div class="col-md-3"><!--col-md-3 start -->
				<?php
				include("includes/sidebar.php");
				?>
			</div><!--col-md-3 end -->
			<div class="col-md-9"><!--col-md-9 start -->

				<?php 

				if(!isset($_GET['p_cat'])){
					if(!isset($_GET['cat_id'])){
						echo "
						<div class='box'>
					<h1>shop</h1>
					<p></p>
				</div>";
					}
				}

				?>




				
				<div class="row"><!-- Row Start -->

					<?php 
					if(!isset($_GET['p_cat'])){
						if(!isset($_GET['cat_id'])){
													
						if(isset($_GET['page']))
						{
						  $page =$_GET['page'];
						}
						else{
						  $page=1;
						}

						$num_per_page = 6;
							$start_from = ($page-1)*$num_per_page;
							$get_product="select * from products order by 1 DESC LIMIT $start_from,$num_per_page";

							$run_pro = mysqli_query($con,$get_product);
							while($row=mysqli_fetch_array($run_pro)){
								$pro_id=$row['product_id'];
								$pro_title=$row['product_title'];
								$pro_price=$row['product_price'];
								$pro_img1=$row['product_img1'];

								echo "<div class='col-md-4 col-sm-6 center-responsive'>
				<div class='product'>
					<a href='details.php?pro_id=$pro_id'>
						<img src='admin/product_images/$pro_img1' class='img-responsive'>
					</a>
					<div class='text'>
						<h3><a href='details.php?pro_id=$pro_id'>$pro_title</a></h3>
						<p class='price'>INR $pro_price</p>
						<p class='buttons'>
							<a href='details.php?pro_id=$pro_id' class='btn btn-default'>View Details</a>
							<a href='details.php?pro_id=$pro_id' class='btn btn-primary'>
								<i class='fa fa-shopping-cart'></i>Add to Cart
							</a>
						</p>
					</div>
				</div>
			</div>

		";
							}
						

					 ?>

				</div><!-- Row End -->

				<center>
					<ul class="pagination">

				 
 <?php 

 $pr_query = "SELECT * FROM products";
 $pr_result = mysqli_query($con,$pr_query);
 $total_record = mysqli_num_rows($pr_result);

 $total_page = ceil($total_record/$num_per_page);

 if($page>1)
 {
   echo "<li><a href='shop.php?page=".($page-1)."' class='btn btn-danger'>Previous</a></li";
 }

 for ($i=1;$i<$total_page;$i++)
 {

  echo "<li><a href='shop.php?page=".$i."' class='btn btn-primary'>$i</a></li>";

 } 
 if($i>$page)
 {
   echo "<li><a href='shop.php?page=".($page+1)."' class='btn btn-danger'>Next</a></li>";
 }
}}

 ?>




						
						
					</ul>
				</center>


				<?php getpcatpro(); 
				getcatpro();

				?>



			</div><!--col-md-9 end -->
		</div><!--container end -->
	</div>



<!--footer start-->
<?php
include ("includes/footer.php");
?>
<!--footer end-->

<!-- Latest compiled JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
</body>
</html>