How use class pagination with Join ?

[eluser]Atharva[/eluser]

Code:

function index(){
      $this->load->library('pagination');

      $per_page= 5;
      $offset = (int) $this->uri->segment(3, 0);

      $config['base_url'] = base_url().index_page().'controller/index/';
      $this->db->select('*');
      $this->db->from('blogs');
      $this->db->join('comments', 'comments.id = blogs.id');

      $this->db->limit($per_page,$offset);

      $data['records'] = $this->db->get();

      $data['total_rows'] = $this->db->query("SELECT COUNT(id) AS cnt FROM blogs b INNER JOIN  comments c ON  b.id = c.id")->row()->cnt;



      $config['total_rows'] = $data['total_rows'];
      $config['uri_segment'] = 3;
      $config['num_links'] = 3 ;
      $config['per_page'] = $per_page;
      $this->pagination->initialize($config);
      $data['offset']=$offset;

      
      $data['links']=$this->pagination->create_links();
      $this->load->view('your_view',$data);
}

And in your_view , you can echo $links to generate links.