<?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">
                                            <div class="row">
                                                <h1 align="center">Latest Product</h1><br>
                                               
                                               				
				<?php

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

	$sql = "SELECT * FROM product where 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="shop-tab">
                                                    <!-- single-product start -->
                                               
                                                <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']; ?>"><i class="zmdi zmdi-eye"></i></a></li>
                                                </ul>
                                                </div>
                                                </div>
                                                <div class="hs-shop-details">
                                                <h4 class="shop-title"><a href="product_sub.php?cat_id=<?php echo $row['cat_id']; ?>"><?php echo $row['p_name']; ?></a></h4>
                                                
                                                </div>
                                                </div>
                                                </div>
                                                 
                                                </div> 
            
           
				
               
<?php  
};  
?> 
                                               
                                                
                                            </div>
                                        </div>
                                        
                                    </div>