Ajax pagination

Have you ever tried the pagiantion with php using Ajax ?
We just pass the query, starting page and records per page you want to display in the pagination.

Lets start with a simple example to understand how it can be done.

steps:

1: create a database 'ajax'
2: create a table 'students':

CREATE TABLE IF NOT EXISTS `students` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
)

3. insert data into the table:

INSERT INTO `students` (`id`, `name`) VALUES
(1, 'Reneesh'),(2, 'Aniesh'),(3, 'Babu'),(4, 'Antony'),(5, 'Praveesh'),
(6, 'Dixon'),(7, 'Sanju'),(8, 'Neeraj'),(9, 'Siju'),(10, 'Noble'),
(11, 'Bibin'),(12, 'Febin'),(13, 'Binu'),(14, 'Charles'),(15, 'jaggu'),
(16, 'mani'),(17, 'milu'),(18, 'aravind'),(19, 'jay'),(20, 'hari');

4. Change the mysql connection settings in index.php and in paginate.php page.

FYI:
pagination_class.php file has the core class that prints the pagination results.
pagination.js sends the ajax request to paginate.php, which handles the pagination.
pgstyle.css is for the styles.

A screenshot is also included for a better understanding.

So download the files in this zip file and run it yourself.
Download

All the best.