Group rows of a 2d array and restructure as a multidimensional array

Question

I have an array like this

[
    1 => [
        'name'             => 123,
        'id'               => 105740727,
        'email'            => 'fghfhfh',
        'phrases_relevant' => 123,
        'searches_id'      => 105740727,
    ],
    2 => [
        'name'             => 'porshe',
        'id'               => 105713889,
        'email'            => 'fghfghf',
        'phrases_relevant' => 'porshe',
        'searches_id'      => 105713889,
    ],
    3 => [
        'name'             => 'porshe',
        'id'               => 105713889,
        'email'            => 'fghfghf',
        'phrases_relevant' => 'merce',
        'searches_id'      => 105713889,
    ],
]

I need group this group via value. Output array should looks like below. dimension second and third has same searches_id

  [0] => Array
    (
        [email] => fghfghf
        [projects]=>
              [porshe] => [porshe, merce]
  [1] => ...

My code:

foreach ($results as $key => $result) {
     $testArray[]['projects'][$result['name']][] = $result['phrases_relevant'];

but this insert one phrases.

Why is phrases_relevant value 123 missing in your output? Your output example is very incomplete. Could you complete it for the given input? — KIKO Software
– KIKO Software, Commented May 20, 2019 at 9:49
Examples always matter in questions, but I think I know what you want. You want to group the array entries on searches_id. So the columns name, id, email and phrases_relevant can all vary when the searches_id is the same? Or does only the phrases_relevant vary, as in your example? — KIKO Software
– KIKO Software, Commented May 20, 2019 at 9:54
if we will group searches id, email will be same everywhere. Name it is always first element phrases_relevant, so it connection. — Pekus
– Pekus, Commented May 20, 2019 at 9:58

Rahul · Accepted Answer · 2019-05-20 10:01:19Z

2

You need to sort first by searches_id then apply loop,

function sortByOrder($a, $b)
{
    return $a['searches_id'] - $b['searches_id'];
}
usort($myArray, 'sortByOrder');
foreach ($myArray as $key => $value) {
    $result[$value['searches_id']]['email']      = $value['email'];
    $result[$value['searches_id']]['projects'][] = $value['phrases_relevant'];
}
$result = array_values($result); // reset keys used for array generation

Working demo.

answered May 20, 2019 at 10:01

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

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

Comments

Rakesh Jakhar · Accepted Answer · 2019-05-20 09:56:12Z

1

You can use foreach

$res = [];
foreach($arr as $key => $value){

array_key_exists($value['id'], $res) ?
    ($res[$value['id']]['phrases_relevant'] = $res[$value['id']]['phrases_relevant'].','.$value['phrases_relevant'])
:
($res[$value['id']] = ['email' => $value['email'],'phrases_relevant' => $value['phrases_relevant']]);
}
print_r(array_values($res))

Live Demo

answered May 20, 2019 at 9:56

Rakesh Jakhar

6,4082 gold badges13 silver badges20 bronze badges

1 Comment

Nick Over a year ago

Using a ternary operator instead of the far more appropriate if/else makes this code almost impossible to understand.

mickmackusa · Accepted Answer · 2024-10-31 08:15:18Z

By using symmetrical array destructuring syntax inside a body-less loop, you can isolate only the row values that you need and push the data into groups. When the loop finishes, call array_values() to re-index the result array. Demo

foreach (
    $array as [
        'id' => $id,
        'name' => $name,
        'email' => $result[$id]['email'],
        'phrases_relevant' => $result[$id]['projects'][$name][]
    ]
);
var_export(array_values($result));

Output:

array (
  0 => 
  array (
    'email' => 'fghfhfh',
    'projects' => 
    array (
      123 => 
      array (
        0 => 123,
      ),
    ),
  ),
  1 => 
  array (
    'email' => 'fghfghf',
    'projects' => 
    array (
      'porshe' => 
      array (
        0 => 'porshe',
        1 => 'merce',
      ),
    ),
  ),
)

Collectives™ on Stack Overflow

Group rows of a 2d array and restructure as a multidimensional array

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related