tp6使用table查询，条件原生

转数组->toArray();

1、单表

$id=1;
Db::connect('csdade')->table('al_paystatus')->whereRaw("id>={$id} and id<10")->limit(2,2)->select()

2、连表

$data = Db::connect('csdade')
   ->table('p_order')
   ->alias('o')
   ->field('o.*,d.itemno')
   ->whereRaw("o.billid>={$id} and o.billid<10")
   ->join('p_orderdetail d','o.billid=d.billid')
   ->limit(2,2)
   ->select();

3、group，having

Db::table('user')
    ->field('user_id,test_time,username,max(score)')
    ->group('user_id,test_time')
    ->select();
//having条件
Db::table('score')
    ->field('username,max(score)')
    ->group('user_id')
    ->having('count(test_time)>3')
    ->select(); 

4、排序

//排序
Db::table('user')
->where('status', 1)
->order('id', 'desc')
->limit(5)
->select();

5、转数组toArray()

//转数组toArray()
$data = Db::connect('csdade')
     ->table('p_order')
     ->alias('o')
     ->field('o.*,d.itemno')
     ->whereRaw("o.billid>={$id} and o.billid<10")
     ->join('p_orderdetail d','o.billid=d.billid')
     ->limit(1,2)
     ->select()
     ->toArray();

6、count条数

$data = Db::connect('csdade')
     ->table('p_order')
     ->alias('o')
     ->field('o.*,d.itemno')
     ->whereRaw("o.billid>={$id} and o.billid<10")
     ->join('p_orderdetail d','o.billid=d.billid')
     ->count();

 $data = Db::connect('csdade')->table('p_order')->whereRaw("billid>={$id} and billid<10")->count();
 print_r($data);

7、指定字段，和排除字段

//field指定字段
$data = Db::connect('csdade')->table('p_order')->field("billid")->whereRaw("billid=2")->select()->toArray();

//withoutField排除字段
$data = Db::connect('csdade')->table('p_order')->withoutField("billid")->whereRaw("billid=2")->select()->toArray();
        print_r($data);