Download the PHP package spatie/laravel-json-api-paginate without Composer

A paginator that plays nice with the JSON API spec

In a vanilla Laravel application the query builder paginators will listen to page request parameter. This works great, but it does not follow the example solution of the json:api spec. That example expects the query builder paginator to listen to the page[number] and page[size] request parameters.

This package adds a jsonPaginate method to the Eloquent query builder that listens to those parameters and adds the pagination links the spec requires.

Support us

We invest a lot of resources into creating best in class open source packages. You can support us by buying one of our paid products.

We highly appreciate you sending us a postcard from your hometown, mentioning which of our package(s) you are using. You'll find our address on our contact page. We publish all received postcards on our virtual postcard wall.

Installation

You can install the package via composer:

In Laravel 5.5 and above the service provider will automatically get registered. In older versions of the framework just add the service provider in config/app.php file:

Optionally you can publish the config file with:

This is the content of the file that will be published in config/json-api-paginate.php

Usage

To paginate the results according to the json API spec, simply call the jsonPaginate method.

Of course you may still use all the builder methods you know and love:

You can also paginate results for relations:

Override default behavior

By default the maximum page size is set to 30. You can change this number in the config file or just pass the value to jsonPaginate.

By default the default page size is set to 30. You can change this number in the config file or just pass the value to jsonPaginate.

You can also pass the total count to the paginate function directly. This can be useful for performance reasons or to prevent issues with DISTINCT keyword (more info).

⚠️ This is effective only with basic pagination (no effect with cursor, simple or fast pagination)

Cursor pagination

This package also supports cursor pagination, which can be briefly defined by the Laravel Framework as follows:

While paginate and simplePaginate create queries using the SQL "offset" clause, cursor pagination works by constructing "where" clauses that compare the values of the ordered columns contained in the query, providing the most efficient database performance available amongst all of Laravel's pagination methods.

You can find more about cursor pagination in the Laravel Documentation.

If you want to use cursor pagination, you can set the use_cursor_pagination to true in the config file.

It's also possible to modify the pagination parameter in the config file, by modifying the cursor_parameter value.

IDE Support

This package includes IDE helper stubs that provide autocompletion and type hints for the jsonPaginate() method in PhpStorm, VSCode (with Intelephense), and other modern PHP IDEs.

After installing the package, your IDE will automatically recognize the jsonPaginate() method on Eloquent models, query builders, and relationships. The method signature includes proper type hints for all parameters and return types.

If you've configured a custom method name using the method_name config option, you may need to create custom IDE hints for your specific method name. The included _ide_helper.php file can serve as a reference for this purpose.

Changelog

Please see CHANGELOG for more information what has changed recently.

Upgrading from v3.x to v4.x

Breaking Change: base_url Config Removed

The base_url configuration option has been removed due to a design flaw where it would completely overwrite the request path, causing all pagination URLs to lose their resource-specific paths.

Before (v3.x - BROKEN for multi-endpoint APIs):

After (v4.x - Use Laravel's native solution):

This approach correctly preserves request paths while controlling the scheme and domain:

• /api/users → https://example.com/api/users?page=2 ✓
• /api/posts → https://example.com/api/posts?page=2 ✓

Why was this removed?

The base_url option used Laravel's setPath() method which completely replaces the pagination path. In real-world applications with multiple endpoints, this caused all resources to generate identical pagination URLs, breaking pagination for all but one endpoint.

For more context, see GitHub Discussion #53.

Testing

Contributing

Please see CONTRIBUTING for details.

Security

If you've found a bug regarding security please mail [email protected] instead of using the issue tracker.

Credits

• Freek Van der Herten
• All Contributors

The base code of this page was published on this Laracasts forum thread by Joram van den Boezem

License

The MIT License (MIT). Please see License File for more information.