Convert array with 3-element rows into hierarchical array with 3 levels

Question

I have an array that looks like this:

[98] => Array
(
    [City] => Caracas
    [Country] => Venezuela
    [Continent] => Latin America
)

[99] => Array
(
    [City] => Cairo
    [Country] => Egypt
    [Continent] => Middle East
)

[105] => Array
(
    [City] => Abu Dhabi
    [Country] => United Arab Emirates
    [Continent] => Middle East
)

[106] => Array
(
    [City] => Dubai
    [Country] => United Arab Emirates
    [Continent] => Middle East
)

[107] => Array
(
    [City] => Montreal
    [Country] => Canada
    [Continent] => North America
)

I am trying to group this array into a new multi-dimensional array structure, so that it outputs something like:

Continent
    - Country Name    
      -- Cities under Every Country

Exact desired result:

array (
  'Latin America' => 
  array (
    'Venezuela' => 
    array (
      0 => 'Caracas',
    ),
  ),
  'Middle East' => 
  array (
    'Egypt' => 
    array (
      0 => 'Cairo',
    ),
    'United Arab Emirates' => 
    array (
      0 => 'Abu Dhabi',
      1 => 'Dubai',
    ),
  ),
  'North America' => 
  array (
    'Canada' => 
    array (
      0 => 'Montreal',
    ),
  ),
)

Out of curiosity, how is the array being generated?

maiorano84
– maiorano84

2013-11-11 17:05:35 +00:00
Commented Nov 11, 2013 at 17:05 — maiorano84
– maiorano84, Commented Nov 11, 2013 at 17:05
I have a SQL query that returns the array.

raeq
– raeq

2013-11-11 17:07:50 +00:00
Commented Nov 11, 2013 at 17:07 — raeq
– raeq, Commented Nov 11, 2013 at 17:07
Maybe it's much easier to organize data by SQL grouping.

sbrbot
– sbrbot

2013-11-11 17:23:26 +00:00
Commented Nov 11, 2013 at 17:23 — sbrbot
– sbrbot, Commented Nov 11, 2013 at 17:23

Raphaël Malié · Accepted Answer · 2013-11-11 17:08:42Z

10

$array = array(
    98 => array(
        'City' => 'Caracas',
        'Country' => 'Venezuela',
        'Continent' => 'Latin America',
    ),
    99 => array(
        'City' => 'Cairo',
        'Country' => 'Egypt',
        'Continent' => 'Middle East',
    ),
    105 => array(
        'City' => 'Abu Dhabi',
        'Country' => 'United Arab Emirates',
        'Continent' => 'Middle East',
    ),
    106 => array(
        'City' => 'Dubai',
        'Country' => 'United Arab Emirates',
        'Continent' => 'Middle East',
    ),
    107 => array(
        'City' => 'Montreal',
        'Country' => 'Canada',
        'Continent' => 'North America',
    )
);

$newArray = array();
foreach ($array as $row)
{
   $newArray[$row['Continent']][$row['Country']][] = $row['City'];
}

print_r($newArray);

answered Nov 11, 2013 at 17:08

Raphaël Malié

4,0221 gold badge24 silver badges40 bronze badges

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

Comments

mickmackusa · Accepted Answer · 2023-01-15 06:49:28Z

1

A couple more alternative approaches:

Use "array destructuring" in a body-less foreach() to populate the hierarchical structure (Demo) (Further about the technique)

$result = [];
foreach (
    $array as
    [
        'Continent' => $a,
        'Country' => $b,
        'City' => $result[$a][$b][]
    ]
);
var_export($result);

Use array_reduce() to avoid declaring a result variable in the global scope. (Demo)

var_export(
    array_reduce(
        $array,
        function($result, $row) {
            $result[$row['Continent']][$row['Country']][] = $row['City'];
            return $result;
        }
    )
);

answered Jan 15, 2023 at 6:49

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

Comments

Peter de Groot · Accepted Answer · 2023-04-03 09:11:13Z

0

What about this solution:

function arrayToMultiDimensionalArray(array $elements, array $dimensions)
{
    $output = [];

    foreach ($elements as $element) {
        $outputElement =& $output;

        // Foreach to build up the dimensions
        foreach ($dimensions as $dimension) {
            $outputElement =& $outputElement[$element[$dimension]];
        }

        $outputElement[] = $element['City'];
    }

    return $output;
}

$dimensions = ['Continent', 'Country'];

$tree = arrayToMultiDimensionalArray($array, $dimensions);

edited Apr 3, 2023 at 9:11

answered Nov 12, 2021 at 19:55

Peter de Groot

8297 silver badges13 bronze badges

3 Comments

Peter de Groot Over a year ago

@mickmackusa Just change $outputElement[] = $element; to $outputElement[] = $element['City']; problem solved

Peter de Groot Over a year ago

@mickmackusa A "thank you" would be nice.

mickmackusa Over a year ago

Stack Overflow doesn't do "thank you"s. Just the same, you can thank me for bringing to your attention that your answer wasn't (and still isn't) the best version of itself. I know what your script is doing, but there will be many PHP developers who won't and they might not use it because they don't understand how it works.

Fabio · Accepted Answer · 2013-11-11 17:11:37Z

-1

I think you just need to loop in your array and create a new one using some values as keys and some other as value, for example

$new_array = array();
foreach($array as $val)
{ 
     $new_array[$val['Continent']][$val['Country']] = array('City' => $val['City']);
}

Live Sample

answered Nov 11, 2013 at 17:11

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

1 Comment

mickmackusa Over a year ago

This answer is incorrect because it only allows one city per subset. Proof: 3v4l.org/aDqFQ

Collectives™ on Stack Overflow

Convert array with 3-element rows into hierarchical array with 3 levels

4 Answers 4

Comments

Comments

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related