How to sort a date array in PHP

by

Use the ISO (yyyy-mm-dd) format rather than the “english” format, and then just use the ksort function to get them in the right order.

There’s no need to remove the hyphens, ksort will do an alphanumeric comparison on the string keys, and the yyyy-mm-dd format works perfectly well as the lexical order is the same as the actual date order.

EDIT I see you’ve now corrected your question to show that you’ve actually got an array of arrays, and that the sort key is in the sub-arrays. In this case, you should use uksort as recommended elsewhere, but I would recommend that you go with your own edit and sort based on the DB formatted date, rather than by parsing the human readable format:

function cmp($a, $b)
{
    global $array;
    return strcmp($array[$a]['db'], $array[$b]['db']);
}

uksort($array, 'cmp');

More Related Contents:

  1. Group rows in an associative array of associative arrays by column value and preserve the original first level keys
  2. Custom key-sort a flat associative based on another array
  3. Sorting an associative array in PHP [duplicate]
  4. Sorting a php array of arrays by custom order
  5. Convert backslash-delimited string into an associative array
  6. PHP sort array by two field values [duplicate]
  7. Sorting a multidimensional array in PHP? [duplicate]
  8. Preserve key order (stable sort) when sorting with PHP’s uasort
  9. How do I sort a multidimensional array by one of the fields of the inner array in PHP? [duplicate]
  10. Sort array of objects by one property
  11. PHP array multiple sort – by value then by key?
  12. Group array by subarray values
  13. Sort an array by a child array’s value in PHP
  14. PHP combine two associative arrays into one array
  15. PHP Get Highest Value from Array
  16. scandir() to sort by date modified
  17. PHP order array by date? [duplicate]
  18. Display array values in PHP
  19. Using usort in php with a class private function
  20. Sort Object in PHP
  21. Flip associative array and store new values in subarrays to prevent losing duplicated values
  22. How to GROUP BY and SUM PHP Array? [duplicate]
  23. Merge multiple associative arrays and add missing columns with a default value
  24. Sort a flat, associative array by numeric values, then by non-numeric keys
  25. Add elements to array which has gapped numeric keys to form an indexed array / list
  26. Merge two numerically-keyed associative arrays and preserve the original keys
  27. Sort array by value alphabetically php
  28. Implementing a simple lookup array
  29. Conditionally add associative element to array
  30. PHP-Sort array based on another array?

Leave a Comment