Or sorting your results: $users = User:: orderBy( 'id', 'desc')-> cursorPaginate( 15) ĭon't worry, the package will detect if the model's primary key is being used for sorting, and it will adapt Of course, you may call paginate after setting other constraints on the query, such as where clauses: $users = User:: where( 'votes', '>', 100)-> cursorPaginate( 15) As you can see, the syntax is identical to paginating query builder results: $users = User:: cursorPaginate( 15) In this example, we will paginate the User model $users = DB:: table( 'users')-> cursorPaginate() This value is automatically detected by the package taking your custom config into account, and is also automatically inserted into links and meta generated by the paginator. Previous elements based on the cursor being viewed by the user.īy default, the cursor is detected by the value of the page query string argument on the HTTP request. The cursorPaginate method automatically takes care of setting the proper limit and fetching the next or The simplest is by using the cursorPaginate method on the query builder or an Eloquent query. There are several ways to paginate items. Basic Usage Paginating Query Builder Results The results will only fetch the new ones. Or do a cursor whenever you need to refresh the list at the top, and if you send the first cursor,
This kind of pagination is useful when you sort using the latest first, so you can keep an infinite scroll using cursor whenever you get to the bottom, The result is the same as the old fashioned page pagination,īut now you have more control on the output, cause it should always return the same. If you decode it, you'll we something like: So instead of saying page=2, you say: cursor=eyJpZCI6MTAsIl9wb2ludHNUb05leHRJdGVtcyI6dHJ1ZX0=Īnd the cursor value is encoded(base64).
The main idea behind a cursor pagination is that it needs a context to know what results to show next. The package will automatically register itself.
#ELOQUENT LARAVEL GET PAGINATED RECORDS INSTALL#
You can install this package via composer using: composer require aloware/laravel-cursor-pagination This package is tested on Laravel 5.6, and we expect it to work on newer versions, but it was never tested. It calculates the SQL query limits automatically by checking the requests GET parameters, and automatically builds This package provides cursor based pagination for Laravel's Query Builder and Eloquent ORM.
0 kommentar(er)
