Skip to Content
PHPCODE
CodeIgniter Pagination
codeigniter code / August 3, 2018
Pagination in Codeigniter

step 1:- Created function in model

public function num_rows()
{
$user_id=$this->session->userdata('user_id');
$query=$this->db
->select(['title','id'])
->from('articles')
->where('user_id',$user_id)
->get();
return $query->num_rows();
}

step 2:- edit model function

public function articles_list($limit,$offset)
{
$user_id=$this->session->userdata('user_id');
$query=$this->db
->select(['title','id'])
// ->select('id')
->from('articles')
->where('user_id',$user_id)
->limit($limit,$offset)
->get();
return $query->result();
}

step 3: Created Controller function

public function dashboard()
{
$this->load->library('pagination');
$this->load->model('articlesmodel',"articles");
$config=[
'base_url' => base_url('admin/dashboard'),
'per_page'  => 5,
'total_row' => $this->articles->num_rows(),
];
$this->pagination->initialize($config);
$this->load->helper('form');
$articles=$this->articles->articles_list($config['per_page'],$this->uri->segment(3));
$this->load->view('admin/dashboard',['articles'=>$articles]);
}

step 4 : create view in function write

 </table>
<?= $this->pagination->create_links(); ?> 

 

PHPCODE © 2024