Welcome Guest, Not a member yet? Register   Sign In
is pagination automatic?
#1

[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.
#2

[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.
#3

[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);




Theme © iAndrew 2016 - Forum software by © MyBB