How can i use an array in a Where Clause in Laravel Query Builder?

Question

I want to use the array $aqui inside where clause, but I don't know how to do it. I know how to put multiple values inside where clause, but I don't know about arrays.

$aqui[1] = 35;
$aqui[2] = 67;
$aqui[3] = 44;
$aqui[4] = 12;
$aqui[5] = 9;
//and goes...

$caraio = DB::connection('mysql')
->table('users')
->select('name')
->where( /* where fields are equal to $aqui */ )
->value('name');

Because i find it confusing and harder to learn and everything i did until now is using Query Builder. — Neyelson Alves
– Neyelson Alves, Commented Mar 8, 2020 at 16:21
That's fine, but you can try. I am saying this because they make your work a lot easier. Otherwise, you have to write raw queries yourself. — mighty_dev
– mighty_dev, Commented Mar 8, 2020 at 16:22
are you looking for ->whereIn('aqui', $aqui)? (guessing here that the attribute you want to filter by is called aqui as well - if not, adjust accordingly — ArSeN
– ArSeN, Commented Mar 8, 2020 at 16:56
Because i find it confusing So practice? It’s more conventional to use models in Laravel (and most other web frameworks) rather than manually writing queries all over your application. — Martin Bean
– Martin Bean, Commented Mar 8, 2020 at 18:39

Ben · Accepted Answer · 2020-03-08 22:01:58Z

0

Just use:

$aqui[1] = 35;
$aqui[2] = 67;
$aqui[3] = 44;
$aqui[4] = 12;
$aqui[5] = 9;
//and goes...

$caraio = DB::connection('mysql')
->table('users')
->select('name')
->whereIn('attributeName', $aqui)
->value('name');

Obviously you want to replace attributeName with the name of the attribute that you want to compare values against.

Collectives™ on Stack Overflow

How can i use an array in a Where Clause in Laravel Query Builder?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related