查看分页数据

最新推荐文章于 2023-04-26 16:38:48 发布

原创最新推荐文章于 2023-04-26 16:38:48 发布 · 250 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#union #数据分页 #php

public function selectdb(){
    $tables = DB::select('SHOW TABLES');
    $object =  json_decode( json_encode( $tables),true);
    $names = array();
    $queries = collect();
    foreach($object as $k => $v){
        if(strpos($v['Tables_in_shop'],'sp_ad2018') !==false){
            $names[] = $v['Tables_in_shop'];
        }
    }
    $query = DB::table('sp_ad')->where('id',1);
    $str='';
    foreach($names as $k => $v){
        if($k==0){
            $str = DB::table($v)->where('id',1);
        }else{
            $a = DB::table($v)->where('id',1);
            $str->union($a);
        }
    }
    $p=$str->get();
    return json_encode($p);
}