I have tried this code and this is working only for one page when i am in basintap page but i want to know how to search anything when i am in another page?
<?php
$query = $_GET['query'];
$min_length = 2;
if(strlen($query) >= $min_length){
$sql ="Select * from basintap where keywords like '%keywords%'";
$run_query = mysqli_query($con,$sql);
if(mysqli_num_rows($run_query) > 0){
while($row = mysqli_fetch_array($run_query)){
$id = $row['id'];
$cat = $row['cat'];
$brand = $row['brand'];
$name = $row['name'];
$image = $row['image'];
echo "<div class='col-md-4'>
<div class='panel panel-info'>
<div class='panel-heading'>$name</div>
<div class='panel-body'>
<img src='basintap/$image' style='width:160px; height:250px;'/>
</div>
</div>
</div> ";
}
}
?>
If you have a separate table per page, then you are going to have to restructure your database in order to solve your problem using a home grown solution. Keep all pages in one table, distinguished by a separate field and/or index.
Alternatively if it's too much hassle, just plug Algolia into your site.
You should probably change your "basintap" string from your query with the table name you'd like to search into.
$sql ="Select * from [place-table-name-here] where keywords like '%keywords%'";