1#@!#!123s

��JFIF�� 1#@!#!123s
: / home2 / argusmeast / www /
Filename : search.php
back
<?php
session_start();
include('include/connect.php');

// Initialize variables for search query and category
$searchQuery = isset($_GET['search']) ? mysqli_real_escape_string($con, $_GET['search']) : '';
$categoryId = isset($_GET['category_id']) && $_GET['category_id'] != '' ? intval($_GET['category_id']) : null;

// Modify the product query to include search conditions
$product_query = "SELECT * FROM product WHERE product_status='In Stock'";

// Add search term filter if provided
if ($searchQuery) {
    $product_query .= " AND product_name LIKE '%$searchQuery%'";
}

// Add category filter if selected
if ($categoryId) {
    $product_query .= " AND category_id = $categoryId";
}

// Execute the query
$product_result = mysqli_query($con, $product_query);
?>

<!doctype html>
<html class="no-js" lang="zxx">

<head>
    <meta charset="utf-8">
    <meta http-equiv="x-ua-compatible" content="ie=edge">
    <title>Gustec Toners | Gustec Ribbons | HP Toner and Cartridge | Canon HP Toner and Cartridge | Brother Toner and Cartridge | Samsung Toner and Cartridge | Epson Toner and Cartridge | Toshiba Toner and Cartridge |Sharp Toner and Cartridge | OKi Toner and Cartridge  Xerox Toner and Cartridge | Panasonic Toner and Cartridge | Lexmark Toner and Cartridge | Kyocera Toner and Cartridge | UTAX Toner and Cartridge | Gustec Drums Toner and Cartridge | Gustec Printers</title>
        <meta name="description" content="Find Gustec toners, ribbons, drums, and top-brand toner cartridges for HP, Canon, Brother, Samsung, Epson, Xerox, Sharp, OKI, Lexmark, Kyocera & more.">
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <!-- Place favicon.ico in the root directory -->
    <link rel="shortcut icon" type="image/x-icon" href="assets/img/favicon.webp">

    <!-- CSS here -->
    <link rel="stylesheet" href="assets/css/preloader.css">
    <link rel="stylesheet" href="assets/css/bootstrap.min.css">
    <link rel="stylesheet" href="assets/css/slick.css">
    <link rel="stylesheet" href="assets/css/backToTop.css">
    <link rel="stylesheet" href="assets/css/meanmenu.css">
    <link rel="stylesheet" href="assets/css/nice-select.css">
    <link rel="stylesheet" href="assets/css/owl.carousel.min.css">
    <link rel="stylesheet" href="assets/css/animate.min.css">
    <link rel="stylesheet" href="assets/css/jquery.fancybox.min.css">
    <link rel="stylesheet" href="assets/css/fontAwesome5Pro.css">
    <link rel="stylesheet" href="assets/css/ui-range-slider.css">
    <link rel="stylesheet" href="assets/css/default.css">
    <link rel="stylesheet" href="assets/css/style.css">
</head>

<body>

    <!-- header area start -->
    <?php include 'header-2.php' ?>
    <!-- header area end -->

    <main>

        <!-- breadcrumb area start -->
        <section class="breadcrumb__area box-plr-75">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-xxl-12">
                        <div class="breadcrumb__wrapper">
                            <nav aria-label="breadcrumb">
                                <ol class="breadcrumb">
                                    <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                                    <li class="breadcrumb-item active" aria-current="page">Product</li>
                                </ol>
                            </nav>
                        </div>
                    </div>
                </div>
            </div>
        </section>
        <!-- breadcrumb area end -->

        <!-- product area start -->
        <section class="product__area box-plr-75 pb-70">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-xxl-10 col-xl-9 col-lg-8 order-first order-lg-last">
                        <div class="product__grid-wrapper">
                            <div class="product__grid-item-wrapper pt-70">
                                <div class="product__filter mb-50">
                                    <div class="row align-items-center">
                                        <div class="col-xxl-6 col-xl-6 col-lg-6 col-md-6">
                                            <div class="product__filter-left d-sm-flex align-items-center">
                                                <div class="product__result pl-60">
                                                    <p>Showing <?php echo mysqli_num_rows($product_result); ?> results</p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

                                <div class="tab-content" id="productGridTabContent">
                                    <div class="tab-pane fade show active" id="FourCol" role="tabpanel" aria-labelledby="FourCol-tab">
                                        <div class="row">
                                            <?php if (mysqli_num_rows($product_result) > 0) {
                                                while ($product = mysqli_fetch_assoc($product_result)) { ?>
                                                    <div class="col-xxl-3 col-xl-3 col-lg-4 col-md-4">
                                                        <div class="product__item white-bg mb-30">
                                                            <div class="product__thumb p-relative">
                                                                <a href="product-details.php?product=<?php echo $product['product_slug']; ?>" class="w-img">
                                                                    <img src="admin-panel/product/product-images/<?php echo $product['product_id']; ?>/<?php echo $product['product_main_image']; ?>" alt="<?php echo $product['product_name']; ?>">
                                                                    <img class="second-img" src="admin-panel/product/product-images/<?php echo $product['product_id']; ?>/<?php echo $product['product_main_image']; ?>" alt="<?php echo $product['product_name']; ?>">
                                                                </a>
                                                            </div>
                                                            <div class="product__content text-center">
                                                                <h6 class="product-name">
                                                                    <a class="product-item-link" href="product-details.php?product=<?php echo $product['product_slug']; ?>">
                                                                        <?php echo $product['product_name']; ?>
                                                                    </a>
                                                                </h6>
                                                                <span class="price">BHD <?php echo $product['product_selling_price']; ?></span>
                                                            </div>
                                                            <div class="product__add-btn">
                                                                <button type="button" onclick="window.location.href='product-details.php?product=<?php echo $product['product_slug']; ?>'">
                                                                    View Product
                                                                </button>
                                                            </div>
                                                        </div>
                                                    </div>
                                            <?php }
                                            } else {
                                                echo "<p>No products found matching your search.</p>";
                                            } ?>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
        <!-- product area end -->

    </main>

    <!-- footer area start -->
    <?php include 'footer.php' ?>
    <!-- footer area end -->

    <!-- JS here -->
    <script src="assets/js/vendor/jquery-3.6.0.min.js"></script>
    <script src="assets/js/vendor/waypoints.min.js"></script>
    <script src="assets/js/bootstrap.bundle.min.js"></script>
    <script src="assets/js/meanmenu.js"></script>
    <script src="assets/js/slick.min.js"></script>
    <script src="assets/js/backToTop.js"></script>
    <script src="assets/js/jquery.fancybox.min.js"></script>
    <script src="assets/js/countdown.js"></script>
    <script src="assets/js/nice-select.min.js"></script>
    <script src="assets/js/isotope.pkgd.min.js"></script>
    <script src="assets/js/owl.carousel.min.js"></script>
    <script src="assets/js/jquery-ui-slider-range.js"></script>
    <script src="assets/js/ajax-form.js"></script>
    <script src="assets/js/wow.min.js"></script>
    <script src="assets/js/imagesloaded.pkgd.min.js"></script>
    <script src="assets/js/main.js"></script>
</body>

</html>