0
$keyword = explode(' ',$_GET['q']);//a b c d e
foreach($keyword => value){
  params[]=$value;
}
$query ="SELECT id,english FROM product WHERE CONCAT(english,Denglish) LIKE CONCAT ('%', ?, '%') ";
$search=$mysqli->prepare($query);
$search->bind_param('s',params);
$search->execute();
$search->bind_result($id,$english);
while($row = $search->fetch()) {
    echo $english;
}

=====================================================================================================================================================================================================================================================================================================

0 Answers0