Laravel build an array from query results

Question

here are some objects which i fetch from query results

{
    {
        "name": "John",
        "notification": "sms"
    },
    {
        "name": "John",
        "notification": "email"
    },
}

From those results, i want to build an array like this

{
   "name":"John",
   "notification":['email', 'sms']
}

Anyone who can light up my day?

The source is an array of objects? The name is unique or you can have different names in same array? — fusion3k
– fusion3k, Commented Apr 19, 2016 at 12:18

fusion3k · Accepted Answer · 2016-04-19 12:30:32Z

1

Assuming your original object is an array of objects, if you want a single object as result, you can do this ($data is your original array):

$result = (object) [ 'name' => $data[0]->name, 'notifications' => [] ];
foreach( $data as $item ) $result->notifications[] = $item->notification;

On php 7, you can also do this:

$result = (object) [ 'name' => $data[0]->name, 'notifications' => array_column( $data, 'notification' ) ];

Both examples have this result:

stdClass Object
(
    [name] => John
    [notifications] => Array
        (
            [0] => sms
            [1] => email
        )

)

Or, wiht JSON syntax:

{"name":"John","notifications":["sms","email"]}

answered Apr 19, 2016 at 12:30

fusion3k

11.7k4 gold badges27 silver badges47 bronze badges

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

1 Comment

Thank you @fusion3k, this answer is very helpful for me, you save my day