how to validate unique combination of two fields in Laravel?

Question

I am trying to add validation constraints on the registration of a new user and I want the combination of two fields be unique in the database. The error that i get is from the database saying i have a integrity constraint violation. the table I have is called users and the fields i want to have unique combination are called ssn and lastfour.

I added the line $table->unique(array('ssn','lastfour')); in the user migration and I also added some fields in the registration which work fine and the database is ok. I tried the solution in a similar question posted about 9 months ago Laravel unique validation on multiple columns but i get undefined variable on line "Rule::unique('servers')->where(function ($query) use($ssn,$lastfour)"

protected function validator(array $data)
{
    return Validator::make($data, [
        'name' => ['required', 'string', 'max:255'],
        'lastname' => ['required', 'string', 'max:255'],
        'username' => ['required', 'string', 'max:255', 'unique:users'],
        'ssn' => ['required', 'string', 'regex:/^[0-9]*$/','max:8', 'min:8'],
        'lastfour' => ['required', 'string', 'regex:/^[0-9]*$/','max:4', 'min:4'],
        'email' => ['required', 'string', 'email', 'max:255', 'unique:users'],
        'password' => ['required', 'string', 'min:6', 'confirmed'],
    ]);
}

i tried the following code

'lastfour' => ['required', 'string', 'regex:/^[0-9]*$/','max:4', 'min:4', 
                        Rule::unique('users')->where(function ($query) use 
                        ($ssn, $lastfour){
                            return $query->where('ssn', $ssn)
                            ->where('lastfour', $lastfour);
                        })
        ],

You said you tried `Rule::unique` but I don't see it in the code you've shared — apokryfos, Feb 18 '19 at 15:51

score 2 · Accepted Answer · answered Feb 18 '19 at 15:56

$ssn and $lastfour don't seem to be defined anywhere. You can try the following instead:

protected function validator(array $data)
{
    $uniqueRule =  Rule::unique('users')->where(function ($query) use 
                    ($data){
                        return $query->where('ssn', $data['ssn']??'')
                        ->where('lastfour', $data['lastfour']??'');
                    });

    return Validator::make($data, [
        'name' => ['required', 'string', 'max:255'],
        'lastname' => ['required', 'string', 'max:255'],
        'username' => ['required', 'string', 'max:255', 'unique:users'],
        'ssn' => ['required', 'string', 'regex:/^[0-9]*$/','max:8', 'min:8',  $uniqueRule ],
        'lastfour' => ['required', 'string', 'regex:/^[0-9]*$/','max:4', 'min:4'],
        'email' => ['required', 'string', 'email', 'max:255', 'unique:users'],
        'password' => ['required', 'string', 'min:6', 'confirmed'],
    ]);
}

score 1 · Answer 2 · answered Sep 19 '19 at 06:26

1

You can also use two querys

$uniqueRule =  Rule::unique('users')->where(function ($query) use ($data){
    $query->where('ssn', $data['ssn']);
    $query->where('lastfour', $data['lastfour']);
});

answered Sep 19 '19 at 06:26

Cui Mingda

803
1
6
15

how to validate unique combination of two fields in Laravel?

2 Answers2