Laravel Eloquent Group Result in array

Question

I have a table called "grids". Columns are id, floor, and grid.

id                 floor           grid
==========         =======       =======
1                     EG            LEFT
2                     EG            RIGHT
3                     DG            LEFT
4                     DG            RIGHT

When I get all my data with:

$data = Grid::all()

I have an array with 0 => Grid Object 1, 1 => Grid Object 2, and so on..

But how is it possible to group my Result in an array like this:

$data = array(
        'EG' => array(
            'LEFT' => Grid Object 1,
            'RIGHT' => Grid Object 2,
        )
        'DG' => array(
            'LEFT' => Grid Object 3,
            'RIGHT' => Grid Object 4,
        )
    )

Thanks in advance

fourzero · Accepted Answer · 2017-11-30 10:05:10Z

3

As of present Laravel versions, you can use the groupBy function

$data = $data->groupBy('floor');

Will give you the desired array

answered Nov 30, 2017 at 10:05

fourzero

615 bronze badges

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

Comments

lukasgeiter · Accepted Answer · 2014-12-15 14:50:46Z

1

I think you'll have to do that manually. Meaning loop through the collection and build the new structure

$result = array();
foreach($data as $d){
    if(!isset($result[$d->floor])){
        $result[$d->floor] = array();
    }
    $result[$d->floor][$d->grid] = $d;
}

answered Dec 15, 2014 at 14:50

lukasgeiter

154k29 gold badges349 silver badges280 bronze badges

2 Comments

goldlife Over a year ago

okay thanks. I feared it. I thought there might be a laravel eloquent function for this ...

lukasgeiter Over a year ago

Not as far as I know. But it's not "bad" when you have to do some things yourself.. ;)

Collectives™ on Stack Overflow

Laravel Eloquent Group Result in array

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related