CDbCommand查询

Question

I would like to bring in php to a CDbCommand query where id=:id. I would like to do id=: $model->id.

$user = Yii::app()->db->createCommand()
->select('id, username, profile')
->from('tbl_user u')
->join('tbl_profile p', 'u.id=p.user_id')
->where('id=:id')
->queryRow();

Answer 1

Try this: ->where('id=:id', array(':id'=> $model->id)).