In other frameworks, pagination can be very painful. Laravel makes it a breeze. Laravel can generate an intelligent "range" of links based on the current page. The generated HTML is compatible with the Bootstrap CSS framework.
There are several ways to paginate items. The simplest is by using
paginate method on the query builder or an Eloquent
Paginating Database Results
$users = DB::table('users')->paginate(15);
Note: Currently, pagination operations that use a
groupBystatement cannot be executed efficiently by Laravel. If you need to use a
groupBywith a paginated result set, it is recommended that you query the database and create a paginator manually.
Creating A Paginator Manually
Sometimes you may wish to create a pagination instance manually,
passing it an array of items. You may do so by creating either an
depending on your needs.
Paginating An Eloquent Model
You may also paginate Eloquent models:
$allUsers = User::paginate(15); $someUsers = User::where('votes', '>', 100)->paginate(15);
The argument passed to the
paginate method is the number
of items you wish to display per page. Once you have retrieved the
results, you may display them on your view, and create the pagination
links using the
<div class="container"> <?php foreach ($users as $user): ?> <?php echo $user->name; ?> <?php endforeach; ?> </div> <?php echo $users->render(); ?>
This is all it takes to create a pagination system! Note that we did not have to inform the framework of the current page. Laravel will determine this for you automatically.
You may also access additional pagination information via the following methods:
If you are only showing "Next" and "Previous" links in your
pagination view, you have the option of using the
simplePaginate method to perform a more efficient query.
This is useful for larger datasets when you do not require the display
of exact page numbers on your view:
$someUsers = User::where('votes', '>', 100)->simplePaginate(15);
Customizing The Paginator URI
You may also customize the URI used by the paginator via the
$users = User::paginate(); $users->setPath('custom/url');
The example above will create URLs like the following: http://example.com/custom/url?page=2
Appending To Pagination Links
You can add to the query string of pagination links using the
appends method on the Paginator:
<?php echo $users->appends(['sort' => 'votes'])->render(); ?>
This will generate URLs that look something like this:
If you wish to append a "hash fragment" to the paginator's URLs, you
may use the
<?php echo $users->fragment('foo')->render(); ?>
This method call will generate URLs that look something like this:
Converting To JSON
Paginator class implements the
Illuminate\Contracts\Support\JsonableInterface contract and
toJson method. You may also convert a
Paginator instance to JSON by returning it from a route.
The JSON'd form of the instance will include some "meta" information
last_page. The instance's data will be available via the
data key in the JSON array.