1.查找并更新 1)獲取該條數據,并更改字段后更新數據 $user = User::get(1); $user->name = 'zhangsan'; $user->age = 18; $user->save(); 2.直接更新數據 $user = new User; //save方法第二個參數為更新條件 $user->save([ 'name'=>'zhangsan', 'age'=>18 ],['id'=>1]); * 過濾非表中的字段 ~~~ $user = new User(); //過濾post數組中非數據表字段 $user->allowField(true)->save($_POST,['id'=>1]); ~~~ * 指定寫入字段 ~~~ $user = new User(); //指定post數組中只有name和age字段會寫入 $user-allowField(['name','age'])->save($_POST,['id'=>1]); ~~~ 3.批量更新數據 ~~~ $user = new User(); $list = [ ['name'=>'zhangsan','age'=>18], ['name'=>'lisi','age'=>19] ]; $user->saveAll($list); echo User::getLastSql(); ~~~ 4.數據庫類更新數據 //無法使用模型的事件功能 $user = new User; $user = where('id',1)->update(['name'=>'zhangsan']); //或者 $user = new User; $user->update(['id'=>1,'name'=>'zhangsan']); 5.靜態方法 User::where('id',1)->update(['name'=>'zhangsan']); //或者 User::update(['id'=>1,'name'=>'zhangsan']); 6.閉包更新 $user = new User; $user->save(['name'=>'thinkphp'],function(){ //更新的條件 $query->where('status',1)->where('id','>',10); });