How to validate combined uniqueness of two fields in Laravel 5.6?

Question

Here is my validation rules:-

$validationCondition    = array(
                            'fname'     => 'required|min:2',
                            'lname'     => 'required|min:2',
                            'email'     => 'required|email|unique:users,email',
                            'isd'       => 'required|unique:users,isd',
                            'mobile'    => 'required',
                            'password'  => 'required'
                        );
$validationMessages     = array(
                            'fname.required'    => 'Please provide first name',
                            'fname.min'         => 'First name should be atleast 3 characters long',

                            'lname.required'    => 'Please provide last name',
                            'lname.min'         => 'Last name should be atleast 3 characters long',

                            'email.required'    => 'Please provide email',
                            'email.email'       => 'Please provide a valid email id',
                            'email.unique'      => 'This email id has already been registered. Choose any other valid email id.',

                            'isd.required'      => 'The city name should be atleast 3 characters long',

                            'mobile.required'   => 'Please provide mobile number',

                            'password.required' => 'Please provide password'
                        );

In the users table, both the isd and mobile are to be checked to ensure whether the contact number is unique.

How can I check that? I know how to check uniqueness of a single field, but don't know how to check combined value as unique.

I don't think there's a way to do this. But you can use this package to achieve your end goal: github.com/felixkiss/uniquewith-validator. You can also try taking a stab at setting up some custom validators. laravel.com/docs/5.6/validation#custom-validation-rules — Kevin Pimentel
– Kevin Pimentel, Commented Jul 27, 2018 at 12:38

Jinal Somaiya · Accepted Answer · 2018-07-27 12:49:29Z

11

$validationCondition = array(
    ...
    'isd' => 'required',
    'mobile' => 'required|unique:users,mobile,NULL,id,isd,' . $request->isd,
    ...
);

The meaning of that unique rule for mobile will be: "value of mobile must be unique among all existing users that have isd of the same value that came in request".

$request here is the instance of incoming request that you are validating (obviously).

edited Jul 27, 2018 at 12:49

Jinal Somaiya

1,99117 silver badges31 bronze badges

answered Jul 27, 2018 at 12:43

d3jn

1,4103 gold badges15 silver badges23 bronze badges

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

2 Comments

Saswat Over a year ago

perfect! That was a charm. What does the NULL do?

d3jn Over a year ago

NULL,id section is responsible for ignore arguments of unique rule. Those are just default values for those arguments since we are not using them, but need to get to where arguments of unique rule. If you specify your model id instead of NULL then unique rule will ignore row that has this id (useful when updating existing row, so that his current values aren't included in uniqueness check). You can read more about it here

Niklesh Raut · Accepted Answer · 2022-12-26 13:11:27Z

1

You can use like below

'mobile'  => 'required|unique:users,mobile,NULL,id,mobile,isd'

Get more details from doc

edited Dec 26, 2022 at 13:11

answered Jul 27, 2018 at 12:44

Niklesh Raut

34.9k17 gold badges82 silver badges112 bronze badges

1 Comment

wruckie Over a year ago

your link is now dead, think this is the current replacement laravel.com/docs/9.x/validation#rule-unique

Collectives™ on Stack Overflow

How to validate combined uniqueness of two fields in Laravel 5.6?

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related