Yii2 WHERE IN query

Question

The following active record WHERE IN query does not work. According to the docs this should work:

$data = $dropDownData->find()
                    ->select('country, country_text')
                    ->distinct()
                    ->WHERE(['in', 'server', $servers]);

$listData = ArrayHelper::map($data,'country', 'country_text');

The sql equivalent is :

$query = "SELECT DISTINCT country, country_text 
          FROM `dropDownData` 
          WHERE server IN ({$servers})";

$servers just contains a string 1,2,4

What am I doing wrong here?

$server is a string or is an array ??? – ScaisEdge Jul 09 '18 at 16:59 — ScaisEdge, Jul 09 '18 at 16:59

score 14 · Accepted Answer · edited Jul 09 '18 at 17:20

Based on Yii2 documentation $servers should be an array not a string.

in: operand 1 should be a column or DB expression. Operand 2 can be either an array or a Query object.

https://www.yiiframework.com/doc/guide/2.0/en/db-query-builder#operator-format

Try using a proper array:

  $servers = [1,2,4]
  $data = $dropDownData->find()
                      ->select('country, country_text')
                      ->distinct()
                      ->WHERE(['in', 'server',[1,2,4]]);

or

  $data = $dropDownData->find()
                      ->select('country, country_text')
                      ->distinct()
                      ->WHERE(['in', 'server', $servers]);

score -1 · Answer 2 · answered Jul 10 '18 at 13:58

-1

You should use array variable

$servers = [1,2,4];

answered Jul 10 '18 at 13:58

Shringiraj Dewangan

784
10
22

Yii2 WHERE IN query

2 Answers2