StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>You have to set offset and limit when you query from the database to make pagination work.</p> <p>your get_search model should be like this</p> <pre><code>function get_search($match, $match2, $limit, $offset){ $this->db->limit($limit, $offset); /*Rest of the code*/ } </code></pre> <p>your current query becomes</p> <pre><code>$data['query'] = $this->bedrijven_model->get_search($match, $match2, 2147483647, 0); /*large number as limit to retrieve all the rows*/ </code></pre> <p>You need to query another time with offset and limit like this</p> <pre><code>$data['query_curr'] = $this->bedrijven_model->get_search($match, $match2, $config['per_page'], $this->uri->segment(3) ); </code></pre> <p>Here, $config['per_page'] is the limit and the offset is taken from the url segment( You have to initialize url helper. You need to use this <code>query_curr</code> variable in the view. This is the way to use pagination and correct number of rows will be shown.</p> <p>Last thing, you don't have to send create_links() as variable in the view. You can use that directly in the view.</p> <p><strong>UPDATE:</strong></p> <p>Change your <code>searchresult</code> function to this</p> <pre><code>function searchresults() { $this->breadcrumbs->page = array('link'=> base_url().'home/search' ,'title' => 'Bedrijven Zoeken' ); $this->breadcrumbs->method = array('link'=> base_url().'home/searchresults' ,'title' => 'Zoekresultaten' ); $data['breadcrumbs'] = $this->breadcrumbs->get(); $match = $this->input->post('search'); if(strlen($this->input->post('cookie')) > 0){ $match2 = $this->input->post('cookie'); } else{ $match2 = '9101'; } $data['query'] = $this->bedrijven_model->get_search($match, $match2, 2147483647, 0); $this->load->library('pagination'); $config['base_url'] = base_url().'home/searchresults/'; $config['total_rows'] = count($data['query']); $config['per_page'] = 4; $this->pagination->initialize($config); $data['links'] = $this->pagination->create_links(); //$data['query'] = $this->bedrijven_model->get_search($match, $match2, 2147483647, 0); /*large number as limit to retrieve all the rows*/ $data['query_curr'] = $this->bedrijven_model->get_search($match, $match2, $config['per_page'], $this->uri->segment(3) ); $this->load->view('views/header'); $this->load->view('views/searchresults', $data); $this->load->view('views/footer'); } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload