Searching a MySQL database using PHP

Does anybody out there know a tutorial or good script to search a MySQL database for keywords using PHP?

Ben

 

There are a few PHP-MySQL tutorials here: http://www.google.com/search?q=php+...ient=firefox-a&rls=org.mozilla:en-US:official


I haven't tried them, but they should get you started.
http://www.freewebmasterhelp.com/tutorials/phpmysql
http://www.webmonkey.com/webmonkey/programming/php/tutorials/tutorial4.html

 

I am not sure if you want to search one table or the whole db but here are some links that may help

http://www.devarticles.com/c/a/MySQL/Getting-Started-With-MySQLs-Full-Text-Search-Capabilities/

http://www.tizag.com/mysqlTutorial/mysqlselect.php

 

Hi

Wonderful info guys....The list of apps looks great.....and i thank u..


edit reason.
Links look like spam.
Sorry if I'm wrong.

 

Code:

SELECT * FROM `PRODUCT`
WHERE Enabled=1 AND
(name LIKE '%".$_GET["searchstring"]."%' OR description LIKE '%".$_GET["searchstring"]."%' OR brief_description LIKE '%".$_GET["searchstring"]."%');

It should return any record with a matching string in either specified field.

Share your results if it works for you.

Angel

 

http://www.tizag.com/mysqlTutorial/-It will surely help you.