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

问题描述

如何在Laravel雄辩地进行以下查询?

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');

但是它只返回两个字段.

but its return only two fields.

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口才中选择某些字段?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！