Solved

filter mysql database query results in the browser in real time

Posted on 2011-02-20
3
1,173 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
hosting images 4 28
paypal ipn url 5 57
SYbase 4 30
Wordpress plugins not working in html 3 23
Learn by example how to specify CSS selectors for Selenium WebDriver test automation software.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

770 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