different goal with multiple search page, need help
2 posts by 2 authors in: Forums > CMS Builder
Last Post: October 25, 2008 (RSS)
By Codee - October 25, 2008
I've searched the forums for the last 2 hours but I don't see this particular scenario.
I would like to make a search form for the end users that has multiple fields to search for/through, but from 1 table/1section.
Example: table is "inventory" section is "Inventory". I want to have 10 boxes on the form (that correspond to data fields in the database) like size, color, weight, content, etc. Some of the form fields will have dropdowns. Then when the end user clicks on the search or submit search button, the search checks any of the form fields that have an entry...maybe "women's dress,12,yellow,copenhagen" and then brought back those specific results on a listviewer.php page
I thought maybe the multiSearch.php function would be helpful but it's not, at least not apparently.
I would like to make a search form for the end users that has multiple fields to search for/through, but from 1 table/1section.
Example: table is "inventory" section is "Inventory". I want to have 10 boxes on the form (that correspond to data fields in the database) like size, color, weight, content, etc. Some of the form fields will have dropdowns. Then when the end user clicks on the search or submit search button, the search checks any of the form fields that have an entry...maybe "women's dress,12,yellow,copenhagen" and then brought back those specific results on a listviewer.php page
I thought maybe the multiSearch.php function would be helpful but it's not, at least not apparently.
Re: [equinox69] different goal with multiple search page, need help
By Kenny - October 25, 2008
You may be able to accomplish this through URL based searching
A typical URL based on specific criteria would look like this:
http://www.yourdomain.com/products/listViewer.php?color=blue&size=XXL
Now you in order to do this, you need a form that can build this URL through "print" statements. If building a URL is not the way to go, take a look at this thread:
http://www.interactivetools.com/forum/gforum.cgi?post=65788#65788
AND
http://www.interactivetools.com/forum/gforum.cgi?post=65150#65150
It does get pretty complicated, but it can be done.
Kenny
A typical URL based on specific criteria would look like this:
http://www.yourdomain.com/products/listViewer.php?color=blue&size=XXL
Now you in order to do this, you need a form that can build this URL through "print" statements. If building a URL is not the way to go, take a look at this thread:
http://www.interactivetools.com/forum/gforum.cgi?post=65788#65788
AND
http://www.interactivetools.com/forum/gforum.cgi?post=65150#65150
It does get pretty complicated, but it can be done.
Kenny