I've looked in all the places I know of to find out if someone has published a way of writing some PHP code to search the tables of their MySQL database for some keywords that the user has input through a form.
On <!-- w --><a class="postlink" href="http://www.mysql.com">www.mysql.com</a><!-- w --> there is some documentation on searching FULLTEXT fields.
On most sites, searching for the word "search" confuses the search itself.
On this site there is an article that describes how to create a table of keywords based on the content of your records, etc, but has anyone seen a bunch of PHP code that will search A table of data for some keywords.
At the moment the only way I can get the search results I need is to make a SELECT from multiple relational tables, then search each query result for the keywords that the user has provided.
This means I have to have a tailor-made query for each table, but can probably use a single piece of code to search the query result for my keywords.
Unless I hear a useful reply from this posting, I'll write it myself.
I don't mind doing this, I just can't believe someone hasn't done a good job of it already.
If I get it in good shape and I've still heard nothing back from this post then maybe I'll submit it.
Cheers,
B
p.s. those of you who reply to people's questions simply with a url to some documentation pages should be giving the people who are starting with php a bit more help. Just throwing out a URL is often bugger-all use to newbies, and gives the impression you're sitting there with nothing better to do than scan forums, waiting for the moment you can raise your eyes to heaven and write a terse reply.
On <!-- w --><a class="postlink" href="http://www.mysql.com">www.mysql.com</a><!-- w --> there is some documentation on searching FULLTEXT fields.
On most sites, searching for the word "search" confuses the search itself.
On this site there is an article that describes how to create a table of keywords based on the content of your records, etc, but has anyone seen a bunch of PHP code that will search A table of data for some keywords.
At the moment the only way I can get the search results I need is to make a SELECT from multiple relational tables, then search each query result for the keywords that the user has provided.
This means I have to have a tailor-made query for each table, but can probably use a single piece of code to search the query result for my keywords.
Unless I hear a useful reply from this posting, I'll write it myself.
I don't mind doing this, I just can't believe someone hasn't done a good job of it already.
If I get it in good shape and I've still heard nothing back from this post then maybe I'll submit it.
Cheers,
B
p.s. those of you who reply to people's questions simply with a url to some documentation pages should be giving the people who are starting with php a bit more help. Just throwing out a URL is often bugger-all use to newbies, and gives the impression you're sitting there with nothing better to do than scan forums, waiting for the moment you can raise your eyes to heaven and write a terse reply.