Laravel Mysql操作

jaly

1. $map['time'] = array('between' , array($start , $end));
   
2. $map['date'] = ['sdate','>=',$sdate];
   
3. User::where($map)->get();
   
4. 
   
5. $users = DB::table('users')->whereBetween('votes', [1, 100])->get();
   
6. $sql->where('online_time', '>=', time())->orWhere('offline_time', '<=', time());
   
7. 
   
8. $list = DB::connection('ysera')->select("SELECT * FROM pv WHERE date BETWEEN 1 AND 10 GROUP BY a,b,c ORDER BY d DESC LIMIT 20 OFFSET 0");

复制代码