How7o
  • Home
  • Tools
  • Prank Screens
  • Contact
  • Blog
Reading: How to Use the Laravel Validator Exists Rule
Share
Subscribe Now
How7oHow7o
Font ResizerAa
  • Marketing
  • OS
  • Features
  • Guide
  • Complaint
  • Advertise
Search
  • Home
  • Tools
  • Prank Screens
  • Contact
  • Blog
Follow US
Copyright © 2014-2023 Ruby Theme Ltd. All Rights Reserved.
How7o > Blog > Web Development > How to Use the Laravel Validator Exists Rule
Web Development

How to Use the Laravel Validator Exists Rule

how7o
By how7o
Last updated: April 19, 2026
6 Min Read
Laravel validator exists rule checking a post_id against the posts table
SHARE

When you’re validating a form that references an existing row — editing a post, attaching a tag, updating a user — you can skip writing a manual existence check in the controller. Laravel’s validator has a built-in exists rule that runs the database check for you and fails validation automatically if the reference is invalid.

Contents
  • TL;DR
  • The Manual Check You’re Replacing
  • Using the exists Rule
    • Table Form
    • Model Form
  • Adding Constraints to the Rule
  • The Opposite: unique Rule
  • Troubleshooting
    • “Table Does Not Exist” From the Validator
    • Validation Passes But the Record Is Soft-Deleted
    • SQL Injection From User Input in Rule::exists()
  • Frequently Asked Questions
  • Related Guides

Originally published August 30, 2022, rewritten and updated April 17, 2026.

TL;DR

Add exists:table,column (or exists:App\Models\ModelName,column) to any validation rule array:

'post_id' => 'required|exists:posts,id'

If no row with id = $request->post_id exists in posts, validation fails before your controller body runs.

The Manual Check You’re Replacing

Without the rule, you end up splitting validation across two places — the validator handles required/format rules, and the controller reaches into the database to confirm the ID is real:

$post = Post::where('id', $request['post_id']);
if ($post->exists()) {
    // Update the post
}

Moving the existence check into the validator centralizes the logic, returns a proper 422 validation response on failure, and keeps the controller focused on the happy path.

Using the exists Rule

Table Form

The simplest form takes a table name and a column:

$this->validate($request, [
    'post_id'      => 'required|exists:posts,id',
    'post_title'   => 'required|string|max:255',
    'post_content' => 'required',
]);

This asks the database: “Does a row exist in posts where id equals the submitted post_id?” If not, the validator adds an error for that field.

Model Form

You can also pass a model class instead of a table name. Laravel resolves the table from the model, which means model-level customizations like a non-default table name or a global scope can apply:

'post_id' => 'required|exists:App\Models\Post,id'

Adding Constraints to the Rule

If you need the row to match more than just the primary key — say, you want to allow only published posts owned by the current user — use the Rule::exists() fluent builder:

use Illuminate\Validation\Rule;

$this->validate($request, [
    'post_id' => [
        'required',
        Rule::exists('posts', 'id')
            ->where('user_id', auth()->id())
            ->where('status', 'published'),
    ],
]);

Each ->where(...) adds a constraint to the underlying query. This is the cleanest way to validate “the row exists AND belongs to the current user” in one pass, without leaking authorization into the controller.

Laravel exists validation rule checking a post_id against the posts table with a scoped query

The Opposite: unique Rule

The inverse of exists is unique. Use it to make sure a value is not already taken — typically on registration forms:

'email' => 'required|email|unique:users,email'

When updating an existing user, you usually want to exempt their own row from the uniqueness check, which you can do with Rule::unique()->ignore():

'email' => [
    'required',
    'email',
    Rule::unique('users', 'email')->ignore($user->id),
],

Troubleshooting

“Table Does Not Exist” From the Validator

If the exists rule reports a missing table, double-check the table name (not the model name) in the string form. When passing a model, use the fully-qualified class name (e.g. App\Models\Post, not just Post).

Validation Passes But the Record Is Soft-Deleted

The exists rule runs a raw query against the table, so it matches soft-deleted rows too. If you want to exclude soft-deleted records, add an explicit constraint:

Rule::exists('posts', 'id')->whereNull('deleted_at')

SQL Injection From User Input in Rule::exists()

Values passed to ->where() are bound as parameters, so user input in those clauses is safe. However, never interpolate user input directly into the table name or column name — those are not bound. Always use fixed strings for the table and column arguments.

Frequently Asked Questions

What’s the syntax for the Laravel exists validation rule?

<code>exists:table,column</code> — for example, <code>’post_id’ => ‘required|exists:posts,id'</code>. You can also pass a fully-qualified model class: <code>exists:App\Models\Post,id</code>.

How do I add extra conditions to the exists rule?

Use the fluent <code>Rule::exists()</code> builder and chain <code>->where()</code> calls. For example, <code>Rule::exists(‘posts’, ‘id’)->where(‘user_id’, auth()->id())</code> validates both that the post exists and that it belongs to the current user.

Does the exists rule include soft-deleted rows?

Yes. The rule runs a raw query against the table and does not know about soft-delete scopes. To exclude soft-deleted rows, add <code>->whereNull(‘deleted_at’)</code> to the Rule builder.

What’s the opposite of the exists rule?

<code>unique</code>. Use it when a value must not already be in the database — for example, a unique email on registration. When updating, use <code>Rule::unique(‘users’, ’email’)->ignore($user->id)</code> to allow the user’s own current value.

Related Guides

  • How to Check if a Record Exists in Laravel
  • Laravel updateOrCreate: Insert or Update Records in Eloquent
  • How to Install Laravel

For the complete list of built-in rules, see the official Laravel validation documentation.

TAGGED:EloquentLaravelphpValidation

Sign Up For Daily Newsletter

Be keep up! Get the latest breaking news delivered straight to your inbox.
By signing up, you agree to our Terms of Use and acknowledge the data practices in our Privacy Policy. You may unsubscribe at any time.
Share This Article
Facebook Copy Link Print
Previous Article Laravel Eloquent exists method checking if a record exists in a database query How to Check if a Record Exists in Laravel
Next Article Laravel foreign key constraint linking posts.user_id to users.id in a schema diagram How to Add Foreign Keys in Laravel Migration
Leave a Comment

Leave a Reply Cancel reply

You must be logged in to post a comment.

FacebookLike
XFollow
PinterestPin
InstagramFollow

Subscribe Now

Subscribe to our newsletter to get our newest articles instantly!
Most Popular
Laravel user password being updated via artisan tinker with Hash::make
How to Change a User Password in Laravel
April 19, 2026
Deleting a Laravel user cascades to remove related posts, photos, and notifications
How to Delete Related Records in Laravel Eloquent
April 19, 2026
Laravel migration converting a MySQL column type from VARCHAR to DECIMAL without losing data
How to Change a MySQL Column Type in Laravel Migration
April 19, 2026
Laravel migration adding two new columns to an existing transactions table
How to Add New Columns to an Existing Table in Laravel Migration
April 19, 2026
Laravel foreign key constraint linking posts.user_id to users.id in a schema diagram
How to Add Foreign Keys in Laravel Migration
April 19, 2026

You Might Also Like

How to use localStorage in JavaScript shown in a browser storage panel
Web Development

How to Use localStorage in JavaScript (With Real Examples + Troubleshooting)

8 Min Read
Check if GD library is installed in PHP (phpinfo and extension_loaded)
Web Development

How to Check if GD Library Is Installed in PHP (3 Easy Methods)

5 Min Read
Create custom exception class in Laravel (Artisan command + secure error handling)
Web Development

How to Create a Custom Exception Class in Laravel (With Clean JSON Responses)

6 Min Read
Install PHP on Ubuntu — terminal with apt install php command and stylized elephant icon
Web Development

How to Install PHP on Ubuntu (22.04 & 24.04): Step-by-Step Guide

9 Min Read
How7o

We provide tips, tricks, and advice for improving websites and doing better search.

Latest News

  • SEO Audit Tool
  • Client ReferralsNew
  • Execution of SEO
  • Reporting Tool

Resouce

  • Google Search Console
  • Google Keyword Planner
  • Google OptimiseHot
  • SEO Spider

Get the Top 10 in Search!

Looking for a trustworthy service to optimize the company website?
Request a Quote
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?