Laravel Unique validation on checking multiple fields

Question

I have subject tables and fields are standard_id, stream_id, medium_id, board_id, subject_name and many others.

I want to add Rule unique for subject_name which is unique for standard_id, stream_id, medium_id, board_id fields.

$validator = Validator::make( $inputs, 
            [
                'v_name' => [
                        'required',
                        Rule::unique( 'tbl_subject' )->ignore( $id, 'id' ),
                    ],
            ],
            [
                'v_name.required' => 'Name is required',
                'unique' => 'Name address already exits.',
            ]
        );

Example

standard_id, stream_id, medium_id, board_id subject_name

1             2            1            3          A
3             2            4            1          B
1             3            1            4          c

Validation like if subject_name "A" unique for 1, 2, 1, 3. B unique for 3, 2, 4, 1. But subject_name "A" not unique for 2,2,1,3 and so on..

Can you show what you have tried so far and how it doesn't match what you need. — Nigel Ren
– Nigel Ren, Commented Jul 18, 2020 at 7:09
So for example it would fail if you got a subject_name of A for the 1, 2, 1, 3 combination of inputs? Are those inputs in your request as well? Try implementing something like what is mentioned in Adding additional where clauses — apokryfos
– apokryfos, Commented Jul 18, 2020 at 7:13
@AmitSenjaliya Can you please share the code where you are validating — Kurt Friars
– Kurt Friars, Commented Jul 18, 2020 at 9:26

Kurt Friars · Accepted Answer · 2020-07-18 14:43:26Z

4

*** After discussion with OP ***

The question should have stated that they are trying to insert a single record, and want to verify the uniqueness against the database. One way to do this is via a custom rule, like so:

class UniqueSubject implements Rule
{
    private $keys;

    public function __construct(array $keys) {
        $this->keys = $keys;
    }

    /**
     * Determine if the validation rule passes.
     *
     * @param  string  $attribute
     * @param  mixed  $value
     * @return bool
     */
    public function passes($attribute, $value)
    {
        return ! Subject::where($this->keys)->where('subject_name', $value)->exists();
    }

    /**
     * Get the validation error message.
     *
     * @return string
     */
    public function message()
    {
        return 'The Subject Name must be unique for the given standard, stream, medium and board.';
    }
}

Then you can use the validation in your rules like:

$keys = $request->only('i_standard_id', 'i_stream_id', 'i_board_id', 'i_medium_id');

$validator = Validator::make( $inputs, [
    ...
    'subject_name' => [
        'required',
        'string',
        new UniqueSubject($keys)
    ],
    ...
]);

edited Jul 18, 2020 at 14:43

answered Jul 18, 2020 at 8:22

Kurt Friars

3,7742 gold badges18 silver badges29 bronze badges

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

1 Comment

Amit Senjaliya Over a year ago

Let us continue this discussion in chat.

Collectives™ on Stack Overflow

Laravel Unique validation on checking multiple fields

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related