?
Solved

filter mysql database query results in the browser in real time

Posted on 2011-02-20
3
Medium Priority
?
1,178 Views
Last Modified: 2012-05-11
What web development tools do I need in order to create a web page where the user can filter the database query results client-side in real time, without resubmitting the search? I am thinking of something like sidestep.com where after the initial search is done the can narrow results by clicking checkboxes and filling in fields while they watch their results narrow in the browser winodow without ever having to refresh or resubmit.

This project ist starting its life on a LAN with a very small database so performance is not much of an issue. My challenge is that I only occasionally create web pages and am hoping for a guide that will direct me to the right libraries and such that I might need to learn about.  ?ajax, jquery, javascript, spry?

Googling is getting me no where because I am using 3g on a 12 hr train ride and don't know the right search terms.   Any search direction or URLs would be appreciated.
0
Comment
Question by:stevenrblake
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 2000 total points
ID: 34940041
Hi stevenrblake,

Whenever you want to mess with data "in real time" you are looking at using some form of AJAX, be it jquery or spry.

Since you mention Spry and posted this in the Dreamweaver Zone, you may want to get started with Spry Data Sets and the Spry tutorial/sample pages:

http://labs.adobe.com/technologies/spry/samples/

The basic workflow goes like this:

1) Create query
2) Parse query results into a format Spry can deal with (usually XML)
3) Create filter events in javascript via Spry framework.
0
 

Author Closing Comment

by:stevenrblake
ID: 34940134
Thanks Jason1178 - that is indeed the place for me to start and is consistent with my workflow.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question