Verify duplicate values on the array in Laravel5.7

Question

I want to verify if email address in my database is duplicate or not? Here is my codes :

'users.*.email'=> ['required','unique:users','email']

and this is my Controller

UsersController

public function MassStore(MassStoreUserRequest $request)
{

    $inputs = $request->get('users');
    return redirect()->route('admin.users.index');
}

and this is my POST data (post data($inputs) will send like as below) :

'users' => [
    [
        'name' => 'Ken Tse',
        'email' => '[email protected]',
        'password' => 'ken12ken34ken',
    ],
    [
        'name' => 'Ken Tse',
        'email' => '[email protected]',   //duplicate, so need trigger error
        'password' => 'ken12ken34ken',
    ],
]

and this is error I get :

[2019-12-10 15:51:16] local.DEBUG: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '[email protected]' for key 'users_email_unique'

MassStoreUserRequest

public function rules()
{
    return [
        'users'                => ['required','array'],
        'users.*.name'         => ['required'],
        'users.*.email'        => ['required','unique:users','email'],
        'users.*.password'     => ['required','min:8']
    ];
}

Rwd · Accepted Answer · 2019-12-10 07:13:22Z

3

To prevent duplicate data being submitted in an array you can use the distinct rule:

return [
    'users'            => ['required', 'array'],
    'users.*.name'     => ['required'],
    'users.*.email'    => ['required', 'email', 'distinct', 'unique:users'],
    'users.*.password' => ['required', 'min:8'],
];

answered Dec 10, 2019 at 7:13

Rwd

35.3k7 gold badges71 silver badges85 bronze badges

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

Comments

PHP Geek · Accepted Answer · 2019-12-10 07:10:22Z

1

Please try to use like this:

$rules = array(
            "name" => "required",
            "email" => "required|email|unique:users",
             "password" => "required|min:6",

        );

answered Dec 10, 2019 at 7:10

PHP Geek

4,0632 gold badges19 silver badges32 bronze badges

Comments

user10678889 · Accepted Answer · 2019-12-10 08:06:31Z

0

Just use the distinct with your email keyword such as :

public function rules()
{
    return [
        'users'                => ['required','array'],
        'users.*.name'         => ['required'],
        'users.*.email'        => ['required','unique:users','email', 'distinct'],
        'users.*.password'     => ['required','min:8']
    ];
}

answered Dec 10, 2019 at 8:06

user10678889

Collectives™ on Stack Overflow

Verify duplicate values on the array in Laravel5.7

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related