1#@!#!123s

: / var / www / vhosts / sarainternational.ae / httpdocs /
Filename : searchlisting.php
back
<?php
include('include/header.php');
$searchlist = $_POST['searchlist'];  
                      
    if(strlen($searchlist)<=1){
	    $serch_item_name =  "<h3 class='pb-3'>Search term too short</h3>";
    }else{
		$serch_item_name = "<h3 class='pb-3'>You searched for <b>$searchlist</b></h3>";
		$all_data = explode (" ", $searchlist);
		foreach($all_data as $find_data){
			$x++;
			if($x==1)
			$query_str .="title LIKE '%$find_data%'";
			else
			$query_str .="AND title LIKE '%$find_data%'";
		}
		$sql ="SELECT * FROM products WHERE $query_str";
		$catdata1 = mysqli_query($conn, $sql) ;
        $row1 = mysqli_fetch_array($catdata1) or die(header("location:products.php"));
        $catg = $row1['category'];
    }
  
?>



            <!-- breadcrumb-area-start -->
            <div class="breadcrumb-area pt-125 pb-125" style="background-image:url(assets/img/bg/04.jpg)">
                <div class="container">
                    <div class="row">
                        <div class="col-xl-12">
                            <div class="breadcrumb-wrapper">
                                <div class="breadcrumb-text">
                                    <h2> Products</h2>
                                </div>
                                <ul class="breadcrumb-menu">
                                    <li><a href="index.php">Home</a></li>
                                    <li><span>Products</span></li> 
                                </ul>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!-- breadcrumb-area-end -->



<!-- shop-banner-area start -->
            <section class="shop-banner-area pt-100 pb-70">
                <div class="container">
                    <div class="row justify-content-between">
                      <div class="col-xl-9 col-lg-9">
                         <div class="row">
                             
                            <div class="col-12 mb-3">
                                 <h3> Search Result of '<?php echo $searchlist ?>'</h3>
                            </div>
                            <?php
                                $catdata = mysqli_query($conn, $sql);
                                while ($row=mysqli_fetch_array($catdata)) { 
                            ?> 
                                <div class="col-xl-4 col-lg-4 col-md-6">
                                    <div class="product-02-wrapper pos-rel text-center mb-30">
                                        <div class="product-02-img pos-rel">
                                            <a href="details.php?product=<?= $row['id']?>">
                                                 <?php echo "<img src='admin/".$row['image']."'>";?>
                                            </a>
                                        </div>
                                        <div class="product-text">
                                            <h4><a href="details.php?product=<?= $row['id']?>"><?php echo $row['title']?> </a></h4>
                                        </div>
                                    </div>
                                </div>
                            <?php
                                }
                            ?>
                         </div>
                      </div>
                      
                      
                      
                      
                            <div class="col-xl-3 col-lg-3 shop1-sidebar">
                           <?php include('sidebar.php'); ?>
                            
                        </div>
                    </div>
                </div>
            </section>
            <!-- shop-banner-area end -->
<?php
include('include/footer.php');
?>