如何在 Laravel Eloquent 中选择某些字段? [英] How to Select Certain Fields in Laravel Eloquent?

问题描述

如何在 Laravel Eloquent 中执行以下查询?

How to Do following Query in Laravel Eloquent?

SELECT catID, catName, imgPath FROM categories WHERE catType = "Root"

我已经尝试过

CategoryModel::where('catType', '=', 'Root')
                ->lists('catName', 'catID', 'imgPath');

但它只返回两个字段.

Array ( [7] => Category 1 )

推荐答案

lists() 将结果集合转换为具有键值的数组.那里只能有两个数据库列.否则你必须使用 select() 但是你会得到一个模型集合而不仅仅是一个数组.

lists() turns the resulting collection into an array with key value. You can only have two database columns in there. Otherwise you have to use select() but then you will get a collection of models not just an array.

$categories = CategoryModel::select('catID', 'catName', 'imgPath')
                           ->where('catType', '=', 'Root')
                           ->get();

这篇关于如何在 Laravel Eloquent 中选择某些字段?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！