thinkphp速查表-快速查询手册_米醋屋个人技术博客

```
## thinkphp6.0模型增删改查速查表
新增
$user = new User;
// 过滤post数组中的非数据表字段数据
$data = Request::only(['name','email']);
$user->save($data);

$user = User::create([
    'name'  =>  'thinkphp',
    'email' =>  'thinkphp@qq.com'
]);

修改
User::update(['name' => 'thinkphp'], ['id' => 1]);
User::update(['name' => 'thinkphp', 'id' => 1]);

批量修改
$user = new User;
$list = [
    ['id'=>1, 'name'=>'thinkphp', 'email'=>'thinkphp@qq.com'],
    ['id'=>2, 'name'=>'onethink', 'email'=>'onethink@qq.com']
];
$user->saveAll($list);

批量修改
$list = Content::where('id','in',$ids)->select();
$res = $list->update(['pid'=>$specialId]);
if($res){
	return json(["code"=>200,"msg"=>"成功"]);
}else{
	return json(["code"=>4000,"msg"=>"失败"]);
}

删除
User::destroy(1);
// 支持批量删除多个数据
User::destroy([1,2,3]);

User::where('id','>',10)->delete();

聚合查询
User::count();
User::where('status','>',0)->count();
User::where('status',1)->avg('score');
User::max('score');

伪静态
location / {
   if (!-e $request_filename) {
   		rewrite  ^(.*)$  /index.php?s=/$1  last;
    }
}
```