Laravel Unique Validation with Condition Example

Jul 30, 2020

Hello Friends,

In this blog, I would like share you how to use unique validation with condition in laravel application. I need to validate if the email field on the users table is unique only if the deleted column is not 1 in laravel app.

In this article, We will use unique validation with condition in laravel. laravel unique validation with condition using rule.

You have to include the Rule class with a use at the top of your file after the namespace declaration.

use Illuminate\Validation\Rule; 

Here I will give solution for laravel unique with condition. So Let's see the solution and implete in your laravel project.

Solution :

use Illuminate\Validation\Rule; 
public function index()
{
	$request->validate([
    		'name' => 'required',
            'email' => [
                'required','email',Rule::unique('transporters')->where(function($query) {
                  $query->where('deleted', '=', '0');
              })
            ],
        ])
}

Solution : On Update

use Illuminate\Validation\Rule; 
public function index()
{
	$request->validate([
    		'name' => 'required',
            'email' => [
                'required','email',Rule::unique('transporters')->where(function($query) {
                  $query->where('deleted', '=', '0')
                  ->where('id', '!=', $id);
              })
            ],
        ])
}

It will help you...