您好,欢迎访问一九零五行业门户网

yii多表关联查询后的数据怎么读出?

我在surl.php中定义了方法
public function relations(){ // 这里我进行了关联。主表surl的duid关联了user表的uid(主键) return array( 'user'=>array(self::belongs_to, 'user', 'duid'), ); } /* 获取短址 */ public function getlist(){ $result = surl::model()->findbypk(50); $criteria=new cdbcriteria; $criteria->with = array('user'); $result = surl::model()->findall($criteria); var_dump($result); // 打印$result }

这个是我的打印结果
array(391) { [0] => object(surl)#64 (11) { [_new:cactiverecord:private] => bool(false) [_attributes:cactiverecord:private] => array(11) { [id] => string(2) 21 [duid] => string(1) 3 } [_related:cactiverecord:private] => array(1) { [user] => object(user)#65 (11) { [_new:cactiverecord:private] => bool(false) [_attributes:cactiverecord:private] => array(10) { [uid] => string(10) 3 [name] => string(10) 渠道商b } [_related:cactiverecord:private] => array(0) { } [_c:cactiverecord:private] => null [_pk:cactiverecord:private] => string(1) 3 [_alias:cactiverecord:private] => string(1) t [_errors:cmodel:private] => array(0) { } [_validators:cmodel:private] => null [_scenario:cmodel:private] => string(6) update [_e:ccomponent:private] => null [_m:ccomponent:private] => null } } [_c:cactiverecord:private] => null [_pk:cactiverecord:private] => string(2) 21 [_alias:cactiverecord:private] => string(1) t [_errors:cmodel:private] => array(0) { } [_validators:cmodel:private] => null [_scenario:cmodel:private] => string(6) update [_e:ccomponent:private] => null [_m:ccomponent:private] => null }

我想问问各位啊 我该如何将user表的数据读出来啊!
foreach ($result as $key => $value) {}报错啊!
回复内容: 我在surl.php中定义了方法
public function relations(){ // 这里我进行了关联。主表surl的duid关联了user表的uid(主键) return array( 'user'=>array(self::belongs_to, 'user', 'duid'), ); } /* 获取短址 */ public function getlist(){ $result = surl::model()->findbypk(50); $criteria=new cdbcriteria; $criteria->with = array('user'); $result = surl::model()->findall($criteria); var_dump($result); // 打印$result }

这个是我的打印结果
array(391) { [0] => object(surl)#64 (11) { [_new:cactiverecord:private] => bool(false) [_attributes:cactiverecord:private] => array(11) { [id] => string(2) 21 [duid] => string(1) 3 } [_related:cactiverecord:private] => array(1) { [user] => object(user)#65 (11) { [_new:cactiverecord:private] => bool(false) [_attributes:cactiverecord:private] => array(10) { [uid] => string(10) 3 [name] => string(10) 渠道商b } [_related:cactiverecord:private] => array(0) { } [_c:cactiverecord:private] => null [_pk:cactiverecord:private] => string(1) 3 [_alias:cactiverecord:private] => string(1) t [_errors:cmodel:private] => array(0) { } [_validators:cmodel:private] => null [_scenario:cmodel:private] => string(6) update [_e:ccomponent:private] => null [_m:ccomponent:private] => null } } [_c:cactiverecord:private] => null [_pk:cactiverecord:private] => string(2) 21 [_alias:cactiverecord:private] => string(1) t [_errors:cmodel:private] => array(0) { } [_validators:cmodel:private] => null [_scenario:cmodel:private] => string(6) update [_e:ccomponent:private] => null [_m:ccomponent:private] => null }

我想问问各位啊 我该如何将user表的数据读出来啊!
foreach ($result as $key => $value) {}报错啊!
$result[0]->user就得到了user下面的所有信息,再继续调用就可以了。
$result[0]->user->id。拿到的就是user表里面的id字段,其他的按照字段拿就行。
其它类似信息

推荐信息