Laravel validation check if a value in database equals either one of two values

Question

I have a user database table that stores user roles. I need to validate if the user is either one of two roles in that table. Normally I could use exists but in this case, I need to check between two values.

How do I create a custom validation to do this? (I've an existing CustomValidator class)

E.g.

protected function validateUserRole($attribute, $value) {
    return (bool) ;
}

Columns in User role table:

id | user_id | role_id

Laravel rules:

$rules = array(
    'user_id' => ?
);

Thanks!

how do I put in multiple clauses? e.g. where role_id =1 or role_id=2? — Lyon
– Lyon, Commented Mar 22, 2015 at 11:16

Julian Camilleri · Accepted Answer · 2015-03-22 11:20:55Z

0

ModelName::where('id', '=', 1)->orWhere('id', '=', 2)->first();

Take a look at the example above; should help you out :)

answered Mar 22, 2015 at 11:20

Julian Camilleri

3,1451 gold badge28 silver badges39 bronze badges

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

1 Comment

Lyon Over a year ago

Thanks! I used my User model in the custom validation and it worked

Collectives™ on Stack Overflow

Laravel validation check if a value in database equals either one of two values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related