php无关联表查询排序分页

最新推荐文章于 2023-09-22 11:56:45 发布

不负好时光！

最新推荐文章于 2023-09-22 11:56:45 发布

阅读量337

点赞数

分类专栏： thinkphp 文章标签：无关联表查询分页

本文链接：https://blog.csdn.net/qq_43632766/article/details/88591242

版权

thinkphp 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

	$data=Db::table('fa_caselistsx')
  ->union('SELECT * FROM fa_caselistyw')
  ->union('SELECT * FROM fa_caselistyy')
  ->union('SELECT * FROM fa_caselistyy')
  ->union('SELECT * FROM fa_caselistyyue')
  ->union('SELECT * FROM fa_caselistty')
  ->union('SELECT * FROM fa_caselistms')
  ->union('SELECT * FROM fa_caselistkx')
  ->union('SELECT * FROM fa_caselistddyfz')
  ->union('SELECT * FROM  fa_caselistpdysh')
  ->union('SELECT * FROM fa_caselistzhsj')
  ->union('SELECT * FROM  fa_caselistxxjs')
  ->order('id desc')->buildSql();
	$list = Db::table($data.' as  a')
    ->paginate(7,false,['query'=>request()->param()]);