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
Subscribe to my newsletter for the latest updates on my books and digital products.
Find posts, tutorials, and resources quickly.
Subscribe to my newsletter for the latest updates on my books and digital products.
