thinkphp 多表关联查询 设置多条件

$this->_link = array( 'NavigationUrl'=>array( 'mapping_type'=>HAS_MANY, 'class_name' =>'NavigationUrl', 'foreign_key'=>'cateid', 'condition'=> "uid=$a", ), 'Navicate'=>array( 'mapping_type'=>HAS_MANY, 'class_name' =>'NavigationUrl', 'foreign_key'=>'cateid', 'condition'=> "catetop=1", ), ); 其实 关联的都是一个表 但是确写了两个数组 目的是返回的数组中返回两个二维数组 分别为 ["NavigationUrl"] ["Navicate"] [1] => array(4) { ["id"] => string(1) "2" ["catename"] => string(6) "影视" ["NavigationUrl"] => array(4) { [0] => array(9) { ["url_id"] => string(1) "9" ["webname"] => string(6) "优酷" ["url"] => string(20) "http://www.youku.com" ["cateid"] => string(1) "2" ["uid"] => string(2) "23" ["time"] => string(10) "1349596263" ["hots"] => string(1) "0" ["top"] => string(1) "0" ["catetop"] => string(1) "1" } [1] => array(9) { ["url_id"] => string(2) "10" ["webname"] => string(6) "酷六" ["url"] => string(18) "http://www.ku6.com" ["cateid"] => string(1) "2" ["uid"] => string(2) "23" ["time"] => string(10) "1349596281" ["hots"] => string(1) "0" ["top"] => string(1) "0" ["catetop"] => string(1) "0" } [2] => array(9) { ["url_id"] => string(2) "12" ["webname"] => string(7) "youtube" ["url"] => string(22) "http://www.youtube.com" ["cateid"] => string(1) "2" ["uid"] => string(2) "23" ["time"] => string(10) "1349596316" ["hots"] => string(1) "0" ["top"] => string(1) "1" ["catetop"] => string(1) "0" } [3] => array(9) { ["url_id"] => string(2) "16" ["webname"] => string(9) "爱奇异" ["url"] => string(16) "http://qqiyi.vom" ["cateid"] => string(1) "2" ["uid"] => string(2) "23" ["time"] => string(10) "1349667378" ["hots"] => string(1) "0" ["top"] => string(1) "0" ["catetop"] => string(1) "0" } } ["Navicate"] => array(1) { [0] => array(9) { ["url_id"] => string(1) "9" ["webname"] => string(6) "优酷" ["url"] => string(20) "http://www.youku.com" ["cateid"] => string(1) "2" ["uid"] => string(2) "23" ["time"] => string(10) "1349596263" ["hots"] => string(1) "0" ["top"] => string(1) "0" ["catetop"] => string(1) "1" } } }

转载于:https://www.cnblogs.com/freefei/archive/2012/10/08/3234952.html

评论将由博主筛选后显示,对所有人可见 | 还能输入1000个字符 “速评一下”
©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页