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

Client Side Filtering of MYSQLI RecordSet

Thread began 7/16/2014 7:38 pm by david | Last modified 7/18/2014 9:44 pm by david | 477 views | 2 replies |

david

Client Side Filtering of MYSQLI RecordSet

I'm trying to figure out how to allow my end users the ability to filter the results from my MYSQLI recordset. The left side of the page has a vertical menu of categories with the recordset on the right. I've researched ajax and jquery options but it's difficult to understand how to accomplish this with the Webassist coding? and guidance would be greatly appreciated.

Sign in to reply to this post

Jason ByrnesWebAssist

the general gist of using ajax is:
you links trigger a jquery function on click, in the onclick function the category ID is passed.

the jquery function calls another page where there is a recordset that uses the passed category ID to look up the categories, and on that page, there is a repeat region to display the information for the selected category.

the jquery function uses innerHTML to populate a div on your page with the information returned from the other page.

This works the same with webassist code as it would with any other code.

If you need help setting this up, we can help you write the jquery code in a premiere support appointment:
http://www.webassist.com/premier_request.php

Sign in to reply to this post

david

Mission accomplished

Sorry, I should have updated this that same night. You are absolutely correct, I was trying to accomplish this from within the Webassist wizards and not from the inner HTML. I did use a jquery function that placed a class on the div tag for the repeat region. Then I attached a binding with the associated category and set that as the class. Worked like a charm. Appreciate the response though!

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