首先在model里面定义一个relations关系,如下:
public function relations()
{
// NOTE: you may need to adjust the relation name and the related
// class name for the relations automatically generated below.
return array(
'fishcenter'=>array(self::BELONGS_TO,'FishCenter','fcid'),
//'typeid'=>array(self::BELONGS_TO,'CommonClass','id'),
);
}
这里的关系被命名为fishcenter,下面我们在controller中使用这样的关系,
$new = Pond::model()->with(array(
'fishcenter'=>array('fcid','address','fcname'),
))->findAll(array(
'select'=>array('pondid','pondname','address','price'),
'order'=>'pondid DESC',
'limit'=>10,
));
这样获得的数据就是这样的结构:
$new=array(
'pondid'=>'',
'pondname'=>'',
......
fishcenter=>array(
'fcid'=>'',
'address'=>'',
......
)
);
所以说如果要获取fcid的数据,必须是:$new['fishcenter']['fcid']的形式。