PHP - Sort Array By SubArray Value By Maintaining original Array key

Question

I would like to Sort an Array with its sub array value ("Name") but keeping its original array key.

default Array:

Array (
    [251] => Array
        (
            [color] => 
            [name] => 8
            [nbr] => 1
            [url_name] => taille-8
            [meta_title] => 
        )

    [323] => Array
        (
            [color] => 
            [name] => 7
            [nbr] => 2
            [url_name] => taille-7
            [meta_title] => 
        )

    [127] => Array
        (
            [color] => 
            [name] => 34
            [nbr] => 2
            [url_name] => taille-34
            [meta_title] => 
        )
);

By using array_multisort, I can able to get following Array:

Array(
    [0] => Array
        (
            [color] => 
            [name] => 7
            [nbr] => 2
            [url_name] => taille-7
            [meta_title] => 
        )

    [1] => Array
        (
            [color] => 
            [name] => 8
            [nbr] => 1
            [url_name] => taille-8
            [meta_title] => 
        )

    [2] => Array
        (
            [color] => 
            [name] => 34
            [nbr] => 2
            [url_name] => taille-34
            [meta_title] => 
        )
);

But what i need is,

Array(
    [323] => Array
        (
            [color] => 
            [name] => 7
            [nbr] => 2
            [url_name] => taille-7
            [meta_title] => 
        )

    [251] => Array
        (
            [color] => 
            [name] => 8
            [nbr] => 1
            [url_name] => taille-8
            [meta_title] => 
        )

    [127] => Array
        (
            [color] => 
            [name] => 34
            [nbr] => 2
            [url_name] => taille-34
            [meta_title] => 
        )
);

Thanks in adv :)

check usort function

jitendrapurohit
– jitendrapurohit

2016-09-20 09:10:42 +00:00
Commented Sep 20, 2016 at 9:10 — jitendrapurohit
– jitendrapurohit, Commented Sep 20, 2016 at 9:10
please add array_multisort code

Noman
– Noman

2016-09-20 09:10:44 +00:00
Commented Sep 20, 2016 at 9:10 — Noman
– Noman, Commented Sep 20, 2016 at 9:10

jmarceli · Accepted Answer · 2018-05-17 13:10:04Z

3

I would go with uasort, it looks much simpler to me:

// $arr is your Array
uasort($arr, function ($a, $b) {
  return $a['name'] - $b['name'];
});

Here is an example: http://sandbox.onlinephpfunctions.com/code/a9f2d1e9702834b3a35206125429739222770301

answered May 17, 2018 at 13:10

jmarceli

20.3k6 gold badges73 silver badges69 bronze badges

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

Comments

Jan Holas · Accepted Answer · 2016-09-20 09:14:21Z

1

$arr being your array:

//obtain list of values to sort by
foreach ($arr as $id => $value) {
    $names[$id] = $value['name'];
}
$keys = array_keys($arr);
array_multisort(
    $names, SORT_ASC, SORT_NUMERIC, $arr, $keys
);
$result = array_combine($keys, $arr);

You were probably missing the last step combining the array with given keys.

answered Sep 20, 2016 at 9:14

Jan Holas

2782 silver badges11 bronze badges

2 Comments

Narayan Bhandari Over a year ago

I have checked your code, Does not gives the result

Jan Holas Over a year ago

@NarayanBhandari check again, please: sandbox.onlinephpfunctions.com/code/…

Noman · Accepted Answer · 2016-09-20 09:35:27Z

1

$arr assuming your array containing numeric keys and sort it by using array_multisort.

array_multisort will return sorted array.
array_combine will combine your original keys with sorted array.

Use:

$result = array_sort_by_column_preserve_keys($arr);
echo '<pre>';print_r($result);echo '</pre>';

Method :

function array_sort_by_column_preserve_keys($arr) {
    $ar2 = [];
    foreach($arr as $key => $sub) {
        $ar2[ $key ] = $sub;
    }
    $keys = array_keys($arr);
    array_multisort($ar2, SORT_ASC, SORT_NUMERIC, $arr, $keys);
    return $result = array_combine($keys, $arr);
}

edited Sep 20, 2016 at 9:35

answered Sep 20, 2016 at 9:26

Noman

4,1361 gold badge23 silver badges37 bronze badges

1 Comment

Jan Holas Over a year ago

You could have edited my answer, since it's basically the same.

Narayan Bhandari · Accepted Answer · 2016-09-20 12:36:46Z

Please try this,

$array=array(
    "251" => array(
        "color" => "",
        "name" => 8,
        "nbr" => 1,
        "url_name" => "taille-8",
        "meta_title" => ""),

    "323" => array(
        "color" => "",
        "name" => 7,
        "nbr" => 2,
        "url_name" => "taille-7",
        "meta_title" => ""),
    "127" => array(
        "color" => "",
        "name" => 34,
        "nbr" => 2,
        "url_name" => "taille-34",
        "meta_title" => ""),
    );
function swapArray( &$arr,$firstPos,$secondPos){
    //echo PHP_EOL."swap: ".$firstPos.", ".$secondPos.PHP_EOL;
    foreach($arr[$firstPos] as $k=>$v){
        //echo PHP_EOL.$k." => ".$v.PHP_EOL;
        $tmp=$v;
        $arr[$firstPos][$k]=$arr[$secondPos][$k];
        $arr[$secondPos][$k]=$tmp;
    }
}
    var_dump($array);

    $keys=array(); // store all key values
    $num=count($array);

    foreach($array as $key=>$tmpArray)
        $keys[]=$key;

    //var_dump($keys);

    for($i=0; $i<$num; $i++){
        for($j=$i+1; $j<$num; $j++){
            if($array[$keys[$i]]["name"]>$array[$keys[$j]]["name"]){
                swapArray($array,$keys[$i],$keys[$j]);
            }
        }
    }


    var_dump($array);

Collectives™ on Stack Overflow

PHP - Sort Array By SubArray Value By Maintaining original Array key

4 Answers 4

Comments

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related