网站搜索框

Question

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>  ";
}
}
?>

Answer 1

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.