Offset pagination made easy for Laravel

v1.2 2019-07-05 12:10 UTC

This package is auto-updated.

Last update: 2022-06-29 01:42:13 UTC


This package provides an offset based pagination already integrated with Laravel's query builder and Eloquent ORM. It calculates the SQL query limits automatically by checking the requests GET parameters, and automatically builds the next and previous urls for you.


You can install this package via composer using:

composer require chelout/offset-pagination

The package will automatically register itself.


To publish the config file to config/offset_pagination.php run:

php artisan vendor:publish --provider="Chelout\OffsetPagination\CursorPaginationServiceProvider" --tag="config"

This will publish the following file. You can customize default items per page and maximum items per page.

Basic Usage

Paginating Query Builder Results

public function index()
    $users = DB::table('users')->offsetPaginate();
    return $users;

Paginating Eloquent Results

$users = User::offsetPaginate(5);

Of course, you may call paginate after setting other constraints on the query, such as where clauses:

$users = User::where('votes', '>', 100)->offsetPaginate(5);

Or sorting your results:

$users = User::orderBy('id', 'desc')->offsetPaginate(5);

Displaying Pagination Results

Converting to JSON

A basic return will transform the paginator to JSON and will have a result like this:

Route::get('api/v1/users', function () {
    return App\User::offsetPaginate();

Calling api/v1 will output:

   "data": [
    "offset": 60,
    "offset": 60,
    "prev": 55,
    "next": 65,
    "limit": 5,
    "total": 100,
    "next_page_url": "",
    "prev_page_url": ""

Using a Resource Collection

By default, Laravel's API Resources when using them as collections, they will output a paginator's metadata into links and meta.

        "links": {
            "first": "",
            "last": "",
            "prev": "",
            "next": ""
        "meta": {
            "offset": 60,
            "prev": 55,
            "next": 65,
            "limit": 5,
            "total": 100


Run the tests with:




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