Model::find() doesn't work with IN condition and bind params

Question

Model::find() doesn't work with IN condition and bind params

vlad4800 Oct '13

Created Oct '13	Last Reply Oct '13	Replies 1	Views 1609	Votes 1

vlad4800 8.6k

Oct '13

This will not work:

$ids = [1,2,3];
Model::find(array(
    "conditions" => "id IN (?0)",
    "bind"       => array(0 => $ids)
));

Neither this:

$ids = implode("','", [1,2,3]);
Model::find(array(
    "conditions" => "id IN (?0)",
    "bind"       => array(0 => $ids)
));

The only thing that works is:

Model::find(array(
    "conditions" => "id IN (?0, ?1, ?2)",
    "bind"       => array(0 => 1, 1 => 1, 2 => 2)
));

But that sucks, because we have to build the placeholders ourselves. We should be able to pass an array to the bind params and the framework should know to transform it to the correct form. Most other frameworks do.

1

Corentin Legros · Answer 1 · 2013-10-19T19:42:22-07:00

Nonono. It works perfectly for me, but with this solution you can try :

<?php

return self::query()
    ->inWhere('id', $arrayIds)
    ->getQuery()
    ->execute();

So indeed, you cannot use Model::find() and IN(), but you have a nice workaround :)

vlad4800 · Answer 2 · 2013-10-19T22:01:38-07:00

Well, yes, there are always workarounds, but I was just pointing out this behaviour as a possible bug :)