1#@!#!123s

: G: / PleskVhosts / jhalakdembla.com / akkonlineservices.com /
Filename : Search.php
back
<?php 
	include('layout/header.php');
	require('Admin/Coding/db.php');
$searchtxt = $_GET['search'];
// echo $searchtxt;

	
	$sql = "SELECT * FROM store WHERE Title LIKE '%{$searchtxt}%'  OR  Description  LIKE '%{$searchtxt}%'";

	$result = mysqli_query($conn, $sql);


$rowcount_= mysqli_num_rows($result);

?>




<section class="latest-product spad" style="padding-top: 30px;">
<div class="container">
<div class="row">




<div class="col-lg-8" style="margin: 0px auto;">
<h4 style="margin-bottom: 10px ;">All Stores in <?php echo $searchtxt;?> (<?php echo $rowcount_;?>)</h4>
         <?php 
  while($res = mysqli_fetch_assoc($result)){
         ?>  
    
<div class="col-lg-12 StoreItems  ">
    
<div class="latest-product__item__text">
        
<span><?php echo $res['Title'];?></span>
<h6><?php echo $res['Description'];?></h6>
</div>

<a href="<?php echo $res['URL'];?>" target="_blank"  style="">View Location</a>

</div>


<?php } ?>

</div>




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


<!-- <section >
	<div >
		<ul style="width:200px; margin:0px auto; list-style: none; ">
			<?php 
			while($row = mysqli_fetch_assoc($result)){?>
			<a href="SingleViewSearch.php?id=<?php echo $row['id'];?>" style="color:white;">	
		  		<li style="background-color: yellowgreen; padding: 5px;"><?php echo $row['Title'];?></li>
		    </a>
		  <?php }?>
		</ul>
	</div>
</section>
 -->


<?php 
    include('layout/footer.php');

?>