php - Extract subset of fields from within a Laravel collection

I have a Laravel collection like this (approximating using array syntax; the actual data is aCollection ofobjects obtained from an API response, not a local DB):

$rows = [
  [
    'id': 1,
    'name': 'Sue',
    'age': 23,
  ],
  [
    'id': 2,
    'name': 'Joe',
    'age': 25,
  ],
]
Copy code

I want to extract a subset of the fields:

$subset = [];
foreach ($rows as $row) {
  $subset[] = ['name' => $row['name'], 'age' => $row['age']];
}
Copy code

So that I end up with:

$subset = [
  [
    'name': 'Sue',
    'age': 23,
  ],
  [
    'name': 'Joe',
    'age': 25,
  ],
]
Copy code

What should I use to achieve that instead of thefor loop?

I found this suggestion, using a higher-order message, which made some kind of sense:

$subset = $rows->map->only(['name', 'age']);
Copy code

but that just gives me aCollection ofnull values. Expanding it into a conventionalmap call produced the same effect. I feel like I want some kind ofmultipluck, but I'm not sure what that corresponds to!

Update

It turns out that I was doing this correctly with the higher-ordermap->only approach. However, while the items in my collection were a kind ofModel, they were not a subclass or compatible implementation of the LaravelModel class, and lacked an implementation of theonly method. The author added the method, and now it works as expected.

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.