laravel返回指定字段

类似tp框架中的field

field(['salesman_id','salesman_name','salesman_mobile'])
1
$data = ModelA::find($id, ['column1', 'column2']);

$data = ModelA::first(['column1', 'column2']);

$data = ModelA::where(['column1', '=', 'value'])->get(['column1', 'column2']);
————————————————
版权声明：本文为CSDN博主「生活你别Null」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/qq_35081380/article/details/105866837

laravel-多条件查询并指定key输出

$room =  DB::table('room')
    ->where(function($query) use($contList){
        foreach ($contList as $k=>$v){
            //拼接查询条件
            $query->orwhere(function ($query) use($v) {
                $query->where('id', '=', $v['room_id'])->where('hotel_id', '=', $v['hotel_id']);
            });
        }
    })
    ->select(['id','hotel_id','room_number'])
    ->get()->keyBy('id')
    ->toArray();

以上代码解析sql语句如下

"select `id`, `hotel_id`, `room_number` from `mm_room` where ((`id` = ? and `hotel_id` = ?) or (`id` = ? and `hotel_id` = ?) or (`id` = ? and `hotel_id` = ?))"

注：keyBY() 意为：以id为键值输出  必须写到get()后面 不然会报错

转载于:https://www.cnblogs.com/luzt/p/9390727.html