Laravel Validation unique on update

Question

I know this question has been asked many times before but no one explains how to get the id when you re validating in the model    email    gt   unique users email address 10    My validation rule is in the model so how do I pass the ID of the record to the validation rule   Here is my models User  protected  rules update          email address    gt   required email unique users email address    id       first name    gt   required        last name    gt   required        password    gt   required min 6 same password confirm        password confirm    gt   required min 6 same password        password current    gt   required min 6       models BaseModel      protected  rules   array     public  errors             data  array  Data to be validated        rules  string  rule name in model      public function validate  data   rules    rules           validation    Validator  make  data   this- gt  rules        if  validation- gt passes              return true              this- gt errors    validation- gt messages         return false

User · Answer

There is a simple and elegant way to do this. If you are passing the user_id in a body request or through a query parameter. e.g

/update/profile?user_id=

Then in your request rules

  public function rules(Request $request)
    {
        return [
            'first_name' => 'required|string',
            'last_name' => 'required|string',
            'email' => ['required','email', 'string', Rule::unique('users')->ignore($request->user_id )],
            'phone_number' => ['required', 'string', Rule::unique('users')->ignore($request->user_id )],
        ];
    }

Better Still, you can pass in auth->id() in place of $request->user_id to get the login user id.

User · Answer

public function rules          switch  this- gt method                  case  GET           case  DELETE                         return                       case  POST                         return                    name    gt   required unique permissions max 255                    display name    gt   required                                    case  PUT           case  PATCH                         return                                        name    gt   unique permissions name    this- gt get  id     max 255                    display name    gt   required                                    default break

User · Answer

rules          email    gt   email unique users  email     id    user id       In Illuminate Validation Rules Unique   Unique validation will parse string validation to Rule object  Unique validation has pattern  unique  s  s  s  s  s   Corresponding with  table name  column  ignore  id column  format wheres         Convert the rule to a validation string         return string     public function   toString         return rtrim sprintf  unique  s  s  s  s  s            this- gt table           this- gt column           this- gt ignore     NULL            this- gt idColumn           this- gt formatWheres

User · Answer

It works like a charm someone can try this  Here I have used soft delete checker  You could omit the last  id deleted at  NULL if your model doesn t have soft delete implementation   public function rules         switch   this- gt method              case  PUT                emailRules    required unique users email   this- gt id  id deleted at NULL               break          default               emailRules    required unique users email NULL id deleted at NULL               break             return            email    gt   emailRules           display name    gt   nullable            description    gt   nullable              Thank you

User · Answer

You can try this  protected  rules update          email address    gt   required email unique users email address     this- gt id       first name    gt   quot required quot        last name    gt   quot required quot        password    gt   quot required min 6 same password confirm quot        password confirm    gt   quot required min 6 same password quot        password current    gt   quot required min 6 quot

User · Answer

Since you will want to ignore the record you are updating when performing an update  you will want to use ignore as mentioned by some others  But I prefer to receive an instance of the User rather then just an ID  This method will also allow you to do the same for other models  Controller      public function update UserRequest  request  User  user                 user- gt update  request- gt all              return back            UserRequest      public function rules                 return                email    gt                     required                    Illuminate Validation Rule  unique  users  - gt ignoreModel  this- gt route  user                                       update  use ignoreModel in stead of ignore

User · Answer

This is what I ended up doing  I m sure there is a more efficient way of doing this but this is what i came up with   Model User php  protected  rules          email address    gt   sometimes required email unique users email address     id          Model BaseModel php  public function validate  data   id   null             rules    this- gt  rules string          let s loop through and explode the validation rules      foreach  rules as  keys   gt   value              validations   explode       value            foreach  validations as  key  gt  value                    Seearch for    id   and replace it with  id              validations  key    str replace     id      id   value                        Let s create the pipe seperator           implode   implode       validations            rules  keys     implode                           I pass the  user id to the validation in the controller  Controller UserController php  public function update  id                     user   User  find  user id        if  user- gt validate  formRequest   user id             validation succcess

User · Answer

Very easy to do it   Write it at your controller  this- gt validate  request         email   gt   required  Rule  unique  yourTableName  - gt ignore  request- gt id       Note   Rule  unique  yourTableName  - gt ignore  idParameter    here  idParameter you can receive from get url also you can get it from hidden field  Most important is don t forget to import Rule at the top

User · Answer

While updating any Existing Data Write validator as following    email    gt    required   email   Rule  unique  users  - gt ignore  user- gt id     This will skip ignore existing user s id s unique value matching for the specific column

User · Answer

Just a side note  most answers to this question talk about email address while in Laravel s inbuilt auth system  the email field name is just email  Here is an example how you can validate a unique field  i e  an email on the update   In a Form Request  you do like this   public function rules       return          email    gt   required email unique users email    this- gt user- gt id           Or if you are validating your data in a controller directly   public function update Request  request  User  user       request- gt validate          email    gt   required email unique users email    user- gt id            Update  If you are updating the signed in user and aren t injecting the User model into your route  you may encounter undefined property when accessing id on  this- gt user  In that case  use   public function rules               return              email    gt   required email unique users email    this- gt user  - gt id                   A more elegant way since Laravel 5 7 is   public function rules         return            email    gt    required    email    Illuminate Validation Rule  unique  users  - gt ignore  this- gt user  - gt id              P S  I have added some other rules  i e  required and email  in order to make this example clear for newbies

User · Answer

Test below code    validator   Validator  make              array                 E-mail   gt  request  email                                array                 E-mail    gt   required email unique users email    request  id

User · Answer

You can also use model classpath  if you don t want to hard code the table name   function rules        return            email    gt    required   string            Rule  unique User  class  email  - gt ignore  this- gt id              Here  this- id is either 0 or the record Id to be updated

User · Answer

If i understand what you want       email      required email unique users email address     id       In model update method  for exemple  should receive the  id with parameter   Sorry my bad english

User · Answer

an even simpler solution tested with version 5 2  in your model      validator rules public static  rules   array               email address    gt   email required unique users id

User · Answer

From Laravel 5 7  this works great  use Illuminate Validation Rule   Validator  make  data         email    gt             required           Rule  unique  users  - gt ignore  user- gt id                Forcing A Unique Rule To Ignore A Given ID

User · Answer

Test below code    email    gt   required email unique users email address     id   ID    Where ID is the primary id of the table

User · Answer

Found the easiest way  working fine while I am using Laravel 5 2  public function rules       switch   this- gt method          case  PUT            rules                  name                     gt   required min 3                gender                   gt   required                email                    gt   required email unique users id  id                password                 gt   required min 5                password confirmation    gt   required min 5 same password                      break       default           rules                  name                     gt   required min 3                gender                   gt   required                email                    gt   required email unique users                password                 gt   required min 5                password confirmation    gt   required min 5 same password                      break     return  rules

User · Answer

Use for Laravel 6 0  use Illuminate Validation Rule   public function update Request  request   id                   Form validation          request- gt validate                category name      gt                      required                    max 255                    Rule  unique  categories  - gt ignore  id

User · Answer

One simple solution   In your Model  protected  rules          email address    gt   sometimes required email unique users               In your Controller  action update       rules   User   rules   rules  email address      rules  email address       id      id   validationCertificate    Validator  make  input   rules

User · Answer

There is an elegant way to do this  If you are using Resource Controllers  your link to edit your record will look like this       users  user  edit OR  users 1 edit   And in your UserRequest  the rule should be like this    public function rules         return            name    gt                 required                unique users name      this- gt user                       Or if your link to edit your record look like this       users edit 1   You can try this also   public function rules         return            name    gt                 required                unique users name      this- gt id

User · Answer

Here is the solution   For Update   public function controllerName Request  request   id           this- gt validate  request             form field name    gt   required unique db table name db table column name    id                 the rest code     That s it  Happy Coding

User · Answer

I read the previous post  but none approach the real problem  We need use the rule unique to apply on add and edit case  I use this rule on edit and add case and work fine   In my solution i use rule function from Request Class     I sent id over hidden input form field on edit form   On the Rule function  we find by unique column and get the record    Now evaluate the situation  If exist record and id are equal the unique must be not activate  that s mean edit record     On the code   public function rules                             user   User  where  email    this- gt email - gt first                        this- gt id   isset  this- gt id     this- gt id   null           emailRule      user    null   amp  amp    user- gt id     this- gt id      required email rfc dns max 255     required unique users email rfc dns max 255                              return                               email               gt    emailRule

User · Answer

My solution    rules    user- gt isDirty  email      User   rules   array except  User   rules   email      Then in validation    validator    Validator  make  Input  all     rules   User   messages     The logic is if the email address in the form is different  we need to validated it  if the email hasn t changed  we don t need to validate  so remove that rule from validation

User · Answer

For unique rule in the controller - which obviously will be different for the store method and the update method  I usually make a function within the controller for rules which will return an array of rules   protected function rules  request         commonRules              first name    gt   required            last name    gt   required            password    gt   required min 6 same password confirm            password confirm    gt   required min 6 same password            password current    gt   required min 6               uniqueRules    request- gt id              update             email address    gt    required    email    unique users email     request- gt get  id                  store             email address    gt    required    email    unique users email           return array merge  commonRules   uinqueRules       Then in the respective store and update methods   validatedData    request- gt validate  this- gt rules  request      This saves from defining two different rule sets for store and update methods   If you can afford to compromise a bit on readability  it can also be   protected function rules  request        return            first name    gt   required            last name    gt   required            password    gt   required min 6 same password confirm            password confirm    gt   required min 6 same password            password current    gt   required min 6            email address    gt    required    email    unique users email     request- gt id    null

User · Answer

The Best Option is here try just once no need more code when unique validation on updating data  email    gt   unique users email address      userId   hereemailis field name and users is table name and email address is table attribute name which you want unique and  userid is updating row id

User · Answer

i would solve that by doing something like this  public function rules         return             name    gt                required min 2 max 255 unique courses name    Request  get  id               Where you get the id from the request and pass it on the rule

User · Answer

After researching a lot on this laravel validation topic including unique column  finally got the best approach  Please have a look In your controller     use Illuminate Http Request      use Illuminate Support Facades Validator       class UserController extends Controller                public function saveUser Request  request                    validator   Validator  make  request- gt all   User  rules  request- gt get  id    User   messages                   if  validator- gt fails                         return redirect  - gt back  - gt withErrors  validator - gt withInput                                           saveUser method can be called for add update user record  In you model class User extends Model       public static function rules  id   null                return                email address    gt   required email unique users email address    id               first name    gt   quot required quot                last name    gt   quot required quot                password    gt   quot required min 6 same password confirm quot                password confirm    gt   quot required min 6 same password quot                password current    gt   quot required min 6 quot                       public static  messages              email address required    gt   Please enter email             email address email    gt   Invalid email             email address unique    gt   Email already exist

[php] Laravel: Validation unique on update

Examples related to php

Examples related to validation

Examples related to laravel

Examples related to laravel-4