Sort PHP arrays by timestamp

Question

I have a problem with arranging the array the way I want.

This is an example of the output of my array: http://pastebin.com/GJNBmqL7

Data comes from different databases at once, so I am limited by how I put the data into an array.

In [2] there is always a linux timestamp. Now I want the whole array to be ordered by this timestamp with the smallest value.

How can i do this?

Answer 1

here is an array_multisort example:

foreach ($array as $key => $node) { $timestamps[$key] = $node[2]; } array_multisort($timestamps, SORT_ASC, $array); 

Answer 2

use usort, which takes a user-defined function to sort arrays:

usort

your function might look something like this:

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

Answer 3

You can do this simply with custom sorting. Therefore, if your date stamp is always listed in index 2:

 function sortArray($a1, $a2){ if ($a1[2] == $a2[2]) return 0; return ($a1[2] > $a2[2]) ? -1 : 1; } usort($array, "sortArray"); 

Answer 4

usort is the easiest to use, but you can also check array_multisort .

Answer 5

Use usort and create your own function, http://php.net/manual/en/function.usort.php

Answer 6

 function cmp($a, $b) { if ($a[2] == $b[2]) { return 0; } return ($a[2] < $b[2]) ? -1 : 1; } $data = array( /* your data */ ); usort($data, "cmp"); 

Answer 7

It might be easier to insert data into one temporary table, then SELECT, with a timestamp ORDER BY

Answer 8

This can be achieved with the following code.

 usort($variable, function ($a, $b) { if ($a['timestamp'] == $b['timestamp']) { return 0; } return ($a['timestamp'] < $b['timestamp']) ? 1 : -1; 

});

This will sort the array of variable $, assuming the timestamp is in Variable $ [0] ['Timestamp']; Variable $ [0] ['Timestamp']; etc.