$xk = DB::table('articles')
->where('status',2)
->where('title', 'like', "%$keyword%")
->select('id', 'title','title as utitle','published_at','status as search_status','status','search_type');
$query = DB::table('question_stages')
->select('id', 'name','name as utitle','updated_at as published_at','search_status','search_status as status','search_type')
->where('search_status',2)
->where('name', 'like', "%$keyword%")
->unionAll($xk);
$querySql = $query->toSql();
$list= DB::table(DB::raw("($querySql) as a"))->mergeBindings($query)
->orderBy('published_at','desc')->paginate($per_page);
Laravel 多表联合查询并分页
最新推荐文章于 2023-12-09 20:42:39 发布