Solved

filter mysql database query results in the browser in real time

Posted on 2011-02-20
3
1,168 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
3 Comments
 
LVL 15

Expert Comment

by:Jagadishwor Dulal
ID: 34940008
0
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 500 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

707 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now