4 ms·
As mentioned: > c) You cannot use page numbers. You can only do first page, next and previous pages, and last page. To get to page 9, you start on first page.
by developer2 9y ago
As mentioned:
> c) You cannot use page numbers. You can only do first page, next and previous pages, and last page.
To get to page 9, you start on first page. Then "next page" 8 times. This is why you see this kind of UI fairly often. First (<<), previous (<), next (>), last (>>). No numbers.
Technically you can do relative page numbers (ie: current page + 8) by increasing the LIMIT of the query and skipping over results. It's really messy to handle and you can never use "real", absolute page numbers, because inserted and deleted records can change how many next or previous pages there will be.
- thriftwy 9y ago> To get to page 9, you start on first page. Then "next page" 8 times. Are you sure it will be faster than just using offset/limit on the server side?