Posts tagged search

Question by :
Problem with live search – jquery (or php?)?
Right now, I am designing a web page with a live search engine that fetches data from the database and styles it into a proper search result. The biggest problem I am experiencing is that you have to enter the exact same words in the exact same sequence as in the database, if you want to see the results. However, i.e when you enter keywords in Google, it does not look for exactly the same sequence, but it scans through the database and finds the keywords in a passage.

All in a few words, when the entry in my database is “Database entry”, I have to write “Database entry” in the search bar if I want to get the result. How ever, I want to be able to write “Entry database” and get the same result.

This is the script that I am using:

And here is my php code without the root, admin and password –>

mysql_select_db(“test1″) or die(mysql_error());

$ partialStates = $ _POST['partialState'];

$ says = mysql_query(“SELECT * FROM says WHERE name LIKE ‘%$ partialStates%’”);
while($ say = mysql_fetch_array($ states)) {
echo
“

“.

“”
;
}
?>

So, that is all. Please help me manipulate my code and make it able to search keywords in a passage.

Read More >>