Thinkphp框架對數據庫的操作（總結）

$user???????????=?new?User; $user->name?????=?'thinkphp'; $user->email????=?'thinkphp@qq.com'; $user->save(); $user?=?new?User; $user->save([ ????'name'??=>??'thinkphp', ????'email'?=>??'thinkphp@qq.com' ]);

$user?=?new?User; //?過濾post數組中的非數據表字段數據 $user->allowField(true)->save($_POST);

$user?=?new?User; //?post數組中只有name和email字段會寫入 $user->allowField(['name','email'])->save($_POST);

$user?=?new?User; $list?=?[ ????['name'=>'thinkphp','email'=>'thinkphp@qq.com'], ????['name'=>'onethink','email'=>'onethink@qq.com'] ]; $user->saveAll($list);

$user?=?User::create([ ????'name'??=>??'thinkphp', ????'email'?=>??'thinkphp@qq.com' ]); echo?$user->name; echo?$user->email; echo?$user->id;?//?獲取自增ID

$user?=?User::get(1); $user->name?????=?'thinkphp'; $user->email????=?'thinkphp@qq.com'; $user->save();

$user?=?new?User; //?save方法第二個參數為更新條件 $user->save([ ????'name'??=>?'thinkphp', ????'email'?=>?'thinkphp@qq.com' ],['id'?=>?1]);

$user?=?new?User; //?過濾post數組中的非數據表字段數據 $user->allowField(true)->save($_POST,['id'?=>?1]);

$user?=?new?User(); //?post數組中只有name和email字段會寫入 $user->allowField(['name','email'])->save($_POST,?['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);

User::where('id',?1) ????->update(['name'?=>?'thinkphp']);

//?實例化模型 $user?=?new?User; //?顯式指定更新數據操作 $user->isUpdate(true) ????->save(['id'?=>?1,?'name'?=>?'thinkphp']);

$user?=?User::get(1); $user->name?=?'thinkphp'; //?顯式指定當前操作為新增操作 $user->isUpdate(false)->save();

$user?=?User::get(1); $user->delete();

User::destroy(1); //?支持批量刪除多個數據 User::destroy('1,2,3'); //?或者 User::destroy([1,2,3]);

User::destroy(function($query){ ????$query->where('id','>',10); });

//?取出主鍵為1的數據 $user?=?User::get(1); echo?$user->name; //?使用查詢構造器查詢滿足條件的數據 $user?=?User::where('name',?'thinkphp')->find(); echo?$user->name;

//?根據主鍵獲取多個數據 $list?=?User::all('1,2,3'); //?或者使用數組 $list?=?User::all([1,2,3]); //?對數據集進行遍歷操作 foreach($list?as?$key=>$user){ ????echo?$user->name; }

//?使用查詢構造器查詢 $list?=?User::where('status',?1)->limit(3)->order('id',?'asc')->select(); foreach($list?as?$key=>$user){ ????echo?$user->name; }

//?獲取某個用戶的積分 User::where('id',10)->value('score'); //?獲取某個列的所有值 User::where('status',1)->column('name'); //?以id為索引 User::where('status',1)->column('name','id');