<?php include_once("include/main.inc.php");
$about_page = mysqli_query($GLOBALS['dbconn'], "select * from static_pages where pageID='2'");
$about_res = mysqli_fetch_array($about_page);
$homepage = mysqli_query($GLOBALS['dbconn'], "select * 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));
$page_metatitle = str_replace('{location}', $ca_nam1, $home_res2['page_metatitle']);
$page_metakey = str_replace('{location}', $ca_nam1, $home_res2['page_keyword']);
$page_metadesc = str_replace('{location}', $ca_nam1, $home_res2['page_metadesc']);
$sql_locas = mysqli_query($GLOBALS['dbconn'], "select * from location_tbl where locationName='$ca_nam1'");
$location = mysqli_fetch_array($sql_locas);
$location_id = $location['locationID'];
$category_sub_specific = mysqli_query($dbconn, "select * from location_content_tbl where category_id='0' AND location_id='$location_id'");
$category_sub_general = mysqli_query($dbconn, "select * 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'];
            }
            if ($categorysubdomain['headingh1']) {
                $headingh1 = $categorysubdomain['headingh1'];
            } else {
                $headingh1 = "Best Stock Market Coach";
            }
            $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 * 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>
    <?php include 'app_header_sub.php'; ?>

    <div class="home_slider">
        <div id="carouselExampleControls" class="carousel slide" data-bs-ride="carousel">
            <div class="carousel-inner">
                <?php
                $i = 0;
                $sql_banner = mysqli_query($GLOBALS['dbconn'], "Select * from banner_tbl where status='Y' order by bannerorder ASC");
                while ($res_banner = mysqli_fetch_array($sql_banner)) {
                    $i++
                ?>
                <div class="carousel-item <?= $i == 1 ? 'active' : ''; ?>">
                    <img src="<?= site_url; ?>/uploaded-files/banner-image/<?= $res_banner['bannerImage']; ?>"
                        class="d-block w-100" alt="<?= $res_banner['personName']; ?> Manufacturers in <?= $ca_nam1; ?>"
                        title="<?= $res_banner['personName']; ?> Manufacturers in <?= $ca_nam1; ?>">
                </div>
                <?php } ?>
            </div>
            <button class="carousel-control-prev" type="button" data-bs-target="#carouselExampleControls"
                data-bs-slide="prev">
                <span class="carousel-control-prev-icon" aria-hidden="true"></span>
                <span class="visually-hidden"></span>
            </button>
            <button class="carousel-control-next" type="button" data-bs-target="#carouselExampleControls"
                data-bs-slide="next">
                <span class="carousel-control-next-icon" aria-hidden="true"></span>
                <span class="visually-hidden"></span>
            </button>
        </div>

    </div>

    <div class="homeFeture">
        <div class="container">
            <div class="row">
                <?php $home_cat = mysqli_query($GLOBALS['dbconn'], "select * from category_tbl where home_category='1' and status='Y' order by homeorder asc limit 0,3");
                while ($home_cat_res = mysqli_fetch_assoc($home_cat)) {
                    if ($home_cat_res['catImage'] != '') {
                        $imglink = getImage($home_cat_res[catImage], 376, 376, $home_cat_res[catName], "/uploaded-files/category/images/");
                    } else {
                        $imglink = NO_IMG_URL;
                    }
                    $catIdss = $home_cat_res['catID'];
                    $sql_content = mysqli_query($dbconn, "select * 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="col-xxl-4 col-xl-4 col-lg-4 col-md-6 col-sm-6 col-12">
                    <div class="serviceBlock">
                        <div class="innerBox">
                            <div class="imageBox">
                                <figure class="image">
                                    <img src="<?= $imglink; ?>"
                                        alt="<?= $home_cat_res['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>"
                                        title="<?= $home_cat_res['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>">
                                </figure>
                                <div class="overlayBox">
                                    <div class="inner">
                                        <div class="text">
                                            <?= html_entity_decode(substr($subcontent_descccc, 0, 100)); ?>...</div>
                                        <div class="linkBox">
                                            <a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($home_cat_res['catName']); ?>.htm"
                                                title="Read More">Read More <svg xmlns="http://www.w3.org/2000/svg"
                                                    width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                                    <path fill-rule="evenodd"
                                                        d="M1 8a.5.5 0 0 1 .5-.5h11.793l-3.147-3.146a.5.5 0 0 1 .708-.708l4 4a.5.5 0 0 1 0 .708l-4 4a.5.5 0 0 1-.708-.708L13.293 8.5H1.5A.5.5 0 0 1 1 8z" />
                                                </svg></a>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="captionBox">
                                <span class="icon">
                                    <img src="<?= site_url; ?>/designer/images/icon.png" alt="Leaf" title="Leaf">

                                </span>
                                <div class="captionBox_title"><a
                                        href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($home_cat_res['catName']); ?>.htm"
                                        title="<?= $home_cat_res['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>"><?= $home_cat_res['displayName']; ?></a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <?php } ?>
            </div>
        </div>
    </div>

    <div class="ab_tx">
        <div class="container">
            <div class="imgs_bx">
                <div class="img_bx1">
                    <img src="<?= site_url; ?>/designer/images/abt_img.jpg" alt="">
                </div>
                <div class="img_bx2">
                    <img src="<?= site_url; ?>/designer/images/pattern.png" alt="pattern">
                </div>
                <div class="call_now">
                    <span><img src="<?= site_url; ?>/designer/images/abt_icon.png" alt="icon"></span>
                    <span>
                        <a href="tel:+91-937-207-6067" class="cl" title="Call Us">+91-937-207-6067</a>
                        <p>Get Instant Quote</p>
                    </span>
                </div>
            </div>
            <div class="tx_bx">
                <div class="ab_head">
                    <span>About Us</span>
                    <h1>Best Psyllium Husk Manufacturers in <?= $ca_nam1; ?></h1>
                    <div class="heading-seperator"><span></span></div>
                </div>
                <div class="ab_con">
                    <p>Our company is ranked among the leading manufacturers, suppliers, and exporters of
                        a broad range of products in the food and dietary supplement industry. We are committed to
                        providing
                        our customers with exceptional quality products and strive to meet their requirements at the
                        best
                        prices.
                    </p>
                    <?= html_entity_decode($page_desc); ?>
                    <a href="<?= site_url; ?>/about-us.htm" class="moreBtn" title="Read More">Read More</a>
                </div>
            </div>
        </div>
    </div>

    <div class="aboutHome" style="background: url(<?= site_url; ?>/designer/images/bg-about.jpg); background-size: cover; ">
        <div class="container">
            <div class="row">
                <div class="col-12 col-md-6 col-lg-3">
                    <div class="homeFactsheet">
                        <img src="<?= site_url; ?>/designer/images/nature-of-business.png" alt="Nature of Business"
                            title="Nature of Business" width="100" height="100">
                        <div class="factsheetTitle">Nature of Business</div>
                        <p>Supplier & Exporter</p>
                    </div>
                </div>
                <div class="col-12 col-md-6 col-lg-3">
                    <div class="homeFactsheet">
                        <img src="<?= site_url; ?>/designer/images/year-of-establishment.png"
                            alt="Year of Establishment" title="Year of Establishment" width="100" height="100">
                        <div class="factsheetTitle">Year of Establishment</div>
                        <p>2016</p>
                    </div>
                </div>
                <div class="col-12 col-md-6 col-lg-3">
                    <div class="homeFactsheet">
                        <img src="<?= site_url; ?>/designer/images/Legal-Status-of-Firm.png" alt="Legal Status of Firm"
                            title="Legal Status of Firm" width="100" height="100">
                        <div class="factsheetTitle">Legal Status of Firm</div>
                        <p>Private Limited Company</p>
                    </div>
                </div>
                <div class="col-12 col-md-6 col-lg-3">
                    <div class="homeFactsheet">
                        <img src="<?= site_url; ?>/designer/images/gst.png" alt="GST Number" title="GST Number"
                            width="100" height="100">
                        <div class="factsheetTitle">GST Number</div>
                        <p>27AAXCS2203F1ZA</p>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="webpulse_home_featured">
        <div class="container">
            <div class="aboutTitle">Our <span>Products</span></div>
            <div class="clearfix"></div>
            <div class="row">

                <div class="col-lg-12">
                    <div id="featuredProducts" class="owl-carousel">


                        <?php $home_cat2 = mysqli_query($GLOBALS['dbconn'], "select * from category_tbl where parentID='1' and status='Y' order by catOrder asc");
                        while ($home_cat_res2 = mysqli_fetch_assoc($home_cat2)) {
                            if ($home_cat_res2['catImage'] != '') {
                                $imglink = getImage($home_cat_res2[catImage], 252, 252, $home_cat_res2[catName], "/uploaded-files/category/images/");
                            } else {
                                $imglink = NO_IMG_URL;
                            }
                            $catIdss = $home_cat_res2['catID'];
                            $sql_content = mysqli_query($dbconn, "select * 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="productBox">
                            <div class="productImg">
                                <a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($home_cat_res2['catName']); ?>.htm"
                                    title="<?= $home_cat_res2['displayName']; ?> Suppliers in <?= $ca_nam1; ?>">
                                    <img src="<?= $imglink; ?>"
                                        alt="<?= $home_cat_res2['displayName']; ?> Suppliers in <?= $ca_nam1; ?>"
                                        title="<?= $home_cat_res2['displayName']; ?> Suppliers in <?= $ca_nam1; ?>">
                                    <div class="boxIcon">
                                        <img src="<?= site_url; ?>/designer/images/icon.png" alt="Leaf" title="Leaf">
                                    </div>
                                </a>
                            </div>
                            <div class="productContent">
                                <h4 class="productTitle"><a
                                        href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($home_cat_res2['catName']); ?>.htm"
                                        title="<?= $home_cat_res2['displayName']; ?> Suppliers in <?= $ca_nam1; ?>"><?= $home_cat_res2['displayName']; ?></a>
                                </h4>
                                <p><?= html_entity_decode(substr($subcontent_descccc, 0, 70)); ?>...</p>

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



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




    <section class="why-choose-us">
        <div class="container">
            <div class="row">
                <div class="image-column col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-sm-12 col-12 wow fadeInLeft"
                    data-wow-delay=".2s">
                    <div class="inner-column">
                        <figure class="image wow fadeInUp"><img
                                src="<?= site_url; ?>/uploaded-files/page-images/<?= $home_res['pageImage']; ?>"
                                alt="<?= COMPANY_NAME; ?>" title="<?= COMPANY_NAME; ?>"></a></figure>
                    </div>
                </div>

                <div class="features-column col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-sm-12 col-12 order-2 wow fadeInRight"
                    data-wow-delay=".4s">
                    <div class="inner-column">
                        <div class="sec-title">
                            <span class="title">Listed Below Four Reasons To Choose Us!</span>
                            <div class="commonHead2">What We Offer</div>
                        </div>
                        <div class="row">
                            <!-- Feature Block -->
                            <div class="feature-block col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-sm-12 col-12">
                                <div class="inner-box">
                                    <div class="icon"><img src="<?= site_url; ?>/designer/images/phone.png"
                                            title="24/7 Availability" alt="24/7 Availability"></div>
                                    <div class="hdtxt">24/7 Availability</div>
                                    <div class="text">We provide our customers with exceptional quality food and dietary
                                        supplement products through our qualified experts.</div>
                                </div>
                            </div>

                            <!-- Feature Block -->
                            <div class="feature-block col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-sm-12 col-12">
                                <div class="inner-box">
                                    <div class="icon"><img src="<?= site_url; ?>/designer/images/icon2.png"
                                            alt="Certified Mechanics" title="Certified Mechanics"></div>
                                    <div class="hdtxt">Certified Mechanics</div>
                                    <div class="text">Our certified mechanics have years of experience and extensive
                                        training and are dedicated to providing you with the best service possible.
                                    </div>
                                </div>
                            </div>

                            <!-- Feature Block -->
                            <div class="feature-block col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-sm-12 col-12">
                                <div class="inner-box">
                                    <div class="icon"><img src="<?= site_url; ?>/designer/images/icon1.png"
                                            alt="No Hidden Cost" title="No Hidden Cost"></div>
                                    <div class="hdtxt">No Hidden Cost</div>
                                    <div class="text">We offer our extremely reliable range of products from the food
                                        and dietary supplement industry offered with no hidden costs.</div>
                                </div>
                            </div>

                            <!-- Feature Block -->
                            <div class="feature-block col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-sm-12 col-12">
                                <div class="inner-box">
                                    <div class="icon"><img src="<?= site_url; ?>/designer/images/hand.png"
                                            alt="Affordable Prices" title="Affordable Prices"></div>
                                    <div class="hdtxt">Affordable Prices</div>
                                    <div class="text">Our products are highly regarded by our clients because we offer
                                        them at the most affordable prices.</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>


            </div>
        </div>
    </section>
    <?php include 'app_testimonials.php'; ?>








    <?php // include 'app_faq.php'; 
    ?>



    <?php include 'app_footer_sub.php'; ?>
    <?php include 'app_bottom.php'; ?>
</body>

</html>