I suppose having the phrase "Galvaccino Moccaee", this data I can keyword search for "vac mocc". where the word "vac" exists between the word I was looking at the data, then the word "mocc" are on the second word in my data.
Such a search is broken because if we forget the name of the data or only remembera few letters only.
I have a php code for a search as I described above. This code is quite simple:
$key=$_GET['key'];
$arrayKata=explode(" ",$key);
for($i=0;$i<count($arrayKata);$i++){
$Kata=$arrayKata[$i];
for($ix=0;$ix<count($arrayFields);$ix++){
$namaField=$arrayFields[$ix];
if(trim($Kata)){
@$hasil.="LOWER($namaField) LIKE '%$Kata%' OR ";
}
}
}
if(@$hasil){
$hasil=substr($hasil,0,-4);
$SQL.=" WHERE $hasil";
}
$result=mysql_query("select * from menu where menu_name like '%$Kata%'");}
I hope this article helpful. use the code to your search to be more dynamic