Sort array in array in array in PHP

Question

I have array like this:

$items = array(
              [1] => array(
                           ['Name']   =>"Item 1", 
                           ['Prices'] => array(
                                               ['Base price'] => 80.25,
                                               ['Discount'] => 5.50
                                              )
                          ),

              [2] => array(
                           ['Name']   =>"Item 2", 
                           ['Prices'] => array(
                                               ['Base price'] => 70.25,
                                               ['Discount'] => 4.50
                                              )
                          )
              );

How can I sort $items that by "Base price"? I want to have lowest price in first element, highest in last element of output array with same structure.

Expected output:

$items = array(
               [1] => array(
                           ['Name']   =>"Item 2", 
                           ['Prices'] => array(
                                               ['Base price'] => 70.25,
                                               ['Discount'] => 4.50
                                              )
                          ),
               [2] => array(
                           ['Name']   =>"Item 1", 
                           ['Prices'] => array(
                                               ['Base price'] => 80.25,
                                               ['Discount'] => 5.50
                                              )
                          )
              );

I don't understand array_multisort() and how to use it in my case.

@JanDvorak I want to sort only by ['Base price'] element. It's always there. — Kamil
– Kamil, Commented Jan 20, 2014 at 13:23
Better way is use ordering on DB Engine and please do not try reinvent the wheel — Dmitry Dubovitsky
– Dmitry Dubovitsky, Commented Jan 21, 2014 at 13:09

sroes · Accepted Answer · 2014-01-20 13:24:51Z

2

This is how you could use array_multisort:

foreach ($items as $item) {
    $sort[] = $item['Prices']['Base price'];
}

array_multisort($sort, SORT_ASC, $items);

Like Jan was saying, you can also use usort:

usort($items, function($a, $b) {
    return $a['Prices']['Base price'] - $b['Prices']['Base price'];
});

answered Jan 20, 2014 at 13:24

sroes

15.1k1 gold badge58 silver badges75 bronze badges

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

Comments

hek2mgl · Accepted Answer · 2014-01-20 13:26:41Z

1

I hope this helps. I'm using usort() with a callback function:

$arr = array(
    array(
        'foo' => 'bar',
        'data' => array(
            'basePrize' => 5
        )   
    ),
    array(
        'foo' => 'bar2',
        'data' => array(
            'basePrize' => 2
        )
    )
);

usort($arr, function($a, $b) {
    if($a['data']['basePrize'] === $b['data']['basePrize']) {
        return 0;
    }   

     if($a['data']['basePrize'] > $b['data']['basePrize']) {
        return 1;
    }   

    return -1
});

answered Jan 20, 2014 at 13:26

hek2mgl

159k31 gold badges263 silver badges279 bronze badges

Collectives™ on Stack Overflow

Sort array in array in array in PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related