Laravel Unique Rules for multiple columns

You may also specify additional query constraints by customizing the query using the where method. Something like this:

'exam_category_id' => Rule::unique('exams')->where(function ($query) use ($request) {
   return $query->where('exam_name', $request->exam_name)
      ->where('exam_year', $request->exam_year)
      ->where('student_id', $request->student_id);
})

https://laravel.com/docs/7.x/validation#rule-unique

try this

before use this in your conroller

use Illuminate\Support\Facades\Validator;

public function rules(Request $request)
    {
$validator = Validator::make($request->all(), [
            'email' => ['required', 'string', 'email', 'max:255', 'unique:users'],
            ]);
}

here users is a table name

I got this error:

Undefined variable: request

@noblemfd oh, you're in the request class, so replace $request with $this.

Do I also need to replace ($query) use ($request) with $this

@noblemfd you need to remove use ($request).

How do I apply the same thing for update

@noblemfd no problem just add this in your controller

use Illuminate\Http\Request;

it will work

Hi all

Using the code:

Rule::unique('exams')->where(function ($query) use ($request) { 
. . .
}

is there a way to customize the output message?

Thank you,

Hi Same question @vlauciani how to handle a custom error message on a multiple field validation ? I have a form request validation rule :

public function rules()
    {
        return [
                'name' => 'required',
                'email' => 'required|email',
                'username' =>  [
                             'required', 
                             Rule::unique('users')
                                    ->where('company_id', $this->company_id)
                            ]
            ];
    }

and a message handler :

public function messages()
    {
        return [
            'username.unique' => 'couple username and company_id has to be unique.',
        ];
    }

Validation rule well pass or not, but my custom message doesn't appear. Any idea ? Thx