Laravel update model with unique validation rule for attribute

Question

I have a laravel User model which has a unique validation rule on username and email  In my Repository  when I update the model  I revalidate the fields  so as to not  have a problem with required rule validation   public function update  id   data         user    this- gt findById  id        user- gt fill  data        this- gt validate  user- gt toArray          user- gt save        return  user      This fails in testing with   ValidationException    username    The username has already been taken     email    The email has already been taken       Is there a way of fixing this elegantly

User · Accepted Answer

Append the id of the instance currently being updated to the validator    Pass the id of your instance to ignore the unique validator  In the validator  use a parameter to detect if you are updating or creating the resource    If updating  force the unique rule to ignore a given id     rules  email    gt   unique users email address      userId    If creating  proceed as usual     rules  email    gt   unique users email address

User · Answer

Unique Validation With Different Column ID In Laravel   UserEmail   gt  required email unique users UserEmail  userID UserID

User · Answer

For a custom FormRequest and Laravel 5 7  you can get the id of your updated model like this   public function rules                 return                name    gt   required min 5 max 255 unique schools name    Request  instance  - gt id

User · Answer

I have BaseModel class  so I needed something more generic     app BaseModel php public function rules         return  rules         public function isValid  id               validation   Validator  make  this- gt attributes   this- gt rules  id         if  validation- gt passes    return true       this- gt errors    validation- gt messages        return false      In user class let s suppose I need only email and name to be validated     app User php   User extends BaseModel public function rules  id              rules                      name    gt   required min 3                    email    gt   required email unique users email                    password    gt   required alpha num between 6 12                    password confirmation    gt   same password required alpha num between 6 12                      if  empty  id                  rules  email        id           unset  rules  password             unset  rules  password confirmation                return  rules      I tested this with phpunit and works fine      tests models UserTest php  public function testUpdateExistingUser          user   User  find 1        result    user- gt id       this- gt assertEquals true   result        user- gt name    test update        user- gt email    ddd test si        user- gt save          this- gt assertTrue  user- gt isValid  user- gt id    Expected to pass         I hope will help someone  even if for getting a better idea  Thanks for sharing yours as well   tested on Laravel 5 0

User · Answer

or what you could do in your Form Request is  for Laravel 5 3    public function rules                 return                 email    gt   required email unique users email    this- gt user    here user is users  user  from resource s route url                           i ve done it in Laravel 5 6 and it worked

User · Answer

I am calling different validation classes for Store and Update  In my case I don t want to update every fields  so I have baseRules for common fields for Create and Edit  Add extra validation classes for each  I hope my example is helpful  I am using Laravel 4   Model    public static  baseRules   array       first name    gt   required        last name     gt   required        description    gt   required        description2    gt   required        phone     gt   required   numeric        video link     gt   required   url        video title     gt   required   max 87        video description     gt   required        sex    gt   in M F B        title     gt   required      public static function validate  data         createRule   static   baseRules       createRule  email      required   email   unique musicians        createRule  band      required   unique musicians        createRule  style      required        createRule  instrument      required        createRule  myFile      required   image        return Validator  make  data   createRule      public static function validateUpdate  data   id         updateRule   static   baseRules       updateRule  email      required   email   unique musicians email      id       updateRule  band      required   unique musicians band      id      return Validator  make  data   updateRule       Controller  Store method   public function store          myInput   Input  all         validation   Musician  validate  myInput       if  validation- gt fails                   key    errorMusician           return Redirect  to  musician create           - gt withErrors  validation   musicain           - gt withInput              Update method   public function update  id          myInput   Input  all         validation   Musician  validateUpdate  myInput   id       if  validation- gt fails                   key    error            message    validation- gt messages            return Redirect  to  musician      id          - gt withErrors  validation   musicain           - gt withInput

User · Answer

If you have another column which is being used as foreign key or index then you have to specify that as well in the rule like this    phone    gt                     required                    phone                   Rule  unique  shops  - gt ignore  shopId   id  - gt where function   query                         query- gt where  user id   Auth  id

User · Answer

You can trying code bellow  return        email    gt   required email max 255 unique users email     this- gt get  id         username    gt   required alpha dash max 50 unique users username    this- gt get  id         password    gt   required min 6        confirm-password    gt   required same password

User · Answer

Laravel 5 compatible and generic way   I just had the same problem and solved it in a generic way  If you create an item it uses the default rules  if you update an item it will check your rules for   unique and insert an exclude automatically  if needed    Create a BaseModel class and let all your models inherit from it    lt  php namespace App   use Illuminate Database Eloquent Model   class BaseModel extends Model                   The validation rules for this model                var array             protected static  rules                       Return model validation rules                return array             public static function getRules             return static   rules                        Return model validation rules for an update        Add exception to  unique validations where necessary        That means  enforce unique if a unique field changed         But relax unique if a unique field did not change                return array              public function getUpdateRules              updateRules               foreach self  getRules   as  field   gt   rule                 newRule                      Split rule up into parts              ruleParts   explode      rule                  Check each part for unique             foreach  ruleParts as  part                    if strpos  part  unique        0                           Check if field was unchanged                     if      this- gt isDirty  field                                Field did not change  make exception for this model                          part    part          field          this- gt getAttribute  field           field                                                             All other go directly back to the newRule Array                  newRule      part                               Add newRule to updateRules              updateRules  field    join       newRule                      return  updateRules                You now define your rules in your model like you are used to   protected static  rules          name    gt   required alpha unique roles        displayName    gt   required alpha dash        permissions    gt   array        And validate them in your Controller  If the model does not validate  it will automatically redirect back to the form with the corresponding validation errors  If no validation errors occurred it will continue to execute the code after it   public function postCreate Request  request           Validate      this- gt validate  request  Role  getRules            Validation successful - gt  create role     Role  create  request- gt all         return redirect  - gt route  admin role index       public function postEdit Request  request  Role  role           Validate      this- gt validate  request   role- gt getUpdateRules            Validation successful - gt  update role      role- gt update  request- gt input         return redirect  - gt route  admin role index        That s it     Note that on creation we call Role  getRules   and on edit we call  role- gt getUpdateRules

User · Answer

public static function custom validation          rules   array  title    gt   required    description     gt   required   status    gt   required          messages   array  title required    gt   The Title must be required   status required    gt   The Status must be required   description required    gt   The Description must be required          validation   Validator  make Input  all     rules   messages       return  validation

User · Answer

I had the same problem  What I ve done  add in my view hidden field with id of a model and in validator check the unique  only if I ve get some id from view    this- gt validate           request                         index          gt  implode        required    request- gt input  id           unique members                  name           gt   required                surname        gt   required

User · Answer

email    gt         required       Rule  exists  staff  - gt where function   query             query- gt where  account id   1                email    gt         required       Rule  unique  users  - gt ignore  user- gt id - gt where function   query             query- gt where  account id   1

User · Answer

public function rules         if   this- gt method       PUT              post id    this- gt segment 3            rules                  post title    gt   required unique posts post title      post id                  else            rules                  post title    gt   required unique posts post title                       return  rules

User · Answer

Working within my question   public function update  id   data         user    this- gt findById  id        user- gt fill  data        this- gt validate  user- gt toArray     id        user- gt save        return  user      public function validate  data   id null         rules   User   rules      if   id     null             rules  username         id            rules  email         id              validation   Validator  make  data   rules       if   validation- gt fails              throw new ValidationException  validation             return true      is what I did  based on the accepted answer above   EDIT  With Form Requests  everything is made simpler    lt  php namespace App Http Requests   class UpdateUserRequest extends Request                  Determine if the user is authorized to make this request                 return bool             public function authorize                 return true                        Get the validation rules that apply to the request                 return array             public function rules                 return                name    gt   required unique users username    this- gt id               email    gt   required unique users email    this- gt id                       You just need to pass the UpdateUserRequest to your update method  and be sure to POST the model id

User · Answer

Laravel 5 8 simple and easy  you can do this all in a form request with quite nicely        first make a field by which you can pass the id  invisible  in the normal edit form  i e       lt div class  form-group d-none  gt         lt input class  form-control  name  id  type  text  value      example- gt id      gt    lt  div gt        Then be sure to add the Rule class to your form request like so   use Illuminate Validation Rule        Add the Unique rule ignoring the current id like so   public function rules         return              example field 1     gt    required   Rule  unique  example table  - gt ignore  this- gt id               example field 2     gt   required                 Finally type hint the form request in the update method the same as you would the store method  like so     public function update ExampleValidation  request  Examle  example         example- gt example field 1    request- gt example field 1               example- gt save          message    The aircraft was successully updated         return  back  - gt with  status    message         This way you won t repeat code unnecessarily  -

User · Answer

Another elegant way     In your model  create a static function   public static function rules   id 0   merge           return array merge                         username     gt   required min 3 max 12 unique users username      id      id                      email        gt   required email unique member     id     id  id                      firstname    gt   required min 2                lastname     gt   required min 2                                        merge       Validation on create    validator   Validator  make  input  User  rules       Validation on update    validator   Validator  make  input  User  rules  id      Validation on update  with some additional rules    extend rules          password          gt   required min 6 same password again        password again    gt   required      validator   Validator  make  input  User  rules  id   extend rules      Nice

User · Answer

For anyone using a Form request  In my case i tried all of the following none of them worked    this- gt id   this- gt user- gt id   this- gt user   It was because i could not access the model  id nor the  id directly    So i got the  id from a query using the same unique field i am trying to validate              Get the validation rules that apply to the request         return array     public function rules          id   YourModel  where  unique field   this- gt request- gt get  unique field   - gt value  id        return            unique field    gt    rule1   rule2  Rule  unique  yourTable  - gt ignore  id

User · Answer

A simple example for roles update       model User php class User extends Eloquent        public static function rolesUpdate  id                return array               username                 gt   required alpha dash unique users username      id               email                    gt   required email unique users email     id               password                 gt   between 4 11                                     controllers UsersControllers php class UsersController extends Controller        public function update  id                 user   User  find  id            validation   Validator  make  input  User  rolesUpdate  user- gt id             if   validation- gt passes                           user- gt update  input                return Redirect  route  admin user show    id                      return Redirect  route  admin user edit    id - gt withInput  - gt withErrors  validation

[php] Laravel update model with unique validation rule for attribute

Examples related to php

Examples related to laravel

Examples related to validation

Examples related to eloquent