CodeIgniter Forums
problem with pagination library - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: problem with pagination library (/showthread.php?tid=69111)



problem with pagination library - oscarenzo - 10-09-2017

Hello all,

I'm starting with codeigniter from some weeks and have a little problem waiting that you can helpme, I'm enabling the paginator module for list rows from table, this is my code:

PHP Code:
function index(){        
 
   $this->load->model("QueryExpense_model");
 
   $this->load->library('pagination');

 
   // init params
 
   $limit_per_page 1;
 
   $start_index = ($this->uri->segment(3)) ? $this->uri->segment(3) : 0;
 
   $total_records $this->QueryExpense_model->count_all_rows_expense();
 
   $data['start_index'] = $start_index;

 
   if ($total_records 0){

 
     $data["page_expense_rows"] = $this->QueryExpense_model->list_all_rows_expense($limit_per_page$start_index);
 
      
      $config
['base_url'] = base_url() . 'expense/index';
 
     $config['total_rows'] = $total_records;
 
     $config['per_page'] = $limit_per_page;
 
     $config['num_links'] = 2;
 
     $config['first_link'] = 'Inicio';
 
     $config['last_link'] = 'Último';
 
     $config['next_link'] = '>';
 
     $config['prev_link'] = '<';
 
      
      $this
->pagination->initialize($config);
 
      
      
// build paging links
 
     $data["links"] = $this->pagination->create_links();
 
   }            

         
$this->load->view('header'$data);
         
$this->load->view('expense/body');
        
$this->load->view('footer');        
    } 


But I have a problem, my case I have by example 25 rows in the database table, in the paginate numbers show correctly begin the rows number but, when go to past each page see that in the page 1 (the first-default) the offset is 0, this is correct correct, but when go to the next page the offstet is 22 instead 11, can you help me?

I tested deleting the option "$config['use_page_numbers'] = TRUE;" and fixed but the page number in pagination not match with the url number, by example the real page 1 in url is "app/index/" and in the real page 2 in the url is "app/index/1"

Thank you advance.


RE: problem with pagination library - InsiteFX - 10-10-2017

Maybe this will help.

Pagination in CodeIgniter: The Complete Guide