TP5 Join 多条件

最新推荐文章于 2024-08-22 14:34:16 发布

我是高手高手高高手

最新推荐文章于 2024-08-22 14:34:16 发布

阅读量2.1w

点赞数

分类专栏： thinkphp5

本文链接：https://blog.csdn.net/haibo0668/article/details/82918002

版权

thinkphp5 专栏收录该内容

264 篇文章 5 订阅

订阅专栏

		$list = db('test_paper')
			->alias('p')
			->Join('test_paper_user u',"u.paper_id=p.id and u.deleted=0 and u.is_finish=0 and u.user_id='".$Session['user_id']."'")
			->field('p.id,p.title,p.description,p.img')
			->where($where)
			->group('p.id')
			->order(['p.id' => 'desc'])
			->paginate(6,false,['query' => request()->param(),'type' => 'page\Page','var_page'  => 'page']);

->Join('test_paper_user u',"u.paper_id=p.id and u.deleted=0 and u.is_finish=0 and u.user_id='".$Session['user_id']."'")