CODEWITHSUNDEEP
phparrayssortingmultidimensional-array
Bravo Net
Bravo Net

Reputation: 805

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

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.

Upvotes: 2

Views: 301

Answers (2)

aldrin27
aldrin27

Reputation: 3407

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);

Upvotes: 0

Bravo Net
Bravo Net

Reputation: 805

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...

Upvotes: 1

Related Questions