close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

How To - Search Form To Filter Repeat Region

Thread began 8/15/2014 6:37 pm by david | Last modified 9/09/2014 11:57 am by Jason Byrnes | 720 views | 5 replies |

david

How To - Search Form To Filter Repeat Region

I've searched this forum and can't find an explanation of how to do this. My PHP "know how" isn't strong ( which is why I purchased super suite ). My repeat region is populating correctly, but I want to give my users the ability of filtering the results with a search bar. More specifically I want my index page to list all products and then allow my users to choose which category and/or which city we sell in using dynamic dropdowns. Can you please point me in the right direction with a tutorial or a brief but detailed explanation of how to do this? Any help would be greatly appreciated. Thanks guys!

Sign in to reply to this post

Jason ByrnesWebAssist

We don't have a tutorial for how to do this using MySQLi

you would need to create the search form, then edit the recordset to add the filtering.

set the search form to use the GET method. the create URL variables for each of the form elements using the same name as the form elements.

Go to the bindings panel, click the plus button and select URL variable. set the url variable name to the same as the form elements, repeat this for each form element.

Now edit the recordset, using the advanced MySQL Query Builder you can add conditions to the where clause to filter the category using the category URL binding and the state using the state URL binding.

Sign in to reply to this post

david

Thanks for the reply Jason. Your instructions worked in a manner of speaking. Originally I wanted the RecordSet to display all on the index page and then have the form filter it while staying on the same page. With your instructions if I modified the RecordSet to look for parameters the index page would not show any results because the user hasn't submitted the form when they first visit the site. So I left the index record set alone and created a results page. Then on the results page I created a RecordSet that binds the parameters from the form. All is working well. it's not exactly what I wanted but it will suffice. However, this has created a new issue for me. From the results page there is no way to view all categories. For example if someone wanted to see all categories available in a certain location they can't. What are your thoughts?

Also, is there a way to create the options in my form dynamically? I had to write out each option for this to work but I'd rather see this list get pulled from my database. I tried to create a recordset and then create a repeat region around the Option tag but that didn't work.

Thanks for the help!

Sign in to reply to this post

Jason ByrnesWebAssist

Please provide a Skype username or a US phone number and a good time to contact you when you will be in front of your computer and we will have an engineer contact you to resolve this issue over the phone.

We are available Monday - Friday from 9am - 4pm EST (except major U.S. holidays).

Sign in to reply to this post

david

Skype Info private

Sign in to reply to this post

Jason ByrnesWebAssist

I have sent a skype contact request.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...