php 45 lines · 9 steps

Building a filtered product index in Laravel

How Eloquent's when() method conditionally chains query filters from validated request input.

Explained by highlit

Laravel Intermediate query-builder validation conditional-queries pagination closures

1<?php
2 
3namespace App\Http\Controllers;
4 
5use App\Models\Product;
6use Illuminate\Http\Request;
7 
8class ProductController extends Controller
9{
  public function index(Request $request)
  {
      $filters = $request->validate([
          'search' => ['nullable', 'string', 'max:255'],
          'category_id' => ['nullable', 'integer', 'exists:categories,id'],
          'min_price' => ['nullable', 'numeric', 'min:0'],
          'max_price' => ['nullable', 'numeric', 'gte:min_price'],
          'in_stock' => ['nullable', 'boolean'],
          'sort' => ['nullable', 'in:newest,price_asc,price_desc'],
      ]);
20 
      $products = Product::query()
          ->with('category')
          ->when($filters['search'] ?? null, function ($query, $search) {
              $query->where(function ($q) use ($search) {
                  $q->where('name', 'like', "%{$search}%")
                      ->orWhere('sku', 'like', "%{$search}%");
              });
          })
          ->when($filters['category_id'] ?? null, fn ($query, $id) => $query->where('category_id', $id))
          ->when($filters['min_price'] ?? null, fn ($query, $min) => $query->where('price', '>=', $min))
          ->when($filters['max_price'] ?? null, fn ($query, $max) => $query->where('price', '<=', $max))
          ->when($request->boolean('in_stock'), fn ($query) => $query->where('stock', '>', 0))
          ->when($filters['sort'] ?? 'newest', function ($query, $sort) {
              match ($sort) {
                  'price_asc' => $query->orderBy('price'),
                  'price_desc' => $query->orderByDesc('price'),
                  default => $query->latest(),
              };
          })
          ->paginate(24)
          ->withQueryString();
42 
      return view('products.index', compact('products', 'filters'));
  }
45}

01 / 01

STEP 01

Walkthrough

Space play ←→ step click any line

Three takeaways

1Validating request input up front turns untrusted query parameters into a safe, typed array you can trust downstream.
2when() lets you assemble a query conditionally without a tangle of if statements, applying each filter only when its value is present.
3Pairing paginate() with withQueryString() keeps active filters intact as users move between pages.

Related explainers

php

<?php
 
namespace App\Models\Scopes;

How a tenant global scope works in Laravel

multi-tenancy global-scope query-builder

Intermediate 5 steps

rust

use axum::{
    extract::{Query, State},
    http::StatusCode,
    Json,

Paginated, filtered product listing in Axum

pagination query-parameters sql-filtering

Intermediate 8 steps

ruby

class Api::V1::ArticlesController < Api::V1::BaseController
  def index
    articles = Article
      .published

Building a JSON:API endpoint in Rails

serialization eager-loading pagination

Intermediate 7 steps

php

<?php
 
namespace App\Support;

Retry with exponential backoff in PHP

retry exponential-backoff error-handling

Intermediate 7 steps

php

<?php
 
declare(strict_types=1);

Validating registration input with filter_var

validation sanitization filter_var

Intermediate 8 steps

python

import time
from dataclasses import dataclass, field
 
from fastapi import Depends, FastAPI, HTTPException, Request, status

Token-bucket rate limiting in FastAPI

rate-limiting token-bucket dependency-injection

Advanced 10 steps

Share this explainer

Here's the card — post it anywhere.

Building a filtered product index in Laravel — share card

Made with highlit — turn any snippet into a walkthrough like this in about a minute.

Explain your code