<?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 = "http://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";
$ee = explode('/', $actual_link);
$mm = $ee[3];
$ss = explode('.', $mm);
$ca_nam1 = $ss[0];
$ca_nam1 = ucwords(str_replace("-", " ", $ca_nam1));
$pid = ucwords(str_replace("-", " ", $_REQUEST['pid']));
$cat_s = "select * from category_tbl where catName='$pid'";
$cat_q = mysqli_query($dbconn, $cat_s);
$num = mysqli_num_rows($cat_q);
$cat_r = mysqli_fetch_array($cat_q);
$category_id = $cat_r['catID'];
$hover = $category_id;
$catn = $cat_r['catName'];
$SITE_Url = getValidFileName($catn);
$cat_sql = "select * from category_tbl where parentID='$category_id' and status='Y'";
$cat_qry = mysqli_query($dbconn, $cat_sql);
$cccnum = mysqli_num_rows($cat_qry);
$cat_sql1 = "select * from category_tbl where catID='$category_id'";
$cat_qry1 = mysqli_query($dbconn, $cat_sql1);
$cat_res = mysqli_fetch_array($cat_qry1);

$page_metatitle = $cat_res['pageTitle'];
$page_metakey = $cat_res['pageKeywords'];
$page_metadesc = $cat_res['pageDescription'];




// $title=$cat_res['pageTitle'];
// $keyword=$cat_res['pageKeywords'];
// $desc=$cat_res['pageDescription'];
$pageTitles = $cat_res['catName'];
$disTitles = $cat_res['displayName'];
$pdes = $cat_res['catDesc'];
$pdes1 = $cat_res['catDesc1'];
$parent = $cat_res['parentID'];
$cat_sql2 = "select * from category_tbl where catID='$parent'";
$cat_qry2 = mysqli_query($dbconn, $cat_sql2);
$num2 = mysqli_num_rows($cat_qry2);
$cat_res2 = mysqli_fetch_array($cat_qry2);
$mparent = $cat_res2['parentID'];
$cat_sql3 = "select * from category_tbl where catID='$mparent'";
$cat_qry3 = mysqli_query($dbconn, $cat_sql3);
$num3 = mysqli_num_rows($cat_qry3);
$cat_res3 = mysqli_fetch_array($cat_qry3);
$mmparent = $cat_res3['parentID'];
$cat_sql4 = "select * from category_tbl where catID='$mmparent'";
$cat_qry4 = mysqli_query($dbconn, $cat_sql4);
$num4 = mysqli_num_rows($cat_qry4);
$cat_res4 = mysqli_fetch_array($cat_qry4);
$loc_sql = mysqli_query($dbconn, "SELECT * FROM location_tbl where locationName='$ca_nam1'");
$location = mysqli_fetch_array($loc_sql);
$location_id = $location['locationID'];
$SITE_loc = getValidFileName($ca_nam1);
$category_sub_specific = mysqli_query($dbconn, "select * from location_content_tbl where category_id='$category_id' AND location_id='$location_id'");
$category_sub_general = mysqli_query($dbconn, "select * from location_content_tbl where category_id='$category_id' AND location_id='0'");
$content_count = mysqli_num_rows($category_sub_specific);
if ($content_count > 0) {
    $categorysubdomain = mysqli_fetch_array($category_sub_specific);

    if ($cat_res['keyword1'] != '' && $cat_res['keyword2'] != '' && $cat_res['keyword3'] != '') {
        $m_title = "hotkeyword1 in location, hotkeyword2 Manufacturers, 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 in location, hotkeyword2 Manufacturers, 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 in location, hotkeyword1 Manufacturers, 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_metatitle = $categorysubdomain['meta_title'];
    $page_metakey = $categorysubdomain['meta_keyword'];
    $page_metadesc = $categorysubdomain['meta_description'];
    $page_desc = $categorysubdomain['description'];
    $page_short_desc = $categorysubdomain['short_description'];
    //    specific location content
} else {
    $categorysubdomain = mysqli_fetch_array($category_sub_general);
    $page_metatitle = $categorysubdomain['meta_title'];
    $page_metakey = $categorysubdomain['meta_keyword'];
    $page_metadesc = $categorysubdomain['meta_description'];
    $page_desc = $categorysubdomain['description'];
    $page_short_desc = $categorysubdomain['short_description'];
    //    general content
}
$page_desc = str_replace('{location}', $ca_nam1, $page_desc);
$page_desc = str_replace('catname', $pid, $page_desc);
$page_metatitle = str_replace('{location}', $ca_nam1, $page_metatitle);
$page_metatitle = str_replace('catname', $pid, $page_metatitle);
$page_metakey = str_replace('{location}', $ca_nam1, $page_metakey);
$page_metakey = str_replace('catname', $pid, $page_metakey);
$page_metadesc = str_replace('{location}', $ca_nam1, $page_metadesc);
$page_metadesc = str_replace('catname', $pid, $page_metadesc);
$page_short_desc = str_replace('{location}', $ca_nam1, $page_short_desc);
$page_short_desc = str_replace('catname', $pid, $page_short_desc);
$admin_sql = mysqli_query($dbconn, "select * from admin_details");
$admin_res = mysqli_fetch_array($admin_sql);
$mobile = $admin_res['mobile'];
$city = $admin_res['city'];
$state = $admin_res['state'];
$country = $admin_res['country'];
$companyName = $admin_res['companyName'];
$address = $admin_res['address'];

if (strpos($_SERVER['REQUEST_URI'], "?") !== false) {
    $uri_parts = explode('?', $_SERVER['REQUEST_URI']);
    $linksLoc = $uri_parts[0];
    header("Location: " . site_url . $linksLoc);
    exit;
}

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

$afterChunk = $eee[3];
$eem = explode('?', $afterChunk);

$finalUrl = $eem[1];
if ($finalUrl) {
    $url = site_url . "/" . SITE_loc . "/" . $SITE_Url . ".htm";
    echo "<script>
           window.location = '" . $url . "';
         </script>";
}

if ($num == 0) {

    echo "<script>window.location='https://www.stainlesssteelpipesinindia.com'</script>";
    exit;
}
if (mysqli_num_rows($loc_sql) > 0) {

?>


    <!DOCTYPE html>
    <html lang="en">

    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">

        <?php if ($page_metatitle != '') { ?>
            <title><?php echo $page_metatitle; ?></title>
            <meta name=description content="<?php echo $page_metadesc; ?>">
            <meta name=keywords content="<?php echo $page_metakey; ?>">
        <?php } else { ?>
            <title><?php echo $disTitles; ?></title>
            <meta name=description content="<?php echo $disTitles; ?>">
            <meta name=keywords content="<?php echo $disTitles; ?>">
        <?php } ?>
        <?php include "app_top.php"; ?>
    </head>

    <body>
        <?php include "app_header_sub.php"; ?>
        <?php
        if ($cat_res['catBanner'] != '') { ?>
            <section class="heading_banner"
                style="background-image:url(<?= site_url; ?>/uploaded-files/category/banners/<?php echo $cat_res['catBanner']; ?>)">
            <?php } else if ($cat_res2['catBanner'] != '') { ?>

                <section class="heading_banner"
                    style="background-image:url(<?= site_url; ?>/uploaded-files/category/banners/<?php echo $cat_res2['catBanner']; ?>)">
                <?php

            } else { ?>
                    <section class="heading_banner" style="background-image: url(<?= site_url; ?>/uploaded-files/page-banners/Stainless-Steel-Plates9ASY.jpg)">
                    <?php } ?>

                    <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">
                                    <?php $pro_title =  $cat_res['catID'] == 1 ? 'Stainless Steel Sheet in ' . $ca_nam1 :  $disTitles . ' in ' . $ca_nam1; ?> <?= $pro_title; ?></h1>
                            </div>
                        </div>
                    </div>
                    </section>
                </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($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($cat_res3['catName']); ?>.htm"
                                                title="<?php echo $cat_res3['catName']; ?>"><?php echo $cat_res3['catName']; ?></a>
                                        </li>
                                    <?php } ?>
                                    <?php if ($num2 > 0) { ?>
                                        <li><a href="<?= site_url; ?>/<?= 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>



                <?php
                if ($cccnum > 0) { ?>
                    <section class="category_page">
                        <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">
                                    <div class="right_side">
                                        <h2 class="title_h2"><?php echo $cat_res['displayName']; ?> Manufacturers in <?= $ca_nam1; ?></h2>
                                        <div class="wps_right">
                                            <div class="product_right_image">
                                                <a href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#productID" onclick="$('#catID').val('<?php echo $cat_res['catID']; ?>');
                                 $('#catName').val('<?php echo $cat_res['catName']; ?>');
                                 $('.catName').html('<?php echo $cat_res['catName']; ?>');  $('.catImg').attr('src',$('.mycatimg_<?php echo $cat_res['catID']; ?> ').attr('src'));">
                                                    <div class="detail_image"> <img class="img-responsive mycatimg_<?php echo $cat_res['catID']; ?>" src="<?= site_url; ?>/uploaded-files/category/images/<?php echo ($cat_res['catImage']); ?>" alt="<?php echo $cat_res['displayName']; ?> Manufacturers in <?php echo $ca_nam1; ?>" title="<?php echo $cat_res['displayName']; ?> Manufacturers in <?php echo $ca_nam1; ?>">
                                                </a>
                                            </div>



                                            <button data-bs-toggle="modal" data-bs-target="#productID" onclick="$('#catID').val('<?php echo $cat_res['catID']; ?>');
                                 $('#catName').val('<?php echo $cat_res['catName']; ?>');
                                 $('.catName').html('<?php echo $cat_res['catName']; ?>');  $('.catImg').attr('src',$('.mycatimg_<?php echo $cat_res['catID']; ?> ').attr('src'));" class="readmoree"
                                                title="Send Enquiry">Send Enquiry <i
                                                    class="fa fa-long-arrow-right"></i></button>
                                        </div>

                                        <?php echo html_entity_decode($page_desc); ?>

                                        <?php $heading_cat = ($cat_res['catID'] == 1) ? "Product Range" : "Products Related to " . $cat_res['displayName']; ?>

                                        <div class="you_may"><?= $heading_cat; ?></div>
                                        <div class="allListing">
                                            <?php

                                            while ($sub_res = mysqli_fetch_array($cat_qry)) {
                                                if ($sub_res['catImage'] != '') {
                                                    $img_link = getImage($sub_res[catImage], 465, 271, $sub_res[catName], "/uploaded-files/category/images/");
                                                    $img_link1 = getImage($sub_res[catImage], 500, 500, $sub_res[catName], "/uploaded-files/category/images/");
                                                } else {
                                                    $img_link = NO_IMG_URL;
                                                    $img_link1 = NO_IMG_URL;
                                                }

                                                $cat_id1 = $sub_res['catID'];
                                                $category_sub_specific1 = mysqli_query($dbconn, "select * from location_content_tbl where category_id='$cat_id1' AND location_id='$location_id'");
                                                $category_sub_general1 = mysqli_query($dbconn, "select * from location_content_tbl where category_id='$cat_id1' AND location_id='0'");

                                                $content_count = mysqli_num_rows($category_sub_specific1);
                                                if ($content_count > 0) {
                                                    $categorysubdomain = mysqli_fetch_array($category_sub_specific1);
                                                    $page_short_desc = $categorysubdomain['short_description'];
                                                } else {
                                                    $categorysubdomain = mysqli_fetch_array($category_sub_general1);
                                                    $page_short_desc = $categorysubdomain['short_description'];
                                                }
                                                $page_short_desc = str_replace('{location}', $ca_nam1, $page_short_desc);
                                                $page_short_desc = str_replace('catname', $pid, $page_short_desc);
                                            ?>


                                                <div class="product_listing">
                                                    <div class="row">
                                                        <div class="col-xxl-3 col-xl-3 col-lg-3 col-md-3 col-sm-3 col-12">
                                                            <div class="product">
                                                                <a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($sub_res['catName']); ?>.htm" title="<?php echo $sub_res['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>">
                                                                    <div class="image1"> <img src="<?= $img_link; ?>" alt="<?php echo $sub_res['displayName']; ?> Manufacturers in <?php echo $ca_nam1; ?>" title="<?php echo $sub_res['displayName']; ?> Manufacturers in <?php echo $ca_nam1; ?>" class="img-responsive mycatimg_<?php echo $sub_res['catID']; ?>"> </div>
                                                                </a>

                                                            </div>
                                                        </div>
                                                        <div class="col-xxl-9 col-xl-9 col-lg-9 col-md-9 col-sm-9 col-12">
                                                            <div class="right-content">
                                                                <h4 class="tt"><a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($sub_res['catName']); ?>.htm" title="<?php echo $sub_res['displayName']; ?> Manufacturers in <?php echo $ca_nam1; ?>"><?php echo $sub_res['catName']; ?></a></h4>
                                                                <div class="blue-line1"></div>
                                                                <div class="more_info">
                                                                    <?php echo html_entity_decode($page_short_desc); ?>

                                                                </div>
                                                                <div class="clearfix"></div>
                                                                <a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($sub_res['catName']); ?>.htm" class="readmoree" title="Read More">Read More</a>

                                                                <span data-bs-toggle="modal" data-bs-target="#productID" onclick="$('#catID').val('<?php echo $sub_res['catID']; ?>');
                                 $('#catName').val('<?php echo $sub_res['catName']; ?>');
                                 $('.catName').html('<?php echo $sub_res['catName']; ?>');  $('.catImg').attr('src',$('.mycatimg_<?php echo $sub_res['catID']; ?> ').attr('src'));" class="read_more_btn_2 ">Send Enquiry <i class="fa fa-long-arrow-right"></i></span>

                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            <?php } ?>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        </div>
                    </section>
                <?php } else {
                    if ($cat_res['catImage'] != '') {
                        $img_link = getImage($cat_res[catImage], 400, 400, $cat_res[catName], "/uploaded-files/category/images/");
                        $img_link1 = getImage($cat_res[catImage], 500, 500, $cat_res[catName], "/uploaded-files/category/images/");
                    } else {
                        $img_link = NO_IMG_URL;
                        $img_link1 = NO_IMG_URL;
                    } ?>
                    <section class="category_page">
                        <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">
                                    <div class="right_side">
                                        <h2 class="title_h2"><?php echo $cat_res['catName']; ?> Manufacturers in <?= $ca_nam1; ?></h2>
                                        <div class="wps_right">
                                            <div class="product_right_image">
                                                <a href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#productID" onclick="$('#catID').val('<?php echo $cat_res['catID']; ?>');
                                 $('#catName').val('<?php echo $cat_res['catName']; ?>');
                                 $('.catName').html('<?php echo $cat_res['catName']; ?>');  $('.catImg').attr('src','<?= $img_link1; ?>');">
                                                    <div class="detail_image"> <img class="img-responsive mycatimg_<?php echo $cat_res['catID']; ?>" src="<?= site_url; ?>/uploaded-files/category/images/<?php echo ($cat_res['catImage']); ?>" alt="<?php echo $cat_res['catName']; ?> Manufacturers in <?php echo $ca_nam1; ?>" title="<?php echo $cat_res['catName']; ?> Manufacturers in <?php echo $ca_nam1; ?>"> </div>

                                                    <button data-bs-toggle="modal" data-bs-target="#productID" class="readmoree"
                                                        title="Send Enquiry">Send Enquiry <i
                                                            class="fa fa-long-arrow-right"></i></button>



                                                </a>
                                            </div>

                                            <?php echo html_entity_decode($page_desc); ?>

                                            <div class="clearfix"></div>
                                            <?php
                                            $sql_pros = mysqli_query($dbconn, "select * from product_tbl where product_specfi='' and prodcut_subcat='$category_id' or product_subsubcat='$category_id' ");
                                            $nums = mysqli_num_rows($sql_pros);
                                            if ($nums > 0) { ?>
                                                <!-- <div class="you_may">Related Product To <?php echo $cat_res['catName']; ?></div> -->

                                                <div class="product_l---isting">
                                                    <div class="row">
                                                        <?php

                                                        while ($res_pros = mysqli_fetch_array($sql_pros)) {
                                                        ?>
                                                            <div class="col-xxl-3 col-xl-3 col-lg-3 col-md-3 col-sm-3 col-12">
                                                                <div class="product-boxed">
                                                                    <div class="product">
                                                                        <a href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#productID" onclick="$('.catID').val('<?php echo $res_pros['product_id']; ?>');
            $('.catName').html('<?php echo $res_pros['product_title']; ?>');
            $('.catImg').attr('src',$('.mycatimg_<?php echo $res_pros['product_id']; ?> ').attr('src'));  $('.catImg').attr('src'); $('.catImg').attr('alt','<?= $res_pros['product_title']; ?> in <?= $ca_nam1; ?>'); $('.catImg').attr('title','<?= $res_pros['product_title']; ?> in <?= $ca_nam1; ?>')">
                                                                            <div class="image1"> <img src="<?= getImage($res_pros['product_image'], 500, 500, $res_pros['product_title'], "/uploaded-files/product/images/"); ?>" alt="<?php echo $res_pros['product_title']; ?> Manufacturers, Suppliers, Exporters in <?php echo $ca_nam1; ?>" title="<?php echo $res_pros['product_title']; ?> Manufacturers, Suppliers, Exporters in <?php echo $ca_nam1; ?>" class="img-responsive mycatimg_<?php echo $res_pros['product_id']; ?>"> </div>
                                                                        </a>

                                                                    </div>
                                                                    <div class="right-content">
                                                                        <h4 class="tt"><?php echo $res_pros['product_title']; ?></h4>

                                                                        <span data-bs-toggle="modal" data-bs-target="#productID" onclick="$('#catID').val('<?php echo $sub_res['product_id']; ?>');
                                 $('#catName').val('<?php echo $res_pros['product_title']; ?>');
                                 $('.catName').html('<?php echo $res_pros['product_title']; ?>');  $('.catImg').attr('src',$('.mycatimg_<?php echo $res_pros['product_id']; ?> ').attr('src'));  $('.catImg').attr('src'); $('.catImg').attr('alt','<?= $res_pros['product_title']; ?> in <?= $ca_nam1; ?>'); $('.catImg').attr('title','<?= $res_pros['product_title']; ?> in <?= $ca_nam1; ?>')" class="read_more_btn_2 " title="Send Enquiry">Send Enquiry <i class="fa fa-long-arrow-right"></i></span>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                    <?php }
                                                    } ?>
                                                    </div>
                                                </div>


                                                <!-- product section multpule images options start -->

                                                <?php $product_s = mysqli_query($dbconn, "select * from product_tbl where product_specfi!='' and  prodcut_subcat='$category_id' or product_subsubcat='$category_id' ");

                                                if (mysqli_num_rows($product_s) > 0) {    ?>


                                                    <div class="you_may">Related Product To <?php echo $cat_res['catName']; ?></div>

                                                    <?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, 500, 500, $product_r['product_title'], "/uploaded-files/product/images/");
                                                        $prod_imgsmall = getImage($probig_img, 58, 58, $product_r['product_title'], "/uploaded-files/product/images/");
                                                        if ($product_r['product_specfi'] != '') { ?>


                                                            <div class="product_listing">
                                                                <div class="row">
                                                                    <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-5 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','<?= site_url; ?>/uploaded-files/product/images/<?= $prod_img; ?>'); $('.catImg').attr('src','<?= $prod_img; ?>'); $('.catImg').attr('alt','<?= $product_r['product_title']; ?> in <?php echo $ca_nam1; ?>'); $('.catImg').attr('title','<?= $product_r['product_title']; ?> in <?php echo $ca_nam1; ?>"
                                                                                    title="<?= $product_r['product_title']; ?>">

                                                                                    <img src="<?= $prod_img; ?>"
                                                                                        alt="<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?php echo $ca_nam1; ?>" title="<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?php echo $ca_nam1; ?>">
                                                                                </a>
                                                                            </div>
                                                                            <div id="small<?= $i; ?>" class="small">
                                                                                <?php
                                                                                if (!empty($pro_image[1])) {
                                                                                    foreach ($pro_image as $pro_imag_vals) { ?>
                                                                                        <img class="item active"
                                                                                            src="<?= site_url; ?>/uploaded-files/product/images/<?php echo $pro_imag_vals; ?>"
                                                                                            alt="<?= $product_r['product_title']; ?>" title="<?= $product_r['product_title']; ?>">

                                                                                <?php }
                                                                                } ?>
                                                                                <?php if ($product_r['product_video'] != '') { ?>
                                                                                    <div class="item youtube">
                                                                                        <a data-fancybox="" href="https://www.youtube.com/watch?v=<?= $product_r['product_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 } ?>
                                                                            </div>
                                                                        </div>
                                                                    </div>

                                                                    <div class="col-xxl-8 col-xl-8 col-lg-8 col-md-8 col-sm-7 col-12">
                                                                        <div class="right-content">
                                                                            <h4 class="title4"><?= $product_r['product_title']; ?> in <?= $ca_nam1; ?></h4>
                                                                            <div class="blue-line1"></div>
                                                                            <div class="product_showcase">
                                                                                <?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>
                                                                            <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="read_more read_more_btn_2 mt-0 mb-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','<?= $prod_img; ?>'); $('.catImg').attr('alt','<?= $product_r['product_title']; ?> in <?php echo $ca_nam1; ?>'); $('.catImg').attr('title','<?= $product_r['product_title']; ?> in <?php echo $ca_nam1; ?>')"
                                                                                    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>
                                                                                <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']; ?> in <?php echo $ca_nam1; ?>'); $('.catImg').attr('title','<?= $product_r['product_title']; ?> in <?php echo $ca_nam1; ?>')" class="read_more  mt-0 mb-2 read_more_btn_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">
                                                                                                    </rect>
                                                                                                    <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>
                                                                                                    <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>
                                                                                                    <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">
                                                                                                    </path>
                                                                                                </g>
                                                                                            </g>
                                                                                        </svg> Request A Callback</span></a>
                                                                            </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 } ?>
                                    <!-- product section multpule images options end -->



                                    <div class="clearfix"></div>
                                    <div class="you_may">You may also like: </div>
                                    <div class="allListing">
                                        <?php
                                        $category_id = $cat_res['catID'];
                                        $cat_final = mysqli_query($dbconn, "select * from category_tbl where parentID='$parent' and status='Y' and catID!='$category_id' order by catOrder Asc");

                                        while ($sub_res = mysqli_fetch_array($cat_final)) {
                                            if ($sub_res['catImage'] != '') {
                                                $img_link = getImage($sub_res[catImage], 400, 400, $sub_res[catName], "/uploaded-files/category/images/");
                                                $img_link1 = getImage($sub_res[catImage], 500, 500, $sub_res[catName], "/uploaded-files/category/images/");
                                            } else {
                                                $img_link = NO_IMG_URL;
                                                $img_link1 = NO_IMG_URL;
                                            }
                                            $cat_id1 = $sub_res['catID'];
                                            $category_sub_specific1 = mysqli_query($dbconn, "select * from location_content_tbl where category_id='$cat_id1' AND location_id='$location_id'");
                                            $category_sub_general1 = mysqli_query($dbconn, "select * from location_content_tbl where category_id='$cat_id1' AND location_id='0'");

                                            $content_count = mysqli_num_rows($category_sub_specific1);
                                            if ($content_count > 0) {
                                                $categorysubdomain = mysqli_fetch_array($category_sub_specific1);
                                                $page_short_desc = $categorysubdomain['short_description'];
                                            } else {
                                                $categorysubdomain = mysqli_fetch_array($category_sub_general1);
                                                $page_short_desc = $categorysubdomain['short_description'];
                                            }
                                            $page_short_desc = str_replace('{location}', $ca_nam1, $page_short_desc);
                                            $page_short_desc = str_replace('catname', $pid, $page_short_desc);
                                        ?>
                                            <div class="product_listing">
                                                <div class="row">
                                                    <div class="col-xxl-3 col-xl-3 col-lg-3 col-md-3 col-sm-3 col-12">
                                                        <div class="product">
                                                            <a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($sub_res['catName']); ?>.htm" title="<?php echo $sub_res['displayName']; ?>">
                                                                <div class="image1"> <img src="<?= $img_link; ?>" alt="<?php echo $sub_res['displayName']; ?> manufacturers in <?php echo $ca_nam1; ?>" title="<?php echo $sub_res['displayName']; ?> Manufacturers in <?php echo $ca_nam1; ?>" class="img-responsive mycatimg_<?php echo $sub_res['catID']; ?>"> </div>
                                                            </a>

                                                        </div>
                                                    </div>
                                                    <div class="col-xxl-9 col-xl-9 col-lg-9 col-md-9 col-sm-9 col-12">
                                                        <div class="right-content">
                                                            <h3><a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($sub_res['catName']); ?>.htm" title="<?php echo $sub_res['displayName']; ?> Manufacturers in <?php echo $ca_nam1; ?>"><?php echo $sub_res['catName']; ?></a></h3>
                                                            <div class="blue-line1"></div>
                                                            <div class="more_info">
                                                                <?php echo html_entity_decode($page_short_desc); ?>

                                                            </div>
                                                            <div class="clearfix"></div> <a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($sub_res['catName']); ?>.htm" class="readmoree" title="Read More">Read More</a>

                                                            <span data-bs-toggle="modal" data-bs-target="#productID" onclick="$('#catID').val('<?php echo $sub_res['catID']; ?>');
                                 $('#catName').val('<?php echo $sub_res['catName']; ?>');
                                 $('.catName').html('<?php echo $sub_res['catName']; ?>');  $('.catImg').attr('src',$('.mycatimg_<?php echo $sub_res['catID']; ?> ').attr('src'));" class="read_more_btn_2 " title="Send Enquiry">Send Enquiry <i class="fa fa-long-arrow-right"></i></span>

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

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

                <?php } ?>

                <?php include "app_footer_sub.php"; ?>
                <?php include "app_bottom.php"; ?>

    </body>

    </html>
<?php
} else {
    echo "<script>window.location='https://www.stainlesssteelpipesinindia.com'</script>";
    exit;
}
?>