Is there a way to specify the Ravel query rebuild SQL bind variable?

ListArray=[1,2,3];
Stack::where('columnA', $ListArray) - > toSQL;

I checked the contents of SQL as and found that where(`columnA`=?).

I'd like to check if where works for the elements of the array, but is there a good way?

laravel

2022-09-29 20:30

1 Answers

If you use getBindings instead of toSql as shown below, you will be able to confirm the binding.
"Also, it may be a code transfer error, but it seems that ""$"" before ""ListArray"" is missing."

$ListArray=[1,2,3];
Stack::where('columnA', $ListArray)->getBindings();

2022-09-29 20:30

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656