Yii学习(7)----使用with关系

首先在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']的形式。