Ezilon.com - Target Your Audience, be Seen in Your Region

PHP MySql Search

You are viewing this site as a guest. Join our community to get your questions answered and share knowledge. Active members may advertise and ask for a website critique.

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?

brady.k's picture

He has: 1,383 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.

Kyle Brady, President, Intuitive Industries LLC.
http://www.int-ind.com
[EMAIL=brady.k@gmail.com]brady.k@gmail.com[/EMAIL] - [EMAIL=brady.kyle@int-ind.com]brady.kyle@int-ind.com[/EMAIL]

They have: 32 posts

Joined: Feb 2007

Thanks!

carloncho's picture

They have: 18 posts

Joined: Jan 2008

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

--------------------
http://www.xumby.com