Laravel validation request from

Question

I have laravel validation request form, like this:

public function rules()
{
    $id = $this->input('wlId');

    return [
        'id'          => ['sometimes ', 'integer'],
        'domain_name'   => ['required', 'string', 'unique:white_label,domain_name' . $id],
        'disabled'      => ['required', 'boolean']
    ];
}

I set id for ignore my entry during the unique check, but if id is't an integer but for example a string then I will get sql error from validator.

How can I stop validation if the id field fails validation?

because you specified that should be integer: 'id' => ['sometimes ', 'integer'], That means that should be only integer, but if you want to be an integer you should use 'numeric' — Marinario Agalliu
– Marinario Agalliu, Commented Oct 30, 2020 at 16:37

cednore · Accepted Answer · 2020-10-30 17:22:08Z

1

You are going to ignore a certain value while using unique validation rule. Consider the following snippet;

use Illuminate\Validation\Rule;

// ...

public function rules() {
    $id = $this->input('wlId');

    return [
        'id' => ['sometimes ', 'integer'],
        'domain_name' => [
            'required',
            'string',
            Rule::unique('white_label', 'domain_name')->ignore($id)
        ],
        'disabled' => ['required', 'boolean']
    ];
}

For more details, see this link; https://laravel.com/docs/8.x/validation#rule-unique

answered Oct 30, 2020 at 17:22

cednore

8856 silver badges21 bronze badges

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

1 Comment

MTakumi Over a year ago

It's the same like in my example. If no id field is passed you will get sql error. Since the validator will try to get the domain name from the white_label table by the id

RazaUsman_k · Accepted Answer · 2020-10-30 17:56:27Z

0

As mentioned in the documentation you can use bail rule

Sometimes you may wish to stop running validation rules on an attribute after the first validation failure. To do so, assign the bail rule to the attribute

    $request->validate([
    'title' => 'bail|required|unique:posts|max:255',
    'body' => 'required',
    ]);

In this example, if the unique rule on the title attribute fails, the max rule will not be checked. Rules will be validated in the order they are assigned.

answered Oct 30, 2020 at 17:56

RazaUsman_k

7047 silver badges22 bronze badges

1 Comment

MTakumi Over a year ago

Bail to stop my validation of a certain field, but further validation will still go. In your example. If the title field is not passed, then unique: posts will no longer be validated, but the body field will still be validated. I want the body field not to be validated in case of a failed title field validation

Collectives™ on Stack Overflow

Laravel validation request from

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related