<?php include("site-header.php");?>
<link rel='stylesheet prefetch' href="<?=$site_url?>/css/ybgpzy.css">
  <div class="page-content">
    <div class="dlab-bnr-inr overlay-black-middle" style="background:url(<?=$site_url?>/images/inner-banner.jpg) no-repeat center; background-size:cover;">
      <div class="container">
        <div class="dlab-bnr-inr-entry">
          <h1 class="text-white">
            <?=db_scalar("select category_name from tbl_category where category_status='Active' and category_id='$catgoryID'")?>
          </h1>
          <ul class="list-inline">
            <li><a href="<?=$site_url?>/index.html">Home</a></li>
            <li>|</li>
            <li>
              <?=db_scalar("select category_name from tbl_category where category_status='Active' and category_id='$catgoryID'")?>
            </li>
          </ul>
        </div>
      </div>
    </div>
    <?php
$prd_name=$_REQUEST['cat_name'];
$catID=db_scalar("select category_id from tbl_category where 1 and category_url='$prd_name'");
if($catID=="")
{
    header("location:error.php");
}
$countSubCat=db_scalar("select count(*) from tbl_category where category_parent_id='$catID' and category_status='Active'"); // Count for sub category
if($countSubCat > 0){ ?>
    <?php 
$sql_cat=db_query("select * from tbl_category where 1 and category_id='$catID'");
if(mysqli_num_rows($sql_cat) > 0){
$CAT_DATA=mysqli_fetch_array($sql_cat);
@extract($CAT_DATA);
}	  
?>






    <div class="section-full mp-top res-pd">
      <div class="container">
        <div class="section-content">
          <div class="row">
            <div class="section-full bg-img-fix content-inner">
              <div class="container">
                <div class="col-md-5 col-sm-12 col-xs-12 col-lg-5 wow fadeInLeft mp-resd">
                
                
                
                
                <div class="col-md-12 col-sm-12 col-xs-12 col-lg-12 serv-sty">
				   <a href="<?=$site_url?>/uploaded_files/<?=$category_image_name?>" data-fancybox="images">
      <img src="<?=$site_url?>/uploaded_files/<?=$category_image_name?>" alt="<?php if($category_is_product=='Yes'){ ?> Manufacturers Exporters and Wholesale Suppliers of <?=$category_name?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? }else{ ?> Service Provider of <?=$category_name?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? } ?>" title="<?php if($category_is_product=='Yes'){ ?> Manufacturers Exporters and Wholesale Suppliers of <?=$category_name?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? }else{ ?> Service Provider of <?=$category_name?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? } ?>">
  </a>
                  </div>
                 
                  <div class="clearfix"></div>
                  <?php
$sql_catimage=db_query("select * from tbl_category_image where 1 and category_image_cat_id='$catID' order by category_image_id desc");
if(mysqli_num_rows($sql_catimage)>0){
?>
      <div class="col-md-12 col-sm-12 col-xs-12 col-lg-12">
      <?php
while($CAT_IMAGE=mysqli_fetch_array($sql_catimage)){
@extract($CAT_IMAGE);
?>
    <div class="col-md-2 col-sm-2 col-xs-2 col-lg-2 serv-dtlsz">
     
				   <a href="<?=$site_url?>/category_more_images/<?=$CAT_IMAGE['category_image_name']?>" data-fancybox="images" title="<?=$category_name?>">
      <img src="<?=$site_url?>/category_more_images/<?=$CAT_IMAGE['category_image_name']?>" alt="<?=$category_name?>" title="<?=$category_name?>"/>
  </a>
				  </div>
                   <? } ?>
    
      </div>
       <? } ?>
      </div>
                <div class="col-md-7 col-xs-12">
                  <h2 class="text-uppercase">
                    <?=$category_name?>
                  </h2>
                  <div class="dlab-separator-outer ">
                    <div class="dlab-separator bg-secondry style-skew"></div>
                  </div>
                  <div class="clear"></div>
                  <div>
                    <?=$category_description?>
                  </div>
                  <a href="<?=$site_url?>/enquiry.html" class="rd-mr">Enquiry Now!</a> </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
    <div class="section-full content-inner bg-clrd">
      <div class="container">
        <div class="section-head text-center">
          <h2 class="text-uppercase">
            <?=$category_name?>
            <?php if($compDATA['admin_product_option']=='Yes'){ ?>
            Products
            <? }else{ ?>
            Services
            <? } ?>
          </h2>
          <div class="dlab-separator-outer ">
            <div class="dlab-separator bg-secondry style-skew"></div>
          </div>
        </div>
        <div class="section-content ">
          <div class="row equal-wraper">
            <?php
$sql_subcat=db_query("select * from tbl_category where 1 and category_parent_id='$catID' and category_status='Active' order by category_id asc");
while($SUBCAT_DATA=mysqli_fetch_array($sql_subcat)){
@extract($SUBCAT_DATA);
?>
            <div class="col-md-4 col-sm-4 equal-col m-b10 mrg-btm">
              <div class="blog-post latest-blog-1 date-style-3 skew-date">
                <div class="dlab-post-media dlab-img-effect zoom-slow serv"> <img src="<?=$site_url?>/uploaded_files/<?=$SUBCAT_DATA['category_image_name']?>"  alt="<?php if($SUBCAT_DATA['category_is_product']=='Yes'){ ?> Manufacturers Exporters and Wholesale Suppliers of <?=$SUBCAT_DATA['category_name']?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? }else{ ?> Service Provider of <?=$SUBCAT_DATA['category_name']?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? } ?>" title="<?php if($SUBCAT_DATA['category_is_product']=='Yes'){ ?> Manufacturers Exporters and Wholesale Suppliers of <?=$SUBCAT_DATA['category_name']?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? }else{ ?> Service Provider of <?=$SUBCAT_DATA['category_name']?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? } ?>"></div>
                <div class="dlab-post-info p-t20">
                  <div class="dlab-post-title ">
                    <h3 class="post-title">
                      <?=$SUBCAT_DATA['category_name']?>
                    </h3>
                  </div>
                  <div class="dlab-post-text">
                    <?php $description=strip_tags($SUBCAT_DATA['category_description']);?>
                    <p>
                      <?=substr($description,0,65);?>
                    </p>
                    <a href="<?=$site_url?>/<?=$SUBCAT_DATA['category_url']?>.html" class="rd-mr1">Read More</a>
                    <br>
                    <br>
                    <br>
                    
                    </div>
                </div>
              </div>
            </div>
            <? } ?>
          </div>
        </div>
      </div>
    </div>
    <? }else{ ?>
    <?php
if(!empty($catID)){
$sql_final=db_query("select * from tbl_category where 1 and category_id='$catID'");
$FINAL_DATA=mysqli_fetch_array($sql_final);
@extract($FINAL_DATA);
$productName=$FINAL_DATA['category_name'];
$productImageName=$FINAL_DATA['category_image_name'];
$productDescription=$FINAL_DATA['category_description'];
}
?>
    <div class="section-full mp-top res-pd">
      <div class="container">
        <div class="section-content">
          <div class="row">
            <div class="section-full bg-img-fix content-inner">
              <div class="container">
                <div class="col-md-5 col-xs-12">
                  
                  
                  <div class="col-md-12 col-sm-12 col-xs-12 col-lg-12 serv-sty">
				   <a href="<?=$site_url?>/uploaded_files/<?=$category_image_name?>" data-fancybox="images">
      <img src="<?=$site_url?>/uploaded_files/<?=$category_image_name?>" alt="<?php if($category_is_product=='Yes'){ ?> Manufacturers Exporters and Wholesale Suppliers of <?=$category_name?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? }else{ ?> Service Provider of <?=$category_name?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? } ?>" title="<?php if($category_is_product=='Yes'){ ?> Manufacturers Exporters and Wholesale Suppliers of <?=$category_name?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? }else{ ?> Service Provider of <?=$category_name?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? } ?>">
  </a>
                  </div>
                  <div class="clearfix"></div>
                  <?php
$sql_catimage=db_query("select * from tbl_category_image where 1 and category_image_cat_id='$catID' order by category_image_id desc");
if(mysqli_num_rows($sql_catimage)>0){
?>
      <div class="col-md-12 col-sm-12 col-xs-12 col-lg-12">
      <?php
while($CAT_IMAGE=mysqli_fetch_array($sql_catimage)){
@extract($CAT_IMAGE);
?>
    <div class="col-md-2 col-sm-2 col-xs-2 col-lg-2 serv-dtlsz">
     
				   <a href="<?=$site_url?>/category_more_images/<?=$CAT_IMAGE['category_image_name']?>" data-fancybox="images" title="<?=$category_name?>">
      <img src="<?=$site_url?>/category_more_images/<?=$CAT_IMAGE['category_image_name']?>" alt="<?=$category_name?>" title="<?=$category_name?>"/>
  </a>
				  </div>
                   <? } ?>
    
      </div>
       <? } ?>
                </div>
                <div class="col-md-7 col-xs-12">
                  <h2 class="text-uppercase">
                    <?=$category_name?>
                  </h2>
                  <div class="dlab-separator-outer ">
                    <div class="dlab-separator bg-secondry style-skew"></div>
                  </div>
                  <div class="clear"></div>
                  <div><?=$category_description?></div>
                  <a href="<?=$site_url?>/enquiry.html" class="rd-mr">Enquiry Now!</a> 
                    <br>
                    <br>
                    <br>
                    </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
    <? } ?>
    <?php include("site-footer.php");?>
  </div>
</div>
<script src="<?=$site_url?>/js/jquery.min.js"></script> 
<script src="<?=$site_url?>/js/bootstrap.min.js"></script> 
<script src="<?=$site_url?>/js/bootstrap-select.min.js"></script> 
<script src="<?=$site_url?>/js/jquery.bootstrap-touchspin.js"></script> 
<script src="<?=$site_url?>/js/magnific-popup.js"></script> 
<script src="<?=$site_url?>/js/waypoints-min.js"></script> 
<script src="<?=$site_url?>/js/imagesloaded.js"></script> 
<script src="<?=$site_url?>/js/masonry-3.1.4.js"></script> 
<script src="<?=$site_url?>/js/masonry.filter.js"></script> 
<script src="<?=$site_url?>/js/owl.carousel.js"></script> 
<script src="<?=$site_url?>/js/custom.js"></script> 
<script src="<?=$site_url?>/js/dz.carousel.js"></script> 
<script src="<?=$site_url?>/js/switcher.min.js"></script>
<script src="<?=$site_url?>/js/js-gallery/index.js"></script>
<script src="<?=$site_url?>/js/js-gallery/ybgpzy.js"></script>
</body>
</html>