PHP associative array merge with unique values

Question

I have an array which looks like this

$array=Array ( [0] => Array ( [Country] => United Arab Emirates [users] => 2 )
        [1] => Array ( [Country] => Albania [users] => 1 ) 
        [2] => Array ( [Country] => Armenia [users] => 4 ) 
        [3] => Array ( [Country] => Argentina [users] => 12 )
        [4] => Array ( [Country] => United Arab Emirates [users] => 3 ) 
        [5] => Array ( [Country] => Austria [users] => 1 ) 
        [6] => Array ( [Country] => Austria [users] => 8 ) 
        [7] => Array ( [Country] => Austria [users] => 1 ) )

I want to add second value if 1st value are same. i have tried array_unique($array) but not able to add second value if first values are same.

So the output i expected is

Array ( [0] => Array ( [Country] => United Arab Emirates [users] => 5 )
        [1] => Array ( [Country] => Albania [users] => 1 ) 
        [2] => Array ( [Country] => Armenia [users] => 4 ) 
        [3] => Array ( [Country] => Argentina [users] => 12 )
        [4] => Array ( [Country] => Austria [users] => 10 ))

I tried as below but not able to solve

$array=array_unique($array)
and 
        foreach ($array as $unique){
            if( in_array( $unique['Country'] ,$array) )
            {
                print_r ($unique['Country']);
            }
        }

Can you help me out?

Sudhir Bastakoti · Accepted Answer · 2018-01-25 06:11:47Z

4

you can use array_reduce, like:

$sum = array_reduce($data, function ($a, $b) {
    isset($a[$b['Country']]) ? $a[$b['Country']]['users'] += $b['users'] : $a[$b['Country']] = $b;  
    return $a;
});


echo "<pre>"; print_r(array_values($sum));

answered Jan 25, 2018 at 6:11

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

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

Comments

Eddie · Accepted Answer · 2018-01-25 06:15:56Z

You can do a classic foreach loop for this:

$result = array();

foreach( $array as $value ){
    if( !isset( $result[ $value[ "Country" ] ] ) ) $result[ $value[ "Country" ] ] = $value;
    else $result[ $value[ "Country" ] ][ "users" ] += $value[ "users" ];
}

$result = array_values($result);

This will result to:

Array
(
    [0] => Array
        (
            [Country] => United Arab Emirates
            [users] => 5
        )

    [1] => Array
        (
            [Country] => Albania
            [users] => 1
        )

    [2] => Array
        (
            [Country] => Armenia
            [users] => 4
        )

    [3] => Array
        (
            [Country] => Argentina
            [users] => 12
        )

    [4] => Array
        (
            [Country] => Austria
            [users] => 10
        )

)

pankaj · Accepted Answer · 2020-02-14 14:50:38Z

2

you can make unique using this method

array_unique($associativeArray,SORT_REGULAR);

Define an associative array $associativeArray with name and age keys.

 $associativeArray[] = array("name" => "pankaj Singh","no"=>4);
 $associativeArray[] = array("name" => "pankaj Singh","no"=>24);

answered Feb 14, 2020 at 14:50

pankaj

1,97026 silver badges37 bronze badges

Comments

M. Eriksson · Accepted Answer · 2018-01-25 06:22:43Z

You can simply iterate through the first array and summarize them your self:

$array = [
    [ "Country" => "United Arab Emirates", "users" => 2 ],
    [ "Country" => "Albania", "users" => 1 ], 
    [ "Country" => "Armenia", "users" => 4 ], 
    [ "Country" => "Argentina", "users" => 12 ],
    [ "Country" => "United Arab Emirates", "users" => 3 ], 
    [ "Country" => "Austria", "users" => 1 ], 
    [ "Country" => "Austria", "users" => 8 ], 
    [ "Country" => "Austria", "users" => 1 ], 
 ];

 $new = [];

 foreach ($array as $item) {
     // Check if we already have added the country to the new array
     if (empty($new[$item['Country']])) {
         // The country doesn't exist, add it
         $new[$item['Country']] = ['Country' => $item['Country'], 'users' => 0]; 
     }

     // Add the amount of users
     $new[$item['Country']]['users'] += $item['users'];
 }

 // Since we used the country as key, we can use array_values() 
 // to get it as an array with numeric indexes again.
 $new = array_values($new);

Demo: https://3v4l.org/ZuUoL

user8352901 · Accepted Answer · 2018-01-25 06:10:41Z

0

You can use PHP function

    in_array()

try this

  $array=array();
  foreach($array as $k=>$v){
  foreach($v as $key=>$value){
    if(!in_array($value, $array)){
    $array[]=$value;
    }
  }
 }

answered Jan 25, 2018 at 6:10

user8352901

Comments

Robin Rai · Accepted Answer · 2018-01-25 06:23:00Z

0

Try This out. I Hope this will help you out :

$country_users = array();
foreach ($array as $each) {
    $value = $each['users'];
    if (array_key_exists($each['Country'], $country_users)) {
        $prev_users = $country_users[$each['Country']];
        $value = $each['users'] + $prev_users;
    }
    $country_users[$each['Country']] = $value;
}
unset($array);
foreach ($country_users as $country=>$users) {
    $array[] = array('Country' => $country, 'users' => $users);
}
echo '<pre>';
print_r($array);

answered Jan 25, 2018 at 6:23

Robin Rai

3823 silver badges14 bronze badges

Comments

vishwas jadav · Accepted Answer · 2018-01-25 06:45:52Z

0

you will get your result by this code:

$request = array();
    foreach ($yourArray as $key => $value) {
      if (!in_array($value['country'], $request)) {
        $request[] = $value['country'];
      }
      else {
        unset($yourArray[$key]);
      }
    }
    print_r($yourArray);

answered Jan 25, 2018 at 6:45

vishwas jadav

2991 gold badge5 silver badges18 bronze badges

Comments

Juljan · Accepted Answer · 2018-01-25 06:53:56Z

0

You may simple use array_merge_recursive(), array_unique(), in_array() functions. As you saw advice above. But my advice is change array structure (if it's possible) to have associative array with country name as key and count as value. It would be more simple and clear to operate and understand.

$array = [
    'Austria' => 12,
];

You may change array structure later for response as you need. But operating with key-value structure helps you prevent a lot of troubles, I believe.

answered Jan 25, 2018 at 6:53

Juljan

2,5461 gold badge19 silver badges21 bronze badges

Collectives™ on Stack Overflow

PHP associative array merge with unique values

8 Answers 8

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related