```php //查询模型全部数据 self::select(); //条件查询模型数据 self::where('id',1)->select(); //Db查询方法 Db('user')->where('id',1)->select(); ``` ```php //引入index下user模型 use app\index\model\User; 实例化后进行调用 $user = new User; //查询数据 $resule = User::where('name','PHPSmarty')->select(); //查询id大于等于5的数据 $resule = User::where(['id' => '>= 5'])->select() //要求id等于5并且只查询id,name,money字段 $resule = User::where('id',5)->field('id','name','money')->select(); //可直接在where里写sql $resule = self::where('id > 5') ->field('id','name','money') ->order('id','desc') ->limit('0,10') ->select(); ``` ## 模糊查询LIKE ```php $resule = self::where('money','LIKE','%1%') ->field('id','name','money') ->order('id','desc') ->limit('0,10') ->select(); ``` ## Where ```php $resule = self::order('id','desc') ->where([ 'id' => '1', 'name' => '123', 'sex' => 'man', 'aaa' => '> 5' ################## ]) ``` ## WhereOr ```php //查询ID等于1 或者等于2 或者等于3 $resule = self::where('id',1) ->whereor('id',2) ->whereor('id',3) ->select(); //输出3条数据 ``` ## limit ```php //默认显示条数 0 - 10 $resule = self::where('id >= 1') ->limit('0,10') ->select(); //从第10条开始，显示15条 $resule = self::where('id', '>=', '1') ->limit('10,15') ->select(); //显示第1页，每页显示15条 $resule = self::where(['id' => '>= 1']) ->limit('1','15') ->select(); //查询第2页，每页显示15条 $resule = self::where('id','>=','1') ->limit('2','15') ->select(); ``` ## Where in ```php public function test(){ $id = '1,2,3,4,5,6,7,8,9,10,11,12'; $resule = Model::table('Test_db') ->where("id in ({$id})") ->select(); return $resule; } ```