Search funcitonality

[indrajit_m]

Dear All,
I am developing one website using php. In that I need search functionality on complete database and pages. Is there any help available on this topic? If any body found an example or good documentation please post it to me.
regards,
Indrajit

[malbera]

take a look here

hope that helps

[goa103]

hi!

here is a simple search engine I use in PHP/MySQL. let's search for a user name.

table user: id, first_name, last_name, address, country,...

here is the SQL query to SELECT the proper users from a $search string:

$search = "martin";

$resUser = mysql_query ("SELECT * FROM user WHERE first_name LIKE '%$search%' OR last_name LIKE '%$search%'");

LIKE means that the follow WHERE parameter is a regular expression
% stands for anything, that's why we use it both at the beginning and at the end of the string

Hope it helps!
JM

[dharbour]

I am using a freeware seach program that I really like. It is available at http://www.digitalgenesis.com. It will search both files and/or database. I found it trying to configure and I am having a slight problem displaying db results (my own stupidity). Good luck.😉