Yii db command and CDbCriteria

Question

我有两个表Products(id, name)和Views(id,count,time)，这两个表彼此不相关。这是我的代码:

$dbCommand = Yii::app()->db->createCommand("
SELECT P.`id`, P.`name`, V.`time` 
FROM `products` P, `views` V 
WHERE P.`type` = 2 
ORDER BY V.`time` DESC
");
$data = $dbCommand->queryAll();

它正在工作，但我想将此查询转换为CDbCriteria语法。

$cdb = new CDbCriteria();
$cdb->select = //???
$cdb->where = //???
$cdb->order = //???

我该怎么做?有人能帮帮我吗?

Answer 1

您不能使用CDbCriteria，请尝试使用查询生成器。

Yii::app()->db->createCommand()
->select('P.id, P.name, V.time')
->from('products P, views V')
->where('P.type = :type')
->order('V.time DESC')
->queryAll(array(
    ':type' => 2
));