#### 1.命令行創建 1)切換到項目根目錄 php think make:model app\index\model\user #### 2.注意 1)數據模型的名字建議與數據庫表名一致 2)如果數據庫表名與模型名不一致,可以設置表名 protected $table="user"; 3)如果表名帶下劃線(yzm_user),數據模型名則為(YzmUser); 4)如果設置了表前綴,默認自動添加表前綴 #### 3.模型的實例化 1)調用靜態方法 //導入User use \app\index\model\User; $res = User::get(1); dump($res->toArray()); 2)實例化數據模型 $user = new User(); $res = $user::get(2); dump($res->toArray()); 3)使用loader類 use \think\Loader; $user = Loader::moder('user'); $res = $user::get(3); dump($res->toArray()); 4)使用助手函數 $user = model('user'); $res = $user::get(4); dump($res->toArray); #### 4.模型的查詢 1)獲取單條數據  //get方法 //使用數字,默認主鍵 $res = User::get(1); //使用數組,默認查找用戶名 $res = User::get(['name'=>'zhangsan']); //使用閉包函數 $res = User::get(function($query){ $query->where('id',1); }); //find方法 $res = User::where('id',2)->find(); 2)查詢多條數據  //查詢所有數據 $res = User::all(); //根據字符串查詢 $res = User::all('1,2,3'); //根據數組查詢 $res = User::all([1,2,3]); $res = User::all(['status'=>1]); //使用閉包查詢 $res = User::all(function($query){ $query->where('status',1)->limit(3)->order('id,'desc'); }); //打印查詢結果 foreach($res as $key=>$val){ //結果為對象,轉為數組 dump($val->toArray()); } //實例化模型后調用查詢方法 $user = new User(); $res = $user->where('name','thinkphp') ->limit(10) ->order('id','desc') ->select(); //獲取某個值 User::where('id',10)->value('age'); //獲取某一列的所有值 User ::where('status',1)->column('name'); //以id為索引 User::where('status',1)->column('name','id'); User::where('status',1)->column('id,name'); #### 動態查詢 //根據name字段查詢 $user = User::getByName('zhangsan'); //根據 email查詢 $user = User::getByEmail('123456@qq.com'); #### 通過query類查詢 User::where('id','>',10)->select(); User::where('name','zhangsan')->find();