<?php include("site-header.php"); ?>

<?php
$cat_url=$_REQUEST['cat_url'];
$cat_id=db_scalar("select category_id from tbl_category where category_url='$cat_url' ");

?>

<?php
if($cat_id!="")
    {?>
<section class="page-title-area">
<div class="container">
<div class="page-title-content">
<h1><?=db_scalar("select category_name from tbl_category where category_id='$cat_id' ")?></h1>
<ul>
<li><a href="<?=$site_url?>">Home</a></li>
<li><a href="<?=$site_url?>/products.html">Products</a></li>
<li><?=db_scalar("select category_name from tbl_category where category_id='$cat_id' ")?></li>
</ul>
</div>
</div>
</section>
<?}else{?>
<section class="page-title-area">
<div class="container">
<div class="page-title-content">
<h1>Products</h1>
<ul>
<li><a href="<?=$site_url?>">Home</a></li>
<li>Products</li>
</ul>
</div>
</div>
</section>
<?}?>

<section class="products-area ptb-70">
<div class="container">
<div class="row">
<div class="col-lg-3 col-md-12">
<div class="woocommerce-widget-area">
<div class="woocommerce-widget ">
<h3 class="woocommerce-widget-title">Categories
    <?php
if($cat_id!="")
    {?>
 <a href="<?=$site_url?>/products.html">
    <i style="color:red; font-weight: bold; border-style: solid; border-width: 1px; padding: 4px; font-size: 12px; border-radius: 10px; " class="fa fa-times">Clear</i>
 </a>
 <?}?>

</h3> 
<ul class="brands-list-row">

        <?php
$sql=db_query("select * from tbl_category where category_parent_id='0' and category_status='Active' order by category_order_by asc ");
while($res=mysqli_fetch_array($sql))
  {?>

<?php
$clr="";
if($cat_id==$res['category_id'])
{
$clr="#fe5d00";
}else{
$clr="black";
}
?>

<li><a style="color:<?=$clr?>;" href="<?=$site_url?>/products/<?=$res['category_url']?>.html"><?=$res['category_name']?></a></li>
<?}?>

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

 <?php
 $parent_con="";
if($cat_id!="")
{
$parent_con="category_parent_id='$cat_id'";
}else{
$parent_con="category_parent_id!='0'";
}

$start = intval($start);
//$pagesize = intval($pagesize)==0?$pagesize=DEF_PAGE_SIZE:$pagesize;
$pagesize=20;
$sql = "select * from  tbl_category where 1 and category_status='Active' and category_is_product='Yes' and $parent_con  order by category_order_by";
$sql .= " limit $start, $pagesize ";
//echo $sql;
$pager = new midas_pager_sql($sql, $pagesize, $start);
if($pager->total_records) {
  $result = db_query($sql);
}
?>

       <? if($pager->total_records>0) {?>  


<div class="col-lg-9 col-md-12">


<div class="drodo-grid-sorting row align-items-center">
 <div class="col-lg-6 col-md-6 result-count">

<? if($pager->total_records!=0) {?>
<? $pager->show_displaying()?>
<?//=pagesize_dropdown('pagesize', $pagesize);?>
<?php
}
?>
</div>
</div>



<div class="row">

<?php
while($pro_res=mysqli_fetch_array($result))
{
?>
<div class="col-lg-4 col-md-4 col-sm-6 change_color_hover">
<div class="single-products-box product">
<div class="image">
<a href="<?=$site_url?>/<?=$pro_res['category_url']?>.html" class="d-block"><img src="<?=$site_url?>/uploaded_files/<?=$pro_res['category_image_name']?>" alt="<?=$pro_res['category_name']?>" title="<?=$pro_res['category_name']?>"></a>
</div>
    <h3><a href="<?=$site_url?>/<?=$pro_res['category_url']?>.html"><?=$pro_res['category_name']?></a></h3>
</div>
</div>
<?}?>





<div class="col-lg-12 col-md-12">
<div class="pagination-area text-center">
    <? $pager->show_pager();?>
</div>
</div>


</div>
</div>

    <?php }else{?>
  <div class="col-md-12">
   <h2  style="color:red; text-align: center; padding-bottom:50px;">
    Product not available !

  </h2>
  </div>
<?php }?>

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


<?php include("site-footer.php"); ?>