Home  >  Article  >  Backend Development  >  Optimization of unique and exists validation rules in Laravel Detailed PHP example

Optimization of unique and exists validation rules in Laravel Detailed PHP example

jacklove
jackloveOriginal
2018-06-28 18:02:061549browse

This article mainly introduces you to 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. Friends who need it Let’s learn together with the editor below.

Preface

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.

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 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 chain method:

  • where

  • whereNot

  • whereNull

  • whereNotNull

unique verification rules also support the ignore method, so that during verification Sometimes you can ignore specific data.

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:

php Method to determine whether the IP is a valid IP address php example

AES encryption class definition and usage examples implemented by php PHP skills

##PHP tips to prevent cross-site and xss attack code

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn