sorting array based on inner-array key-value

Question

I have an array like one mentioned below

Array
(
[6] => Array
    (
        [name] => Extras
        [total_products] => 0
        [total_sales] => 0
        [total_affiliation] => 0
    )

[5] => Array
    (
        [name] => Office Products
        [total_products] => 7
        [total_sales] => 17
        [total_affiliation] => 8
    )

[1] => Array
    (
        [name] => Hardware Parts
        [total_products] => 6
        [total_sales] => 0
        [total_affiliation] => 0
    )

)

Right now, order is: Extras, Office Products, Hardware Parts

I want to sort main array in such as way that it is order by total_sales of inner-array in desc order

so order will be: Office Products, Extras, Hardware Parts

Any help guys

In general, anytime you need to sort an array in a special way and the regular sorting functions won't do the job, you should take a look at the [u-sort family of functions](http://php.net/manual/en/array.sorting.php). — , Jun 30 '11 at 06:27

deceze · Accepted Answer · 2011-06-30T06:28:32.997

17

PHP 5.3:

usort($array, function ($a, $b) { return $b['total_sales'] - $a['total_sales']; });

PHP 5.2-:

usort($array, create_function('$a,$b', 'return $b["total_sales"] - $a["total_sales"];'));

edited Jun 30 '11 at 06:28

answered Jun 30 '11 at 06:23

deceze

510,633
85
743
889

2

+1, too fast, I was writing that – Stuti Jun 30 '11 at 06:26
@deceze: what if I use PHP 5.2 version with 5.3 or higher? – I-M-JM Aug 23 '11 at 09:47
@I-M Not sure exactly what you're saying. If you need to make this compatible with all PHP versions, use the PHP 5.2- version. That still works in PHP 5.3+. Only the PHP 5.3 syntax wasn't supported in 5.2-. – deceze Aug 23 '11 at 10:21
is this can be done with asort? Because i want to main the array's key title. currently array keys are text but after sorting becomes numbers. – siniradam May 30 '14 at 16:08
1

@sini Yes, the exact same thing works with `uasort` too. – deceze May 30 '14 at 18:12
How to do sorting array on inner array STRING value?? – Kamlesh Nov 21 '19 at 10:30
1

@Kamlesh https://stackoverflow.com/a/17364128/476 – deceze Nov 21 '19 at 10:41

score 3 · Answer 2 · 2011-06-30T06:24:17.747

3

Use a custom function and usort:

<?php
function custom_sale_sort($a, $b)
{
    if ($a['total_sales'] < $b['total_sales'])
        return 1;
    elseif ($a['total_sales'] == $b['total_sales'])
        return 0;
    else
        return -1;
}

usort($array, 'custom_sale_sort');

If you need your array sorted in the other direction, then switch the (1,-1) values around in the custom function.

edited Jun 30 '11 at 06:24

answered Jun 30 '11 at 06:17

1

can be simplified from if-else by simply returning difference of $a['total_sales'] and $b['total_sales'] as usort checks -ve,+ve not magnitude to assign order. – DhruvPathak Jun 30 '11 at 06:33

score 2 · Answer 3 · answered Jun 30 '11 at 06:30

Here is the class you can use to do multidimension sort

Note: You must have PHP5

class MultiDimensionSort
{
    const ASCENDING = 0,DESCENDING = 1;

    public  $sortColumn,$sortType;

    public function __construct($column = 'price', $type = self::ASCENDING)
    {
        $this->column = $column;
        $this->type = $type;
    }

    public function cmp($a, $b)
    {
        switch($this->type)
        {
            case self::ASCENDING:
                return ($a[$this->column] == $b[$this->column]) ? 0 : (($a[$this->column] < $b[$this->column]) ? -1 : 1);
            case self::DESCENDING:
                return ($a[$this->column] == $b[$this->column]) ? 0 :(($a[$this->column] < $b[$this->column]) ? 1 : -1);
            default:
                assert(0); // unkown type
        }
    }
}

Like you have array named summary with contain above array. than you can do sort by following statements. // assuming your array variable is $summary

$s = new MultiDimensionSort('total_sales', MultiDimensionSort::DESCENDING); // sort by total_sales

usort($summary, array($s, 'cmp'));
print"<pre>";print_r($summary);

Cheers! May be this ll help you

A whole class wrapper where a one-liner would do...? If you're going OO, why not abstract it further to get something like `MultiDimensionSort::sort($array, 'total_sales', MultiDimensionSort::DESCENDING)`? — deceze, Jun 30 '11 at 06:41

sorting array based on inner-array key-value

3 Answers3

Linked

Related