Development Tutorials PHP & MySQL
I've recently wrote a pagination class for php, I used to do this in a procedural way by using functions, it's always worked fine, but its not as reusable as a class is.
I've released this class on Github this tutorial will explain how to use the pagination class.
//include the class
include('paginator.php');
//create new object pass in number of pages and identifier
$pages = new Paginator('10','p');
//get number of total records
$stmt = $db->query('SELECT count(id) FROM table');
$row = $stmt->fetch(PDO::FETCH_NUM);
$total = $row[0];
//pass number of records to
$pages->set_total($total);
$data = $db->query('SELECT * FROM table '.$pages->get_limit());
foreach($data as $row) {
//display the records here
}
//create the page links
echo $pages->page_links();
Download the class from Github
Read articles directly inside your inbox. Subscribe to the newsletter, and don't miss out.
Copyright © 2006 - 2025 DC Blog - All rights reserved.