[php] Thinkphp 联表查询

在查询之前首先实例化一个模型

$list = M('list');  // 表前缀是 tp_

一、sql语句查询

$sql = 'select * from tp_list as list, tp_article as article where list.sub_category = article.sub_category';print_r($list->query($sql));

二、join方法查询

$listArticle = $list->join('__ARTICLE__ ON __LIST__.sub_category = __ARTICLE__.sub_category')->select();  // __ARTICLE__ = tp_article print_r($listArticle);

三、table方法查询

$listArticle = $list->table('tp_list as list, tp_article as article')->where('list.sub_category = article.sub_category')->select();print_r($listArticle);

谢谢关注！