Laravel Eloquent: Return Array key as the fields ID

Question

When I execute a query via Laravel's Eloquent ORM, I want to get the row ID as the Array result key, this will make things easier when I want to check something based on an ID (using array_key_exists) or do some look ups (if I need a specific entry from the result array)

Is there any way I can tell Eloquent to set the key to the fields ID? see image http://oi60.tinypic.com/kc02a8.jpg

score 30 · Answer 1

You can simply do

    Model::all()->keyBy('category_id');

Cheers :)

score 25 · Answer 2

Since you have an Eloquent Collection (a child class of the generic Collection class) you can use the getDictionary method. $collection->getDictionary() will give you an array of your Category objects keyed by their primary keys.

If you wanted another Collection rather than a native PHP array, you could instead use $collection->keyBy($property). It looks like your primary key is category_id, so $collection->keyBy('category_id'). You can use that method to key by any arbitrary property, including any get mutators you may have written.

While getDictionary is unique to the Eloquent Collection extension, keyBy is available to all Laravel Collection objects. See the Laravel 4.2 API docs or Laravel 5.0 API docs.

score 5 · Answer 3

You have a Support\Collection/Database\Eloquent\Collection you can use the method lists('id') to return an array of the id of each of the models within the collection.

Then use array_combine to map the keys to the models. The result of which will be an array with the id mapped to their corresponding model.

score 0 · Answer 4

If you need id as the key, then rely on the Collection:

$collection = Model::all();

$collection->getDictionary();

// returns:
array(
  1 => object(Model) ( ... ),
  2 => object(Model) ( ... ),
  ...
  idN => object(Model) ( ... )
);

Otherwise, nice or not, you can do this:

$keys = $collection->lists('columnName');

$arrayOfModels = array_combine($keys, $collection->getDictionary);

You are here

laravel eloquent get collection key is id 作为 collection 数组的键数组键 id 为键有大用

Laravel Eloquent: Return Array key as the fields ID

4 Answers 正确答案

友情链接

up vote30down vote	You can simply do Model::all()->keyBy('category_id'); Cheers :) shareimprove this answeranswered Feb 6 '16 at 22:18Bhoj Raj Bhatta511712
	add a comment

搜索表单

用户登录

You are here

laravel eloquent get collection key is id 作为 collection 数组的键 数组键 id 为键 有大用

Laravel Eloquent: Return Array key as the fields ID

4 Answers 正确答案

友情链接

laravel eloquent get collection key is id 作为 collection 数组的键数组键 id 为键有大用