Pagination and Search

Goal

This snapshot advances Marlowe Gazette by teaching you to paginate the feed and filter story text safely.

Every numbered folder is complete and independently runnable, so you can inspect this stage without rebuilding earlier lessons.

Prerequisites

Use PHP 8.2 or newer, Composer, Docker, and a terminal. Basic PHP, HTML, and SQL familiarity will help.

The Laravel development server uses port 8000. Root Docker Compose exposes MySQL 8 on port 3307 and each snapshot has a separate database.

• PHP and Composer
• Docker
• A code editor and terminal

Concepts

Pagination bounds query work, and grouped LIKE conditions filter public title/body fields while preserving page query strings.

Laravel keeps HTTP routes, controllers, Eloquent models, validation, authorization, and Blade presentation in explicit layers.

Walkthrough

Trace the optional query filter, eager loading, newest-first ordering, six-item paginator, and Bulma-compatible links.

Inspect the matching snapshot around the example. The repository includes validation, errors, CSRF protection, and the surrounding application structure.

$posts->when($q, fn ($query) => $query->where(...))->paginate(6)->withQueryString();

Run and verify

Start MySQL from the repository root, enter 10-Pagination-And-Search, install dependencies, copy the environment file, generate an application key, migrate, seed, and serve.

Open http://localhost:8000. From data lessons onward, Ada and Grace are deterministic accounts with password password123.

docker compose up -d
git clone https://github.com/michaeldunga1/fcc-laravel-blog.git
cd fcc-laravel-blog/10-Pagination-And-Search
composer install
cp .env.example .env
php artisan key:generate
php artisan migrate --seed
php artisan storage:link
php artisan serve --host=0.0.0.0 --port=8000

Troubleshooting

Group OR conditions inside a closure so they cannot bypass surrounding publication constraints.

If MySQL fails, verify Docker is healthy, port 3307 is free, and this snapshot's DB_DATABASE matches its unique marlowe_XX database.

• Read the first exception
• Clear cached config after environment changes
• Never commit .env, vendor, or node_modules

Try this

Seed enough stories for two pages and confirm a search term persists in Next links.

Exercise both a successful request and a validation or authorization failure before moving to the next snapshot.

• Make one focused change
• Test it in the browser
• Compare the next snapshot after it works