<?php 

include_once("include/main.inc.php"); 
@extract($_REQUEST);

ini_set('memory_limit', "400M");

if (preg_match('webpulse\.co$/', $_SERVER['HTTP_HOST'], $match)) {
    $match1=$match[1];
    $vanity_url='http://'.$_SERVER['HTTP_HOST'];
}
$actual_link = "http://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";
$ee=explode('/',$actual_link);
$ca_nam1=$ee[3];
$ca_nam1=ucwords(str_replace("-"," ",$ca_nam1));
$pid=ucwords(str_replace("-"," ",$_REQUEST['pid']));
$cat_s="select catImage, catName, displayName, catDesc, catID, catDesc1,catBanner, keyword1, keyword2, keyword3, parentID, headingh1, headingh2,alttag,catVideo from category_tbl where catName='$pid'";
$cat_q=mysqli_query($GLOBALS['dbconn'],$cat_s);
$num=mysqli_num_rows($cat_q);
$cat_r=mysqli_fetch_array($cat_q);
$category_id=$cat_r['catID'];
$hover='category';
$catn=$cat_r['catName'];
$cat_sql="select catImage, catName, displayName, catDesc, catID, catDesc1,catBanner, parentID from category_tbl where parentID='$category_id' and status='Y'";
$cat_qry=mysqli_query($GLOBALS['dbconn'],$cat_sql);
$cccnum=mysqli_num_rows($cat_qry);
$cat_sql1="select catName, displayName, catID, parentID,catImage,catDesc1,catBanner,keyword1,keyword2,keyword3,headingh1, headingh2,alttag,pageTitle,pageKeywords,pageDescription,multi_image from category_tbl where catID='$category_id'";
$cat_qry1=mysqli_query($GLOBALS['dbconn'],$cat_sql1);
$cat_res=mysqli_fetch_array($cat_qry1);
$pageTitles=$cat_res['catName'];
$disTitles=$cat_res['displayName']; 
$pdes=$cat_res['catDesc'];
$parent=$cat_res['parentID'];
$cat_sql2="select catName, displayName, catID, parentID from category_tbl where catID='$parent'";
$cat_qry2=mysqli_query($GLOBALS['dbconn'],$cat_sql2);
$num2=mysqli_num_rows($cat_qry2);
$cat_res2=mysqli_fetch_array($cat_qry2);
$mparent=$cat_res2['parentID'];
$cat_sql3="select catName, displayName, catID, parentID from category_tbl where catID='$mparent'";
$cat_qry3=mysqli_query($GLOBALS['dbconn'],$cat_sql3);
$num3=mysqli_num_rows($cat_qry3);
$cat_res3=mysqli_fetch_array($cat_qry3);
$mmparent=$cat_res3['parentID'];
$cat_sql4="select catName, displayName, catID, parentID from category_tbl where catID='$mmparent'";
$cat_qry4=mysqli_query($GLOBALS['dbconn'],$cat_sql4);
$num4=mysqli_num_rows($cat_qry4);
$cat_res4=mysqli_fetch_array($cat_qry4);
$mobile=$admin_res['mobile'];
$city=$admin_res['city'];
$state=$admin_res['state'];
$country=$admin_res['country'];
$companyName=$admin_res['companyName'];
$address=$admin_res['address']; 
$multi_image = explode(',', $cat_res['multi_image']);



if($cat_res['catImage']!=''){
    $imglink= getImage($cat_res[catImage], 500, 500, $cat_res[catName],"/uploaded-files/category/images/");
    } else {
        $imglink= getImage("noimage.jpg", 500, 500, "noimages","/uploaded-files/category/images/");
    } 
    $loc_sql=mysqli_query($GLOBALS['dbconn'], "select locationID from location_tbl where locationName='$ca_nam1' and status='Y'");
    $location = mysqli_fetch_array($loc_sql);
    $location_id = $location['locationID']; 
    $category_sub_general=mysqli_query($dbconn,"select location_ids,headingtwosub,meta_title,headingtwosub,meta_keyword,meta_description,description,short_description from location_content_tbl where category_id='$category_id' AND location_id='0'");
    $content_count = mysqli_num_rows($category_sub_general);
    if($content_count > 0){
        while($categorysubdomain=mysqli_fetch_array($category_sub_general)){
            $locati = explode(",", $categorysubdomain['location_ids']);
            if(in_array($location_id, $locati)){
                if($categorysubdomain['meta_title'] != ''){
                    $page_metatitle1=$categorysubdomain['meta_title'];
                }
                if($categorysubdomain['meta_keyword'] != ''){
                    $page_metakey1=$categorysubdomain['meta_keyword'];
                }
                if($categorysubdomain['meta_description']){
                    $page_metadesc1=$categorysubdomain['meta_description'];
                }
                $page_desc=$categorysubdomain['description'];
            }
        }
    //    specific location content
    }
    if($cat_res['keyword1']!='' && $cat_res['keyword2']!='' && $cat_res['keyword3']!=''){
        $m_title = "hotkeyword1 Manufacturers in location, hotkeyword2 Suppliers Exporters location"; 
       $page_metatitle = str_replace('hotkeyword1',$cat_res[keyword1],str_replace('hotkeyword2', $cat_res[keyword2], str_replace('location', $ca_nam1,$m_title)));
       $m_keyword = "hotkeyword1 Manufacturers in location, hotkeyword2 Manufacturers in location, hotkeyword1 Suppliers in location, hotkeyword2 Suppliers in location, hotkeyword1 Exporters in location, hotkeyword2 Exporters in location, hotkeyword1 in location, hotkeyword2 in location";
       $page_metakey = str_replace('hotkeyword1',$cat_res[keyword1],str_replace('hotkeyword2', $cat_res[keyword2], str_replace('hotkeyword3', $cat_res[keyword3],str_replace('location', $ca_nam1,$m_keyword))));
       $meta_des = "Looking for Premium Quality hotkeyword1 Manufacturers in location? companyName - Leading Suppliers Exporters of hotkeyword2 Since 2016, Supplying at ✓Factory Price. Call phone.";    
       $page_metadesc = str_replace('hotkeyword1',$cat_res[keyword1],str_replace('hotkeyword2', $cat_res[keyword2],str_replace('hotkeyword3', $cat_res[keyword3],str_replace('companyName', $admin_res['companyName'], str_replace('phone', $admin_res['mobile_meta'], str_replace('location', $ca_nam1,$meta_des))))));
       } else if($cat_res['keyword1']!='' && $cat_res['keyword2']!=''){
           $m_title = "hotkeyword1 Manufacturers in location, hotkeyword2 Suppliers Exporters location";  
           $page_metatitle = str_replace('hotkeyword1',$cat_res[keyword1],str_replace('hotkeyword2', $cat_res[keyword2], str_replace('location', $ca_nam1,$m_title)));
           $m_keyword = "hotkeyword1 Manufacturers in location, hotkeyword2 Manufacturers in location, hotkeyword1 Suppliers in location, hotkeyword2 Suppliers in location, hotkeyword1 Exporters in location, hotkeyword2 Exporters in location, hotkeyword1 in location, hotkeyword2 in location";
           $page_metakey = str_replace('hotkeyword1',$cat_res[keyword1],str_replace('hotkeyword2', $cat_res[keyword2], str_replace('location', $ca_nam1,$m_keyword)));
           $meta_des = "Looking for Premium Quality hotkeyword1 Manufacturers in location? companyName - Leading Suppliers Exporters of hotkeyword2 Since 2016, Supplying at ✓Factory Price. Call phone.";    
           $page_metadesc = str_replace('hotkeyword1',$cat_res[keyword1],str_replace('hotkeyword2', $cat_res[keyword2], str_replace('companyName', $admin_res[companyName], str_replace('phone', $admin_res['mobile_meta'], str_replace('location', $ca_nam1,$meta_des)))));
       }else if($cat_res['keyword1']!=''){
           $m_title = "hotkeyword1 Manufacturers in location, hotkeyword1 Suppliers Exporters location";  
           $page_metatitle = str_replace('hotkeyword1',$cat_res[keyword1], str_replace('location', $ca_nam1,$m_title));
           $m_keyword = "hotkeyword1 Manufacturers in location, hotkeyword1 Suppliers in location, hotkeyword1 Exporters in location, hotkeyword1 in location";
           $page_metakey = str_replace('hotkeyword1',$cat_res[keyword1], str_replace('location', $ca_nam1,$m_keyword));
           $meta_des = "Looking for Premium Quality hotkeyword1 Manufacturers in location? companyName - Leading Suppliers Exporters of hotkeyword1 Since 2016, Supplying at ✓Factory Price. Call phone.";    
           $page_metadesc = str_replace('hotkeyword1',$cat_res[keyword1], str_replace('companyName', $admin_res[companyName], str_replace('phone',$admin_res['mobile_meta'], str_replace('location', $ca_nam1,$meta_des))));
       } else{
           $page_metatitle=$page_metatitle1;
           $page_metakey=$page_metakey1;
           $page_metadesc=$page_metadesc1;
       }
    $page_desc = str_replace('countryname',$ca_nam1, $page_desc);
    $page_desc = str_replace('catname',$pid, $page_desc);
    $page_desc = str_replace('{location}',$ca_nam1, $page_desc);
    $page_desc=str_ireplace('{companyName}',$admin_res['companyName'],$page_desc);
    $page_metatitle = str_replace('countryname',$ca_nam1, $page_metatitle);
    $page_metatitle = str_replace('catname',$pid, $page_metatitle);
    $page_metatitle = str_replace('{location}',$ca_nam1, $page_metatitle);
    $page_metakey = str_replace('countryname',$ca_nam1, $page_metakey);
    $page_metakey = str_replace('catname',$pid, $page_metakey);
    $page_metakey = str_replace('{location}',$ca_nam1, $page_metakey);
    $page_metadesc = str_replace('countryname',$ca_nam1, $page_metadesc);
    $page_metadesc = str_replace('catname',$pid, $page_metadesc);
    $page_metadesc = str_replace('{location}',$ca_nam1, $page_metadesc);
    $page_short_desc = str_replace('countryname',$ca_nam1, $page_short_desc);
    $page_short_desc = str_replace('catname',$pid, $page_short_desc);
    $page_short_desc = str_replace('{location}',$ca_nam1, $page_short_desc);
    $category_sub_uncheck_loc=mysqli_query($GLOBALS['dbconn'],"select description,short_description,headingtwosub from location_content_tbl where category_id='$category_id' AND location_id='0'");
    $category_sub_uncheck_res=mysqli_fetch_array($category_sub_uncheck_loc);
    $page_desc1=$category_sub_uncheck_res['description'];
    $page_desc1 = str_replace('{location}',$ca_nam1,  $page_desc1);
    $page_desc1=str_ireplace('{companyName}',$admin_res['companyName'],$page_desc1);



if($cat_res['headingh1']!=''){
    $heading1=$cat_res['headingh1'].' Manufacturers in '.$ca_nam1;
}else{
    $heading1=$disTitles.' Manufacturers in '.$ca_nam1;
}



if($category_sub_uncheck_res['headingtwosub']!=''){
    $heading2=$category_sub_uncheck_res['headingtwosub'].'';
}else{
    $heading2=$disTitles.'';
}



if($cat_res['alttag']!=''){
    $alttag=$cat_res['alttag'].' Manufacturers in '.$ca_nam1;
}else{
    $alttag=$disTitles.' Manufacturers in '.$ca_nam1;
}



if(mysqli_num_rows($loc_sql) > 0)
{
}



else
{
    header("Location: ".site_url);
    exit;
}



if(mysqli_num_rows($cat_q) > 0)
{ ?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <?php include "app_top.php"; ?>
</head>
<body>
    <?php include "app_header_sub.php"; ?>
    <section class="heading_banner" style="background-image: url(<?=site_url;?>/designer/images/about-banner.jpg)">
        <div class="container">
            <div class="row">
                <div class="col-xxl-12 col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12 text-center">
                    <h1 class="cat_title"> <?=$heading1;?></h1>
                    <div class="clearfix"></div>
                </div>
            </div>
        </div>
    </section>
    <div class="inner_breadcrumb hidden_xs">
        <div class="container">
            <div class="row">
                <div class="col-xxl-12 col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
                    <ul class="breadcrumb">
                        <?php if($num4 > 0) {?>
                        <li><a href="<?=site_url;?>/<?=getValidFileName($ca_nam1);?>/<?=getValidFileName($cat_res4['catName']);?>.htm"
                                title="<?php echo $cat_res4['catName']; ?> "><?php echo $cat_res4['catName']; ?></a>
                        </li>
                        <?php } ?>
                        <?php if($num3 > 0) {?>
                        <li><a href="<?=site_url;?>/<?=getValidFileName($ca_nam1);?>/<?=getValidFileName($cat_res3['catName']);?>.htm"
                                title="<?php echo $cat_res3['catName']; ?>"><?php echo $cat_res3['catName']; ?></a>
                        </li>
                        <?php } ?>
                        <?php if($num2 > 0) {?>
                            <?php if($cat_res2['parentID']=='0'){?>
                        <li><a href="javascript:void();"
                                title="<?php echo $cat_res2['catName']; ?>"><?php echo $cat_res2['catName']; ?></a>
                                <?php } else{?>
                                    <li><a href="<?=site_url;?>/<?=getValidFileName($ca_nam1);?>/<?=getValidFileName($cat_res2['catName']);?>.htm"
                                    title="<?php echo $cat_res2['catName']; ?>"><?php echo $cat_res2['catName']; ?></a>
                        </li>
                        <?php  } } ?>
                        <li class="active"><?php echo $cat_res['catName'];?></li>
                    </ul>
                </div>
            </div>
        </div>
    </div>
    <section class="category_page">
        <div class="container">
            <!-- <div class="tt-bx">
                <h2 class="tt"><?=$heading2;?> <span> in <?=$ca_nam1;?></span></h2>
            </div> -->
            <div class="clearfix"></div>
            <div class="row">
                <div class="col-xxl-12 col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
                    <div class="wps_right">
                        <div class="product_right_image">
                            <div class="more_images">
                                <div class="single_image">
                                    <a href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#productID"
                                        onclick="$('.catID').val('<?php echo $cat_res['catID'];?>');
                                        $('.catName').html('<?php echo $cat_res['catName'];?>');
                                        $('.catImg').attr('src','<?=$imglink;?>');  $('.catImg').attr('alt','<?=$alttag;?>'); $('.catImg').attr('title','<?=$alttag;?>');"
                                        title="<?=$alttag;?>">
                                        <img id="largeImage" src="<?=$imglink;?>" alt="<?=$alttag;?>"
                                            title="<?=$alttag;?>">
                                    </a>
                                </div>
                                <div id="thumbs">
                                    <?php



if (!empty($multi_image[0])) {
    $snn = 1;
  foreach ($multi_image as $multi_imag_vals) { ?>
                                    <img class="item"
                                        src="<?= site_url; ?>/uploaded-files/category/images/<?= $multi_imag_vals; ?>"
                                        alt="<?= $disTitles; ?> Manufacturers in <?=$ca_nam1;?>"
                                        title="<?= $disTitles; ?> Manufacturers in <?=$ca_nam1;?>">
                                    <?php $snn++;
 }
}
?>
                                </div>
                            </div>
                            <a class="readMore" href="javascript:void(0);" data-bs-toggle="modal"
                                data-bs-target="#productID"   onclick="$('.catID').val('<?php echo $cat_res['catID'];?>');
$('.catName').html('<?php echo $cat_res['catName'];?>');
$('.catImg').attr('src','<?=$imglink;?>');  $('.catImg').attr('alt','<?=$alttag;?>'); $('.catImg').attr('title','<?=$alttag;?>');" title="Get Best Quote">
                                Get Best Quote <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16"
                                    fill="currentColor" viewBox="0 0 16 16">
                                    <path
                                        d="M.05 3.555A2 2 0 0 1 2 2h12a2 2 0 0 1 1.95 1.555L8 8.414.05 3.555ZM0 4.697v7.104l5.803-3.558L0 4.697ZM6.761 8.83l-6.57 4.027A2 2 0 0 0 2 14h12a2 2 0 0 0 1.808-1.144l-6.57-4.027L8 9.586l-1.239-.757Zm3.436-.586L16 11.801V4.697l-5.803 3.546Z">
                                    </path>
                                </svg></a>
                        </div>
                        <?php if($page_desc!=''){ ?>
                                <?=html_entity_decode($page_desc);?>
                                    <?php }else{ ?>
                                    <?=html_entity_decode($page_desc1);?>
                                    <?php   } ?>


                                    <?php
                    $whr = ' FIND_IN_SET(' . $cat_res['catID'] . ', product_cat)';
                    $totalcount = mysqli_num_rows(mysqli_query($GLOBALS['dbconn'], "select product_id from product_tbl where   " . $whr . "  order by product_id desc"));
                    $product_s = mysqli_query($GLOBALS['dbconn'], "select product_image,product_title,catalog,product_id,product_video,product_specfi from product_tbl where   " . $whr . "  order by product_id desc limit 9");
                    $num = mysqli_num_rows($product_s);
                    if ($num > 0) {    ?>
                        <div class="tt-bx text-start float-start my-3  d-block w-100 mb-2">
                            <div class="tt fs-4">Products Related to <span><?=$disTitles;?></span></div>
                        </div>
                        <!-- <div class="you_may">You may Also Like These</div> -->
                        <div class="allListing product-container">
                        <?php $i=1;



while($product_r=mysqli_fetch_array($product_s)){
         $pro_image =  explode(',',$product_r['product_image']);
        $probig_img=$pro_image[0];
        $prod_img=getImage($probig_img, 400, 400, $product_r['product_title'],"/uploaded-files/product-images/");
         $prod_imgsmall=getImage($probig_img, 175, 177, $product_r['product_title'],"/uploaded-files/product-images/");
        ?>
                            <div class="product_listing productlist">
                                <div class="row">
                                    <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-12 col-12">
                                        <div class="product">
                                            <div class="single_image">
                                            <a class="largeImage" id="bigImage<?=$i;?>" href="javascript:void(0);"
                                                    data-bs-toggle="modal" data-bs-target="#productID"
                                                    onclick="$('.catID').val('<?php echo $product_r['product_id'];?>');
$('.catName').html('<?php echo $product_r['product_title'];?>');  $('.catImg').attr('src','<?=$prod_img;?>'); $('.catImg').attr('alt','<?=$product_r['product_title'];?> in <?=$ca_nam1;?>'); $('.catImg').attr('title','<?=$product_r['product_title'];?> in <?=$ca_nam1;?>');"
                                                    title="<?=$product_r['product_title'];?> in <?=$ca_nam1;?>">
                                                    <img src="<?=$prod_img;?>"
                                                        alt="<?=$product_r['product_title'];?> Manufacturers, Suppliers in <?=$ca_nam1;?>"
                                                        title="<?=$product_r['product_title'];?> Manufacturers, Suppliers in <?=$ca_nam1;?>">
                                                </a>
                                            </div>
                                            <div id="small<?=$i;?>" class="small">
                                            <?php



if(!empty($pro_image[1])){
    $snn=1;

foreach($pro_image as $pro_imag_vals){?>
                                                <img class="item <?=$snn=='1'?'active':'';?>"
                                                    src="<?=site_url;?>/uploaded-files/product-images/<?=$pro_imag_vals;?>"
                                                    alt="<?=$product_r['product_title'];?> Manufacturers, Suppliers in <?=$ca_nam1;?>"
                                                    title="<?=$product_r['product_title'];?> Manufacturers, Suppliers in <?=$ca_nam1;?>">
                                                <?php $snn++; } } ?>
                                                
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xxl-8 col-xl-8 col-lg-8 col-md-8 col-sm-12 col-12">
                                        <div class="right-content">
                                            <h4 class="head"><?=$product_r['product_title'];?> in <?=$ca_nam1;?></h4>
                                            <div class="blue-line1"></div>
                                            <?php if($product_r['catalog']!=''){ ?>
                                            <div class="productBrochureandvideo">
                                                    <a href="<?=site_url;?>/uploaded-files/pdf/<?=$product_r['catalog'];?>" title="Product Brochure" target="_blank">
                                                        <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-filetype-pdf" viewBox="0 0 16 16">
                                                            <path fill-rule="evenodd" d="M14 4.5V14a2 2 0 0 1-2 2h-1v-1h1a1 1 0 0 0 1-1V4.5h-2A1.5 1.5 0 0 1 9.5 3V1H4a1 1 0 0 0-1 1v9H2V2a2 2 0 0 1 2-2h5.5L14 4.5ZM1.6 11.85H0v3.999h.791v-1.342h.803c.287 0 .531-.057.732-.173.203-.117.358-.275.463-.474a1.42 1.42 0 0 0 .161-.677c0-.25-.053-.476-.158-.677a1.176 1.176 0 0 0-.46-.477c-.2-.12-.443-.179-.732-.179Zm.545 1.333a.795.795 0 0 1-.085.38.574.574 0 0 1-.238.241.794.794 0 0 1-.375.082H.788V12.48h.66c.218 0 .389.06.512.181.123.122.185.296.185.522Zm1.217-1.333v3.999h1.46c.401 0 .734-.08.998-.237a1.45 1.45 0 0 0 .595-.689c.13-.3.196-.662.196-1.084 0-.42-.065-.778-.196-1.075a1.426 1.426 0 0 0-.589-.68c-.264-.156-.599-.234-1.005-.234H3.362Zm.791.645h.563c.248 0 .45.05.609.152a.89.89 0 0 1 .354.454c.079.201.118.452.118.753a2.3 2.3 0 0 1-.068.592 1.14 1.14 0 0 1-.196.422.8.8 0 0 1-.334.252 1.298 1.298 0 0 1-.483.082h-.563v-2.707Zm3.743 1.763v1.591h-.79V11.85h2.548v.653H7.896v1.117h1.606v.638H7.896Z">
                                                            </path>
                                                        </svg>
                                                        <span>Product Brochure</span>
                                                    </a>
                                                </div>
                                                <?php } ?>
                                                 <div class="more_info">
                                                 <?=html_entity_decode($product_r['product_specfi']);?>
                                            </div>
                                            <div class="clearfix"></div>
                                            <div class="button_two">
                                            <div class="butt_se">
                                            <a class="readMore" href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#productID"  onclick="$('.catID').val('<?php echo $product_r['product_id'];?>');
$('.catName').html('<?php echo $product_r['product_title'];?>');  $('.catImg').attr('src','<?=$prod_img;?>'); $('.catImg').attr('alt','<?=$product_r['product_title'];?> in <?=$ca_nam1;?>'); $('.catImg').attr('title','<?=$product_r['product_title'];?> in <?=$ca_nam1;?>');" title="Get Best Quote">
                                                Get Best Quote <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                                    <path d="M.05 3.555A2 2 0 0 1 2 2h12a2 2 0 0 1 1.95 1.555L8 8.414.05 3.555ZM0 4.697v7.104l5.803-3.558L0 4.697ZM6.761 8.83l-6.57 4.027A2 2 0 0 0 2 14h12a2 2 0 0 0 1.808-1.144l-6.57-4.027L8 9.586l-1.239-.757Zm3.436-.586L16 11.801V4.697l-5.803 3.546Z" />
                                                </svg></a>
                                            <a class="readMore" href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#callback"  onclick="$('.catID').val('<?php echo $product_r['product_id'];?>');
$('.catName').html('<?php echo $product_r['product_title'];?>');  $('.catImg').attr('src','<?=$prod_imgsmall;?>'); $('.catImg').attr('alt','<?=$product_r['product_title'];?> in <?=$ca_nam1;?>'); $('.catImg').attr('title','<?=$product_r['product_title'];?> in <?=$ca_nam1;?>');" title="Request A Callback">
                                                Request A Callback <svg fill="currentColor" width="24px" height="24px" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg">
                                                    <g data-name="Layer 2">
                                                        <g data-name="phone-call">
                                                            <rect width="24" height="24" opacity="0" />
                                                            <path d="M13 8a3 3 0 0 1 3 3 1 1 0 0 0 2 0 5 5 0 0 0-5-5 1 1 0 0 0 0 2z" />
                                                            <path d="M13 4a7 7 0 0 1 7 7 1 1 0 0 0 2 0 9 9 0 0 0-9-9 1 1 0 0 0 0 2z" />
                                                            <path d="M21.75 15.91a1 1 0 0 0-.72-.65l-6-1.37a1 1 0 0 0-.92.26c-.14.13-.15.14-.8 1.38a9.91 9.91 0 0 1-4.87-4.89C9.71 10 9.72 10 9.85 9.85a1 1 0 0 0 .26-.92L8.74 3a1 1 0 0 0-.65-.72 3.79 3.79 0 0 0-.72-.18A3.94 3.94 0 0 0 6.6 2 4.6 4.6 0 0 0 2 6.6 15.42 15.42 0 0 0 17.4 22a4.6 4.6 0 0 0 4.6-4.6 4.77 4.77 0 0 0-.06-.76 4.34 4.34 0 0 0-.19-.73zM17.4 20A13.41 13.41 0 0 1 4 6.6 2.61 2.61 0 0 1 6.6 4h.33L8 8.64l-.54.28c-.86.45-1.54.81-1.18 1.59a11.85 11.85 0 0 0 7.18 7.21c.84.34 1.17-.29 1.62-1.16l.29-.55L20 17.07v.33a2.61 2.61 0 0 1-2.6 2.6z" />
                                                        </g>
                                                    </g>
                                                </svg></a>
                                                </div>
                                                <div class="video_bbt">
                                                <?php if($product_r['product_video']!=''){ ?>
                                                <div class="item youtube">
                                                    <a data-fancybox="" href="https://www.youtube.com/watch?v=<?=$product_r['product_video'];?>" title="Youtube Video">
                                                        <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                                            <path d="m11.596 8.697-6.363 3.692c-.54.313-1.233-.066-1.233-.697V4.308c0-.63.692-1.01 1.233-.696l6.363 3.692a.802.802 0 0 1 0 1.393z">
                                                            </path>
                                                        </svg>
                                                    </a>
                                                </div>
                                                <?php } else if($cat_res['catVideo']!=''){  ?>
                                                    <div class="item youtube">
                                                    <a data-fancybox="" href="https://www.youtube.com/watch?v=<?=$cat_res['catVideo'];?>">
                                                        <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                                            <path d="m11.596 8.697-6.363 3.692c-.54.313-1.233-.066-1.233-.697V4.308c0-.63.692-1.01 1.233-.696l6.363 3.692a.802.802 0 0 1 0 1.393z">
                                                            </path>
                                                        </svg>
                                                    </a>
                                                </div>
<?php } else if($admin_res['company_video']!=''){  ?>       <a data-fancybox="" href="https://www.youtube.com/watch?v=<?=$admin_res['company_video'];?>">
                                                        <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                                            <path d="m11.596 8.697-6.363 3.692c-.54.313-1.233-.066-1.233-.697V4.308c0-.63.692-1.01 1.233-.696l6.363 3.692a.802.802 0 0 1 0 1.393z">
                                                            </path>
                                                        </svg>
                                                    </a>
                                                        <?php } ?>
                                                        </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <script>
                            $('#small<?=$i;?> .item').click(function() {
            $('#bigImage<?=$i;?> img').attr('src', $(this).attr('src').replace('thumb', 'large'));
            if ($(this).hasClass("active")) {
                $("#small<?=$i;?> .item").removeClass("active");
            } else {
                $("#small<?=$i;?> .item").removeClass("active");
                $(this).addClass("active");
            }
        });
        </script>
                            <?php $i++; } ?>
                        </div>
                        <?php if (mysqli_num_rows($product_s) > 8) { ?>
                                      <?php echo '<div class="mt-2 text-center" id="loadmore" data-id="' . $whr . '"><i class="fa fa-spinner fa-spin"></i> Loading...</div>';
                                             } ?>
                        <?php } ?>
                        
                        <div class="tt-bx text-start float-start  d-block w-100 mb-2">
                            <div class="tt fs-4">All Category <span>Range</span></div>
                        </div>
                        <!-- <div class="you_may">All Category Range</div> -->
                        <div class="allListing">
                            <div class="row">
                            <?php



if(mysqli_num_rows($cat_qry)>0){
$subcat_sql=$cat_qry;
}else{
   $subcat_sql=mysqli_query($GLOBALS['dbconn'],"select catImage, catName, displayName, catDesc, catID, catDesc1, parentID from category_tbl where parentID ='$parent' and status='Y' and catID!='$category_id' order by catOrder Asc");
}



while($sub_res=mysqli_fetch_array($subcat_sql)) {



if($sub_res['catImage'] != ''){
    $img_link = getImage($sub_res[catImage], 300, 300, $sub_res[catName],"/uploaded-files/category/images/");
    $img_link1 = getImage($sub_res[catImage], 436, 429, $sub_res[catName],"/uploaded-files/category/images/");
}else{
    $img_link = getImage("noimage.jpg",  300, 300, "noimages","/uploaded-files/category/images/");
    $img_link1 = getImage("noimage.jpg", 436, 429, "noimages","/uploaded-files/category/images/");
}
$catIdss=$sub_res['catID'];
$sql_content=mysqli_query($dbconn,"select short_description from location_content_tbl where category_id ='$catIdss'");
$res_content=mysqli_fetch_array($sql_content);
$subcontent_descc=html_entity_decode($res_content['short_description']);
$subcontent_desccc=str_replace('{location}', $ca_nam1, $subcontent_descc );
$subcontent_descccc=str_replace('catname', $res_cat['catName'], $subcontent_desccc );
$subcontent_descccc=str_ireplace('{companyName}',$admin_res['companyName'], $subcontent_descccc);
?>
                                <div class="col-lg-6 col-md-6">
                                    <div class="product_listing">
                                        <div class="row">
                                            <div class="col-xxl-5 col-xl-5 col-lg-5 col-md-12 col-sm-12 col-12">
                                                <div class="product">
                                                    <a href="<?=site_url;?>/<?=getValidFileName($ca_nam1);?>/<?=getValidFileName($sub_res['catName']);?>.htm" title="<?= $sub_res['displayName'];?> Manufacturers in <?=$ca_nam1;?>">
                                                        <div class="image1">
                                                            <img src="<?=$img_link;?>"
                                                                alt="<?= $sub_res['displayName'];?> Manufacturers in <?=$ca_nam1;?>" title="<?= $sub_res['displayName'];?> Manufacturers in <?=$ca_nam1;?>">
                                                        </div>
                                                    </a>
                                                </div>
                                            </div>
                                            <div class="col-xxl-7 col-xl-7 col-lg-7 col-md-12 col-sm-12 col-12">
                                                <div class="right-content">
                                                    <div class="head"><a href="<?=site_url;?>/<?=getValidFileName($ca_nam1);?>/<?=getValidFileName($sub_res['catName']);?>.htm" title="<?= $sub_res['displayName'];?> Manufacturers in <?=$ca_nam1;?>"><?= $sub_res['displayName'];?></a>
                                                    </div>
                                                    <div class="blue-line1"></div>
                                                    <div class="more_info">
                                                        <p><?=substr($subcontent_descccc,0,200);?>...</p>
                                                    </div>
                                                    <div class="clearfix"></div>
                                                    <a class="readMore" href="javascript:void(0);"
                                                        data-bs-toggle="modal" data-bs-target="#productID"  onclick="$('.catID').val('<?php echo $sub_res['catID'];?>');
$('.catName').html('<?php echo $sub_res['catName'];?>');
$('.catImg').attr('src','<?= $img_link1;?>'); $('.catImg').attr('alt','<?= $sub_res['displayName'];?> in <?=$ca_nam1;?>'); $('.catImg').attr('title','<?= $sub_res['displayName'];?> in <?=$ca_nam1;?>');"
                                                        title="Get Best Quote"> Get Best Quote <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                                            <path d="M.05 3.555A2 2 0 0 1 2 2h12a2 2 0 0 1 1.95 1.555L8 8.414.05 3.555ZM0 4.697v7.104l5.803-3.558L0 4.697ZM6.761 8.83l-6.57 4.027A2 2 0 0 0 2 14h12a2 2 0 0 0 1.808-1.144l-6.57-4.027L8 9.586l-1.239-.757Zm3.436-.586L16 11.801V4.697l-5.803 3.546Z" />
                                                        </svg></a>
                                                    <a href="<?=site_url;?>/<?=getValidFileName($ca_nam1);?>/<?=getValidFileName($sub_res['catName']);?>.htm" class="readMore" title="View More">View More <svg
                                                            xmlns="http://www.w3.org/2000/svg" width="16" height="16"
                                                            fill="currentColor" viewBox="0 0 16 16">
                                                            <path fill-rule="evenodd"
                                                                d="M1 8a.5.5 0 0 1 .5-.5h11.793l-3.147-3.146a.5.5 0 0 1 .708-.708l4 4a.5.5 0 0 1 0 .708l-4 4a.5.5 0 0 1-.708-.708L13.293 8.5H1.5A.5.5 0 0 1 1 8z">
                                                            </path>
                                                        </svg></a>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <?php } ?>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <?php include "app_footer_sub.php"; ?>
    <?php include "app_bottom.php"; ?>
    <script>
      var loading = false;
      $(window).scroll(function() {
        var offset = $("#loadmore").offset().top;
        if ($(window).scrollTop() >= offset - 500) {
          let whr = $("#loadmore").data('id');
          let start = $('.productlist').length;
          if (loading === false) {
            loading = true;
            $.ajax({
              url: '<?= site_url ?>/ajaxloadcategory.php',
              data: {
                whr: whr,
                start: start,
                loadmores: '<?= $admin_res['targetlocation']; ?>'
              },
              type: 'post',
              success: function(r) {
                $('.product-container').append(r);
                if (r.length > 5) {
                  loading = false;
                } else {
                  $("#loadmore").remove();
                }

                if (start == <?= $totalcount; ?>) {
                  $("#loadmore").remove();
                }
              }
            });
          }
        }
      })
    </script>

</body>
</html>
<?php
}



else
{
    header("Location: ".site_url);
    exit;
}
?>