Laravel Unique Validation on Multiple Columns

Let’s discuss this example:

 

 'username' => [ 'required', Rule::unique('users') ->where('company_id', $this->company_id) ]

The code you provided is defining validation rules for the ‘username’ field in a Laravel application.

The first rule ‘required’ means that the field is mandatory and must have a value.

The second rule ‘Rule::unique’ is a dynamic rule that checks for uniqueness of the ‘username’ field in the ‘users’ table.

The ‘where’ method is used to specify additional conditions to be added to the query. In this case, the condition is that the ‘company_id’ column in the ‘users’ table should match the value of `$this->company_id`.

This means that the ‘username’ field must be unique within the context of the current company, as identified by the value of `$this->company_id`.

For example, if two users are being registered with the same username but different company ids, the validation will pass because the ‘username’ is unique in the context of each company. However, if two users are being registered with the same username and the same company id, the validation will fail because the ‘username’ is not unique in that context.

Overall, this validation rule helps to ensure that each user in the system has a unique username within the context of their company.

 

References: 

https://laravel.com/docs/10.x/validation#rule-unique 

https://www.itsolutionstuff.com/post/laravel-unique-validation-on-multiple-columns-exampleexample.html

Leave a Comment

Your email address will not be published. Required fields are marked *