May

CodeIgniter Tutorial: How to Create Ajax Pagination using CodeIgniter?

ZeeShaN

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`)
)

Your controller:

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->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->ajax_pagination->initialize($config);
echo $this->ajax_pagination->create_links();

View: friend_list.php in application/views/ folder

<table border="1" width="200">
<tbody>
<tr>
<td>Friend Name</td>
<td>Friend Phone</td>
<td>Friend Address</td>
</tr>
foreach($all_friends as $row)
 {
<tr>
<td>echo $row->f_name</td>
<td>echo $row->f_phone</td>
<td>echo $row->f_address</td>
</tr>
}</tbody>
</table>

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.

<div id="container">
     echo @$body_content;</div>

Written by ZeeShaN

ZeeShaN RasooL is a web developer who loves to work in latest technologies to create more interactive dynamic and beautiful web pages.

Most recent

Most liked

Show all comments (13)

99points Codeigniter Tutorials » CodeIgniter Resources

[...] How to create AJAX pagination using codeigniter: http://www.99points.info/2010/05/codeigniter-tutorials-how-to-create-ajax-pagination-using-codeignit... [...]

January 09 2012

Comments Like

0 people liked this

how can i remove index.php from my codeigniter url

Thanks in advance

December 29 2011

Comments Like

0 people liked this

kartik

thanks………. very easy.. .

August 02 2011

Comments Like

0 people liked this

KoAung

Dear bro,
I want to know, how to keep paging in main.php.

Thanks

June 02 2011

Comments Like

0 people liked this

lê văn chiến

hello!
I know about CodeIgniter through your website, I do not know how to call a class in CodeIgniter, you guide me or give me an example of it? thank you very much !

November 24 2010

Comments Like

0 people liked this

8 Best Tutorials On ‘How To Create Pagination In Codeigniter’

[...] who have never done something like that before, but with Code Igniter its a cinch to do.5. How to Create Ajax Pagination using CodeIgniter? – CodeIgniter TutorialCodeIgniter has many built-in classes and plugins. Pagination class of [...]

November 17 2010

Comments Like

0 people liked this

William Rouse

Can you provide a zip file this tutorial. Thanks!

August 11 2010

Comments Like

0 people liked this

ang2ara

thanks for your great tutorial, I think this tutorial is simple to use.

August 01 2010

Comments Like

1 people liked this

ZeeShaN

@Muta, you welcome. You can find in its detail in codeigniter manual

July 14 2010

Comments Like

0 people liked this

muta

thanx for your reply, i’ll try to use it.

July 14 2010

Comments Like

0 people liked this

<< More Records

Who I Am

Zeeshan Rasool

Software Engineer - PHP
Lahore - Pakistan

zeeshan(@)99points.info
Skype: zeeshan-rasool
gTalk: zishan.rasool85

99Pointsin Web Technologies

CodeIgniter Tutorial: How to Create Ajax Pagination using CodeIgniter?

Written by ZeeShaN

Who I Am

Categories

Tags

Comments

Friends