raymond_feliciano Posted May 31, 2012 Share Posted May 31, 2012 I have a quick question. I am trying to create a complex search form which will join nth number of tables. Here is the process for doing the search the way I have it setup so far. The user clicks the advance search link and a jquery popup is displayed. The user will see the first set of checkboxes which he can check and under the first set of checkboxes the user will be able to click a link stating And | Or. If the user clicks the And link a second set of checkboxes will be displayed using jquery containing the same values as the first set of checkboxes. Now if the user checks the first checkbox in the first set and clicks the second checkbox in the second set these values will be used to query the database. I tried using select boxes but when the form is submitted all the values are sent over instead of what the user pick. Is this the best way to do it or should it be done a different way. Quote Link to comment https://forums.phpfreaks.com/topic/263441-best-approach-for-complex-search/ Share on other sites More sharing options...
QuickOldCar Posted June 1, 2012 Share Posted June 1, 2012 You can use mysql fulltext search http://dev.mysql.com/doc/refman/5.6/en/fulltext-search.html Here was a post I did for an example, same post also leads to another post I did with some multiple query examples. http://www.phpfreaks.com/forums/index.php?topic=358927.0 Quote Link to comment https://forums.phpfreaks.com/topic/263441-best-approach-for-complex-search/#findComment-1350179 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.