Group rows on one column and create nested array from another column

Question

I have an array that looks like this:

[
    [
        'name' => 'Umber',
        'reason' => 'No data',
        'id' => '12'
    ],
    [
        'name' => 'Jakar',
        'reason' => 'Wrong format',
        'id' => '12'
    ],
    [
        'name' => 'Lane',
        'reason' => 'No data',
        'id' => '12'
    ],
    [
        'name' => 'Jake',
        'reason' => 'Not found',
        'id' => '13'
    ],
    [
        'name' => 'Jame',
        'reason' => 'Wrong name',
        'id' => '13'
    ],
    [
        'name' => 'Joe',
        'reason' => 'No data',
        'id' => '13'
    ]
];

What I want to do is group these elements in a table row if the same id value:

12 | No data, wrong format, No data
13 | Not found, Wrong name, No data

I know I have to use foreach for this one but the logic for grouping these elements in a single row is beyond me. Any help would be appreciated. Thanks in advance. I've started with this.

foreach($a as $value){
    echo $value['id'] . ' ' . $value['reason'];
}

Group row data of a 2d array by a column and push another column as subarray items per group — mickmackusa
– mickmackusa ♦, Commented Jan 26 at 7:54

mickmackusa · Accepted Answer · 2021-11-10 14:10:09Z

6

First group elements to subarrays, then output each subarray:

$groups = [];
foreach($a as $value){
    $groups[$value['id']][] = $value['reason'];
}

foreach ($groups as $key => $value) {
    echo $key . ' | ' . implode(', ', $value);
}

edited Nov 10, 2021 at 14:10

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

answered Sep 12, 2017 at 14:04

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

Comments

mickmackusa · Accepted Answer · 2021-11-10 14:10:51Z

1

Something like this, perhaps. It should help get you started:

$output = [];
foreach ($arrary as $arr) {
    $output[$arr['id']][] = $arr['reason'];
}

foreach ($output as $k => $v) {
    echo $k;
    echo implode(',', $v);
}

edited Nov 10, 2021 at 14:10

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

answered Sep 12, 2017 at 14:04

OptimusCrime

14.9k13 gold badges63 silver badges98 bronze badges

Comments

mickmackusa · Accepted Answer · 2021-09-02 11:26:09Z

0

In PHP, it is not necessary to declare an empty parent array before pushing data into it using square brace syntax.

Use the id values as keys and push the reason values into the group's array.

Codes: (Demo)

$result = [];
foreach ($array as $row) {
    $result[$row['id']][] = $row['reason'];
}
var_export($result);

Or functional syntax:

var_export(
    array_reduce(
        $array,
        function($result, $row) {
            $result[$row['id']][] = $row['reason'];
            return $result;
        },
        []
    )
);

Output:

array (
  12 => 
  array (
    0 => 'No data',
    1 => 'Wrong format',
    2 => 'No data',
  ),
  13 => 
  array (
    0 => 'Not found',
    1 => 'Wrong name',
    2 => 'No data',
  ),
)

edited Sep 2, 2021 at 11:26

answered Sep 2, 2021 at 11:20

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

Collectives™ on Stack Overflow

Group rows on one column and create nested array from another column

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related