雅安论坛

标题: laravelDB类之查询 [打印本页]

作者: 匿名 时间: 2022-11-24 17:01
标题: laravelDB类之查询
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();

欢迎光临雅安论坛 (https://www.yaanbbs.net/)