# 數據查詢
```
public function index()
{
// 查詢數據一條
// get()方法傳入查詢的id
$res1 = User::get(1);
$res2 = User::get(function ($query){
$query->where('username','eq','000066')
->field('username, email');
});
// where方法
$res3 = User::where('id',43)->field('id, username')->find();
// 查詢多條 查詢的數據是一個對象
$res4 = User::all([22,29,54]);
foreach ($res4 as $val) {
//dump($val->toArray());
}
$res5 = User::all(function ($query){
$query->where("id", '<', 26)
->field('id, username, email');
});
foreach ($res5 as $val) {
//dump($val->toArray());
}
$res6 = User::where('id','<',26)->select();
foreach ($res6 as $val) {
//dump($val->toArray());
}
// 獲取某個字段 value()
$res7 = User::where('id',22)->value('email');
//echo $res7;
// 獲取某一列中的全部字段，第一個參數要獲取的字段，第二個參數為數組的下表
$res8 = User::column("email","username");
dump($res8);
}
```
*****
# 添加數據
~~~
public function index()
{
// create()方法
$res = User::create([
'username' => 'admin',
'password' => md5(sha1('admin')),
'email' => 'admin@qq.com',
'num' => 100
],['username', 'email']); // 僅允許添加username和email字段
dump($res->id); // 獲取添加數據的id
dump($res);
// save()方法需要先實例化模型
$userModel = new User();
$userModel->username = 'admin';
$userModel->email = 'admin@qq.com';
$userModel->save();
dump($userModel->id); // 獲取添加數據的id
dump($userModel);
// save()方法的其他寫法
$userModel = new User();
// allowField過濾掉不存在的字段如果為allowField(['username'])則只添加username字段
$res = $userModel->allowField(true)
->save([
'username' => 'admin',
'password' => md5('admin')
]);
dump($res->id); // 獲取添加數據的id
dump($res);
}
~~~
*****
# 更新數據
~~~
// update方法適用于不需要驗證的數據如果下面的代碼執行2次看不出是否數據有改變
$res = User::update([
'id' => 1,
'username' => 'admin'
],function($query){
$query->where("id","LT",5) // id小于5
});
//$res = User::where('id',1)->update(['username'=>'admin']);
~~~
