Detailed explanation of optimization steps for unique and exists validation rules in Laravel-PHP Tutorial-php.cn

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

php中世界最好的语言

Release： 2023-03-26 21:22:01

Original

1371 people have browsed it

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'

Copy after login

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);
 }),
],

Copy after login

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

Copy after login

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(',');
}

Copy after login

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!