<?php

include_once("include/main.inc.php");

@extract($_REQUEST);



if (preg_match('webpulse\.co$/', $_SERVER['HTTP_HOST'], $match)) {

  $match1 = $match[1];

  $vanity_url = 'http://' . $_SERVER['HTTP_HOST'];

}

$actual_link = "https://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";

$ee = explode('/', $actual_link);

$loc_url = $ee[3];

$cat_url = $_REQUEST['pid'];

$cats = ucwords(str_replace("-", " ", $_REQUEST['pid']));

$cat_s = "select catName, catID from category_tbl where catName='$cats' or catUrl='$cat_url'";

$cat_q = mysqli_query($GLOBALS['dbconn'], $cat_s);



if (mysqli_num_rows($cat_q) > 0) {

} else {

  header("Location: " . site_url);

  exit;

}

$num = mysqli_num_rows($cat_q);

$cat_r = mysqli_fetch_array($cat_q);

if ($cat_r['catID'] == 1) {
    header("Location: " . site_url);
    exit;
}

$category_id = $cat_r['catID'];

$hover='category';

$catn = $cat_r['catName'];

$cat_sql = "select catImage, catName, displayName, catDesc, catID, catDesc1, parentID,catUrl,alt, title 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,catHeading1, catHeading2,alt,pageTitle,pageKeywords,pageDescription,multi_image,catDesc2 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'];



$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 (10).jpg", 500, 500, "noimage", "/uploaded-files/category/images/");

}

$loc_sql = mysqli_query($GLOBALS['dbconn'], "select locationID,locationName,loc_url from location_tbl where loc_url='$loc_url' and status='Y'");

$location = mysqli_fetch_array($loc_sql);

$locationName = $location['locationName'];

$location_id = $location['locationID'];

$category_sub_general = mysqli_query($dbconn, "select location_ids,meta_title,meta_keyword,meta_description,description,short_description,subheadingtwo,description2 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_metatitle = $categorysubdomain['meta_title'];

      }

      if ($categorysubdomain['meta_keyword'] != '') {

        $page_metakey = $categorysubdomain['meta_keyword'];

      }

      if ($categorysubdomain['meta_description']) {

        $page_metadesc = $categorysubdomain['meta_description'];

      }

      $page_desc = $categorysubdomain['description'];

      $page_desc2 = $categorysubdomain['description2'];

    }

  }

  //    specific location content

}



if ($cat_res['keyword1'] != '' && $cat_res['keyword2'] != '' && $cat_res['keyword3'] != '') {
  $m_title = "hotkeyword1 Manufacturers in location, hotkeyword2 Suppliers, Exporters in location";
  $page_metatitle = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('hotkeyword2', $cat_res[keyword2], str_replace('location', $locationName, $m_title)));
  $m_keyword = "hotkeyword1 in location, hotkeyword2 in location, hotkeyword1 Manufacturers in location, hotkeyword2 Manufacturers in location, hotkeyword1 Suppliers in location, hotkeyword2 Suppliers in location, hotkeyword1 Exporters in location, hotkeyword2 Exporters 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', $locationName, $m_keyword))));
  $meta_des = "companyName leading hotkeyword1 Manufacturers in location, since 2014. Premium Quality hotkeyword2 Suppliers Exporters in location, Get latest factory price for hotkeyword3. ✓Fast Delivery ✓Good Price ✓Premium Quality";
  $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', $locationName, $meta_des))))));
} else if ($cat_res['keyword1'] != '' && $cat_res['keyword2'] != '') {
  $m_title = "hotkeyword1 Manufacturers in location, hotkeyword2 Suppliers Exporters in location";
  $page_metatitle = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('hotkeyword2', $cat_res[keyword2], str_replace('location', $locationName, $m_title)));
  $m_keyword = "hotkeyword1 in location, hotkeyword2 in location, hotkeyword1 Manufacturers in location, hotkeyword2 Manufacturers in location, hotkeyword1 Suppliers in location, hotkeyword2 Suppliers in location";
  $page_metakey = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('hotkeyword2', $cat_res[keyword2], str_replace('location', $locationName, $m_keyword)));
  $meta_des = "companyName leading hotkeyword1 Manufacturers in location, since 2014. Premium Quality hotkeyword2 Suppliers, Exporters in location, Get latest factory price for hotkeyword1. ✓Fast Delivery ✓Good Price";
  $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', $locationName, $meta_des)))));
} else if ($cat_res['keyword1'] != '') {
  $m_title = "hotkeyword1 Manufacturers in location, hotkeyword1 Suppliers Exporters in location";
  $page_metatitle = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('location', $locationName, $m_title));
  $m_keyword = "hotkeyword1 in location, hotkeyword1 Manufacturers in location, hotkeyword1 Suppliers in location, hotkeyword1 Exporters in location";
  $page_metakey = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('location', $locationName, $m_keyword));
  $meta_des = "companyName leading hotkeyword1 Manufacturers in location, since 2014. Premium Quality hotkeyword1 Suppliers Exporters in locationh, Get latest factory price for hotkeyword1. ✓Fast Delivery ✓Good Price ✓Premium Quality";
  $page_metadesc = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('companyName', $admin_res[companyName], str_replace('phone', $admin_res['mobile_meta'], str_replace('location', $locationName, $meta_des))));
} else {
  $page_metatitle = $page_metatitle1;
  $page_metakey = $page_metakey1;
  $page_metadesc = $page_metadesc1;
}

$page_desc = str_replace('countryname', $locationName, $page_desc);

$page_desc = str_replace('catname', $pid, $page_desc);

$page_desc = str_replace('{location}', $locationName, $page_desc);

$page_desc = str_ireplace('{companyName}', $admin_res['companyName'], $page_desc);

// for second description

$page_desc2 = str_replace('countryname', $locationName, $page_desc2);

$page_desc2 = str_replace('catname', $pid, $page_desc2);

$page_desc2 = str_replace('{location}', $locationName, $page_desc2);

$page_desc2 = str_ireplace('{companyName}', $admin_res['companyName'], $page_desc2);

// meta keywords

$page_metatitle = str_replace('countryname', $locationName, $page_metatitle);

$page_metatitle = str_replace('catname', $pid, $page_metatitle);

$page_metatitle = str_replace('{location}', $locationName, $page_metatitle);

$page_metakey = str_replace('countryname', $locationName, $page_metakey);

$page_metakey = str_replace('catname', $pid, $page_metakey);

$page_metakey = str_replace('{location}', $locationName, $page_metakey);

$page_metadesc = str_replace('countryname', $locationName, $page_metadesc);

$page_metadesc = str_replace('catname', $pid, $page_metadesc);

$page_metadesc = str_replace('{location}', $locationName, $page_metadesc);

// if location not checked in admin

$category_sub_uncheck_loc = mysqli_query($GLOBALS['dbconn'], "select description,subheadingtwo,meta_title,meta_keyword,meta_description,short_description,description2 from location_content_tbl where category_id='$category_id' AND location_id='0'");

$category_sub_uncheck_res = mysqli_fetch_array($category_sub_uncheck_loc);



// // For metatitle 1 (uncheck location)

// $page_metatitle = $category_sub_uncheck_res['meta_title'];

// $page_metatitle= str_replace('{location}', $locationName,  $page_metatitle);

// $page_metatitle= str_ireplace('{companyName}', $admin_res['companyName'], $page_metatitle);



// // For metadescription 1 (uncheck location)

// $page_metadesc = $category_sub_uncheck_res['meta_description'];

// $page_metadesc= str_replace('{location}', $locationName,  $page_metadesc);

// $page_metadesc= str_ireplace('{companyName}', $admin_res['companyName'], $page_metadesc);





// // For metakeyword 1 (uncheck location)

// $page_metakey = $category_sub_uncheck_res['meta_keyword'];

// $page_metakey= str_replace('{location}', $locationName,  $page_metakey);

// $page_metakey= str_ireplace('{companyName}', $admin_res['companyName'], $page_metakey);





// For description 1 (uncheck location)

$page_descUncheck = $category_sub_uncheck_res['description'];

$page_descUncheck = str_replace('{location}', $locationName,  $page_descUncheck);

$page_descUncheck = str_ireplace('{companyName}', $admin_res['companyName'], $page_descUncheck);

// For description 2 (uncheck location)

$page_desc2Uncheck = $category_sub_uncheck_res['description'];

$page_desc2Uncheck = str_replace('{location}', $locationName,  $page_desc2Uncheck);

$page_desc2Uncheck = str_ireplace('{companyName}', $admin_res['companyName'], $page_desc2Uncheck);

$page_desc = $page_desc != '' ? $page_desc : $page_descUncheck;

$page_desc2 = $page_desc2 != '' ? $page_desc2 : $page_desc2Uncheck;







// if ($cat_res['catHeading1'] != '') {

//   $heading1 = $cat_res['catHeading1'] . ' Services in ' . $locationName;

// } else {

//   $heading1 = $disTitles . ' Services in ' . $locationName;

// }



if ($cat_res['catHeading1'] != '') {

    $heading1 = $cat_res['catHeading1'] . ' Manufacturers in ' . $locationName;

} else {

    // Join array into a string

    $heading1 = $disTitles . ' Manufacturers in ' . $locationName;

}



if ($cat_res['catHeading2'] != '') {

  $heading2 = $cat_res['catHeading2'] . ' in ' . $locationName;

} else {

  $heading2 = $disTitles . ' in ' . $locationName;

}



// if ($cat_res['alt'] != '') {

//   $alttag = $cat_res['alt'] . ' Services in ' . $locationName;

// } else {

//   $alttag = $disTitles . ' Services in ' . $locationName;

// }



if ($cat_res['alttag'] != '') {

    $alttag = $cat_res['alttag'] . ' in ' . $locationName;

} else {

    if ($cat_res['catID'] == '8') {

        $alttag = $cat_res['displayName'] . ' Manufacturers in ' . $locationName;

    } else {

        $alttag = $disTitles . ' Manufacturers in ' . $locationName;

    }

}





if (mysqli_num_rows($loc_sql) > 0) {

} else {

  header("Location: " . site_url);

  exit;

}

?>
<!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/bannersmalls1.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 class="cat_title2">We Are Available For You</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">
                        <li><a href="<?=site_url;?>" title="Home">Home</a></li>
                        <?php if ($num4 > 0) { ?>
                            <li><a href="<?= site_url; ?>/<?= getValidFileName($loc_url); ?>/<?= getValidFileName($cat_res4['catName']); ?>.htm"
                                    title="<?php echo $cat_res4['displayName']; ?> "><?php echo $cat_res4['displayName']; ?></a>
                            </li>
                        <?php } ?>
                        <?php if ($num3 > 0) { ?>
                                <?php if ($cat_res3['catID'] == '1') { ?>
                                    <li><a href="javascript:void(0);"
                                            title="<?php echo $cat_res3['displayName']; ?>"><?php echo $cat_res3['displayName']; ?></a></li>
                                <?php } else { ?>
                                    <li><a href="<?= site_url; ?>/<?= getValidFileName($loc_url); ?>/<?= getValidFileName($cat_res3['catName']); ?>.htm"
                                            title="<?php echo $cat_res3['displayName']; ?>"><?php echo $cat_res3['displayName']; ?></a>
                                    </li>
                            <?php  }
                            } ?>
                       <?php if ($num2 > 0) { ?>
                                <?php if ($cat_res2['catID'] == '1') { ?>
                                    <li><a href="javascript:void(0);"
                                            title="<?php echo $cat_res2['displayName']; ?>"><?php echo $cat_res2['displayName']; ?></a></li>
                                <?php } else { ?>
                                    <li><a href="<?= site_url; ?>/<?= getValidFileName($loc_url); ?>/<?= getValidFileName($cat_res2['catName']); ?>.htm"
                                            title="<?php echo $cat_res2['displayName']; ?>"><?php echo $cat_res2['displayName']; ?></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="title_21 h2_title  aboutTitle">Wardrobe <span>In Delhi</span></div> -->
            <!-- <div class="w-75 mx-auto text-center text-white mb-4">
                <h2 class="h2_title_1 wow fadeInDown" data-wow-delay=".1s"><?= $heading2; ?></h2>

            </div> -->
            <!-- <h2 class="title_1">Category Details</h2> -->
            <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="Get Best Quote"><img src="<?= $imglink; ?>"
                                            alt="<?= $alttag; ?>" title="<?= $alttag; ?>">
                                    </a>
                                </div>

                            </div>
                            <a class="readMore_2" 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">
                                <span>
                                    <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> Get Best Quote</span></a>
                        </div>
                        <?php echo html_entity_decode($page_desc); ?>




                    </div>

                </div>

            </div>
        </div>

        <div class="container">
              <?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 product_status='1' AND " . $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 6");
                    $num = mysqli_num_rows($product_s);
                    if ($num > 0) {    ?>
<div class="you_may mt-5 mb-4 d-block">Products Related To <?=$disTitles;?></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];
                                $imgname = explode('.', $pro_image[0]);
                                $prod_img = getImage($probig_img, 475, 475, $product_r['product_title'] . $imgname[0], "/uploaded-files/product-images/");
                                $prod_imgsmall = getImage($probig_img, 50, 50, $product_r['product_title'], "/uploaded-files/product-images/");

                            ?>
                            <div class="product_listing productlist">
                                <div class="row">
                                    <div class="col-xxl-5 col-xl-5 col-lg-5 col-md-5 col-sm-12 col-12">
                                        <div class="product">
                                            <div class="product-lists">
                                                <div class="w-100">
                                                    <a href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#productID"
                                            onclick="var src = $(this).find('img.clickable-image').attr('src');$('.catID').val('<?php echo $product_r['product_id']; ?>');$('.catName').html('<?php echo $product_r['product_title']; ?>');  $('.catImg').attr('src', src); $('.catImg').attr('alt','<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?=$locationName;?>'); $('.catImg').attr('title','<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?=$locationName;?>');"
                                            title="Enquiry Now">
                                            <img id="myImage<?= $product_r['product_id']; ?>" src="<?= $prod_img; ?>"
                                                class="w-100 clickable-image"
                                                alt="<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?=$locationName;?>"
                                                title="<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?=$locationName;?>">
                                        </a>
                                                </div>
                                                <div class="slider d-flex justify-content-center">
                                                     <?php
                                                            if (!empty($pro_image[1])) {
                                                                $snn = 1;
                                                                foreach ($pro_image as $pro_imag_vals) { ?>
                                                    <div class="slides p-0 h-auto d-block m-1 bg-dark  <?= $snn == 1 ? 'active' : ''; ?>"
                                                        onclick="imgMulti(<?= $product_r['product_id']; ?>, '<?= getImage($pro_imag_vals, 375, 375, $product_r['product_title'] . $product_r['product_id'] . $snn, '/uploaded-files/product-images/'); ?>', this)">
                                                        <img src="<?= getImage($pro_imag_vals, 50, 50, $product_r['product_title'] . $product_r['product_id'] . $snn, '/uploaded-files/product-images/'); ?>" class="w-100" alt="<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?=$locationName;?>" title="<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?=$locationName;?>">
                                                    </div>
                                                    <?php $snn++;
                                                                }
                                                            } ?>
                                                    <!-- <div class="slides  p-0 h-auto d-block m-1 bg-dark "
                                                        onclick="imgMulti(2, 'designer/images/product/Carbon-Stocker-Bush.jpg', this)">
                                                        <img src="designer/images/product/Carbon-Stocker-Bush.jpg" class="w-100" alt="">
                                                    </div>
                                                    <div class="slides p-0 h-auto d-block m-1 bg-dark "
                                                        onclick="imgMulti(2, 'designer/images/product/Ceramic-Bush.jpg', this)">
                                                        <img src="designer/images/product/Ceramic-Bush.jpg" class="w-100" alt="">
                                                    </div> -->
                                                </div>
                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-xxl-7 col-xl-7 col-lg-7 col-md-7 col-sm-12 col-12">
                                        <div class="right-content">
                                            <div class="title4"><?= $product_r['product_title']; ?> in <?=$locationName;?></div>
                                            <div class="blue-line1"></div>
                                            <div class="d-flex">
                                                <?php if ($product_r['catalog'] != '') { ?>
                                                <div class="product_showcase">
                                                    <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>
                                                </div>
                                                <?php } ?>
                                                <?php if ($product_r['product_video'] != '') { ?>
                                                <div class="youtube">
                                                    <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>
                                                </div>
                                                <?php } ?>
											</div>
                                            <div class="more_info">
                                               <?= html_entity_decode($product_r['product_specfi']); ?>
                                            </div>

                                            <div class="clearfix"></div>
                                            <div class="d-flex justify-content-start">
                                                <a class="readMore_2  mx-1" 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','<?= site_url; ?>/uploaded-files/product-images/<?= $probig_img; ?>'); $('.catImg').attr('alt','<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?=$locationName;?>'); $('.catImg').attr('title','<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?=$locationName;?>');"
                                                    title="Enquiry Now">
                                                    <span><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> Enquiry Now</span></a>
                                                <a 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_img; ?>'); $('.catImg').attr('alt','<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?=$locationName;?>'); $('.catImg').attr('title','<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?=$locationName;?>');" title="Request A Callback" class="readMore_2 px-2 callback mx-1">
                                                    <span><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> Request A Callback</span></a>
                                            </div>

                                        </div>
                                    </div>
                                </div>
                            </div>
                            <?php $i++;
                            } ?>
                        </div>
                  
                            
                            <!-- second -->
                             


                        
                         <?php if (mysqli_num_rows($product_s) > 5) { ?>
          <?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="you_may">All Category Range</div>
            <div class="allListing categorysd">

             <?php
                                if (mysqli_num_rows($cat_qry) > 0) {
                                    $subcat_sql = $cat_qry;
                                } else {
                                    $sqlsub2 = mysqli_query($GLOBALS['dbconn'], "select catImage, catName, displayName, catDesc, catID, catDesc1, alt, title, parentID from category_tbl where parentID ='$parent' and status='Y' and catID!='$category_id' order by catOrder Asc");
                                    if (mysqli_num_rows($sqlsub2) > 1) {
                                        $subcat_sql = $sqlsub2;
                                    } else {
                                        $subcat_sql = mysqli_query($GLOBALS['dbconn'], "select catImage, catName, displayName,catDesc, catID, alt, title, catDesc1, parentID from category_tbl  where parentID ='0' 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], 415, 415, $sub_res[catName], "/uploaded-files/category/images/");
                                        $img_link1 = getImage($sub_res[catImage], 415, 415, $sub_res[catName], "/uploaded-files/category/images/");
                                    } else {
                                        $img_link = getImage("noimage (10).jpg",  415, 415, "noimage", "/uploaded-files/category/images/");
                                        $img_link1 = getImage("noimage (10).jpg", 415, 415, "noimage", "/uploaded-files/category/images/");
                                    }
                                    $caturls1 = !empty($sub_res['catUrl']) ? $sub_res['catUrl'] : $sub_res['catName'];

                                    $sub_desc = $sub_res['catDesc'];
            
            
            
                                    $catIdss = $sub_res['catID'];
            
                                                $sql_content = mysqli_query($GLOBALS['dbconn'], "select subheadingtwo,short_description,meta_title,meta_keyword,meta_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}', $locationName, $subcontent_descc);
            
                                                $subcontent_descccc = str_replace('catname', $res_cat['catName'], $subcontent_desccc);
            
                                                $subcontent_descccc = str_ireplace('{companyName}', $admin_res['companyName'], $subcontent_descccc);
            
            
            
                                                if ($sub_res['alt'] != '') {
            
                                                    $alttag1 = $sub_res['alt'] . ' in ' . $locationName;
            
                                                } else {
            
                                                    if ($sub_res['catID'] == '8') {
            
                                                        $alttag1 = $sub_res['displayName'] . ' in ' . $locationName;
            
                                                    } else {
            
                                                        $alttag1 = $sub_res['displayName'] . ' in ' . $locationName;
            
                                                    }
            
                                                }

                                   


                                ?>
                <div class="product_listing">
                    <div class="row">
                        <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-12 col-sm-12 col-12">
                            <div class="product">
                                <a href="<?= site_url; ?>/<?= getValidFileName($loc_url); ?>/<?= getValidFileName($caturls1); ?>.htm" title="<?= $sub_res['displayName']; ?> Manufacturers in <?=$locationName;?>">
                                    <div class="image1">
                                        <img src="<?= $img_link; ?>"
                                            alt="<?= $sub_res['displayName']; ?> Manufacturers in <?=$locationName;?>"
                                                    title="<?= $sub_res['displayName']; ?> Manufacturers in <?=$locationName;?>">
                                    </div>
                                </a>
                            </div>
                        </div>
                        <div class="col-xxl-8 col-xl-8 col-lg-8 col-md-12 col-sm-12 col-12">
                            <div class="right-content">
                                <h4 class="title4">
                                    <a href="<?= site_url; ?>/<?= getValidFileName($loc_url); ?>/<?= getValidFileName($caturls1); ?>.htm" title="<?= $sub_res['displayName']; ?> Manufacturers in <?=$locationName;?>"><?= $sub_res['displayName']; ?> in <?=$locationName;?></a>
                                            </h4>
                                <div class="blue-line1"></div>
                                <div class="more_info h-auto mb-0">
                                    <p><?= $subcontent_descccc; ?></p>
                                </div>
                                <div class="clearfix"></div>
                                <div class="d-flex">
                                    <a class="readMore_2 mx-1" 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']; ?> Manufacturers in <?=$locationName;?>'); $('.catImg').attr('title','<?= $sub_res['displayName']; ?> Manufacturers in <?=$locationName;?>');" title="Enquiry Now">
                                        <span> Enquiry Now</span></a>
                                    <a href="<?= site_url; ?>/<?= getValidFileName($loc_url); ?>/<?= getValidFileName($caturls1); ?>.htm" title="Read More" class="readMore_2 callback mx-1">
                                        <span> Read More</span></a>

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

                <?php } ?>
           
            </div>

        </div>
    </section>


    <?php include "app_footer_sub.php"; ?>
    <?php include "app_bottom.php"; ?>
    <script>
    function imgMulti(id, url, elm) {

        document.getElementById(`myImage${id}`).src = url;

        $(elm).addClass('active').siblings().removeClass('active');

    }
    </script>
    <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: '<?=$locationName;?>'
              },
              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>