Building a Pagination System with AJAX	2.2/5.0 (60 votes total) Rate: Select 1 - Terrible 2 - Poor 3 - Average 4 - Good 5 - Outstanding
Alejandro Gervasio June 06, 2006

You know how to use AJAX to pull rows from a database , but do you know how to create an AJAX-based system to organize the records neatly into pages? You'll know how to do that by the end of this series! This first article shows you how to build the user interface.

Introduction

If you’re an enthusiast  web developer who has been working with AJAX for a while, then you probably think of it as a remarkable combination of programmatic methods for making HTTP requests in the background, with no page reloads. The longer you think about the methods in the abstract, apart from the possible implementations for this requesting mechanism, the more ideas you’ll get for developing potential applications.

Quite possibly, you’ve already used AJAX in several areas of web development in order to create auto completion systems, highly responsive chatters, or different desktop-like applications that use silent requests as the driving force for performing specific tasks. Does all this stuff sound familiar to you? I hope so.

Also, it should be noticed that most of these applications use a database as the backend for storing dynamic and static content, and eventually there will be a moment when a bunch of records will need to be pulled directly from one or many tables. So, after all this largesse, the question that comes up now is: is it possible to create an AJAX-based mechanism that not only fetches some rows from a database, but is also capable of paginating them? Well, since the first thing you did (at least here) was read the title of this article, the answer is a loud Yes!

Read on...