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"]的形式。