Skip to main content

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.

Comments

Popular posts from this blog

Browser tips and tricks, my tests

Note that, by default, Firefox and IE align the page elements differently. For ex, Firefox aligns elements to the left, and IE to center. Hence you may need to write in your page, like: align="left" to get the left display properly in IE. If you want to control the display of elements in IE6 and other browsers, you can use !important property. (People still using IE6 are not better than early men). A way to control the display of elements in IE6 and other browsers: .main-nav { margin-top: 10px; *margin-top: 20px; } // IE6 takes margin-top: 20px, other browsers take margin-top: 10px; Check that there are no unclosed comments in the file, in either css or javascript code, like for example, the html comments are opened, but not closed later. Better to write the style tags before the script tags in a file, as browsers like chrome may not work properly. Its better to include the css (and probably js ?) files in the header file. Because the css is global for the enti

Joomla validate chrono forms using jquery

It is a common practice to use Chrono forms in our joomla site to setup various forms in the site, be it a contact us form, submit a ticket form, or whatever. I have set the option "validate form" to "No" under chronoform settings in admin panel, and also preferred to not include any js or css files. For validating the chrono forms, i prefer jquery. So first lets add jquery support in our joomla. It is quite simple: 1. Download jquery.js and jquery_min.js (1.4.2 version is enough) and place them in media/system/js folder of your joomla. 2. Edit libraries->joomla->html->html->behavior.php, and add the following function below the mootools() function: function jQuery($debug = null)     {         static $loaded;         global $mainframe;         // Only load once         if ($loaded) {             return;         }         // If no debugging value is set, use the configuration setting         if ($debug === null) {             $confi

php read file line by line, write file line by line

The following code is an example to write to a file line-by-line: if(file_exists("files/john") && is_dir("files/john")) $myFile = "files/john/msg.txt"; else { mkdir("files/john"); $myFile = "files/john/msg.txt"; } $fh = fopen($myFile, 'a') or die("can't open file"); $stringData = date("d-M-Y H:i:s").' : '.trim($_POST['msg']); fwrite($fh, $stringData." "); fclose($fh); Read a file line-by-line: $filename = "test.txt"; $fp = fopen( $filename, "r" ) or die("Couldn't open $filename"); while ( ! feof( $fp ) ) {    $line = fgets( $fp, 1024 );    print "$line<br>"; }