The optimization method of unique and exists validation rules in Laravel

Laravel provides several ways to validate the application input data. By default, the Laravel controller base class uses validatesrequests trait, which provides a convenient way to validate incoming HTTP requests through various powerful validation rules. This paper mainly introduces the laravel of the unique and exists validation rules of the relevant data, the text through the sample code introduced in very detailed, to everyone's study or work has a certain reference learning value, hope to help everyone.

It is very convenient to verify requests by validatesrequests this trait in laravel, and it is automatically introduced in the Basecontroller class. The two rules of Exitsts () and unique () are very powerful and convenient.

They need to validate the data that is already in the database as they are used, and usually they write as follows:

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

The syntax of this notation is hard to remember, and we have to check the documentation almost every time we use it. But starting with the version of Laravel 5.3.18 These two validation rules can be simplified by a new rule class.

We can now use the familiar chained 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 of these validation rules also support the following chained methods:

• where

• Wherenot

• Wherenull

• Wherenotnull

The unique validation rule also supports the Ignore method so that specific data can be ignored when validating.

The good news is that the old notation is still fully supported, and the new writing is actually converting it to the old way at the bottom through the Formatwheres method:

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