Laravel Pagination: Basic Usage

Paginating Query Builder Results

<?php

namespace App\Http\Controllers;

use Illuminate\Support\Facades\DB;
use App\Http\Controllers\Controller;

class UserController extends Controller
{
    /**
     * Show all of the users for the application.
     *
     * @return Response
     */
    public function index()
    {
        $users = DB::table('users')->paginate(15);

        return view('user.index', ['users' => $users]);
    }
}

Paginating Eloquent Results

$users = App\User::paginate(15);
$users = User::where('votes', '>', 100)->paginate(15);
$users = User::where('votes', '>', 100)->simplePaginate(15);

Manually Creating A Paginator

When manually creating a paginator instance, you should manually "slice" the array of results you pass to the paginator.

Laravel Pagination: Basic Usage — Structure map

Clickable & Draggable!

Laravel Pagination: Basic Usage — Related pages: