CodeIgniter Forums
is pagination automatic? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: is pagination automatic? (/thread-20848.html)



is pagination automatic? - El Forum - 07-23-2009

[eluser]johnnyForums[/eluser]
If I have this code in my controller (index):

Code:
$data['title'] = 'My New Title';
        $data['heading'] = 'My New Heading';
        $this->load->model('Product_model');
        $data['query'] = $this->Product_model->get_products();
        $this->load->view('my_view',$data);
        $this->load->library('pagination');

        $config['base_url'] = 'http://127.0.0.1/catalog/index.php/products/';
        $config['total_rows'] = $this->db->count_all('tblproducts');
        $config['per_page'] = '5';
        $config['uri_segment'] = 4;
        $this->pagination->initialize($config);

        echo $this->pagination->create_links();

Is that all I need or do I need a page that actually does database work to get paging to work? I ask because this brings back all the data each time instead of just five rows. I have 30k that come back each time.


is pagination automatic? - El Forum - 07-23-2009

[eluser]elvix[/eluser]
you need to pass a limit and offset to your get_products function. Limit is your per_page value and offset is will be in uri segment 4, based on your pagination setup above.

hope that helps.


is pagination automatic? - El Forum - 07-24-2009

[eluser]philm[/eluser]
Snippet from one of mine if it helps make it a little clearer... ;-)
Code:
$data['pagination'] = $this->pagination->create_links();

// get paginated results
$num = $config['per_page'];
$offset = $this->uri->segment(3);
$this->pagination->initialize($config);
$data['rows'] = $this->Categories->getPaginated($num, $offset);

$this->load->view('vw_viewCategories', $data);