Laravel Validation Unique Rule On Multiple Columns

Question

I have a users table and two columns that are: email and phone. In my register and login controller, I wanna make a field unique in both email and phone columns.

$data = request()->validate([
   'login' => ['required', 'string', 'email', 'max:255', 'unique:users,email'],
   'password' => ['required', 'string', 'min:8', 'confirmed'],
]);

This is my code and it only checks email column to ensure the value of login field doesn't exist there. How can I change this rule to check both email and phone columns?

I finished up making custom validation rule for this use case — Ali Raghebi, Nov 24 '20 at 07:50

score 1 · Accepted Answer · edited Oct 29 '20 at 20:40

1

Just make another ‌‌‌‌‌rule‌‌‌‌‌‌‌:‌‌‌‌‌‌‌‌‌

$data = request()->validate([
   'login' => ['required', 'string', 'email', 'max:255', 'unique:users,email','unique:users,phone'],
   'password' => ['required', 'string', 'min:8', 'confirmed'],
]);

edited Oct 29 '20 at 20:40

sajad abbasi

1,988
2
22
43

answered Oct 29 '20 at 15:48

STA

30,729
8
45
59

1

But that produces an unnecessary second query, wouldn't it? – Dan Oct 29 '20 at 15:52
@Dan I think if you pass the value as an array, then it will do a second query too – STA Oct 29 '20 at 16:04

Laravel Validation Unique Rule On Multiple Columns

1 Answers1