php - yii queryAll 传递参数失败

Question

我正在通过:

Yii::app()->db->createCommand($query)->queryAll(true,array(':bizid'=>$params));

查询:

 SELECT DISTINCT(BI.item_name)
 FROM items BI 
 WHERE BI.b_id IN (:bizid) ORDER BY BI.item_name ASC 

查询未能找到结果，但此查询获取结果:

SELECT DISTINCT(BI.item_name) as i_name FROM blacklist_items BI WHERE BI.business_id IN   (165,664,842,866,1234,3007,3030,3031,3032) ORDER BY BI.item_name ASC

为什么 queryAll 失败？

Answer 1

将 id 分配给数组:

$ids = [165,664,842,866,1234,3007,3030,3031,3032];

查询应该是:

$query = "SELECT DISTINCT(BI.item_name)"
 . " FROM items BI"
 . " WHERE BI.b_id IN (" . implode(',', $ids) . ") ORDER BY BI.item_name ASC