PHP MySql Search
Can anyone give me recommendations for a mysql/php search application that I could somewhat easily implement in a site?
Thanks!
Can anyone give me recommendations for a mysql/php search application that I could somewhat easily implement in a site?
Thanks!
Kufr posted this at 07:14 — 10th September 2007.
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?
kb posted this at 04:01 — 16th September 2007.
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.
L3ZL1E posted this at 15:17 — 18th September 2007.
They have: 32 posts
Joined: Feb 2007
Thanks!
carloncho posted this at 23:15 — 8th February 2008.
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.