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

最新推荐文章于 2024-07-15 17:00:02 发布

weixin_33713707

最新推荐文章于 2024-07-15 17:00:02 发布

阅读量2.1k

点赞数

CC 4.0 BY-SA版权

文章标签： php

原文链接：http://www.cnblogs.com/freefei/archive/2012/10/08/3234952.html

本文深入探讨了PHP中复杂关联查询的实现方式，通过实例展示了如何使用ORM（对象关系映射）来简化数据库操作，提高代码的可读性和维护性。详细介绍了`hasOne`、`hasMany`和`belongsTo`等关系类型的应用场景，并提供了具体的代码示例。

$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