转数组->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);