Question

thinkphp 怎么使用多表查询?

Answer 1

在model里进行关联，在 model里这么写，例如是 ArticleViewModel.class.php
class ArticleViewModel extends Model{
protected $viewModel = true;
protected $masterModel = 'a';
protected $viewFields = array(
'a'=>array('id','subject','_type'=>'桐高伏LEFT'念卜),
'b'=>array('title','_on'=>'a.gid=b.id'),
);
}
那么就可以将表a.gid和表b的id关联起来了。
然后在 ArticleAction.class.php
public function read(){
$Article=D("ArticleView");//调用上面的ArticleViewModel
$list=$Article->find();
echo $Article->getlastsql();
}

然后你会打印出类似局携:SELECT a.id AS id,a.subject AS subject b.title AS title FROM xx_a a LEFT JOIN xx_b b ON a.gid=b.id

Answer 2

楼上正解。你可以去看手册。手册5.3.18上面有详细的介绍。希望能帮到你

Answer 3

使用关联模型 RelationModel