Laravel validation on two columns

Question

I have contacts table with field email and alteranate_email. While adding new contact i want to check email address should not present in either email or alteranate_email. For Example, There is contact present with alteranate_email = '[email protected]'. When I tried to add new contact with email = '[email protected]', it allows me to add new contact.

I have tried below code but its not working.

 $validator = Validator::make($request->all(), [
            'email' => ['nullable', 'email',
                 Rule::unique('contacts')->where(function ($query) use ($request) {
                     return $query->where('email', $request->email)->orWhere('alteranate_email', $request->email);
                 }),
            ],

        ]);

'email' => 'nullable|email|unique: contacts.email,alteranate_email' — Bohdan Petrenko
– Bohdan Petrenko, Commented Mar 27, 2020 at 7:53
it allows me to add new contact even if email address present in alternate email address field. — Sangita Kendre
– Sangita Kendre, Commented Mar 27, 2020 at 8:27
remove whitespace between unique: and contacts - 'email' => 'nullable|email|unique:contacts.email,alteranate_email' — Bohdan Petrenko
– Bohdan Petrenko, Commented Mar 27, 2020 at 8:39

tempra · Accepted Answer · 2020-03-27 09:32:05Z

1

You try to use two unique instead of making new rule. Try these one line solution below.

'email' => 'nullable|email|unique:contacts,email|unique:contacts,alternate_email'

answered Mar 27, 2020 at 9:32

tempra

2,3914 gold badges19 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Laravel validation on two columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related