CodeIgniter Tutorial: How to Create Ajax Pagination using CodeIgniter?

CodeIgniter has many built-in classes and plugins. Pagination class of CodeIgniter is very easy and simple to use. Also Ajax Pagination library is availanle in Codeigniter. Here i will describe how to create simple ajax pagination in Codeigniter using some simple steps.
First of all download Ajax Pagination from Codeigniter site. And put this library in “system/libraries/” folder.
Along with library you need to download prototype.js file and put this file any where on root.
Here we have a table which we use for getting records and apply pagination on its records.

CREATE TABLE `my_best_friends` (
  `f_id` int(11) NOT NULL auto_increment,
  `f_name` varchar(100) NOT NULL,
  `f_phone` int(11) NOT NULL,
  `f_email` int(11) NOT NULL,
  `f_address` int(11) NOT NULL,
  PRIMARY KEY  (`f_id`)
)

CREATE TABLE `my_best_friends` (

`f_id` int(11) NOT NULL auto_increment,

`f_name` varchar(100) NOT NULL,

`f_phone` int(11) NOT NULL,

`f_email` int(11) NOT NULL,

`f_address` int(11) NOT NULL,

PRIMARY KEY (`f_id`)

)

Your controller:

class Paging extends Controller {

	function Paging(){

		parent::Controller();
		$this-&gt;load-&gt;helper(array('form','url'));
		$this-&gt;load-&gt;helper('text');
		$this-&gt;load-&gt;library('Ajax_pagination');
	}

	function index()
	{
		redirect ('paging/my_friends');
	}

	function my_friends()
	{
		$pdata['TotalRec'] 	= $this-&gt;FriendsModel-&gt;TotalRec();
		$pdata['perPage'] 	= $this-&gt;perPage();
		$pdata['ajax_function']	= 'get_friends_ajax';

		$subdata['paging'] 	= $this-&gt;parser-&gt;parse('paging', $pdata, TRUE);
		$subdata['all_friends'] 	= $this-&gt;FriendsModel-&gt;my_friends($this-&gt;perPage());

		$data['body_content'] 	= $this-&gt;parser-&gt;parse('friend_list', $subdata, TRUE);	

		$this-&gt;load-&gt;view('main',$data);
	}

	function get_friends_ajax()
	{
             $pdata['TotalRec'] = $this-&gt;FriendsModel-&gt;TotalRec();
             $pdata['perPage']  = $this-&gt;perPage();

	     $pdata['ajax_function'] =  'get_friends_ajax';

	     $data['paging'] =  $this-&gt;parser-&gt;parse('paging', $pdata, TRUE);
	     $data['all_friends'] = $this-&gt;FriendsModel-&gt;my_friends($this-&gt;perPage());

	     $this-&gt;load-&gt;view('friend_list',$data);
	}

	function PerPage()
	{
		return 5;
	}

}

class Paging extends Controller {

function Paging(){

parent::Controller();

$this->load->helper(array('form','url'));

$this->load->helper('text');

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

}

function index()

{

redirect ('paging/my_friends');

}

function my_friends()

{

$pdata['TotalRec'] = $this->FriendsModel->TotalRec();

$pdata['perPage'] = $this->perPage();

$pdata['ajax_function'] = 'get_friends_ajax';

$subdata['paging'] = $this->parser->parse('paging', $pdata, TRUE);

$subdata['all_friends'] = $this->FriendsModel->my_friends($this->perPage());

$data['body_content'] = $this->parser->parse('friend_list', $subdata, TRUE);

$this->load->view('main',$data);

}

function get_friends_ajax()

{

$pdata['TotalRec'] = $this->FriendsModel->TotalRec();

$pdata['perPage'] = $this->perPage();

$pdata['ajax_function'] = 'get_friends_ajax';

$data['paging'] = $this->parser->parse('paging', $pdata, TRUE);

$data['all_friends'] = $this->FriendsModel->my_friends($this->perPage());

$this->load->view('friend_list',$data);

}

function PerPage()

{

return 5;

}

Model :

class FriendsModel extends Model
{
    function FriendsModel()
    {
		parent::Model();
	}

	function TotalRec()
	{
	  $sql = "SELECT * FROM my_friends";
          $q = $this-&gt;db-&gt;query($sql);
          return $q-&gt;num_rows();
       }

	function my_friends($perPage)
	{
		$offset = $this-&gt;getOffset()
		$query ="SELECT * FROM  my_friends Order By f_id Desc LIMIT ".$offset.", ".$perPage;
		$q = $this-&gt;db-&gt;query($query);
		return $q-&gt;result();
	}

	function getOffset()
	{
        $page = $this-&gt;input-&gt;post('page');
        if(!$page):
        $offset = 0;
        else:
        $offset = $page;
        endif;
        return $offset;
    }
}

class FriendsModel extends Model

{

function FriendsModel()

{

parent::Model();

}

function TotalRec()

{

$sql = "SELECT * FROM my_friends";

$q = $this->db->query($sql);

return $q->num_rows();

}

function my_friends($perPage)

{

$offset = $this->getOffset()

$query ="SELECT * FROM my_friends Order By f_id Desc LIMIT ".$offset.", ".$perPage;

$q = $this->db->query($query);

return $q->result();

}

function getOffset()

{

$page = $this->input->post('page');

if(!$page):

$offset = 0;

else:

$offset = $page;

endif;

return $offset;

}

View: paging.php in application/views/ folder

$config['first_link'] 	= 'First';
$config['div'] 		= 'container'; //Div tag id
$config['base_url'] 	= base_url().'paging/'.$ajax_function;
$config['total_rows']	= $TotalRec;
$config['per_page'] 	= $PerPage;
$config['postVar'] 	= 'page';

$this-&gt;ajax_pagination-&gt;initialize($config);
echo $this-&gt;ajax_pagination-&gt;create_links();

$config['first_link'] = 'First';

$config['div'] = 'container'; //Div tag id

$config['base_url'] = base_url().'paging/'.$ajax_function;

$config['total_rows'] = $TotalRec;

$config['per_page'] = $PerPage;

$config['postVar'] = 'page';

$this->ajax_pagination->initialize($config);

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

View: friend_list.php in application/views/ folder

foreach($all_friends as $row)
 {

}

foreach($all_friends as $row)

{

}

Friend Name	Friend Phone	Friend Address
echo $row->f_name	echo $row->f_phone	echo $row->f_address

Main home file: main.php in application/views/ folder
This file contains your html code and all css and js files.
I have just given main container where your data will show. you have to add html and css/js files your self.

echo @$body_content;

5 thoughts on “CodeIgniter Tutorial: How to Create Ajax Pagination using CodeIgniter?”

ravindra says:

March 26, 2014 at 11:58 am

give me a running code zip file
chirag says:

February 13, 2015 at 6:25 am

use this one…
http://www.joelsays.com/simple-ajax-pagination-in-codeigniter/
chirag says:

February 13, 2015 at 6:27 am

http://www.joelsays.com/simple-ajax-pagination-in-codeigniter/
chirag says:

February 13, 2015 at 6:28 am

overwrite thw .htaccess file
Virendra Arekar says:

December 13, 2017 at 6:45 am

Where is ajax

Comments are closed.

Few More Brilliant Posts !

5 thoughts on “CodeIgniter Tutorial: How to Create Ajax Pagination using CodeIgniter?”