Searching a MySQL database using PHP

[badben]

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

Ben

[falko]

There are a few ;) PHP-MySQL tutorials here: http://www.google.com/search?q=php+mysql+tutorial&start=0&ie=utf-8&oe=utf-8&client=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

[Destroyer]

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

[AaronDavison]

Hi:cool:

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


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

[Angelito]

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

[hardy123]

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