Recommend this page to a friend! | Stumble It! | Bookmark in del.icio.us |
All requests | > | Keywords search on multiple table fields of a MySQL database | > | Request new recommendation | > | Featured requests | > | No recommendations | ||
by domenic - 9 months ago (2015-05-06) keyword search mysql
+1 | I would like to search for multiple keywords of different fields and return results as table. |
0 | by Manuel Lemos 11100 - 9 months ago (2015-05-11) Comment This class seems to do exactly what you ask, search MySQL tables for given fields with given keywords and then display the results in a HTML table. The only details is that it uses the mysql extension that is being deprecated in PHP 5.5. |
0 | by Samuel Adeshina 775 - 9 months ago (2015-05-10) Comment You can use this class to perform a lot of database operations. To search for multiple fields in a mysql table, you need to pass in a query that looks like this: SELECT * FROM [The Field You want to search from] WHERE [what you are searching for] LIKE [what you want it to look like] OR .... If you want your result as table, all you have to do is format the resulting array generated from the execution of the query to look like a table |
1. by Manuel Lemos - 9 months ago (2015-05-11) Reply
I guess the original poster wants a solution that composes and executes the search query from parameters that define the keywords to search and then displays the output on a HTML table.
2. by Dave Smith - 9 months ago (2015-05-11) in reply to comment 1 by Manuel Lemos Reply
He actually posted this request right after I made a recommendation to a similar request, rewording it slightly. I think he is after how to do it and not a class to do it for him.
3. by Manuel Lemos - 9 months ago (2015-05-11) in reply to comment 2 by Dave Smith Reply
Maybe you are right Dave. Anyway, with a class he can look at the code and learn how to do it.
4. by domenic - 9 months ago (2015-05-11) in reply to comment 3 by Manuel Lemos Reply
Thanks for the suggestions. I have a functioning system, but I was wondering how someone else may approach the code with security in mind. I've downloaded the suggestions and appreciate the responses. Thanks.
Recommend package | |
|