Pagination in codeigniter

Page

In your controller,

Pagination_controller.php
<?php
class Pagination_controller extends CI_Controller
{
public function __construct()
{
parent::__construct();
load->model('pagination_model');
$this->load->library('pagination');
}
public function pagination_result()
{
$config=array();
$config["base_url"]=base_url()."Pagination_controller/pagination_result";
$total_row=$this->pagination_model->record_count();
$config["total_rows"]=$total_row;
$config["per_page"]=1;
$config["use_page_numbers"]=TRUE;
$config["num_links"]=$total_row;
$config["cur_tag_open"]=' ‘;
$config[‘cur_tag_close’] = ‘
‘;
$config[‘next_link’] = ‘Next’;
$config[‘prev_link’] = ‘Previous’;
$this->pagination->initialize($config);
if($this->uri->segment(3))
{
$page = ($this->uri->segment(3)) ;
}
else
{
$page = 1;
}
$data[“results”] = $this->pagination_model->fetch_data($config[“per_page”], $page);
$str_links = $this->pagination->create_links();
$data[“links”] = explode(‘ ‘,$str_links );
$this->load->view(“advertising/pagination_view”, $data);

}
}
?>

In your model,

pagination_model.php

<?php
class Pagination_model extends CI_Model
{
public function __construct()
{
parent::__construct();
}
public function record_count()
{
db->count_all("register");
}
public function fetch_data($limit,$customer_id)
{
$this->db->limit($limit);
$this->db->where('customer_id',$customer_id);
$query=$this->db->get("register");
if($query->num_rows()>0)
{
foreach($query->result() as $row)
{
$data[]=$row;
}
return $data;
}
return false;
}
}
?>

In your view,

pagination_view.php

ID Company Name Address Phone Number Contact Person Mobile Number Account Number Account Name Bank Swift Code IBan Currency
customer_id;?> company_name;?> address;?> phone_number;?> contact_person;?> mobile_number;?> account_number;?> account_name;?> bank;?> swift_code;?> internet_banking;?> currency;?> <a href="config->base_url(“Update_controller/show_customer_id/$row->customer_id”);?>”>edit <a href="config->base_url(“Delete_controller/delete_customer_id/$row->customer_id”);?>”>delete

Leave a comment