sort array on specific value with php [duplicate]

Question

I have an array with specific values in it and i would like to sort the array on a specific value in it. For instance, TOTCOM_METIER DESC. Ex :

Array
(
[0] => Array
    (
        [TOTCOM_METIER] => 1
        [metier] => Traiteur
    )

[1] => Array
    (
        [TOTCOM_METIER] => 4
        [metier] => Restauration traditionnelle
    )

[2] => Array
    (
        [TOTCOM_METIER] => 2
        [metier] => Coiffure
    )

)

I would like to sort it on TOTCOM_METIER DESC to have this result :

Array
(
[0] => Array
    (
        [TOTCOM_METIER] => 4
        [metier] => Restauration traditionnelle
    )

[1] => Array
    (
        [TOTCOM_METIER] => 2
        [metier] => Coiffure
    )

[2] => Array
    (
        [TOTCOM_METIER] => 1
        [metier] => Traiteur
    )

)

ewcz · Accepted Answer · 2017-03-20 09:07:25Z

8

<?php

$arr = Array(
    0 => Array
        (
            'TOTCOM_METIER' => 1,
            'metier' => 'Traiteur'
        ),
    1 => Array
        (
            'TOTCOM_METIER' => 4,
            'metier' => 'Restauration traditionnelle'
        ),
    2 => Array
        (
            'TOTCOM_METIER' => 2,
            'metier' => 'Coiffure'
        )
);

//define custom "comparator" (in reverse order)
function cmp($a, $b){
    $key = 'TOTCOM_METIER';
    if($a[$key] < $b[$key]){
        return 1;
    }else if($a[$key] > $b[$key]){
        return -1;
    }
    return 0;
}
usort($arr, "cmp");

print_r($arr);

?>

answered Mar 20, 2017 at 9:07

ewcz

13.1k1 gold badge30 silver badges47 bronze badges

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

2 Comments

Vince Over a year ago

works like a charm! thks

Igor Bykov Over a year ago

In PHP >= 7 you might also change all ifs & returns to return $a[$key] <=> $b[$key]; thanks to spaceship operator.

Rahul · Accepted Answer · 2017-03-20 09:05:12Z

3

Try this,

function compare($a, $b)
{
   return ($a['TOTCOM_METIER']< $b['TOTCOM_METIER']);
}
usort($your_array, "compare");

Here is usort docs which states Sort an array by values using a user-defined comparison function

answered Mar 20, 2017 at 9:05

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

Comments

Delly.Liu · Accepted Answer · 2017-03-20 09:06:49Z

0

How do you get this data ? If you select from db system,you can use order by TOTCOM_METIER desc in your select sql.

answered Mar 20, 2017 at 9:06

Delly.Liu

14 bronze badges

Comments

napolux · Accepted Answer · 2017-03-20 09:13:06Z

0

With this you can pass the order you want, "desc" or "asc"

function sortAsc($a, $b) {
   return ($a[TOTCOM_METIER] < $b[TOTCOM_METIER]);
}

function sortDesc($a, $b) {
   return ($a[TOTCOM_METIER] > $b[TOTCOM_METIER]);
}

function sortMyArray($array, $order = "asc") {
    if($order === "desc") {
        return usort($array, "sortDesc");
    }

    return usort($array, "sortAsc");
}

// Call it like
sortMyArray($array, "asc");

answered Mar 20, 2017 at 9:13

napolux

16.2k9 gold badges55 silver badges72 bronze badges

Collectives™ on Stack Overflow

sort array on specific value with php [duplicate]

4 Answers 4

2 Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Linked

Related