close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

DataAssist Dynamic Checkboxes Search

Thread began 3/04/2010 3:15 pm by vito374252 | Last modified 3/06/2010 12:04 am by anonymous | 638 views | 2 replies |

vito374252

DataAssist Dynamic Checkboxes Search

Hello,
I built the search using DataAssist Search Wizard. The form is made of checkboxes and it all works well.

The next step that I would like to take is to make the search form dynamic. At the moment the values of the checkboxes are taken out of an MySQL table and each checkbox category is populated from its own recordset.

What I would like to achieve is that when one checkbox is selected all others change automatically to match the selected checkbox. It would sort of be a filtered search.

For example:
When "Gaming" checkbox is selected all other checkboxes values would need to change to match this selection. For example manufacturer would change to Dell, MSI. Display size to 17, CPU model to Intel Core 2 Duo and so on.

Here is the link notebooks-search.php and scripts attached.

Thanks!

Attached Files
search.zip
Sign in to reply to this post

Eric Mittman

This is not a feature that is supported in DataAssist or any of our other tools and would require a custom solution. From what you have described you would need to have some recordsets on the page and use some js to switch out the display based on the user selection. The idea is similar to what Dynamic Dropdowns does, but takes it quite a bit further. If you have Dynamic Dropdowns you might be able to look at the code there to get an idea for how this type of thing can be done.

Sign in to reply to this post

anonymous

I have actually create a similar search application. The best way to accomplish this would be to use an AJAX script to add variables, based on selection criteria from the check boxes, to the URL, such as this: www.mypage.com?computer=dell&othervar=anothervalue&nextvar=athirdvalue

Then, just as Eric stated, you use recordsets where you would filter the recordset based on the appropraite column containing the data in the URL variables.

such as: SELECT * FROM table WHERE computer = '$_GET['computer'] AND othervarcolumn = '$_GET['otherval']

You may need several record sets to get it done to exact spec as you want. And you may also need a lot of "if" statements.

Regards,

Brian

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...