laravelDB类之查询
- 满足条件的全部获取：DB::table("表名")->where("name",">","1")->get();
- 满足条件的第一列获取：DB::table("表名")->where("name",">","1")->first();
- 满足条件的全部字段：DB::table("表名")->where("name",">","1")->lists("title");
- 满足条件的单一字段：DB::table("表名")->where("name",">","1")->pluck("title");//返回二位字段值数组
DB::table("表名")->where("name",">","1")->pluck("title","name");//返回二位字段值数组 第二个参数指定key - 分块查询数据列：DB::table("表名")->chunk(100,function($users){
//$users to do $user是table中2行一次查询的结果
//return false; 停止处理接下来的数据
}) - 指定查询字句：DB::table("表名")->select("name","email")->get();
- 增加查询子句到已有查询中：$query=DB::table("表名")->select("name","email");$query->addSelect("age")->get();
- 条件查询where和orWhere：DB::table("表名")->where("name",">","10")->orWhere("titile","=","0")->get();
- 条件查询whereBetween和whereNotBetween：DB::table("表名")->where("name",">","10")->whereBetween("titile","=","[0,10]")->get();
- 条件查询whereIn：DB::table("表名")->where("name",">","10")->whereIn("titile","[1,2,3]")->get();
- 条件查询whereNull：DB::table("表名")->where("name",">","10")->whereNull("titile")->get();//未配置的值
- 条件查询where Clauses：DB::table("表名")->where("name",">","10")->whereNameAndTitle("name",titile")->get()；
- 排序（Drder By）,分群（Group By）及 Having:
$users=DB::table("users")->orderBy("name","desc")->groupBy("count")->having("count",">",100)->get()
偏移（Offset）及 限制 （Limit）
$users=DB::table("users")->skip(10)->take(5)->get();
|
扫码关注官方微信
手机扫描直接访问
本站网友
发表于 2022-11-24 17:01:37
