Sort Array Date wise if given at Zero index Key

Question

Actually I have one array and I need to sort it according to date wise but unfortunately it becomes difficult for me. Can you help me out ...

I have an array like that in below

         $data = array ( 
            array('July 2015', 2 , 5, 0, ''),
            array('September 2015', 2 , 5, 0, ''),
            array('August 2015', 2 , 5, 0, ''),
            array('March 2017', 2 , 5, 0, ''),
            array('December 2015', 2 , 5, 0, ''),
            array('March 2016', 2 , 5, 0, ''),
         );

Now I want to sort this array according to date wise that start from the smallest date to bigger date like, it will becomes like that.

         $data = array ( 
            array('July 2015', 2 , 5, 0, ''),
            array('August 2015', 2 , 5, 0, ''),
            array('September 2015', 2 , 5, 0, ''),
            array('December 2015', 2 , 5, 0, ''),
            array('March 2016', 2 , 5, 0, ''),
            array('March 2017', 2 , 5, 0, ''),
         );

Can anyone help me.

Any help will be appreciated.

Thanks

Start here: http://stackoverflow.com/q/17364127/476. That'd reduce this question to a more specific "How to compare two strings like 'July 2015'?" — deceze, Jun 04 '15 at 12:25

score 1 · Answer 1 · answered Jun 04 '15 at 12:10

1

Use the usort function and convert string dates to timestamps using strtotime:

usort($data, function ($a, $b) {
    $aTime = strtotime($a[0]);
    $bTime = strtotime($b[0]);

    if ($aTime == $bTime)
        return 0;

    return $aTime > $bTime ? 1 : -1;
});

answered Jun 04 '15 at 12:10

MaGnetas

4,918
4
32
52

Thank you sir for your help – John Brad Jun 04 '15 at 12:30
Not a problem. Good luck with your project. BTW the method suggested by @Uchiha is similar except it keeps index association. – MaGnetas Jun 04 '15 at 12:32

Narendrasingh Sisodia · Accepted Answer · 2015-06-04T12:28:56.123

1

$data = array(
    array('July 2015', 2, 5, 0, ''),
    array('September 2015', 2, 5, 0, ''),
    array('August 2015', 2, 5, 0, ''),
    array('March 2017', 2, 5, 0, ''),
    array('December 2015', 2, 5, 0, ''),
    array('March 2016', 2, 5, 0, ''),
);

uasort($data, function($a,$b){ 
    if(strtotime($a[0]) == strtotime($b[0])) 
    { 
        return 0;
    } 
    return strtotime($a[0]) < strtotime($b[0]) ? -1 : 1;
 });

print_r($data);

Or the simplest way as DECEZE said

uasort($data, function($a,$b){ 
   return strtotime($a[0]) - strtotime($b[0]);
});

DEMO

DEMO SUGGESTED BY DECEZE

edited Jun 04 '15 at 12:28

answered Jun 04 '15 at 12:14

Narendrasingh Sisodia

21,247
6
47
54

1

Tip: `return strtotime($a[0]) - strtotime($b[0]);` – deceze Jun 04 '15 at 12:24
Thank You @deceze never know that one. Thanks a Lot – Narendrasingh Sisodia Jun 04 '15 at 12:26

Sort Array Date wise if given at Zero index Key

2 Answers2