如何在 Laravel Eloquent 中选择某些字段?

2021-12-26 00:00:00 php mysql laravel laravel-4 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();

相关文章