Solved

filter mysql database query results in the browser in real time

Posted on 2011-02-20
3
1,174 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
Where can I find... 1 43
Simple SQL query from two tables 13 58
Syntax for query to update table 2 29
Code Manager | Snippits 2 36
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

809 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