Array sort on datetime

Question

I'm having some problems trying to sort my array on a time. The array has a value with minutes, the lowest has to show at the top.

This is my array:

$voertuigen[] = array(
'img' => $img,
'nummer' => $nummer,
'soort' => $rnaam,
'aankomst' => $formatted
);

I've tryed to use sort()

sort($voertuigen, SORT_NUMERIC);

But then I get this: 9:42 10:50 9:42 13:43 It isn't correctly sorted.

Thanks for helping!

It isn't a datetime, it is just something like this: 10:30 - Minutes:seconds

So where are you telling your sort to sort against a datetime? Which is the datetime? — Mark Baker, Jan 01 '17 at 19:24
Sorry, forgot to tell, the 'aankomst' is the one with the datetime — Jesper, Jan 01 '17 at 19:28
That post doesn't help me. My value is like 10:00 -- Minutes:Seconds — Jesper, Jan 01 '17 at 20:16

score 0 · Answer 1 · answered Jan 01 '17 at 23:54

You can just use usort to define your own comparison and then use DateTime to parse the times in the array and then compare them:

usort($voertuigen, function ($a, $b) {
    return new DateTime($a['aankomst']) > new DateTime($b['aankomst']);
});

Hope this helps!

1 Answers1