Back to Top

How to use Pagination in CodeIgniter

Pagination is a number of rows to be fetched from the database and mostly found at the bottom of the page which allow you to navigate to a different page. Today I will show you to use pagination in CodeIgniter which is easy to use.

To Load the pagination library, following code is useful:

$this->load->library('pagination');

The library comes with around 20 configurable items and you need only the three items to create the links.

To use Pagination in CodeIgniter, you must have the Pagination library must be loaded.

Let’s check it out here

First of all, add following code into the model file.

$this->load->library('pagination');
$result = $this->m_demo->getRows($page);

$config['base_url'] = 'url_of_page';

//The base_url is the URL of your controller
$config['total_rows'] = $this->m_demo->getTotalNumRows();

//total_rows is the number of rows you have in your database
$config['per_page'] = 2;

//per_page is the number of results that you want to show per page
$this->pagination->initialize($config);

foreach($result as $item)
{
	echo $item['cat_name'];
}

echo $this->pagination->create_links();

To add above code into the function index and add one parameter $page=0 into the function.see in below:

function index($page=0)

Next,Move to the controller file and add following function into it:

function getRows($page)
{
	$this->load->database();
	$query = $this->db->query("select * from category limit $page,2");
	return $query->result_array();
}

function getTotalNumRows()
{
	$this->load->database();
	$query = $this->db->query("select * from category");
	return $query->num_rows();
}

Further Reading:

Image Upload in CodeIgniter
Get IP address in CodeIgniter
Prepping Functions in CodeIgniter

That’s it.This is all that you need in order to create pagination.I hope this post will help you. Don’t Forget to Follow us on Twitter or Subscribe us to Get the Latest Updates.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Most Popular Posts

To get Last auto increment id in WordPress

Posted on 4 years ago

Bhumi

Tips to Choose Your Next WordPress Theme

Posted on 6 years ago

Bhumi

Learn React JS with simple Application

Posted on 3 years ago

Bhumi

The Readers’ Poll – June 2012

Posted on 7 years ago

Bhumi

Hello world

Updated 1 week ago

Nick Carter

In depth Understanding of Laravel Core

Updated 2 months ago

Bhumi

ECMAScript 6 New Features – 2

Updated 1 year ago

Bhumi

The Reader’s Poll – June 2015

Posted on 4 years ago

Bhumi

The Reader’s Poll – August 2014

Posted on 4 years ago

Bhumi

The Reader’s Poll – June 2014

Posted on 5 years ago

Bhumi

The Readers’ Poll – May 2014

Posted on 5 years ago

Bhumi

The Readers’ Poll – August 2013

Posted on 5 years ago

Bhumi