我的模型中有这个:
public function relations()
{
return array(
'role' => array(self::BELONGS_TO, 'MedRoles', 'role_id'),
);
}
我的控制器中也有这个:
public function actionIndex() {
$criteria = new CDbCriteria;
$criteria->join = "LEFT JOIN med_roles r ON r.id = t.role_id";
$criteria->order = "id DESC";
$userData = MedUsers::model()->findAll($criteria);
$this->render('index', array(
'users' => $userData
));
}
我的数据库有表:med_users和med_roles我显示来自med_users的数据没有问题,但无法显示来自相关med_roles的数据。我该怎么做?
像这样的东西?
$userData = MedUsers::model()->with('role')->findAll($criteria);
foreach($userData as $user) {
echo $user->role->name;
}