Laravel validation throws error on updating same unique value

Question

I have a form which has an input name. I want to update a database table through that form. The only condition is, the name must be unique. So this is what I did for validation in the backend:

$this->validate($request, [
    'name' => 'required|unique:myTableName'
]);

It's working as expected. It throws this error "The name has already been taken." when I try to enter a name which already exists in the database. But the problem I have with this is, when I'm updating the same entry from database without any change (I.E. I go to edit form, do nothing, update the form), it shows me the same error. In this case, I don't want the error as I'm updating the same value. How can I achieve this with laravel validation?

Does this answer your question? Laravel: Validation unique on update — katsarov
– katsarov, Commented Apr 27, 2021 at 9:34

A.A Noman · Accepted Answer · 2021-04-27 09:45:41Z

3

You have to use following code

$this->validate($request, [
    'name' => ['required', Rule::unique('myTableName')->ignore($yourVariable->id)],
]);

Add header section below code

use Illuminate\Validation\Rule;

More Details here

edited Apr 27, 2021 at 9:45

answered Apr 27, 2021 at 9:39

A.A Noman

5,2669 gold badges28 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

STA · Accepted Answer · 2021-04-27 09:46:40Z

1

You need to pass the table id, to ignore that field from validation

'name' => 'required|unique:myTableName,name,' . $table->id,

With custom Rule :

use Illuminate\Validation\Rule;

'name' => ['required', Rule::unique('myTableName', 'name')->ignore($table->id)],

edited Apr 27, 2021 at 9:46

answered Apr 27, 2021 at 9:34

STA

35.3k9 gold badges49 silver badges62 bronze badges

Collectives™ on Stack Overflow

Laravel validation throws error on updating same unique value

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related