Assign value from array as key and merge records of same key

Question

I have array like below in PHP (Codeigniter). I want to group them by using country names. So value of country key will become key of outer array

Array
(
    [0] => Array
        (
            [city] => Buenos Aires
            [country] => Argentina
        )

    [1] => Array
        (
            [city] => Adelaide
            [country] => Australia
        )

    [2] => Array
        (
            [city] => Brisbane
            [country] => Australia
        )

    [3] => Array
        (
            [city] => Fremantle
            [country] => Australia
        )

    [4] => Array
        (
            [city] => Melbourne
            [country] => Australia
        )

    [5] => Array
        (
            [city] => Sydney
            [country] => Australia
        )

)

I want to convert it into array like below so country will become key with city list as per country name

Array
(
    [Argentina] => Array
    (
        [0] => Buenos Aires
    )

    [Australia] => Array
    (
        [0] => Adelaide
        [1] => Brisbane
        [2] => Melbourne
        [3] => Sydney
    )

)

@u_mulder.. I tried many things in for loop but was not working as expected — hrishi
– hrishi, Commented Jan 6, 2017 at 8:56

Rahul · Accepted Answer · 2017-01-06 08:48:45Z

1

Here is the code,

$arr = [//your arr];

$result = []; // will be your output

foreach($arr as $k => $v){
   $result[$v['country']][] = $v['city'];
}

I hope this will work

answered Jan 6, 2017 at 8:48

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

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

1 Comment

Rahul Over a year ago

Welcome ! If this solution solves your problem, please accept my answer.

Collectives™ on Stack Overflow

Assign value from array as key and merge records of same key

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related