Laravel - Where statement and array

Question

I have an array to perform a where statement:

$array = ['name' => 'Jhon', 'age' => '27'];
User::where($array);

I need to use the same array to perform a search between two different age, I need something like:

User::where('age', '>=', '28')->where('age' , '<=', 50);

How should I do that using the above array?

Answer 1

You can use the whereBetween method:

User::whereBetween('age', [28, 50]);

You can read more about what conditions you can use in the Where Clauses documentation.