Tech or Treat! Write an article about your scariest tech disaster to win gadgets!Learn more

x
?
Solved

filter mysql database query results in the browser in real time

Posted on 2011-02-20
3
Medium Priority
?
1,180 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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

What we learned in Webroot's webinar on multi-vector protection.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.
Suggested Courses

649 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