Loadmodel for two or more related tables

moylua · January 16, 2012, 1:19pm

hi! i have a problem in my actionUpdate and loadmodel function when i update a form with relations. There is no problem with my actioncreate. The loadmodel should point to all related tables.

public function actionUpdate($id)

{


	&#036;model = &#036;this-&gt;loadModel(&#036;id);


	&#036;account = &#036;this-&gt;loadModel(&#036;id);


	&#036;student = &#036;this-&gt;loadModel(&#036;id);


	&#036;faculty = &#036;this-&gt;loadModel(&#036;id);


	// Uncomment the following line if AJAX validation is needed


	// &#036;this-&gt;performAjaxValidation(&#036;model);





	if(isset(&#036;_POST['Patron']))


	{


		&#036;model-&gt;attributes=&#036;_POST['Patron'];


	


		if(&#036;model-&gt;save())


			&#036;this-&gt;redirect(array('view','id'=&gt;&#036;model-&gt;Patron_ID));


		


	}





	&#036;this-&gt;render('update',array(


		'model'=&gt;&#036;model,


		'account'=&gt;&#036;account,


		'student'=&gt;&#036;student,


		'faculty'=&gt;&#036;faculty,


	));


}

public function loadModel($id)

{


	&#036;model=Patron::model()-&gt;with('PatronAccount')-with('Student')-&gt;findByPk(&#036;id);


	


	if(&#036;model===null)


		throw new CHttpException(404,'The requested page does not exist.');


	return &#036;model;


}

sorry i’m just new to yii.

bettor · January 16, 2012, 1:58pm

Please see the usage of with() - http://www.yiiframework.com/doc/api/1.1/CActiveRecord#with-detail


$model=Patron::model()->with('PatronAccount','Student')->findByPk($id);

then once you assign


$model = $this->loadModel($id);

you should access student and account information via $model->PatronAccount->username;

The above usage is just an example you should use the attributes you’ve declared in each model.