<?php 
ob_start();
require('controller/function.php');
require('controller/database.php');
$ob = new database();
 ?>
 
 
  <div class="tab-content">
                                        <div role="tabpanel" class="tab-pane active" id="home">
                                        <?php
									
 							$obj = new database();
							$obj->query("SELECT * FROM sub_cat where id='$_GET[subcat_id]' order by id desc");
                                        foreach($obj->rows() as $cat)
                                        {
											$id= $cat['id'];
										
							?>  
                                        <h1 align="center"><?php echo $cat['sub_cat']; ?> Product<h1><?php } ?>
                                            <br>
                                       
             
            <div class="row">
                                                <div class="shop-tab">
                                                    <!-- single-product start -->
<?php

$limit = 12;  
if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };  
$start_from = ($page-1) * $limit;  

	$sql = "SELECT * FROM product where sub_cat_id='$_GET[subcat_id]' and cat_id='$_GET[cat_id]' and type='Public' ORDER BY p_name ASC LIMIT $start_from, $limit"; 

							

 
$rs_result = mysql_query ($sql);  
?>

 
<?php  
while ($row = mysql_fetch_assoc($rs_result)) {  
?>  
             

                                                
                                                <div class="col-md-4 col-sm-6 mb-30">
                                                <div class="hs-single-shop-area">
                                                <div class="single-shop-thumd">
                                                <img src="controller/pro/<?php echo $row['p_image']; ?>" alt="<?php echo $row['p_name']; ?>">
                                                <div class="product-information">
                                                <ul>
                                                
                                                <li><a data-toggle="" data-target="#" title="quick-view" class="quick-view modal-view detail-link" href="products_shop_detail.php?id=<?php echo $row['p_id']; ?>&name=<?php echo $row['p_name']; ?>&cat_id=<?php echo $row['cat_id']; ?>&sub_cat_id=<?php echo $row['sub_cat_id']; ?>"><i class="zmdi zmdi-eye"></i></a></li>
                                                </ul>
                                                </div>
                                                </div>
                                                <div class="hs-shop-details">
                                                <h4 class="shop-title"><a href="products_shop_detail.php?id=<?php echo $row['p_id']; ?>&name=<?php echo $row['p_name']; ?>&cat_id=<?php echo $row['cat_id']; ?>&sub_cat_id=<?php echo $row['sub_cat_id']; ?>"><?php echo $row['p_name']; ?></a></h4>
                                                
                                                </div>
                                                </div>
                                                </div>
                                                
                                               
				
               
<?php  
};  
?> 
               </div>
                                            </div>

			</div></div>