Level 3
same on with cursor pagination
select * from `flights` order by `id` asc limit 6
Jun 12, 2021
8
Level 3
pagination
hello Everyone, when i run this queries they show 5 record per page but when i see queries in laravel debugger they show limit(6) why
$flight = Flight::orderBy('id')->simplepaginate(5);
select * from `flights` order by `id` asc limit 6 offset 0
Level 3
but work correctly use paginate
$flight = Flight::orderBy('id')->paginate(5);
select count(*) as aggregate from `flights`
select * from `flights` order by `id` asc limit 5 offset 0
Level 28
I see what you mean I get the same thing with simplePaginate
select `threads`.*, (select count(*) from `replies` where `threads`.`id` = `replies`.`thread_id`) as `replies_count` from `threads` order by `created_at` desc limit 6 offset 0
But it works and I can't figure out why... Magic.
Level 3
@lemmon same on here but what is the reason behind this??
Level 122
interesting read, https://simonkollross.de/posts/implementing-cursor-based-pagination-in-laravel
But why the $limit + 1? That's a little trick to find out if there is another page of results available. We fetch one row more than required, which is later removed from the results. So we know we have to create another cursor, because there is at least one more result available that lives on the next page.
Level 3
thank you @snapey Sir
Level 28
Thanks @snapey, good read.
@asadali007 , I don't think there is a better answer than that do you? :)
Please or to participate in this conversation.