- $data = Db::query('select * from tf_action');
- $data = Db::query('select * from tf_action where id> ? and id <?',[1,10]);
- $sql = Db::getLastSql();
查询用 query.
删除, 增加, 修改, 用 execute.
$data = Db::table('tf_action')->select();
这里用的是表全名.
$data = Db::name('action')->select();
这里用的是去掉前缀的表名.
$data = db('action')->select();
助手函数, 效果与 Db::name 差不多.
但是又不完全相同.
$data = db('action')->where('id','>',1)->where('id','<',9)->select();
多条件查询.
$data = db('action')->where('id','>',20)->whereOr('id','<',9)->select();
或查询.
如果中间的条件是空, 就是 = 的意思.
- $where = new Where();
- $where['name'] = ['like','% 户 %'];
- $where['id'] = ['>',1];
- $data = db('action')->where($where)->select();
- $where[] = ['name','like','% 户 %'];
- $where[] = ['id','>',1];
- $data = db('action')->where($where)->select();
组合查询.
- $where = new Where();
- $where['name'] = ['like','% 户 %'];
- $where['id'] = ['>',1];
- $data = db('action')->where($where)->limit(2,2)->order('id desc')->select();
分页排序.
- $where = new Where();
- $where['name'] = ['like','% 户 %'];
- $where['id'] = ['>',1];
- $data = db('action')->where($where)->limit(2,2)->order('id desc')->field('id,name')->select();
查询指定字段.
- $where = new Where();
- $where['name'] = ['like','% 户 %'];
- $where['id'] = ['>',1];
- $data = db('action')->where($where)->limit(2,2)->order('id desc')->field('id aid,name')->select();
起别名.
$data = db('action')->where($where)->field('count(*) as count')->find();
使用系统函数.
$data = db('action')->where("name like'% 户 %'AND id> 1")->select();
直接写字符串也是 OK 的.
来源: http://www.bubuko.com/infodetail-2755100.html