帖子内容表ThreadContent ，
用户表User ，
用户收藏表 Collect ，
四个表，我现在想查出用户的收藏，要四表进行关联。
<?php
class ThreadContentModel extends RelationModel{
public $_link = array(
//第一个关系
'ThreadDatas'=>array(
'mapping_type'=>BELONGS_TO,
'foreign_key' =>'nid'
),
//第2个关系
'Collects'=>array(
'mapping_type'=>HAS_MANY,
'class_name'=>'Collect',
'foreign_key'=>'nid'
),
);
}<?php
class ThreadDataModel extends RelationModel{
public $_link = array (
//第一个关系
'ThreadContents'=>array(
'mapping_type'=>HAS_ONE,
'class_name'=>'ThreadContent',
'foreign_key'=>'nid'
),
//第二个关系
'Users'=>array(
'mapping_type'=>BELONGS_TO,
'class_name'=>'User',
'foreign_key'=>'uid'
),
//第三个关系
'ThreadReplys'=>array(
'mapping_type'=>HAS_MANY,
'class_name'=>'ThreadReply',
'foreign_key'=>'rid'
),
//第4个关系
'Collects'=>array(
'mapping_type'=>HAS_MANY,
'class_name'=>'Collect',
'foreign_key'=>'tid'
),
);
}<?php
class CollectModel extends RelationModel{
public $_link = array(
//第1个关系
'Users'=>array(
'mapping_type'=>BELONGS_TO,
'class_name'=>'User',
'foreign_key' =>'uid'
),
//第2个关系
'ThreadDatas'=>array(
'mapping_type'=>BELONGS_TO,
'class_name'=>'ThreadData',
'foreign_key'=>'tid'
),
//第3个关系
'ThreadContents'=>array(
'mapping_type'=>BELONGS_TO,
'class_name'=>'ThreadContent',
'foreign_key'=>'tid'
),
);
}只有ThreadCntent掉不出来，，，不知道哪里不对啊。。。Array
(
[0] => Array
(
[id] => 9
[uid] => 2
[tid] => 46
[time] => 1385608033
[Users] => Array
(
[id] => 2
[user] => 15021822918
[nickname] => test
[passwd] => e10adc3949ba59abbe56e057f20f883e
[sex] => 0
[qq] =>
[email] =>
[weixin] =>
[qianming] =>
[xunzhang] => 7.gif
[resigntime] => 1384485086
[resignip] => 127.0.0.1
[logintime] => 1385607809
[fraction] => 63
[state] => 1
[question] =>
[loginip] => 127.0.0.1
[isadmin] => 0
[answer] =>
[img] => 17.jpg
)
[ThreadDatas] => Array
(
[id] => 46
[uid] => 1
[author] => Link
[addtime] => 1385542903
[ifpic] => 1
[ifgif] => 0
[hits] => 29
[category] => 2
[ip] => 127.0.0.1
[type] => 2
[state] => 1
[shuxing] => 0
[bi] => 0
[buynum] =>
)
[ThreadContents] =>
)
[1] => Array
(
[id] => 8
[uid] => 2
[tid] => 4
[time] => 1385608015
[Users] => Array
(
[id] => 2
[user] => 15021822918
[nickname] => test
[passwd] => e10adc3949ba59abbe56e057f20f883e
[sex] => 0
[qq] =>
[email] =>
[weixin] =>
[qianming] =>
[xunzhang] => 7.gif
[resigntime] => 1384485086
[resignip] => 127.0.0.1
[logintime] => 1385607809
[fraction] => 63
[state] => 1
[question] =>
[loginip] => 127.0.0.1
[isadmin] => 0
[answer] =>
[img] => 17.jpg
)
[ThreadDatas] => Array
(
[id] => 4
[uid] => 2
[author] => test
[addtime] => 1384486894
[ifpic] => 0
[ifgif] => 0
[hits] => 95
[category] => 5
[ip] => 127.0.0.1
[type] => 1
[state] => 1
[shuxing] => 1
[bi] => 2
[buynum] =>
)
[ThreadContents] =>
) 最佳答案
