php array sort numeric first and alphabetic last

Question

I have an array:

Array
(
    ...
    [14] => Array
        (
            [date] => 2014-04-14
            [period] => 6
        )

    [15] => Array
        (
            [date] => 2014-04-21
            [period] => R1
        )

    [16] => Array
        (
            [date] => 2014-04-21
            [period] => R2
        )

    [17] => Array
        (
            [date] => 2014-04-21
            [period] => 4
        )

    [18] => Array
        (
            [date] => 2014-04-21
            [period] => 8
        )

    [19] => Array
        (
            [date] => 2014-04-28
            [period] => 1
        )
     ...
)

It has 2 types of sorts: Date and Period. But in the same time, the sort of the Period item is numeric and alphabetic. Looking the example of day 2014-04-21:

    [15] => Array
        (
            [date] => 2014-04-21
            [period] => R1
        )

    [16] => Array
        (
            [date] => 2014-04-21
            [period] => R2
        )

    [17] => Array
        (
            [date] => 2014-04-21
            [period] => 4
        )

    [18] => Array
        (
            [date] => 2014-04-21
            [period] => 8
        )

Is it possible to sort numerically and later alphabetically? I need a similar result:

[15] => Array
    (
        [date] => 2014-04-21
        [period] => 4
    )

[16] => Array
    (
        [date] => 2014-04-21
        [period] => 8
    )
[17] => Array
    (
        [date] => 2014-04-21
        [period] => R1
    )

[18] => Array
    (
        [date] => 2014-04-21
        [period] => R2
    )

I use this code:

function cmp($a, $b) {
    if ($a['date'] == $b['date']) { 
        if(is_numeric($a['period']) && !is_numeric($b['period'])) {
            return 1;
        }     
        else if(!is_numeric($a['period']) && is_numeric($b['period'])) {
            return -1;
        }
        else {
            return ($a['period'] < $b['period']) ? -1 : 1;
        }       
    }
    return (strtotime($a['date']) < strtotime($b['date']))? -1 : 1;
}

usort($arr, "cmp");

ziollek · Accepted Answer · 2014-02-19 13:57:23Z

1

you should change direction in first two conditions:

if(is_numeric($a['period']) && !is_numeric($b['period'])) {
  return -1;
}     
else if(!is_numeric($a['period']) && is_numeric($b['period'])) {
  return 1;
}

answered Feb 19, 2014 at 13:57

ziollek

1,9831 gold badge13 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

php array sort numeric first and alphabetic last

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related