更新期间验证用户电子邮件字段

Question

I am new to laravel.

Currently, I'm working on user table CRUD operations. I've no problems while create, delete and read. I want to update user email column with validation.

When I've made email field as unique, no problem while creating since it will work perfectly with no duplicate email fields.

Validation:

$this->validate($request,[
    'email' => 'required|unique:users'
],
$messages = [
        'required' => 'The :attribute field is required.',
        'unique' => 'The :attribute must be unique',
    ]
);

But, While updating the record, if email field is not changed and other changed, validation fails due to unique violation because of email is checked with record it self.

I want uniqueness in email field even if user email is changed.

Can anyone give me some suggestion to get out of this problem ?

Answer 1

What you want to do is ignore a specific user ID during the validation process. By passing an ID to ignore to your unique rule, Laravel will exclude that user when checking the uniqueness of the email address.

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

The format of the rule is:

unique:table,column,except,idColumn

And in your scenario you can use it like this:

[
    'email' => 'required|unique:users,email,' . $userId
]

Where the $userId in this scenario is the ID of the user you're updating. Usually, this will be present in your request so you should be able to access it from there. If the column you want to ignore is different from id you can add that as the next part of your rule:

'email' => 'required|unique:users,email,' . $userId . ',other_column'

An alternative, and more readable syntax for the unique rule in versions 5.3 and above is:

Rule::unique('users')->ignore($userId),