#### －－－上－－－
批量查詢
~~~
$result = Db::name('user')
->where('name','like','%m%')
->where('id',['in',[1,2,3]],['between','5,8'],'or')
->limit(10)->select();
~~~
dump($result);
用 table()，要加前綴。
快捷查詢
~~~
where('id&age','>',0);
where('id|age','>',0);
~~~
視圖查詢
~~~
$result =
Db::view('user','id,name,age')
->view('score_list','id,score','user.id = score_list.id')
->select();
dump($result);
~~~
#### －－－中－－－
閉包查詢
~~~
$result = Db::name('data')
->select(function($query){$query->where('name','like','%think%')
->where('id','in','1,2,3')->limit(10);
});
$result = Db::name('data')
->select(function($query){$query->where('name','like','%think%')
->where('id',' between',[1,3])->limit(10);
});
dump($result);
select * from think_data where name like '%think%' and id in ('1','2','3') limit 10;
~~~
Query 對象查詢
~~~
$query = new \think\db\Query;
$query ->name('city')
->where('name','like','%think%')
->where('id','in','1,2,3')
->limit(10);
$result = Db::select($query);
dump($result);
~~~
獲取數值
~~~
$name= Db::name('data')
->where('id',8)
->value('name');
dump($name);
$result = Db::table('user')
->where('id','exp','>1')
->value('name');
dump($result);
有兩條，取得第一條
~~~
獲取列數據
并且以id為索引
~~~
$list = Db::name('data')
->where('status',1)
->column('name','id');
~~~
####－－－下－－－
聚合查詢
~~~
Db::name('data')
->where('id','>',1)
->count();
Db::name('data')
->where('id','>',1)
->max('age');
~~~
字符串查詢
~~~
$result = Db::table('user')
->where('id>:id and name is not null',['id'=>10])
->select();
dump($result);
~~~
日期時間查詢
查詢大于某日的數據
~~~
$result = Db::table('user')
->whereTime('create_time','>','2017-01-01')
->select();
dump($result);
~~~
查詢本周的數據
~~~
$result = Db::table('user')
->whereTime('create_time','week')
->select();
dump($result);
~~~
查詢最近兩天添加的數據
~~~
$result = Db::table('user')
->whereTime('create_time','-2 days')
->select();
dump($result);
~~~
查詢一個時間范圍的數據
~~~
$result = Db::table('user')
->whereTime('create_time','between',['2017-1-1','2017-1-10'])
->select();
dump($result);
~~~
查詢上周的數據
~~~
$result = Db::table('user')
->whereTime('create_time','last week')
->select();
dump($result);
~~~
