How can PHP developers efficiently sort a multidimensional array by multiple keys, similar to an SQL query?

When sorting a multidimensional array by multiple keys in PHP, developers can use the `array_multisort()` function to achieve the desired result. This function allows sorting by multiple keys in a similar way to an SQL query with ORDER BY clauses. By specifying the keys and sorting direction for each key, developers can efficiently sort the multidimensional array. 

// Sample multidimensional array
$data = [
    ['name' => 'John', 'age' => 30],
    ['name' => 'Jane', 'age' => 25],
    ['name' => 'Alice', 'age' => 35],
];

// Sort the array by 'name' ascending and 'age' descending
array_multisort(array_column($data, 'name'), SORT_ASC, array_column($data, 'age'), SORT_DESC, $data);

// Output the sorted array
print_r($data);

Keywords

PHP multidimensional array sorting multiple keys SQL query

Related Questions