find by foreign key

gavinajayar · January 27, 2012, 6:48am

Hi everyone how can I substitute the findByPk in loadModelb because $id is not Pk and it is a Fk. thanks




	public function loadModel($id)

	{

		$model=Useraccounts::model()->findByPk($id);

		if($model===null)

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

		return $model;

	}

	public function loadModelb($id)

	{

		$modelb=Basicdetails::model()->findByPk($id);

		if($modelb==null)

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

		return $modelb;

	}

gavinajayar · January 27, 2012, 7:11am

I solved it thanks…




$modelb=Basicdetails::model()->findByAttributes(array('userid'=>$id,));

shailesh · January 27, 2012, 7:17am

Hi ,

These Solution that May Help.

public function loadModel($id)

    {


            &#036;criteria=New CDbCritieria;


 	&#036;critieria-&gt;condition='&lt;where Condition&gt;'; //Remove these if not required.


	&#036;model=Useraccounts::model()-&gt;findByAttributes(array('&lt;fieldname&gt;'=&gt;&#036;id),&#036;criteria);





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


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


            return &#036;model;


    }


    public function loadModelb(&#036;id)


    {


            &#036;criteria=New CDbCritieria;


 	&#036;critieria-&gt;condition='&lt;where Condition&gt;'; //Remove these if not required.


	&#036;model=Useraccounts::model()-&gt;findByAttributes(array('&lt;fieldname&gt;'=&gt;&#036;id),&#036;criteria);


            if(&#036;modelb==null)


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


            return &#036;modelb;


    }