Laravel - how to group data by key and save to array?

Question

I have table attribute_values(id, value, attr_group_id).
I need to return the collection grouped by key attr_group_id.

in clear php using ORM RedBean i made:

$data = \DB::table('attribute_values')->get();
$attrs = [];
foreach ($data as $k => $v){
    $attrs [$v['attr_group_id']][$k] = $v['value'];
   }
return $attrs;

I need same using Laravel, after this one:

  $data = \DB::table('attribute_values')->get();

My table

  id    value     attr_group_id
   1     one          1
   2     two          1
   3     three        2
   4     four         2
   5     five         3
   6     six          3

And i need result

   Array(
[1] => Array 
    (
    [1] => one
    [2] => two
    )
[2] => Array 
    (
    [3] => three
    [4] => four
    )
[3] => Array 
    (
    [5] => five
    [6] => six
    )
  )

sorry, my pictures. my table : prntscr.com/o18o89 and i need result: prntscr.com/o18oxp — Alex Batashov
– Alex Batashov, Commented Jun 13, 2019 at 8:11
try $data = \DB::table('attribute_values')->groupBy('attr_group_id')->get(); — Sohel0415
– Sohel0415, Commented Jun 13, 2019 at 8:15
no i havent. I do not want to create a separate model for this. — Alex Batashov
– Alex Batashov, Commented Jun 13, 2019 at 8:34
@ Sohel0415 it wont work because you are grouping the record in mysql query so the first record from each attr_group_id will be returened and rest of them will be skipped — ManojKiran
– ManojKiran, Commented Jun 13, 2019 at 9:37

Rahul · Accepted Answer · 2019-06-13 09:05:06Z

7

Fetch all data, and map it with attribute id of every row will work,

$data = \DB::table('attribute_values')->get();
$attrs = [];
foreach ($data as $key => $value) {
    // -> as it return std object
    $attrs[$value->attr_group_id][] = $value->value;
}
dd($attrs);

edited Jun 13, 2019 at 9:05

answered Jun 13, 2019 at 8:13

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

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

9 Comments

Alex Batashov Over a year ago

Please check my question. I made adjustments and added what I need: My table and need result.

ManojKiran Over a year ago

try answer by @Martin Henriksen

ManojKiran Over a year ago

since laravel has a collection so you don't need foreach

ManojKiran Over a year ago

@Drakula Predator Larevel Version please

Rahul Over a year ago

Ok if we will group by attr_group_id it won't give two results for the same attr_group_id but OP's result has two records per each attr_group_id. So @Martin Henriksen's data will fetch only three records and will skip remaining from each attr_group_id.

|

Jasmel Singh · Accepted Answer · 2019-06-13 08:29:06Z

3

You can use the groupBy() function of collection as:

$data = \DB::table('attribute_values')->get()->groupBy('attr_group_id');

It merges records with same attr_group_id under this field's value as making key of the collection.

answered Jun 13, 2019 at 8:29

Jasmel Singh

1211 silver badge7 bronze badges

2 Comments

Alex Batashov Over a year ago

Please check my question. I made adjustments and added what I need: My table and need result.

Jasmel Singh Over a year ago

@SashaSan - This function creates a collection making attr_group_id attribute as a collection key. If you want to convert it into an array you can also use toArray() function of collection.

mrhn · Accepted Answer · 2019-06-13 09:43:39Z

3

Doing all this in raw SQL will be more efficient, SQL database are quite good at these operations. SQL has a group by function, since you are overwriting value, i just get it out with max() (this seems weird, that you overwrite the value, do you actually just want unique results?).

DB::table('attribute_values')
    ->select('attr_group_id', DB::raw('max(value)'))
    ->groupBy('attr_group_id')
    ->get();

EDIT Since the scope has changed, you can utilize Laravels Collection methods, that is opreations on a Collection.

DB::table('attribute_values')
    ->get()
    ->groupBy('attr_group_id')
    ->toArray();

edited Jun 13, 2019 at 9:43

answered Jun 13, 2019 at 8:17

mrhn

19.1k6 gold badges31 silver badges48 bronze badges

3 Comments

Alex Batashov Over a year ago

Please check my question. I made adjustments and added what I need: My table and need result.

ManojKiran Over a year ago

its the elegant way using colletion

Alex Batashov Over a year ago

Please check my answer. it is described below. I made it for you. explained what the task was and how it was solved.

Alex Batashov · Accepted Answer · 2019-06-13 13:48:58Z

2

Friends, this is a ready task that I needed ! I did it myself and you helped me. If anyone interested can read.

I'll explain to you why I needed this particular method. I am doing an online store with a clock and now there was a task to make filters and attributes for filters. So there are three tables

attribute_groups table

attribute_products table

attribute_values

I need to display the Laravel widget on my .blade.php like as

{{ Widget::run('filter', 'tpl' => 'widgets.filter', 'filter' => null,]) }}

When i creating a new product in the admin panel. I must to save the product id and attribute_id in attribute_products, but there can be as many attributes as possible for one product. so, if I'll use this option

$data = \DB::table('attribute_values')
            ->get()
            ->groupBy('attr_group_id')
            ->toArray();

I got result:

But! each new array starts with index 0. But I need an index that means its id. attr_group_id from table attribute_value for saving into attribute_products. And after I see only one method for me.

$data = \DB::table('attribute_values')->get();
        $attrs = [];
        foreach ($data as $key => $value) {
            $attrs[$value->attr_group_id][$value->id] = $value->value;
        }

        return $attrs;

and the result I was looking for

now you can see what's the difference and what was needed. Array index starts 1,2,3,4,5 and this index = attr_group_id. Unfortunately I could not initially ask the right question. thanks to all.

edited Jun 13, 2019 at 13:48

answered Jun 13, 2019 at 13:31

Alex Batashov

3071 gold badge2 silver badges14 bronze badges

2 Comments

ManojKiran Over a year ago

can you share the sql file wih some data. i will dig deeper into it and fulfill your requirement

Alex Batashov Over a year ago

bro ) I have already did what I needed .. I share my completed task.

ManojKiran · Accepted Answer · 2019-06-13 09:35:45Z

1

Laravel Version 5.8

So You need to Group the id if You need in the Model Way I have created the Model as AttributeValue

$modelWay = \App\AttributeValue::get()
            ->groupBy('attr_group_id');

if You need in the DBWay I have created the table as attribute_values

$dbWay = \DB::table('attribute_values')
        ->get()
        ->groupBy('attr_group_id');

Both Will give the Same Result

answered Jun 13, 2019 at 9:35

ManojKiran

6,3604 gold badges35 silver badges44 bronze badges

1 Comment

Alex Batashov Over a year ago

Please check my answer. it is described below. I made it for you. explained what the task was and how it was solved.

Collectives™ on Stack Overflow

Laravel - how to group data by key and save to array?

5 Answers 5

9 Comments

2 Comments

3 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

9 Comments

2 Comments

3 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related