[TOC] ## 靜態增刪改查操作 ### 增 ``` $user = User::create([ 'name' => 'thinkphp', 'email' => 'thinkphp@qq.com' ]); echo $user->email; echo $user->id; // 獲取自增ID ``` ### 增or 更新 ``` //批量添加或更新 $user = new User; $list = [ ['id'=>1, 'name'=>'thinkphp', 'email'=>'thinkphp@qq.com'], ['id'=>2, 'name'=>'onethink', 'email'=>'onethink@qq.com'] ]; $user->saveAll($list); //單個添加或更新 $user = new User(); $user->allowField(true)->save($_POST,['id' => 1]); $user->allowField(true)->save($_POST]); ``` ### 刪 #### 根據主鍵刪除 ``` User::destroy(1); //或 User::destroy([1,2,3]); ``` #### 條件刪除 ``` User::destroy(['status' => 0]); //或 User::where('id','>',10)->delete(); ``` ### 改 #### 查找并更新 ``` $user = User::get(1); $user->name = 'thinkphp'; $user->save(); ``` #### 直接更新數據 ``` User::update(['id' => 1, 'name' => 'thinkphp']); ``` #### 復雜界面更新 ``` User::where(['status'=>1,'name'=>'cpj'])->update(['name' => 'thinkphp']); ``` #### 更新個別字段 ``` $loan = LoanModel::get($id); $loan->show_app = $loan->getData('show_app')==1?0:1; $loan->save(); ``` ### 查 #### 獲取單個數據 ``` $user = User::get(1); echo $user->name; // 使用數組查詢 $user = User::get(['name' => 'thinkphp']); // 使用閉包查詢 $user = User::get(function($query){ $query->where('name', 'thinkphp'); }); echo $user->name; // 獲取某個列的所有值 User::where('status',1)->column('name') // 以id為索引 User::where('status',1)->column('name','id'); ``` #### 獲取多個數據 ``` // 或者使用數組 $list = User::all([1,2,3]); // 使用條件查詢(只能對where操作) $list = User::all(['status'=>1]); //閉包 比條件查找強大 $list = User::all(function($query){ $query->where('status', 1)->limit(3)->order('id', 'asc'); }); ``` ### 一對一關聯 #### 隱藏關聯的數組,綁定父元素 加別名 ``` //模型中方法,注意使用return進行 public function Reloan(){ //外鍵id reloanModel 的外鍵id return $this->hasOne('ReloanModel','lid')->bind('tid'); //->bind('username'=>'name') 把name改為username } //調用 LoanModel::get(8,'reloan')->hidden(['reloan']) //hidden 先用bind綁定到父類 然后用hidden 隱藏關聯表 LoanModel::all(8,'reloan')->hidden(['reloan','users']) ``` #### 更新關聯表 ``` $loan = LoanModel::get(8); $loan->reloan->tid=12; $loan->reloan->save(); ```