易腾动力社区

标题: Laravel Mysql操作 [打印本页]

---

作者: jaly    时间: 2020-9-21 11:37
标题: Laravel Mysql操作

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");

复制代码

---

欢迎光临 易腾动力社区 (http://bbs.yidz.cn/)

Powered by Discuz! X3