Pagination – The Joys of Computing

Here is an example of how to use pagination in your PHP oage. I’m using a pagination class developed by Shiege Iseng’ and can be downloaded from here.

We include this file in the page we use. So here is a basic script that shows the details of users from a database and shows 4 of them in a pagae and shows 3 pages as links in between the [prev] and [next] links.


<?php

//making the database connection
include_once('includes/connection/connection.inc');
 dbConnect();

//including the paging class
 require_once('paging_class.php');

//database query
 $qry = "SELECT * FROM USERS";
 $results = mysql_query($qry);
 $num_rows = mysql_num_rows($results);

//making a paging object that shows 4 results and 3 links
$paging = new paging(4,3);
 $paging->db($host,$username,$passwd,$dbName);
 $paging->query($qry);
?>

<html>
 <head>
 <title>Pagination Example</title>
 </head>

<body>

<table>
 <tr>
 <td>Total Results Found: <?php echo $num_rows; //prints total results ?></td>
 </tr>
 <tr>
 <td>Sl No</td>
 <td>First Name</td>
 <td>Last Name</td>
 <td>Sex</td>
 <td>DOB</td>
 <td>Email</td>
 </tr>

 <?php
 $sl = 1;
 $pageno = 1;
 $pageno = $pageno - 1;
 if($pageno > 0)
 $s1 = $pageno * 10;
 else
 $s1 = 0;
 ?>

 <?php
 if($num_rows > 0)
 {
 $i = 1;
 while($obj=$paging->result_assoc())
 {
 $s1 = $s1 + 1;
//to alternate b/w colors in the row
 if(($i + 1) % 2 == 0)
 $bgcolor="#dbe3f0";
 else
 $bgcolor="#dbdcf0";
 ?>

 <tr bgcolor="<?php echo $bgcolor?>">
 <td><?php echo $sl; ?></td>
 <td><?php echo $obj['firstname']; ?></td>
 <td><?php echo $obj['lastname']; ?></td>
 <td><?php echo $obj['sex']; ?></td>
 <td><?php echo $obj['dob']; ?></td>
 <td><?php echo $obj['email']; ?></td>
 </tr>

 <?php
 $i++;
 }
 }
 else
 {
 ?>

 <tr>
 <td>No Data Available !! Please redifine your Search.... </td>
 </tr>

 <?php
 }
 ?>
 <tr>
 <td><?php echo "<hr>".$paging->print_link();?></td>
 </tr>

 </table>