Sort and merge a multidimensional array by common value

Question

I have a multidimensional array and I'm trying to sort it by common value of one particular key, name in my case.

I already tried using a foreach to loop into the array, or using usort, but I just can't find the way to do it.

Notice how the values of the "Diamètre" key are merged into an array in the final result.

Array
(
    [0] => Array
        (
            [0]  => Array
                (
                    [name]  => Diamètre
                    [value]  => 5                   
                )

            [1]  => Array
                (
                    [name]  => Force
                    [value]  => 30                  
                )

        )

    [1]  => Array
         (

            [0]  => Array
                (
                    [name]  => Force
                    [value]  => 20             
                )

            [1]  => Array
                (
                    [name]  => Poids
                    [value]  => 50         
                )
          )
     [2]  => Array
         (
            [0]  => Array
                (
                    [name]  => Diamètre
                    [value]  => 40
                )

            [1]  => Array
                (
                    [name]  => Largeur
                    [value]  => 40
                )

          )
)

Expected result :

Array
(

            [0]  => Array
                (
                    [name]  => Diamètre
                    [value]  => Array (5, 40)                                                              
                )

            [1]  => Array
                (
                    [name]  => Force
                    [value]  => Array (30, 20)               
                )

             [2]  => Array
                 (
                    [name]  => Poids
                    [value]  => 50        
                 ) 

             [3]  => Array
               (
                    [name]  => Largeur
                    [value]  => 40
                )     
)

"I already tried many things" Show these things that you've tried. — Patrick Q, Apr 25 '18 at 20:40
Possible duplicate of [Sort Multi-dimensional Array by Value](https://stackoverflow.com/questions/2699086/sort-multi-dimensional-array-by-value) — GrumpyCrouton, Apr 25 '18 at 20:52
@GrumpyCrouton There seem to be a "merge the array when collisons occurs" here that I don't see in that duplicate target though. — Félix Adriyel Gagnon-Grenier, Apr 25 '18 at 21:32
@Marco is it important that the values in "Poids" and "Largeur" stay as single value, instead of arrays containing only one value? — Félix Adriyel Gagnon-Grenier, Apr 25 '18 at 21:36
@FélixGagnon-Grenier The requirements for that weren't even mentioned in the question — GrumpyCrouton, Apr 26 '18 at 12:29
@GrumpyCrouton I think they are very much mentioned when you actually read the desired output. Desired output being one of the things we ask of askers, it'd be great if you read it. — Félix Adriyel Gagnon-Grenier, Apr 26 '18 at 12:32
@FélixGagnon-Grenier Yes, it's in the output but the question itself does not mention this requirement or detail at all when and where it merges. Either way your right though it's not a correct target. — GrumpyCrouton, Apr 26 '18 at 12:33
@GrumpyCrouton good point, I was on the lucky side when adding it in the question. — Félix Adriyel Gagnon-Grenier, Apr 26 '18 at 12:35

Mkk · Accepted Answer · 2018-04-25T21:54:02.147

1

You could try something along the lines of:

$result = [];

foreach($array1 as $array2) {
    foreach($array2 as $item) {

        if(array_key_exists($item['name'], $result)) {
            $newItem = $result[$item['name']];

            $valueArray = (array) $item['value'];
            $newValueArray = (array) $newItem['value'];

            $newItem['value'] = array_merge($valueArray, $newValueArray);
        } else {
            $newItem = $item;
        }

            $result[$item['name']] = $newItem;
    }
}

// In case you don't want an associative array.
$result = array_values($result);

edited Apr 25 '18 at 21:54

answered Apr 25 '18 at 20:55

Mkk

433
3
8

Here the result @Mkk : Array ( [Diamètre] => Array ( [0] => 5 ) [Force] => Array ( [0] => 30 ) [Poids] => Array ( [0] => 50) ) – Marco Apr 25 '18 at 21:09

Sort and merge a multidimensional array by common value

1 Answers1