Sort a 3 level multi-dimension array by value in PHP

Question

Here is the array,

array(
[0] => Array
        (
            [IdRedeemProduct] => Item-A
            [RedeemOptions] => Array
                (
                    [0] => Array
                        (
                            [Points] => 1000
                        )

                    [1] => Array
                        (
                            [Points] => 2000
                        )

                    [2] => Array
                        (
                            [Points] => 43000
                        )

                )

            [ProductType] => 1
        )
[1] => Array
        (
            [IdRedeemProduct] => Item-B
            [RedeemOptions] => Array
                (
                    [0] => Array
                        (
                            [Points] => 6200
                        )

                    [1] => Array
                        (
                            [Points] => 53000
                        )

                )

            [ProductType] => 1
        )
)

most of the usort examples are just 2 level dimension array. I couldn't find any example for 3 level.

In this case i wanted to sort the smallest points to show first. Item-A will be the first and Item-B will be the 2nd.

Bravo Net · Accepted Answer · 2015-09-02 05:09:12Z

1

foreach ($filteredResults as $key => $row)
                    {
                        foreach ($row['RedeemOptions'] as $key2 => $option) {
                            $vc_array_name[$key] = $option['Points'];
                        }
                    }

array_multisort($vc_array_name, SORT_ASC, $filteredResults);

this is working...

answered Sep 2, 2015 at 5:09

Bravo Net

8055 gold badges17 silver badges30 bronze badges

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

1 Comment

Andrew Hardiman Over a year ago

This works nicely. Thank you. You do not need the index in the second loop though.

aldrin27 · Accepted Answer · 2015-09-02 05:09:41Z

0

Try this:

  function sort_2d_desc($array, $key) {

    usort($array, function($a, $b) use ($key) {
        return strnatcasecmp($b[$key], $a[$key]);
    });

    return $array;
  }

       $a = [];
    foreach($arr as $key => $val){
        $a[$key] = $this->sort_2d_desc($val['RedeemOptions'], 'Points');
    }

    $newArr = [];
    foreach($arr as $key => $val){

        $newArr[] = ['IdRedeemProduct' => $val['IdRedeemProduct'], 'RedeemOptions' => $a, 'ProductType' => $val['ProductType']];
    }



    print_r($newArr);

edited Sep 2, 2015 at 5:09

answered Sep 2, 2015 at 2:09

aldrin27

3,4184 gold badges31 silver badges44 bronze badges

10 Comments

Bravo Net Over a year ago

return asort() expects parameter 1 to be array, null given. :(

aldrin27 Over a year ago

Can you try it again?

Bravo Net Over a year ago

this will only return the key instead of the value.. output: Array ( [0] => 1 [1] => 1 )

Buildersrejected Over a year ago

This seems like its only for two levels though right? You should just add another foreach statement with $val as $key => $thirdVal

aldrin27 Over a year ago

@bravonet try changing that asort to sort

|

Collectives™ on Stack Overflow

Sort a 3 level multi-dimension array by value in PHP

2 Answers 2

1 Comment

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related