PHP MySql Search

They have: 32 posts

Joined: Feb 2007

Can anyone give me recommendations for a mysql/php search application that I could somewhat easily implement in a site?
Thanks!

He has: 16 posts

Joined: Jul 2007

Can you be a little more specific? Like search for a field in a database? Search for specific keywords on a site?

He has: 1,380 posts

Joined: Feb 2002

(Sorry for the delay on this)

You can run a MySQL query using something like:

SELECT * FROM my_table WHERE the_field LIKE '%the_variable%'
'
Where 'the_variable' is what you're looking for, with the percent signs acting as wildcards, both before and after.

Or you can use a number of different search services... Nutch (http://lucene.apache.org/nutch/about.html) and Lucene (http://lucene.apache.org) both sit on top of Apache...

Or you can use something like Google Custom Search (http://www.google.com/coop/cse/)

... that's all I can think of right now. There are other things out there that exist between lying on top of the server, and a pure web-based application. Take a look around.

They have: 32 posts

Joined: Feb 2007

Thanks!

carloncho's picture

They have: 17 posts

Joined: Jan 2008

TEST the "MATCH" MySQL function. Is better than LIKe to perform a search

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.