Optimization method for unique and exists validation rules in Laravel

Laravel provides a variety of methods to validate application input data. By default, Laravel's controller base classes use the ValidatesRequests trait, which provides convenience methods to validate incoming HTTP requests through a variety of powerful validation rules. This article mainly introduces you to the relevant information about the optimization of unique and exists validation rules in Laravel. The article introduces it in great detail through sample code. It has certain reference learning value for everyone's study or work. I hope it can help everyone.

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 above The syntax of this writing method is difficult to remember, and we have to look up the documentation almost every time we use it. But starting from version 5.3.18 of Laravel, both validation rules can be simplified through a new Rule class.

We can now achieve the same effect using the familiar chain syntax like this:

'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 methods:

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

Related recommendations:

laravel5.1 Validation rules alpha is invalid for Chinese?

PHP Yii framework form validation rules collection

YII form validation rules collection

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