Codeigniter Tutorials

Home » Codeigniter »

Pagination

File name : index.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Mypagination extends CI_Controller{
function __construct(){
parent::__construct();
}

function index($offset = 0){
$this->load->library('table');
$this->load->library('pagination');
$this->load->helper('form');
$this->load->helper('url');
$this->load->database(); //load library database

// Config setup
$num_rows=$this->db->count_all("users");
$config['base_url'] = base_url().'mypagination/index';
$config['total_rows'] = $num_rows;
$config['per_page'] = 5;
$config['num_links'] = $num_rows;
$config['use_page_numbers'] = TRUE;
$config['full_tag_open'] = '<ul class="pagination">';
$config['full_tag_close'] = '</ul>';
$config['prev_link'] = '«';
$config['prev_tag_open'] = '<li class="page-link">';
$config['prev_tag_close'] = '</li>';
$config['next_tag_open'] = '<li class="page-link">';
$config['next_tag_close'] = '</li>';
$config['cur_tag_open'] = '<li class="page-link"><a href="#">';
$config['cur_tag_close'] = '</a></li>';
$config['num_tag_open'] = '<li class="page-link">';
$config['num_tag_close'] = '</li>';

$config['next_link'] = '»';

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

$data['records']=$this->db->get('users', $config['per_page'],$offset);// take record of the table
$header = array('Id', 'Name','Email','Mobile','Address'); // create table header
$tmpl = array ( 'table_open' => '<table class="table table-bordered table-striped table-condensed">' );

$this->table->set_template($tmpl);
$this->table->set_heading($header);// apply a heading with a header that was created
$this->load->view('mypagination_view',$data); // load content view with data taken from the daily table
}

}

view

File name : mypagination_view.php

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Welcome to CodeIgniter Pagination System</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.6/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.2.1/js/bootstrap.min.js"></script>

</head>
<body>

<div id="container">
<h1>Welcome to CodeIgniter Pagination System!</h1>

<div id="body">

<?php echo $this->table->generate($records); ?>
<?php echo $this->pagination->create_links(); ?>
</div>

<p class="footer">Page rendered in <strong>{elapsed_time}</strong> seconds</p>
</div>

</body>
</html>

table

File name : index.php

-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 02, 2019 at 06:33 PM
-- Server version: 10.1.37-MariaDB
-- PHP Version: 7.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `db_test`
--

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
`id` int(11) NOT NULL,
`name` varchar(50) CHARACTER SET latin1 NOT NULL,
`email` varchar(150) CHARACTER SET latin1 NOT NULL,
`mobile` varchar(20) CHARACTER SET latin1 NOT NULL,
`address` varchar(255) CHARACTER SET latin1 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `mobile`, `address`) VALUES
(1, 'Al-Amin Khan', 'al@min.com', '6546464', 'Dhaka,Bangladesh'),
(2, 'Sahed Bhuiyan', 's@hed.com', '987979', 'Khulna, Bangladesh'),
(3, 'Mamun', 'm@mun.com', '646465', 'Bikrom Pur'),
(9, 'foysal1', 'foysal@yahoo.com', '1234556', 'Dhaka, Bangladesh.'),
(36, 'Masdu', 'masud.eden@gmail.com', '0432324', 'Dhaka,Bangladesh'),
(37, 'Masdu', 'masud.eden@gmail.com', '0432324', 'Dhaka,Bangladesh'),
(38, 'sd', 'ADSa', 'asdAD', 'Adsas'),
(39, 'Al-Amin Khan', 'al@min.com', '6546464', 'Dhaka,Bangladesh'),
(40, 'Sahed Bhuiyan', 's@hed.com', '987979', 'Khulna, Bangladesh'),
(41, 'Mamun', 'm@mun.com', '646465', 'Bikrom Pur'),
(42, 'foysal1', 'foysal@yahoo.com', '1234556', 'Dhaka, Bangladesh.'),
(43, 'Masdu', 'masud.eden@gmail.com', '0432324', 'Dhaka,Bangladesh'),
(44, 'Masdu', 'masud.eden@gmail.com', '0432324', 'Dhaka,Bangladesh'),
(45, 'sd', 'ADSa', 'asdAD', 'Adsas'),
(46, 'Al-Amin Khan', 'al@min.com', '6546464', 'Dhaka,Bangladesh'),
(47, 'Sahed Bhuiyan', 's@hed.com', '987979', 'Khulna, Bangladesh'),
(48, 'Mamun', 'm@mun.com', '646465', 'Bikrom Pur'),
(49, 'foysal1', 'foysal@yahoo.com', '1234556', 'Dhaka, Bangladesh.'),
(50, 'Masdu', 'masud.eden@gmail.com', '0432324', 'Dhaka,Bangladesh'),
(51, 'Masdu', 'masud.eden@gmail.com', '0432324', 'Dhaka,Bangladesh'),
(52, 'sd', 'ADSa', 'asdAD', 'Adsas'),
(53, 'Al-Amin Khan', 'al@min.com', '6546464', 'Dhaka,Bangladesh'),
(54, 'Sahed Bhuiyan', 's@hed.com', '987979', 'Khulna, Bangladesh'),
(55, 'Mamun', 'm@mun.com', '646465', 'Bikrom Pur'),
(56, 'foysal1', 'foysal@yahoo.com', '1234556', 'Dhaka, Bangladesh.'),
(57, 'Masdu', 'masud.eden@gmail.com', '0432324', 'Dhaka,Bangladesh'),
(58, 'Masdu', 'masud.eden@gmail.com', '0432324', 'Dhaka,Bangladesh'),
(59, 'sd', 'ADSa', 'asdAD', 'Adsas');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Codeigniter pagination Example

Controller

<?php
defined('BASEPATH') OR exit('no direct script access allowed');
class Students extends CI_Controller
{
public function __construct()
{
parent::__construct();

if(! $this->session->userdata('admin_id'))
{
redirect('admin/login');
}
/*
$loggedIn = $this->session->userdata('admin_id');
if(!$loggedIn)
{
redirect('admin/login');
}
*/

/*
if($this->session->userdata('username') == NULL ) {
redirect('admin/login');
}
*/

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

}

public function student_list_pagination()
{
$data = array();
$header['title'] = "Students List";
$config = array();
$config["base_url"] = base_url() . "admin/students/student_list_pagination";
$config["total_rows"] = $this->Admin_model->get_count();
$config["per_page"] = 10;
$config["uri_segment"] = 4;
$this->pagination->initialize($config);
$page = ($this->uri->segment(4)) ? $this->uri->segment(4) : 0;
$data["links"] = $this->pagination->create_links();
$data['authors'] = $this->Admin_model->get_authors($config["per_page"], $page);
$this->load->view('admin/header',$header);
$this->load->view('admin/student_list_pagination',$data);
$this->load->view('admin/footer');
}

}

Model

/* ##################### Pagination ############################ */
protected $table = 'authors';
public function get_count() {
return $this->db->count_all($this->table);
}

public function get_authors($limit, $start) {
$this->db->limit($limit, $start);
$query = $this->db->get($this->table);

return $query->result();
}
/* ##################### End Pagination ############################ */

View :- student_list_pagination.php

Pagination Example :

Itechtuto

Codeigniter Tutorials

Pagination

File name : index.php

view

File name : mypagination_view.php

table

File name : index.php

Connect Us Socially:

Quick Links