分頁

use Illuminate\Support\Facades\DB;

// 每頁 15 筆
$users = DB::table('users')->paginate(15);

use App\Models\User;

$users = User::paginate(15);

// 附加條件
$users = User::where('votes', '>', 100)->paginate(15);

$users = DB::table('users')->simplePaginate(15);
$users = User::where('active', true)->simplePaginate(15);

// 必須使用 orderBy
$users = DB::table('users')->orderBy('id')->cursorPaginate(15);
$users = User::where('active', true)->cursorPaginate(15);

http://example.com/users?cursor=eyJpZCI6MTUsIl9wb2ludHNUb05leHRJdGVtcyI6dHJ1ZX0

-- paginate() / simplePaginate() — 使用 OFFSET
SELECT * FROM users ORDER BY id ASC LIMIT 15 OFFSET 15;

-- cursorPaginate() — 使用 WHERE 子句（索引生效）
SELECT * FROM users WHERE id > 15 ORDER BY id ASC LIMIT 15;

<?php

namespace App\Http\Controllers;

use App\Models\User;
use Illuminate\View\View;

class UserController extends Controller
{
    public function index(): View
    {
        $users = User::orderBy('name')->paginate(20);

        return view('users.index', compact('users'));
    }
}

<div class="container">
    @foreach ($users as $user)
        <p>{{ $user->name }}</p>
    @endforeach

    {{-- 輸出分頁連結（支援 Tailwind CSS） --}}
{{ $users->links() }}
</div>

{{-- 顯示目前頁面前後 5 頁 --}}
{{ $users->onEachSide(5)->links() }}

public function index(Request $request): View
{
    $perPage = $request->integer('per_page', 15);
    $perPage = min(max($perPage, 1), 100); // 限制在 1〜100

    $users = User::paginate($perPage);

    return view('users.index', compact('users'));
}

$users = User::paginate(
    perPage: 15,
    columns: ['*'],
    pageName: 'users'
);

$posts = Post::paginate(
    perPage: 10,
    columns: ['*'],
    pageName: 'posts'
);

$users = User::paginate(15);

// 產生 /admin/users?page=N 形式的 URL
$users->withPath('/admin/users');

// 在每個頁面連結加入 sort=votes
$users->appends(['sort' => 'votes']);

// 繼承目前請求的所有查詢參數
$users->withQueryString();

// 在 URL 尾端附加 #users
$users->fragment('users');

use App\Models\User;

Route::get('/api/users', function () {
    return User::paginate(15);
});

{
    "total": 50,
    "per_page": 15,
    "current_page": 1,
    "last_page": 4,
    "first_page_url": "http://example.com/api/users?page=1",
    "last_page_url": "http://example.com/api/users?page=4",
    "next_page_url": "http://example.com/api/users?page=2",
    "prev_page_url": null,
    "path": "http://example.com/api/users",
    "from": 1,
    "to": 15,
    "data": [
        { "id": 1, "name": "山田太郎" },
        { "id": 2, "name": "鈴木花子" }
    ]
}

use App\Http\Resources\UserResource;
use App\Models\User;

Route::get('/api/users', function () {
    $users = User::paginate(15);

    return UserResource::collection($users);
});

{{-- 使用自訂 view 輸出連結 --}}
{{ $paginator->links('vendor.pagination.custom') }}

{{-- 額外傳入資料 --}}
{{ $paginator->links('vendor.pagination.custom', ['theme' => 'dark']) }}

php artisan vendor:publish --tag=laravel-pagination

use Illuminate\Pagination\Paginator;

public function boot(): void
{
    Paginator::defaultView('vendor.pagination.custom');
    Paginator::defaultSimpleView('vendor.pagination.simple-custom');
}

use Illuminate\Pagination\Paginator;

public function boot(): void
{
    Paginator::useBootstrapFive(); // Bootstrap 5
    // Paginator::useBootstrapFour(); // Bootstrap 4
}

use Illuminate\Pagination\LengthAwarePaginator;

$items = collect(range(1, 200))->map(fn ($i) => ['id' => $i, 'name' => "アイテム{$i}"]);

$perPage = 15;
$currentPage = request()->integer('page', 1);

$paginator = new LengthAwarePaginator(
    items: $items->forPage($currentPage, $perPage),
    total: $items->count(),
    perPage: $perPage,
    currentPage: $currentPage,
    options: ['path' => request()->url()]
);

$paginator = User::paginate(15);

$paginator->currentPage();     // 目前頁碼
$paginator->lastPage();        // 最後頁碼（simplePaginate 無法使用）
$paginator->total();           // 總筆數（simplePaginate 無法使用）
$paginator->perPage();         // 每頁筆數
$paginator->count();           // 目前頁面的筆數
$paginator->firstItem();       // 目前頁面第一筆的編號
$paginator->lastItem();        // 目前頁面最後一筆的編號
$paginator->hasPages();        // 是否有多頁
$paginator->hasMorePages();    // 是否有下一頁
$paginator->onFirstPage();     // 是否為第一頁
$paginator->onLastPage();      // 是否為最後一頁
$paginator->nextPageUrl();     // 下一頁 URL
$paginator->previousPageUrl(); // 上一頁 URL
$paginator->url(3);            // 第 3 頁的 URL
$paginator->items();           // 目前頁面的項目陣列