Format multi dimensional array using Laravel collections

Question

I have an array like this , which I am getting as a result of a database query (Google BigQuery) :

Array
(
    [0] => Array
        (
            [points] => 95
            [user] => 434
            [type] => 20
            [identifier] => tv
            [date] => 2016-11-01
        )

    [1] => Array
        (
            [points] => 349
            [id] => 2989631
            [type] => 20
            [identifier] => app
            [date] => 2016-11-01
        )
)

and another one for identifiers :

Array
(
    [tv] => 1
    [app] => 2
)

What I need is to do is to transform the array as the identifier key has corresponding value from identifiers array. So it will look like :

Array
(
    [0] => Array
        (
            [points] => 95
            [user] => 434
            [type] => 20
            [identifier] => 1
            [date] => 2016-11-01
        )

    [1] => Array
        (
            [points] => 349
            [id] => 2989631
            [type] => 20
            [identifier] => 2
            [date] => 2016-11-01
        )
)

How can I do this using Laravel collections ?

I have been trying with transform function, but not getting an idea to return specific column from the multidimensional array.

Armin Sam · Accepted Answer · 2016-11-09 09:35:58Z

1

You can use array_map():

$identifiers = [
    'tv' => 1,
    'app' => 2
];

$result = array_map(function($item) use ($identifiers) {
    $item['identifier'] = $identifiers[$item['identifier']];
    return $item;
}, $itemsArray);

edited Nov 9, 2016 at 9:35

answered Nov 9, 2016 at 9:27

Armin Sam

9339 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alexey Mezenin · Accepted Answer · 2016-11-09 09:13:39Z

0

Probably the best solution here would be using an acessor:

public function getIdentifier($value)
{
    return $identifiersArray[$value];
}

If you do this, you will not need to rebuild your collection.

answered Nov 9, 2016 at 9:13

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

1 Comment

Happy Coder Over a year ago

One thing is I am using Google Bigquery as the database and so using their API to execute query. They are basically returning an array.

Collectives™ on Stack Overflow

Format multi dimensional array using Laravel collections

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related