如果某些键相似，则合并数组中的数据

Question

Array (
        [0] => Array (
            [Name] => Banana
            [Percentage] => 25
            [Sum] => 70
        )
        [1] => Array (
            [Name] => Banana
            [Percentage] => 25
            [Sum] => 168
        )
        [2] => Array (
            [Name] => Apple
            [Percentage] => 14
            [Sum] => 8
        )
    )

How can I merge the value only if keys [Name] and [Percentage] is similar to the other one in the array ?

For example, I search to have something like this:

Array (
    [0] => Array (
        [Name] => Banana
        [Percentage] => 25
        [Sum] => 238
    )
    [1] => Array (
        [Name] => Apple
        [Percentage] => 14
        [Sum] => 8
    )
)

Here's what I tried:

foreach($myArray as $value){
    $Name = $value['Name'];
    if(isset($result[$Name]))
        $index = count($result[$Name]);
    else
        $index = 1;

    $result['Name'] = $Name;
    $result['Percentage'] = $value['Percentage'];
    $result['Sum'] += $value['Sum'];        
}
$result = array_values($result);

Thanks.

Answer 1

The problem with what you currently have is that you are just kind of duplicating what you already have in your original array except you are throwing in a failed sum with $result['Sum'] += $value['Sum'];. See new example with notations below:

# Try setting a storing array
$new    =   array();
#loop through the array
foreach($array as $row) {
    # Check if you have already set the sum for this name type
    if(isset($new[$row['Name']]['Sum']))
        # Add new and stored value together
        $sum    =   $new[$row['Name']]['Sum'] + $row['Sum'];
    else
        # If not already set, set it
        $sum    =   $row['Sum'];
    # Start storing values into the new array. It's easiest to set the key
    # as the name value so it saves to unique keys
    $new[$row['Name']]  =   array(
        'Name'=>$row['Name'],
        'Percentage'=>$row['Percentage'],
        'Sum'=>$sum
    );
}

print_r(array_values($new));