Detailed explanation of optimization steps for unique and exists validation rules in Laravel

This time I will bring you the unique and exists verification rules in LaravelDetailed explanation of the optimization steps, what are the notes for optimizing the unique and exists verification rules in Laravel, and the following are practical cases , let’s take a look.

Preface

Laravel provides a variety of methods to validate application input data. By default, Laravel's

Controller base class uses the ValidatesRequests trait, which provides convenience methods to validate incoming HTTP requests through a variety of powerful validation rules.

It is very convenient to verify requests through the ValidatesRequests trait in Laravel, and it is automatically introduced in the BaseController class. The two rules exitsts() and unique() are very powerful and convenient.

They need to verify the existing data in the database during use. Usually they will be written like the following:

// exists example
'email' => 'exists:staff,account_id,1'
// unique example
'email' => 'unique:users,email_address,$user->id,id,account_id,1'

The syntax of the above writing method is difficult to remember, we Almost every time I use it, I have to look up the documentation. But starting from version 5.3.18 of Laravel, both validation rules can be simplified through a new Rule class.

We can now use the familiar chaining syntax below to achieve the same effect:

'email' => [
 'required',
 Rule::exists('staff')->where(function ($query) {
 $query->where('account_id', 1);
 }),
],

'email' => [
 'required',
 Rule::unique('users')->ignore($user->id)->where(function ($query) {
 $query->where('account_id', 1);
 })
],

Both validation rules also support the following chaining method:

• where

• whereNot

• whereNull

• whereNotNull

unique validation rules also support the ignore method, so that specific data can be ignored during validation.

The good news is that the old writing method is still fully supported, and the new writing method actually converts it into the old writing method at the bottom through the formatWheres method:

protected function formatWheres()
{
 return collect($this->wheres)->map(function ($where) {
 return $where['column'].','.$where['value'];
 })->implode(',');
}

I believe I read the case in this article You have mastered the method. For more exciting information, please pay attention to other related articles on the php Chinese website!

Recommended reading:

Detailed explanation of the use of PHP doubly linked list

Detailed explanation of the steps for PHP to use foreach to convert an array

The above is the detailed content of Detailed explanation of optimization steps for unique and exists validation rules in Laravel. For more information, please follow other related articles on the PHP Chinese website!