我有2个数据 一个是url_info 一个是category
url_info 中cid 是category的外键
我想用 YII中自带的CGridView 显示出 url_info.id category,name 这个2个字段在同一个表中
/**
* Manages all models.
*/
public function actionAdmin()
{
$dataProvider=new CActiveDataProvider('url_info,category', array(//这边写的有问题,不知道该如何写
'criteria'=>array(
'condition'=>'url_info.cid=category.id',//这变也是
'order'=>'id desc',
),
'pagination'=>array(
'pageSize'=>self::PAGE_SIZE,
),
));
$this->render('admin',array(
'dataProvider'=>$dataProvider,
));
}
显示层:
<?php $this->widget(‘zii.widgets.grid.CGridView’, array(
'dataProvider'=>$dataProvider,
'columns'=>array(
'id',
'cid',
'category.name'
array(
'class'=>'CButtonColumn',
),
),