<?php include_once('include/main.inc.php');

$hover = "home";

$homepage = mysqli_query($GLOBALS['dbconn'], "select pageDesc,pageTitle, pageImage, page_keyword, page_metadesc, page_metatitle, pageBanner from static_pages where pageID='1' and status='Y'");

$home_res = mysqli_fetch_array($homepage);

@extract($_REQUEST);

$ca_nam1 = $_REQUEST['cid'];

$ca_nam1 = ucwords(str_replace("-", " ", $cid));

$sql_locas = mysqli_query($GLOBALS['dbconn'], "select locationID, locationName from location_tbl where locationName='$ca_nam1'");

$location = mysqli_fetch_array($sql_locas);

$location_id = $location['locationID'];

$ca_nam1 = $location['locationName'];

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

$category_sub_general = mysqli_query($GLOBALS['dbconn'], "select location_ids,meta_title,meta_keyword,meta_description,description,short_description from location_content_tbl where category_id='0' 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'];
        } else {

            $page_desc = $categorysubdomain['description'];
        }
    }

    //    specific location content

} else {

    $categorysubdomain = mysqli_fetch_array($category_sub_specific);

    $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('countryname', $ca_nam1, $page_desc);

$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_metakey = str_replace('{location}', $ca_nam1, $page_metakey);

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

if (mysqli_num_rows($sql_locas) > 0) {
} else {

    header("Location: " . site_url);



    exit;
}

$blog = mysqli_query($GLOBALS['dbconn'], "select blogDate,catImage,catName,blogDname,catDesc from blog_tbl  limit 0,3");



?>

<!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 class="home_only">

    <?php include "app_header_sub.php"; ?>

    <div class="home_slider">
        <div id="carouselExampleControls1" class="carousel slide carousel-fade" data-bs-ride="carousel">
            <div class="carousel-inner">
                <?php
                $sql_banner = mysqli_query($GLOBALS['dbconn'], "Select bannerImage, personName, bannerUrl, Decs from banner_tbl where status='Y' order by bannerorder ASC");
                $sno = 0;
                while ($res_banner = mysqli_fetch_array($sql_banner)) {
                    $sno++;
                ?>
                    <div class="carousel-item <?= $sno == 1 ? 'active' : ''; ?>">
                        <div class="slide">
                            <img src="<?= site_url; ?>/uploaded-files/banner-image/<?= $res_banner['bannerImage']; ?>" alt="<?= $res_banner['personName']; ?> Manufacturers in <?= $ca_nam1; ?>" title="<?= $res_banner['personName']; ?> Manufacturers in <?= $ca_nam1; ?>">
                            <div class="sliderCaption">
                                <div class="bannerTitle"><?= $res_banner['personName']; ?></div>
                                <p><?= $res_banner['Decs']; ?></p>
                                <a class="read_more" href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= $res_banner['bannerUrl']; ?>" title="Read More"><span>Read More</span></a>
                            </div>
                        </div>
                    </div>
                <?php } ?>
            </div>
            <button class="carousel-control-prev owl-prev" type="button" data-bs-target="#carouselExampleControls1"
                data-bs-slide="prev">
                <span class="carousel-control-prev-icon" aria-hidden="true"></span>
                <span class="visually-hidden">Previous</span>
            </button>
            <button class="carousel-control-next owl-next" type="button" data-bs-target="#carouselExampleControls1"
                data-bs-slide="next">
                <span class="carousel-control-next-icon" aria-hidden="true"></span>
                <span class="visually-hidden">Next</span>
            </button>
        </div>
    </div>
    <!-- 
    <div class="homeSlider">

        <div id="slider" class="owl-carousel">

        <?php
        $sql_banner = mysqli_query($GLOBALS['dbconn'], "Select bannerImage, personName,bannerUrl,Decs from banner_tbl where status='Y' order by bannerorder ASC");

        while ($res_banner = mysqli_fetch_array($sql_banner)) { ?>

            <div class="slide">

                <img src="<?= site_url; ?>/uploaded-files/banner-image/<?= $res_banner['bannerImage']; ?>" alt="<?= $res_banner['personName']; ?> Manufacturers in <?= $ca_nam1; ?>" title="<?= $res_banner['personName']; ?> Manufacturers in <?= $ca_nam1; ?>">

                <div class="sliderCaption">

                    <div class="container">

                        <div class="row">

                            <div class="col-xxl-8 col-xl-8 col-lg-8 offset-xxl-2 offset-xl-2 offset-lg-2">

                                <div class="bannerTitle"><?= $res_banner['personName']; ?></div>

                                <p><?= $res_banner['Decs']; ?></p>

                                <a class="read_more" href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= $res_banner['bannerUrl']; ?>" title="Read More"><span>Read More</span></a>

                            </div>

                        </div>

                    </div>

                </div>

            </div>

            <?php } ?>



        </div>

    </div> -->



    <section class="wps_home_about">

        <div class="container">

            <div class="row align-items-center">

                <div class="col-xxl-5 col-xl-5 col-lg-5 col-md-12 col-sm-12 col-xs-12 col-12 wow fadeInLeft"

                    data-wow-delay=".1s">

                    <h1 class="h1_title">Stainless Steel Pipes in <?= $ca_nam1; ?></h1>

                </div>

                <div class="col-xxl-7 col-xl-7 col-lg-7 col-md-12 col-sm-12 col-xs-12 col-12 wow fadeInRight"

                    data-wow-delay=".2s">

                    <div class="text">



                        <div class="exp">

                            <div class="exp_num">20+</div>

                            <div class="valign">Years of Experience<br> In Manufacturer and Supplier of Pipes</div>

                        </div>

                    </div>

                </div>

            </div>

            <hr class="hr_padding" />

        </div>

    </section>



    <section class="home_about_2">

        <div class="container">

            <div class="row">

                <div class="col-xxl-12 col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12 col-12">

                    <div class="about_img wow fadeInUp" data-wow-delay=".3s">

                        <div class="img">

                            <img src="<?= getImage($home_res['pageImage'], 510, 348, $home_res['pageTitle'], "/uploaded-files/page-images/"); ?>" alt="Stainless Steel Pipes Manufacturers in <?= $ca_nam1; ?>" title="Stainless Steel Pipes Manufacturers in <?= $ca_nam1; ?>">

                        </div>

                        <div class="about_img">Tricon Steel & Alloys</div>

                    </div>

                    <h2 class="h2_title">Top Stainless Steel Pipes Manufacturers in <?= $ca_nam1; ?></h2>

                    <?= html_entity_decode($page_desc); ?>





                    <a class="read_more wow fadeInLeft" data-wow-delay=".2s" href="<?= site_url; ?>/about-us.htm" title="Read More"><span>Read

                            More</span> </a>

                </div>

            </div>

        </div>

    </section>



    <section class="webpulse_home_product pb-4">

        <div class="container">

            <div class="offerWidth_2 wow fadeInDown" data-wow-delay=".1s">

                <div class="title_2"><span>Our Top Products</span></div>

            </div>

            <div class="clearfix"></div>

            <div class="row">

                <div class="col-xxl-12 col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">

                    <div id="ourProducts" class="owl-carousel">

                        <?php

                        $home_cat1 = mysqli_query($GLOBALS['dbconn'], "select catImage, catName, displayName, catDesc, catID from category_tbl where parentID='2' and status='Y' order by homeorder asc limit 0,6");

                        while ($home_cat_res2 = mysqli_fetch_assoc($home_cat1)) {

                            if ($home_cat_res2['catImage'] != '') {

                                $imglink = getImage($home_cat_res2[catImage], 379, 379, $home_cat_res2[catName], "/uploaded-files/category/images/");
                            } else {
                                $imglink = getImage("noimage.png", 379, 379, "noimages", "/uploaded-files/category/images/");
                            }

                            $catIdss = $home_cat_res2['catID'];

                            $sql_content = mysqli_query($dbconn, "select short_description from location_content_tbl where category_id ='$catIdss'");

                            $res_content = mysqli_fetch_array($sql_content);

                            $subcontent_descc = $res_content['short_description'];

                            $subcontent_desccc = str_replace('{location}', $ca_nam1, $subcontent_descc);

                            $subcontent_descccc = str_replace('catname', $res_cat['catName'], $subcontent_desccc);

                        ?>

                            <div class="item">

                                <div class="item_info wow fadeInRight" data-wow-delay=".2s">

                                    <a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($home_cat_res2['catName']); ?>.htm" title="<?= $home_cat_res2['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>">

                                        <div class="image">

                                            <img src="<?= $imglink; ?>" alt="<?= $home_cat_res2['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>" title="<?= $home_cat_res2['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>">

                                        </div>

                                    </a>

                                    <div class="con">

                                        <h4 class="pr-ti"><a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($home_cat_res2['catName']); ?>.htm" title="<?= $home_cat_res2['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>"><?= $home_cat_res2['displayName']; ?></a></h4>

                                        <p><?= html_entity_decode(substr($subcontent_descccc, 0, 100)); ?>...</p>

                                        <div class="line"></div>

                                        <a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($home_cat_res2['catName']); ?>.htm" title="<?= $home_cat_res2['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>"><svg xmlns="http://www.w3.org/2000/svg" width="16"

                                                height="16" fill="currentColor" viewBox="0 0 16 16">

                                                <path fill-rule="evenodd"

                                                    d="M4 8a.5.5 0 0 1 .5-.5h5.793L8.146 5.354a.5.5 0 1 1 .708-.708l3 3a.5.5 0 0 1 0 .708l-3 3a.5.5 0 0 1-.708-.708L10.293 8.5H4.5A.5.5 0 0 1 4 8z" />

                                            </svg></a>

                                    </div>

                                </div>

                            </div>

                        <?php } ?>



                    </div>

                </div>

            </div>

        </div>

    </section>



    <section class="services_feature">

        <div class="container">

            <div class="title_2">Best Features</div>

            <div class="row">

                <div class="col-lg-4 col-md-6 col-sm-6 col-12 item-bx wow fadeInDown" data-wow-delay=".2s">

                    <img src="<?= site_url; ?>/designer/images/icon/Premium-Quality-Guarantee.png" alt="Premium Quality Guarantee"

                        title="Premium Quality Guarantee">

                    <div class="count">01</div>

                    <div class="titleH4">Premium Quality Guarantee</div>

                    <p>Uncompromising quality sets us apart, ensuring premium steel products for your projects.</p>

                </div>

                <div class="col-lg-4 col-md-6 col-sm-6 col-12 item-bx wow fadeInDown" data-wow-delay=".2s">

                    <img src="<?= site_url; ?>/designer/images/icon/Top-Choice-for-Customers.png" alt="Top Choice for Customers"

                        title="Top Choice for Customers">

                    <div class="count">02</div>

                    <div class="titleH4">Top Choice for Customers</div>

                    <p>We provide the best option for steel solutions that consistently exceed their expectations.</p>

                </div>

                <div class="col-lg-4 col-md-6 col-sm-6 col-12 item-bx wow fadeInDown" data-wow-delay=".2s">

                    <img src="<?= site_url; ?>/designer/images/icon/Outstanding-Customer-Service.png" alt="Outstanding Customer Service"

                        title="Outstanding Customer Service">

                    <div class="count">03</div>

                    <div class="titleH4">Outstanding Customer Service</div>

                    <p>Experience our steel expertise backed by outstanding service, exceeding your expectations.</p>

                </div>

            </div>

        </div>

    </section>

    <?php include "app_testimonials.php"; ?>





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

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

</body>



</html>