Pagination negative offset |
Imagine page has Pagination,when use follow code to implement Pagination limit
Code: $data ['list'] = $this->test_model->get_list ( $per_page, $this->uri->segment ( 2 )); Now lets say user modify segment to -20 (negative value), code will give error Code: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 4 how we can solved this issue? currently I'm using following code to avoid mention issue..is any better way? Code: $offset = NULL; Thank You
Hi,
You could use the max function. Code: $data ['list'] = $this->test_model->get_list(max(0, $per_page), $offset);
You can check that the page isn't negative.
Something like this: Code: $page = $this->uri->segment ( 2 ) && $this->uri->segment ( 2 ) > 0 ? (int) $this->uri->segment ( 2 ) : 1; |
Welcome Guest, Not a member yet? Register Sign In |