How to select specific fields in Laravel Rloquent?

Question

How to make the following query in Laravel Rloquent?

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

I tried to follow

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

but returns only two fields.

Array ( [7] => Category 1 )

Answer 1

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

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

Answer 2

Select multiple columns

CategoryModel::get(['catName', 'catID', 'imgPath']);

Works with Laravel 5.3 too!

Answer 3

CategoryModel::wherecatType('Root')
            ->pluck('catName', 'catID', 'imgPath');

Answer 4

laravel 5.3 ^ lists() , pluck().

pluck() , , ->toArray() .

Answer 5

, get() all()

, get() array , all() string :

:: ( 'field1', 'field2')

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

:: ([ 'field1', 'field2'])

CategoryModel::get(['catName', 'catID', 'imgPath'])->where('catType','Root');