Pagination with a PHP class

By David Carr On 20 January 2013 In PHP, Tutorials

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
create a new instance of the class, set the number of records by page and a reference
Then set the total number of records, do this by either setting in manually or by counting records from a dataset
Set the total number of records by passing the total to the method set_total()
Then display the records as normal
To show the page links echo page_links() optionally passin 2 parameters the first set the address by default this is ? the second parameter is for any $_GET’s you want to pass from page to page.

//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
$rows = $db->query('SELECT id FROM table');
$total = count($rows);

//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();

//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

$rows = $db->query('SELECT id FROM table');

$total = count($rows);

//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

Tags:class, OOP, pagination, php

About Author

David Carr | Website | Twitter

I'm a PHP Web Developer based in Hull it is my passion to develop clean, accessible and usable websites and applications, I'm an avid Twitter user why not Follow me? @daveismynamecom or join me on Google+

http://www.biztechconsultancy.co.uk/php-web-development.htm PHP Web Development

I faced problem while creating a new class. I do lots of things to solve it but haven’t succeed. what can i do now? any solution ?
- http://www.daveismyname.com David Carr
  
  do you receive any errors?
  
  Also did you include the pagination class that this tutorial is based on?
  - http://www.biztechconsultancy.co.uk/php-web-development.htm PHP Web Development
    
    I received creating new class error while i make new class.. Yeah I include it..
Guest

I received creating new class error while i make new class.. Yeah I include it.
- http://www.daveismyname.com David Carr
  
  what was the error?
mrashutoshanand

awesome tutorials..

Share this:

Related Posts

About Author

David Carr | Website | Twitter