PHP – Sort multi-dimensional array by another array

by

In your example the ids in the $data array are are numbered consecutively and starting at 1. The code I give below assumes this is always the case. If this is not the case, the code does not work.

$result = array();
$index = 0;
foreach ($order as $position) {
    $result[$index] = $data[$position - 1];
    $index++;
}

At http://codepad.org/YC8w0yHh you can see that it works for your example data.

EDIT

If the assumption mentioned above does not hold, the following code will achieve the same result:

<?php

$data = array(
    array('id' => 1, 'title' => 'whatever'),
    array('id' => 2, 'title' => 'whatever'),
    array('id' => 3, 'title' => 'whatever')
);

$order = array(2,3,1);
$order = array_flip($order);

function cmp($a, $b)
{
    global $order;

    $posA = $order[$a['id']];
    $posB = $order[$b['id']];

    if ($posA == $posB) {
        return 0;
    }
    return ($posA < $posB) ? -1 : 1;
}

usort($data, 'cmp');

var_dump($data);

See http://codepad.org/Q7EcTSfs for proof.

By calling array_flip() on the $order array it can be used for position lookup. This is like a hashtable lookup, which is linear in time, or O(n). You cannot do better.

More Related Contents:

  1. How to Sort a Multi-dimensional Array by Value
  2. How do I Sort a Multidimensional Array in PHP [duplicate]
  3. How to sort an array of associative arrays by value of a given key in PHP?
  4. Sort multidimensional array by multiple columns
  5. Sorting a php array of arrays by custom order
  6. Sorting a multidimensional array in PHP? [duplicate]
  7. How do I sort a multidimensional array by one of the fields of the inner array in PHP? [duplicate]
  8. Sort array of objects by one property
  9. How to sort a multidimensional array by a certain key?
  10. Sort multidimensional array by date column, then use other column values if dates are the same
  11. Recursively sort keys of a multidimensional array
  12. Sort an array of associative arrays by column value
  13. In php how does usort() function works
  14. how to sort a multidemensional array by an inner key
  15. Sort a multidimensional array descending by subarray count and preserve first level keys
  16. PHP multidimensional array search by value
  17. How to sum all column values in multi-dimensional array?
  18. Get difference between associative rows of two 2-dimensional arrays
  19. Sort an array by a child array’s value in PHP
  20. PHP combine two associative arrays into one array
  21. using array_search for multi dimensional array
  22. PHP: How to sort the characters in a string?
  23. File creation time [closed]
  24. sum specific values in a multidimensional array (php)
  25. How to GROUP BY and SUM PHP Array? [duplicate]
  26. Sort a flat, associative array by numeric values, then by non-numeric keys
  27. Merge two indexed arrays of indexed arrays based on first column value
  28. Group subarrays by one column, make comma-separated values from other column within groups
  29. Custom key-sort a flat associative based on another array
  30. Combine two 2d arrays and have duplicate rows removed

Leave a Comment