Sort multidimensional array by multiple columns

by

You need array_multisort

$mylist = array(
    array('ID' => 1, 'title' => 'Boring Meeting', 'event_type' => 'meeting'),
    array('ID' => 2, 'title' => 'Find My Stapler', 'event_type' => 'meeting'),
    array('ID' => 3, 'title' => 'Mario Party', 'event_type' => 'party'),
    array('ID' => 4, 'title' => 'Duct Tape Party', 'event_type' => 'party')
);

# get a list of sort columns and their data to pass to array_multisort
$sort = array();
foreach($mylist as $k=>$v) {
    $sort['title'][$k] = $v['title'];
    $sort['event_type'][$k] = $v['event_type'];
}
# sort by event_type desc and then title asc
array_multisort($sort['event_type'], SORT_DESC, $sort['title'], SORT_ASC,$mylist);

As of PHP 5.5.0:

array_multisort(array_column($mylist, 'event_type'), SORT_DESC,
                array_column($mylist, 'title'),      SORT_ASC,
                $mylist);

$mylist is now:

array (
  0 => 
  array (
    'ID' => 4,
    'title' => 'Duct Tape Party',
    'event_type' => 'party',
  ),
  1 => 
  array (
    'ID' => 3,
    'title' => 'Mario Party',
    'event_type' => 'party',
  ),
  2 => 
  array (
    'ID' => 1,
    'title' => 'Boring Meeting',
    'event_type' => 'meeting',
  ),
  3 => 
  array (
    'ID' => 2,
    'title' => 'Find My Stapler',
    'event_type' => 'meeting',
  ),
)

More Related Contents:

  1. How to Sort a Multi-dimensional Array by Value
  2. How to sort an array of associative arrays by value of a given key in PHP?
  3. Sorting a php array of arrays by custom order
  4. Sorting a multidimensional array in PHP? [duplicate]
  5. How do I sort a multidimensional array by one of the fields of the inner array in PHP? [duplicate]
  6. Sort array of objects by one property
  7. How to sort a multidimensional array by a certain key?
  8. Sort multidimensional array by date column, then use other column values if dates are the same
  9. Recursively sort keys of a multidimensional array
  10. Sort an array of associative arrays by column value
  11. how to sort a multidemensional array by an inner key
  12. Sort a multidimensional array descending by subarray count and preserve first level keys
  13. Sorting an associative array in PHP [duplicate]
  14. Sum values of multidimensional array by key without loop
  15. Preserve key order (stable sort) when sorting with PHP’s uasort
  16. PHP array multiple sort – by value then by key?
  17. Group array by subarray values
  18. Implode a column of values from a two dimensional array [duplicate]
  19. Recursively remove empty elements and subarrays from a multi-dimensional array
  20. PHP remove duplicate values from multidimensional array
  21. PHP combine two associative arrays into one array
  22. scandir() to sort by date modified
  23. Sort Object in PHP
  24. Dynamic array keys
  25. Group 2d array data using column value to create a 3d array
  26. Sort array by value alphabetically php
  27. PHP – Sort multi-dimensional array by another array
  28. How to create multi-dimensional array from a list?
  29. Recreate original PHP array from print_r output [duplicate]
  30. Sort array by numeric keys

Leave a Comment