Laravel ignore unique validation

Question

I have a products table and unique column, but when I try to update it fails and show me unique error message.I try to make something to ignore, but does not work.

 $attributes = $request->validate([
            'name' => 'required|min:3',
            'description' => 'nullable|min:3',
            'selling_price' => 'required|numeric',
            'purchase_price' => 'required|numeric',
            'quantity' => 'required|integer',
            'unit' => 'nullable',
            'stock_alert' => 'nullable|numeric',
            'unique_code' => "required|unique:products,unique_code,$product->id",
            'awb' => 'required|numeric'
        ]);

Thank you so much!

Store or update method? To make an update, take the id out of the quotation marks "required|unique:products,unique_code,". $product->id. To make store method, just required|unique:products — Rinho
– Rinho, Commented Jun 24, 2019 at 12:57

Jino Antony · Accepted Answer · 2019-06-24 12:59:47Z

2

You can ignore a field like this

use Illuminate\Validation\Rule;

 $attributes = $request->validate([
            'name' => 'required|min:3',
            'description' => 'nullable|min:3',
            'selling_price' => 'required|numeric',
            'purchase_price' => 'required|numeric',
            'quantity' => 'required|integer',
            'unit' => 'nullable',
            'stock_alert' => 'nullable|numeric',
            'unique_code' => [
                "required",
                Rule::unique('products', 'unique_cod')->ignore($product->id),
             ],
            'awb' => 'required|numeric'
        ]);

answered Jun 24, 2019 at 12:59

Jino Antony

3644 silver badges10 bronze badges

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

7 Comments

Ionut Paduraru Over a year ago

It still fails, and show me this error message.The unique code has already been taken.

Jino Antony Over a year ago

what is the primary key of products table ?

Ionut Paduraru Over a year ago

$table->bigIncrements('id');

Jino Antony Over a year ago

can you make sure $product->id is the id of the record you have been updating

Ionut Paduraru Over a year ago

I used dd to display and it's the correct id.. I dont know why is not working.I am using route-model binding.

|

Rinho · Accepted Answer · 2019-06-24 13:05:14Z

0

Ignoring it isn't the right way. You use a validation for some reason.

To make an update, just take the product id out of the quotation marks like this:

'unique_code' => 'required|unique:products,unique_code,'. $product->id,

answered Jun 24, 2019 at 13:05

Rinho

5843 silver badges8 bronze badges

3 Comments

Ionut Paduraru Over a year ago

It still fails, and show me this error message.The unique code has already been taken.

Ionut Paduraru Over a year ago

'unique_code' => 'required|unique:products,unique_code,' .$product->id,

Rinho Over a year ago

Get the id of the product you want to update, for example 1000, change the validation to 'unique_code' => 'required|unique:products,unique_code,1000', check if it fails with that exact product, if not, you are not passing the id correctly.

Collectives™ on Stack Overflow

Laravel ignore unique validation

2 Answers 2

7 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related