Laravel : Unique validation with different fields

Question

I have a table states and fields are id,country_id,state_code,state_name.Now I want to validate that same country doesn't have a same state_code and same state_name in a table.

I tried but it's not working.

In my Controller :

    $validator = State::validator($request->all(), $id); 
    if ($validator->fails()) {
        return redirect()->back()
            ->withErrors($validator->getMessageBag())
            ->withInput($request->all());
    }

Here is my validation function in model :

protected function validator(array $data, $id)
{
    return Validator::make($data, [
        'country_id'               => 'required',
        'state_code'               => 'required',
        'state_name'               => 'required',
    ]);
}

How can I solved this without custom validation ?

For a little clarification; do you need a unique validation rule that checks the uniqueness of a combination of state_code and state_name? I would think that state_code would be unique enough on its own, and you shouldn't have to worry about state_name. — Tim Lewis
– Tim Lewis, Commented Sep 18, 2019 at 14:33
country Romania,state Gorj has same code GJ for Gujarat state — Javed
– Javed, Commented Sep 18, 2019 at 14:36
Ah, I see; good example. In that case, consider something like a slug column, which is a lower-cased, - separated string of "unique" parts, like ro-gj-gorj and ro-gj-gurarat; constructed from country_code, state_code, state_name, and check uniqueness of that. — Tim Lewis
– Tim Lewis, Commented Sep 18, 2019 at 14:40

guttume · Accepted Answer · 2019-09-18 14:21:07Z

1

First of all, your validation rules are only checking if these fields are present in the request. There is no validation happening for a value exists in database. First of all, you might wanna go through the documentation for the rule_exists. Secondly, you may have to update the query for this rule as per the documentation


use Illuminate\Validation\Rule;

Validator::make($data, [
    'email' => [
        'required',
        Rule::exists('staff')->where(function ($query) {
            $query->where('account_id', 1);
        }),
    ],
]);

Here you can pass additional query parameters.

answered Sep 18, 2019 at 14:21

guttume

2861 silver badge7 bronze badges

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

2 Comments

Javed Over a year ago

of-course i know that it is checking only the required field, As i don't want to confuse with my code.

guttume Over a year ago

so did you try rule_exists with your custom query?

Leo · Accepted Answer · 2019-09-18 14:28:26Z

0

You do not need a custom validation for that one, laravel has a unique column validation

$this->validate($request, [
    'country_id' => 'required',
    'state_code' => 'required|unique:states,state_name',
    'state_name' => 'required|unique:states,state_code',
]);

This way you know for sure that column values in state_code will be unique compare to state_name for more check the docs

answered Sep 18, 2019 at 14:28

Leo

7,4105 gold badges28 silver badges48 bronze badges

Collectives™ on Stack Overflow

Laravel : Unique validation with different fields

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related