~NAXC~

File Content: `index.php`

<?php include 'connection.php'; 

$seo_q = "select * from seo";
$seo_result = select($seo_q);
$title = $seo_result[0]['title'];
$keywords = $seo_result[0]['keywords'];
$description = $seo_result[0]['description'];

?>
<!DOCTYPE html>
<html lang="zxx">
<?php
$i = 1;

// Initialize variables to avoid undefined warnings
$title = $description = $keyword = "";

// First query for SEO pages
$sql = "SELECT * FROM seo_pages WHERE page='Home'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $title = $row['title'];
        $description = $row['description'];
    }
}

// Second query for SEO keywords
$sql1 = "SELECT * FROM seo_keyword ORDER BY id DESC";
$result1 = $conn->query($sql1);
if ($result1->num_rows > 0) {
    while ($row1 = $result1->fetch_assoc()) {
        $keyword = $row1['keyword']; // Use $row1 here
    }
}
?>
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">

    <title><?php echo htmlspecialchars($title); ?></title>
    <meta name="description" content="<?php echo htmlspecialchars($description); ?>">
    <meta name="keywords" content="<?php echo htmlspecialchars($keywords); ?>">

    <!-- ✅ Favicon for Google Search and All Devices -->
    <!-- Place a copy of favicon.png or favicon.ico in your site root directory -->
    <link rel="shortcut icon" href="/favicon.ico" type="image/x-icon">
    <link rel="icon" type="image/png" sizes="32x32" href="/favicon-32x32.png">
    <link rel="icon" type="image/png" sizes="16x16" href="/favicon-16x16.png">


    
    <link rel="icon" href="/favicon.ico" type="image/x-icon">
    <link rel="apple-touch-icon" href="/apple-touch-icon.png">
    <meta name="theme-color" content="#ffffff">
    <link rel="manifest" href="/site.webmanifest">


    <!-- Google Tag -->
    <script async src="https://www.googletagmanager.com/gtag/js?id=G-ES5R9FHFS5"></script>
    <script>
        window.dataLayer = window.dataLayer || [];
        function gtag(){ dataLayer.push(arguments); }
        gtag('js', new Date());
        gtag('config', 'G-ES5R9FHFS5');
    </script>

    <!-- Google Site Verification -->
    <meta name="google-site-verification" content="VJVErHKROM-BFxUadFFf9wuURaZAb-FRBIxPFLOrx_0" />

    <!-- Google Fonts -->
    <link href="https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600,700,800,900&display=swap" rel="stylesheet">
    <link href="https://fonts.googleapis.com/css?family=Lato:400,700,900&display=swap" rel="stylesheet">

    <!-- CSS Styles -->
    <link rel="stylesheet" href="css/bootstrap.min.css" type="text/css">
    <link rel="stylesheet" href="css/font-awesome.min.css" type="text/css">
    <link rel="stylesheet" href="css/elegant-icons.css" type="text/css">
    <link rel="stylesheet" href="css/jquery-ui.min.css" type="text/css">
    <link rel="stylesheet" href="css/nice-select.css" type="text/css">
    <link rel="stylesheet" href="css/owl.carousel.min.css" type="text/css">
    <link rel="stylesheet" href="css/magnific-popup.css" type="text/css">
    <link rel="stylesheet" href="css/slicknav.min.css" type="text/css">
    <link rel="stylesheet" href="css/style.css" type="text/css">

    <!-- Font Awesome 6 -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.1/css/all.min.css">

    <style>
        .card1 {
            border: 2px solid rgb(227, 227, 227);
            border-radius: 20px;
        }
        .border1 {
            border: 1px solid rgb(215, 215, 215);
        }
        .border1:hover {
            box-shadow: rgba(0, 0, 0, 0.24) 0px 3px 8px;
        }
        .call {
            border-radius: 30px;
        }
    </style>
</head>


<body>
    <!-- Page Preloder -->
    <div id="preloder">
        <div class="loader"></div>
    </div>

    <?php include 'header.php'; ?>


    <!-- Hero Section Begin -->
    <section class="hero-section">
        <div class="container">
            <div class="hs-slider owl-carousel">

            <?php
            $featured_q = "select *, business.img as business_img, business.id as business_id from business inner join category on category.id = business.category_id where featured = 'yes'";
            $featured_res = select($featured_q);
            foreach($featured_res as $featured_row){
            ?>
                <div class="container p-3">
                    <a href="single.php?id=<?php echo $featured_row['business_id'] ?>">
                        <div class="hs-item set-bg" data-setbg="<?php echo str_replace('..', 'admin', $featured_row['business_img']) ?>" style="border-radius:20px;">
                            <!-- <div class="row">
                                <div class="col-lg-12 ">
                                    <div class="hc-inner-text">
                                        <div class="hc-text">
                                            <h4><?php echo $featured_row['business'] ?></h4>
                                            
                                            <p><span class="icon_pin_alt"></span> <?php echo $featured_row['state'] ?>, <?php echo $featured_row['city'] ?></p>
                                            <div class="label "><?php echo $featured_row['category'] ?></div>
                                            <a href="single.php?id=<?php echo $featured_row['business_id'] ?>" class="site-btn"> View More</a>
                                        </div>
                                       
                                    </div>
                                </div>
                            </div> -->
                        </div>
                    </a>
                </div>
            <?php } ?>    
            </div>
        </div>
    </section>
    <!-- Hero Section End -->

    <!-- Search Section Begin -->
    <section class="search-section spad p-md-5 p-lg-5 p-3">
        <div class="container card1 spad p-md-5 p-lg-5 p-3">
            <div class="row align-items-center"> <!-- Added align-items-center class to center vertically -->
                <div class="col-lg-7 p-3">
                    <div class="section-title">
                        <h4>What are you looking for?</h4>
                    </div>
                </div>
                <div class="col-lg-5 ">
                    <div class="change-btn">
                        <div class="cb-item">
                            <label for="cb-rent" class="active">
                                <i class="fa-regular fa-circle-check"></i> Find your needs
                            </label>
                        </div>
                    </div>
                </div>
            </div>
            <div class="search-form-content">
                <nav class=" navbar-light bg-light">
                    <form action="list.php" method="GET"> 
                        <div class="d-flex align-items-center my-3">
                            <select class="w-50" name="state">
                                <option value="">Select State</option>
                                <?php
                                $state_q = "SELECT DISTINCT state FROM business";
                                $state_res = select($state_q);
                                foreach ($state_res as $state_row) {
                                    ?>
                                    <option value="<?php echo $state_row['state'] ?>"><?php echo $state_row['state'] ?>
                                    </option>
                                <?php } ?>
                            </select>
                            <select class="w-50" name="city">
                                <option value="">Select City</option>
                                <?php
                                $city_q = "SELECT DISTINCT city FROM business";
                                $city_res = select($city_q);
                                foreach ($city_res as $city_row) {
                                    ?>
                                    <option value="<?php echo $city_row['city'] ?>"><?php echo $city_row['city'] ?></option>
                                <?php } ?>
                            </select>
                        </div>

                        <div class="w-100 d-flex align-items-center" >
                            <input class="form-control mr-sm-2 py-3" type="search" placeholder="Search" aria-label="Search" name="query">
                            <button class="btn btn-outline-success my-2 my-sm-0" type="submit">Search</button>
                        </div>
                    </form>
                </nav>
            </div>
            
        </div>
    </section>
    <!-- Search Section End -->


    <!-- categories start -->
    <section class="profile-section mb-5" id="categories">
        <div class="p-md-3" >
            <div class="profile-agent-content justify-content-center" >
                <div class="row " >

                <?php
                $category_query = "SELECT c.*, COUNT(DISTINCT b.id) AS business_count, COUNT(DISTINCT b.location) AS location_count
                                    FROM category c
                                    LEFT JOIN business b ON c.id = b.category_id
                                    GROUP BY c.id";
                $category_res = select($category_query);

                foreach ($category_res as $category_row) {
                    $business_count = $category_row['business_count'] ?? 0;
                    $location_count = $category_row['location_count'] ?? 0;
                ?>
                    <div class="col-lg-3 border1 p-3">
                        <a href="list.php?id=<?php echo $category_row['id'] ?>">
                            <div class="profile-agent-info d-flex align-items-center">
                                <div class="pi-pic" style="width:40%;">
                                    <img src="<?php echo str_replace('../', 'admin/', $category_row['img']) ?>" alt="category_img">
                                    <div class="rating-point">
                                        <?php echo $business_count ?>
                                    </div>
                                </div>
                                <div class="pi-text px-md-1 px-4" style="width:60%;">
                                    <h5><?php echo $category_row['category'] ?></h5>
                                    <span><?php echo $location_count ?> Locations</span> 
                                    <p><?php echo $business_count ?> Businesses</p>
                                </div>
                            </div>
                        </a>
                    </div>
                <?php
                }
                ?>
                </div>
            </div>
        </div>
    </section>
    <!-- categories end -->

    <!-- Recently added -->
    <section class="property-section latest-property-section">
        <div class="container">
            <div class="row">
                <div class="col-lg-5">
                    <div class="section-title">
                        <h4>Recently Added</h4>
                    </div>
                </div>
            </div>
            <div class="row property-filter">
    <?php 
    $recent_q = "SELECT business.*,business.id as business_id, category.category 
                FROM business 
                INNER JOIN category ON business.category_id = category.id 
                ORDER BY business.id DESC 
                LIMIT 6";
    $recent_res = select($recent_q);
    foreach($recent_res as $recent_row){
    ?>
        <div class="col-lg-4 col-md-6 mix all house d-flex align-items-stretch">
            <a href="single.php?id=<?php echo $recent_row['business_id'] ?>">
                <div class="property-item border p-3 d-flex flex-column">
                    <div class="pi-pic set-bg" data-setbg="" style="height:auto !important;">
                        <div class="label"><?php echo $recent_row['category'] ?></div>
                        <img src="<?php echo str_replace('../', 'admin/', $recent_row['img'])?>" alt="">
                    </div>
                    <div class="pi-text mt-3 flex-grow-1">
                        <h4><b><?php echo $recent_row['business'] ?></b></h4>
                        <p><span class="icon_pin_alt"></span> <?php echo $recent_row['city'] ?>, <?php echo $recent_row['state'] ?></p>
                    </div>
                    <div class="pi-agent mt-auto">
                        <div class="pa-item">
                            <div class="pa-text text-center">
                                <a href="single.php?id=<?php echo $recent_row['business_id'] ?>" class="btn btn-outline-dark call">View more</a>
                            </div>
                        </div>
                    </div>
                </div>
            </a>
        </div>
    <?php } ?>
</div>

        </div>
    </section>
    <!-- Recently added End -->

    <!-- About Section Begin -->
    <section class="chooseus-section spad set-bg" data-setbg="img/chooseus/chooseus-bg.jpg" id="about">
        <div class="container">
            <div class="row">
                <div class="col-lg-8">
                    <div class="chooseus-text">
                        <div class="section-title">
                            <h4>ICT Global Tech Pvt. Ltd.</h4>
                        </div>
                        <p>ICT Global Tech Pvt Ltd presents an innovative platform tailored for a dynamic business scene globally. We are providing a comprehensive online business listing service, including QR code generators, digital business card makers, and free SEO listings. We also offer online coupon code generators, website marketing solutions, and the best online business directory. Enhance your local business presence with our customized solutions and stand out in the global digital landscape.</p>
                            <a href="https://ictglobaltech.com/" class="btn btn-outline-light mt-2">www.ictglobaltech.com</a>
                    </div>
  
                </div>
            </div>
        </div>
    </section>
    <!-- About Section End -->


    

    <!-- Footer Section Begin -->
    <?php include 'footer.php' ?>
    <!-- Footer Section End -->


    <style>
        #scrollUpBtn {
    position: fixed;
    bottom: 30px;
    right: 30px;
    z-index: 99;
    border: none;
    outline: none;
    background-color: #00C89E;
    color: white;
    cursor: pointer;
    padding: 10px 15px;
    border-radius: 50%;
    font-size: 18px;
    display: none; /* Hidden by default */
}

#scrollUpBtn:hover {
    background-color: #00a5c8;
}

    </style>
    <button id="scrollUpBtn" title="Go to top"><i class="fa-solid fa-arrow-up"></i></button>
    <script>
    // Get the button
    var scrollUpBtn = document.getElementById("scrollUpBtn");

    // Show the button when the user scrolls down 20px from the top of the document
    window.onscroll = function() {
        scrollFunction();
    };

    function scrollFunction() {
        if (document.body.scrollTop > 20 || document.documentElement.scrollTop > 20) {
            scrollUpBtn.style.display = "block";
        } else {
            scrollUpBtn.style.display = "none";
        }
    }

    // When the user clicks on the button, scroll to the top of the document
    scrollUpBtn.onclick = function() {
        window.scrollTo({
            top: 0,
            behavior: 'smooth'
        });
    };
</script>



    <!-- Js Plugins -->
    <script src="js/jquery-3.3.1.min.js"></script>
    <script src="js/bootstrap.min.js"></script>
    <script src="js/jquery.magnific-popup.min.js"></script>
    <script src="js/mixitup.min.js"></script>
    <script src="js/jquery-ui.min.js"></script>
    <script src="js/jquery.nice-select.min.js"></script>
    <script src="js/jquery.slicknav.js"></script>
    <script src="js/owl.carousel.min.js"></script>
    <script src="js/jquery.richtext.min.js"></script>
    <script src="js/image-uploader.min.js"></script>
    <script src="js/main.js"></script>
</body>

</html>
File Content: index.php

File Content: `index.php`
