This is probably the smallest pagination class in php, that you can use to paginate. You need four pages, to show first row, previous row, next row and the last row. I keep pagination class in my 'inc' folder and include it in four pages. I used only two array functions. prev() and next(). You may modify this code to add more features.
1) The pagination class code or pagination.php/*
* This is pagination class
*/
class pagination {
var $_con='';
var $_db='';
var $_query='';
var $_page;
var $_total_rows;
function __construct($con, $db) {
$this->_con = $con;
$this->_db = $db;
}
function firstpage($query) {
$this->_query = mysql_query($query);
while ($row = mysql_fetch_array($this->_query)) {
echo "Title : ". $row['title'];
echo "Description : ". $row['description'];
$next=next($row);
$next++;
}
echo "<a href='http://localhost/ClassesAndObjects/page3.php?page={$next}'>NEXT</a>";";
if(isset ($_REQUEST['page'])){
$this->_page = $_REQUEST['page'];
}
}
function paginate() {
$this->_page = $_REQUEST['page'];
if(isset ($_REQUEST['page'])){
$this->_page = $_REQUEST['page'];
}
$all_rs = &mysql_query('select * from comments');
$this->_total_rows = mysql_num_rows($all_rs);
$this->_query = mysql_query('select * from comments where id="'.$this->_page.'"');
while ($row = mysql_fetch_array($this->_query)) {
echo "Title : ". $row['title'];
echo "Description : ". $row['description'];
$next = next($row);
$next++;
$prev = prev($row);
$prev--;
echo "<a href='http://localhost/ClassesAndObjects/page1.php'>FIRST PAGE</a>";
echo '<------>';
echo "<a href='http://localhost/ClassesAndObjects/page2.php?page={$next}'>PREV</a>";
echo '<------>';
echo "<a href='http://localhost/ClassesAndObjects/page3.php?page={$next}'>NEXT</a>";
echo '<------>';
echo "<a href='http://localhost/ClassesAndObjects/page4.php?page={$this->_total_rows}'>LAST PAGE</a>";
} //at the beginning and at the end of the row $prev and $next become NULL
//we go back to the first page
if($next==NULL || $prev==NULL){
header('Location:http://localhost/ClassesAndObjects/page1.php');
}
}
}
2) To show the first row i start with page1.php. Here is the code...
include_once 'inc/pagination.php';
$con = mysql_connect('localhost', 'root', '');
$db = mysql_select_db('appababa');
$query = 'select * from comments LIMIT 1';
$pagination = new pagination($con, $db);
$pagination->firstpage($query);
3) To show the previous post i use page2.php. Here is the code...
include_once 'inc/pagination.php';
$con = mysql_connect('localhost', 'root', '');
$db = mysql_select_db('appababa');
$query = 'select * from comments';
$pagination = new pagination($con, $db);
$pagination->paginate();
4) To show the previous post i use page3.php. Here is the code...
include_once 'inc/pagination.php';
$con = mysql_connect('localhost', 'root', '');
$db = mysql_select_db('appababa');
$query = 'select * from comments';
$pagination = new pagination($con, $db);
$pagination->paginate();
5) To show the last post i use page4.php. Here is the code...
include_once 'inc/pagination.php';
$con = mysql_connect('localhost', 'root', '');
$db = mysql_select_db('appababa');
$query = 'select * from comments';
$pagination = new pagination($con, $db);
$pagination->paginate();
ellievsbear
origamiaround
titsay
discoholicmusic
snowghoul
