//查询构造器 public function query() { //获取所有的数据 $student = DB::table('student')->get(); var_dump($student); //获取一条数据 $student = DB::table('student')->first(); var_dump($student); //使用where获取数据 $student = DB::table('student')->where('id','>=',12)->get(); var_dump($student); //使用多个where条件获取数据 $student = DB::table('student') ->whereRaw('id>=? and age > 10',[2,18]) ->get(); var_dump($student); //pluck返回结果集中指定的字段,列数据 $student = DB::table('student') ->whereRaw('id>=? and age > 10',[2,18]) ->pluck('name'); var_dump($student); //lists,返回结果 $student = DB::table('student') ->whereRaw('id>=? and age > 10',[2,18]) ->lists('name','id');//id作为下标，name作为值 var_dump($student); //select获取指定的字段 $student = DB::table('student') ->whereRaw('id>=? and age > 10',[2,18]) ->select('id','name','age') ->get(); var_dump($student); //chunk,分次查询，查询量过大的时候使用 DB::table('student')->chunk(1000,function($students){ var_dump($students);//每次查询1000条// if(条件满足){// return false;//跳出查询// } }); //查询中的聚合函数 //count() avg() max() sum() min() $count = DB::table('student')->count(); $avg = DB::table('student')->avg('age'); $max = DB::table('student')->max('age'); $min = DB::table('student')->min('age'); $sum = DB::table('student')->sum('age'); }
转载于:https://www.cnblogs.com/gyfluck/p/9039678.html
相关资源：解决laravel查询构造器中的别名问题
