Powered By Blogger

Monday, September 7, 2015

Pagination in codeigniter

Controller.php


public function view(){
$config = array();
$config["base_url"] = base_url() . "frontend/users/view";

//getting registered user list from model
$config["total_rows"] = $this->users_model->user_count( );
$config["per_page"] = 3;
$config["uri_segment"] = 4;
$config['use_page_numbers'] = TRUE;
$this->pagination->initialize($config);
$page = ($this->uri->segment(4)) ? $this->uri->segment(4) : 0;


$data["user_list"] = $this->users_model->user_details($config["per_page"], $page);
$data["links"] = $this->pagination->create_links();
//send user list to view
$this->load->view('frontend/users/view',  $data);
}


model.php

function user_details($limit, $start){
   
    $this->db->limit($limit, $start);
    $this->db->from('users as US');
    $query = $this->db->get();
    if($result = $query->num_rows > 0)
    {
    $result = $query->result_array();
    return $result;
    }
    else{
    return false;
    }
    }
   
    public function user_count() {
    return $this->db->count_all_results("users");
    }



view.php

foreach($user_list as $details) {

}

<?php echo $links; ?>

No comments:

Post a Comment