create pagination using the codeigniter pagination library – onlinecode
In this post we will give you information about create pagination using the codeigniter pagination library – onlinecode. Hear we will give you detail about create pagination using the codeigniter pagination library – onlinecodeAnd how to use it also give you demo for it if it is necessary.
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 tableStep 2: Connect to DatabaseStep 3: Create ControllerStep 4: Create a ModelStep 5: Create View File
Step 1: Create a Database in tableIn 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 ;Step 2: Connect to DatabaseGo 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 );
Step 3: Create ControllerIn 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 ><ul>';
$config['full_tag_close'] = '</ul></div>';
$config['first_link'] = '« First';
$config['first_tag_open'] = '<li >';
$config['first_tag_close'] = '</li>';
$config['last_link'] = 'Last »';
$config['last_tag_open'] = '<li >';
$config['last_tag_close'] = '</li>';
$config['next_link'] = 'Next →';
$config['next_tag_open'] = '<li >';
$config['next_tag_close'] = '</li>';
$config['prev_link'] = '← Previous';
$config['prev_tag_open'] = '<li >';
$config['prev_tag_close'] = '</li>';
$config['cur_tag_open'] = '<li ><a href="">';
$config['cur_tag_close'] = '</a></li>';
$config['num_tag_open'] = '<li >';
$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 ModelIn 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');
}
}
?>Step 5: Create View FileSo 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 - onlinecode</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 >
<div >
<div >
<table >
<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 >
<div >
<?php echo $this->pagination->create_links(); ?>
</div>
</div>
</div>
</body>
</html>Hope this code and post will helped you for implement create pagination using the codeigniter pagination library – onlinecode. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs