Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

777not888's avatar

Variable in query

I want to use variable $number in query like DB::select (..... whereIn ("id", $number ) ..... )

How write it correctly? may be in quotes?

0 likes
3 replies
gazd1977's avatar

You can use Named bindings as well

$results = DB::select('select * from users where id = :id', ['id' => 1]);

taken from laravel docs

jlrdw's avatar

I want to use variable $number in query like DB::select (..... whereIn ("id", $number ) ..... )

DB::select (..... whereIn ("id", $your_array ) ..... )

Please or to participate in this conversation.