Thinkphp3.2.3多表查询（结合项目实战）

最新推荐文章于 2020-03-13 19:29:11 发布

weixin_34335458

最新推荐文章于 2020-03-13 19:29:11 发布

阅读量216

点赞数

文章标签： php python

原文链接：https://my.oschina.net/botkenni/blog/1826970

版权

2019独角兽企业重金招聘Python工程师标准>>>

以一个 fh_joinactivity表和fh_activity表联查为例：

方法一：

$data = M()->table('fh_joinactivity as a')->join('fh_activity as b on b.a_id = a.a_id')->where(' a.u_id = 1 ')->select();

注意，方法一这里的表名要带上前缀，最后取2个表的满足where()条件的所有数据

array (size=2)
  0 => 
    array (size=18)
      'ja_id' => string '12' (length=2)
      'ja_name' => string '鍚嶅瓧涓€' (length=9)
      'ja_tel' => string '13578945612' (length=11)
      'a_id' => string '21' (length=2)
      'ja_addtime' => string '1459999999' (length=10)
      'u_id' => string '1' (length=1)
      'is_read' => string '0' (length=1)
      'a_title' => string '娲诲姩浜�' (length=9)
      'a_time' => string '1486141800' (length=10)
      'a_addr' => string '娲诲姩鍦扮偣浜�' (length=15)
      'a_content' => string '&lt;p&gt;娲诲姩浜�&lt;br/&gt;&lt;/p&gt;' (length=39)
      'a_num' => string '13' (length=2)
      'a_joinnum' => string '2' (length=1)
      'a_img' => string 'Upload/activity/1486089587.png' (length=30)
      'a_author' => string '1' (length=1)
      'is_show' => string '1' (length=1)
      'is_del' => string '0' (length=1)
      'add_time' => string '1486089587' (length=10)
  1 => 
    array (size=18)
      'ja_id' => string '13' (length=2)
      'ja_name' => string '鍚嶅瓧浜�' (length=9)
      'ja_tel' => string '13578948888' (length=11)
      'a_id' => string '21' (length=2)
      'ja_addtime' => string '1469999999' (length=10)
      'u_id' => string '1' (length=1)
      'is_read' => string '0' (length=1)
      'a_title' => string '娲诲姩浜�' (length=9)
      'a_time' => string '1486141800' (length=10)
      'a_addr' => string '娲诲姩鍦扮偣浜�' (length=15)
      'a_content' => string '&lt;p&gt;娲诲姩浜�&lt;br/&gt;&lt;/p&gt;' (length=39)
      'a_num' => string '13' (length=2)
      'a_joinnum' => string '2' (length=1)
      'a_img' => string 'Upload/activity/1486089587.png' (length=30)
      'a_author' => string '1' (length=1)
      'is_show' => string '1' (length=1)
      'is_del' => string '0' (length=1)
      'add_time' => string '1486089587' (length=10)