create pagination using the codeigniter pagination library

September 10, 2019 XpertPhp Comments 0 Comment

In this tutorial, We will inform you How to create Pagination using the Codeigniter pagination library. so you can see this article that how to use Codeigniter Pagination Library for pagination.

Pagination means document content dividing into multiple pages. whenever we have one long page at that time we dividing into multiple pages.

When we create pagination at that time use limit clause, it takes two arguments first is “offset” and the second is the “end”. the end means a number of records returned from the database.

Overview

Step 1: Create a Database in table
Step 2: Connect to Database
Step 3: Create Controller
Step 4: Create a Model
Step 5: Create View File

Step 1: Create a Database in table
In this step, we have to create a table in the database, so we will create a database using the below code.

CREATE TABLE IF NOT EXISTS `register` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(64) NOT NULL,
  `last_name` varchar(64) NOT NULL,
  `address` text NOT NULL,
  `email` varchar(64) NOT NULL,
  `mobile` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

CREATE TABLE IF NOT EXISTS `register` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`first_name` varchar(64) NOT NULL,

`last_name` varchar(64) NOT NULL,

`address` text NOT NULL,

`email` varchar(64) NOT NULL,

`mobile` varchar(12) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

Step 2: Connect to Database
Go to the config folder and open database.php file some changes in this file like hostname, database username, database password, and database name.

$db['default'] = array(
	'dsn'	=> '',
	'hostname' => 'localhost',
	'username' => 'root',
	'password' => '',
	'database' => 'enter here database name',
	'dbdriver' => 'mysqli',
	'dbprefix' => '',
	'pconnect' => FALSE,
	'db_debug' => (ENVIRONMENT !== 'production'),
	'cache_on' => FALSE,
	'cachedir' => '',
	'char_set' => 'utf8',
	'dbcollat' => 'utf8_general_ci',
	'swap_pre' => '',
	'encrypt' => FALSE,
	'compress' => FALSE,
	'stricton' => FALSE,
	'failover' => array(),
	'save_queries' => TRUE
);

$db['default'] = array(

'dsn' => '',

'hostname' => 'localhost',

'username' => 'root',

'password' => '',

'database' => 'enter here database name',

'dbdriver' => 'mysqli',

'dbprefix' => '',

'pconnect' => FALSE,

'db_debug' => (ENVIRONMENT !== 'production'),

'cache_on' => FALSE,

'cachedir' => '',

'char_set' => 'utf8',

'dbcollat' => 'utf8_general_ci',

'swap_pre' => '',

'encrypt' => FALSE,

'compress' => FALSE,

'stricton' => FALSE,

'failover' => array(),

'save_queries' => TRUE

);

Step 3: Create Controller
In this step, we will create a Users.php file in the “application/controller” directory and paste the below code in this controller.
application/controller/Users.php

<?php
class Users extends CI_Controller {
  
    public function __construct()
    {
        parent::__construct();
        $this->load->model('user_model');
        $this->load->helper('url_helper');
        $this->load->library('pagination');
    }
  
    public function index($offset=0)
    {    
         $config['total_rows'] = $this->user_model->totalUsers();
   
          $config['base_url'] = base_url()."users";
          $config['per_page'] = 5;
          $config['uri_segment'] = '2';
          
          $config['full_tag_open'] = '<div class="pagination"><ul>';
          $config['full_tag_close'] = '</ul></div>';
          
          $config['first_link'] = '« First';
          $config['first_tag_open'] = '<li class="prev page">';
          $config['first_tag_close'] = '</li>';
          
          $config['last_link'] = 'Last »';
          $config['last_tag_open'] = '<li class="next page">';
          $config['last_tag_close'] = '</li>';
          
          $config['next_link'] = 'Next →';
          $config['next_tag_open'] = '<li class="next page">';
          $config['next_tag_close'] = '</li>';
          
          $config['prev_link'] = '← Previous';
          $config['prev_tag_open'] = '<li class="prev page">';
          $config['prev_tag_close'] = '</li>';
          
          $config['cur_tag_open'] = '<li class="active"><a href="">';
          $config['cur_tag_close'] = '</a></li>';
          
          $config['num_tag_open'] = '<li class="page">';
          $config['num_tag_close'] = '</li>';
 
         $this->pagination->initialize($config);
          
         $page = ($this->uri->segment(2)) ? $this->uri->segment(2) : 0;
 
         $query = $this->user_model->list($config["per_page"], $page);
            
         $data['users'] =  $query;
 
         $data['title'] = 'User List';
 
         $this->load->view('list', $data);
    }
 
}
?>

<?php

class Users extends CI_Controller {

public function __construct()

{

parent::__construct();

$this->load->model('user_model');

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

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

}

public function index($offset=0)

{

$config['total_rows'] = $this->user_model->totalUsers();

$config['base_url'] = base_url()."users";

$config['per_page'] = 5;

$config['uri_segment'] = '2';

$config['full_tag_open'] = '<div class="pagination"><ul>';

$config['full_tag_close'] = '</ul></div>';

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

$config['first_tag_open'] = '<li class="prev page">';

$config['first_tag_close'] = '</li>';

$config['last_link'] = 'Last »';

$config['last_tag_open'] = '<li class="next page">';

$config['last_tag_close'] = '</li>';

$config['next_link'] = 'Next →';

$config['next_tag_open'] = '<li class="next page">';

$config['next_tag_close'] = '</li>';

$config['prev_link'] = '← Previous';

$config['prev_tag_open'] = '<li class="prev page">';

$config['prev_tag_close'] = '</li>';

$config['cur_tag_open'] = '<li class="active"><a href="">';

$config['cur_tag_close'] = '</a></li>';

$config['num_tag_open'] = '<li class="page">';

$config['num_tag_close'] = '</li>';

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

$page = ($this->uri->segment(2)) ? $this->uri->segment(2) : 0;

$query = $this->user_model->list($config["per_page"], $page);

$data['users'] = $query;

$data['title'] = 'User List';

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

}

Step 4: Create a Model
In this step, we will create a User_model.php file in the “application/models” directory and paste the below code in this model.
application/models/User_model.php

<?php
class User_model extends CI_Model {
  
    public function __construct()
    {
        $this->load->database();
    }
     
    public function list($limit, $offset)
    {
      $this->db->select("*");
      $this->db->from('users');
      $this->db->limit($limit, $offset);
      $query = $this->db->get();
      return $query->result();
    }
 
    function totalUsers(){
      return $this->db->count_all_results('users');
   }
     
}
?>

<?php

class User_model extends CI_Model {

public function __construct()

{

$this->load->database();

}

public function list($limit, $offset)

{

$this->db->select("*");

$this->db->from('users');

$this->db->limit($limit, $offset);

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

return $query->result();

}

function totalUsers(){

return $this->db->count_all_results('users');

}

Step 5: Create View File
So finally, we will create the user_list.php file in the “application/views/” directory.
application/views/user_list.php

<!DOCTYPE html>
<html lang="en">
<head>
  <title>Create Pagination Using The Codeigniter Pagination Library - XpertPhp</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
    <div class="row">
	    <div class="col-lg-12">
			<table class="table table-bordered">
			   <thead>
				  <tr>
					 <th>Id</th>
					 <th>Name</th>
					 <th>Email</th>
					 <th>Mobile</th>
				  </tr>
			   </thead>
			   <tbody>
				  <?php if($users): ?>
				  <?php foreach($users as $user): ?>
				  <tr>
					 <td><?php echo $user->id; ?></td>
					 <td><?php echo $user->name; ?></td>
					 <td><?php echo $user->email; ?></td>
					 <td><?php echo $user->mobile_number; ?></td>
				  </tr>
				 <?php endforeach; ?>
				 <?php endif; ?>
			   </tbody>
			</table>
		</div>
    </div>
	<div class="row">
		<div class="col-md-12">
			<?php echo $this->pagination->create_links(); ?>
		</div>
	</div>
</div>
</body>
</html>

<!DOCTYPE html>

<head>

<title>Create Pagination Using The Codeigniter Pagination Library - XpertPhp</title>

</head>

<body>

<thead>

<tr>

<th>Email</th>

<th>Mobile</th>

</tr>

</thead>

<tbody>

<?php if($users): ?>

<?php foreach($users as $user): ?>

<tr>

<td><?php echo $user->email; ?></td>

<td><?php echo $user->mobile_number; ?></td>

</tr>

<?php endforeach; ?>

<?php endif; ?>

</tbody>

</table>

</div>

<?php echo $this->pagination->create_links(); ?>

</div>

</body>

</html>

Please follow and like us:

Related posts: