mysql - Yii2 更新条件是一个数组

Question

这是更新代码

 $clients = OpClient::find(['id'])->where(['status'=>'Active'])->all();

    foreach($clients as $client)
    {
        $array[] = $client['unit_id'];
        $unit = OpUnit::find()->where(['id'=>$array]);

         file_put_contents('test.txt',print_r($client['unit_id'],true));

         $connection = Yii::$app->db;
        $connection->createCommand()->update('op_unit', ['selected' => 'Yes'], 'id='.$array.'')->execute();
    }

我应该如何输入 id 是数组的更新查询？它一直显示错误 Array to string conversion。任何建议将不胜感激。谢谢

Answer 1

应该是这样的..

$connection->createCommand()->update('user', 
             ['selected' => 'Yes'],['id' => $array])->execute();

尝试使用真正的sql代码

$myRawSql=   $connection->createCommand()->update('user', 
             ['selected' => 'Yes'],['id' => $array])>getRawSql();

var_dump($myRawSql);