PHP sort array by two field values [duplicate]

by

array_multisort() is the correct function, you must have messed up somehow:

// Obtain a list of columns
foreach ($data as $key => $row) {
    $return_fare[$key]  = $row['return_fare'];
    $one_way_fare[$key] = $row['one_way_fare'];
}

// Sort the data with volume descending, edition ascending
array_multisort($data, $return_fare, SORT_ASC, $one_way_fare, SORT_ASC);

If you take a look at the comments at PHP’s manual page for array_multisort(), you can find a very helpful array_orderby() function which allows you to shorten the above to just this:

$sorted = array_orderby($data, 'return_fare', SORT_ASC, 'one_way_fare', SORT_ASC);

To avoid the looping use array_column() (as of PHP 5.5.0):

array_multisort(array_column($data, 'return_fare'),  SORT_ASC,
                array_column($data, 'one_way_fare'), SORT_ASC,
                $data);

More Related Contents:

  1. How to get popular keywords in an array
  2. How can I sort arrays and data in PHP?
  3. How to Sort a Multi-dimensional Array by Value
  4. How to sort an array of associative arrays by value of a given key in PHP?
  5. Sort array of objects by object fields
  6. Sort multidimensional array by multiple columns
  7. PHP Sort a multidimensional array by element containing Y-m-d H:i:s date
  8. PHP Sort Array By SubArray Value
  9. Sorting a php array of arrays by custom order
  10. Preserve key order (stable sort) when sorting with PHP’s uasort
  11. How do I sort a multidimensional array by one of the fields of the inner array in PHP? [duplicate]
  12. Sort array of objects by one property
  13. PHP array multiple sort – by value then by key?
  14. Group array by subarray values
  15. How to sort a multidimensional array by a certain key?
  16. How to sort a date array in PHP
  17. How to sort an array of UTF-8 strings?
  18. scandir() to sort by date modified
  19. PHP Sort array by field? [duplicate]
  20. How to sort an array of arrays in php?
  21. Sort Object in PHP
  22. Sort multidimensional array by date column, then use other column values if dates are the same
  23. Group rows in an associative array of associative arrays by column value and preserve the original first level keys
  24. Recursively sort keys of a multidimensional array
  25. Sort an array of associative arrays by column value
  26. Sort array by value alphabetically php
  27. How to have a stable sort in PHP with arsort()?
  28. how to sort a multidemensional array by an inner key
  29. Sort a multidimensional array descending by subarray count and preserve first level keys
  30. PHP-Sort array based on another array?

Leave a Comment