PHP
Extract a Column from an Array of Associative Arrays in PHP
Efficiently extract a specific column (key's value) from a list of associative arrays using PHP's `array_column` function. Perfect for processing database results.
<?php
$users = [
['id' => 1, 'name' => 'Alice', 'email' => '[email protected]'],
['id' => 2, 'name' => 'Bob', 'email' => '[email protected]'],
['id' => 3, 'name' => 'Charlie', 'email' => '[email protected]']
];
// Extract all 'name' values
$names = array_column($users, 'name');
// $names will be ['Alice', 'Bob', 'Charlie']
print_r($names);
// Extract 'email' values, using 'id' as keys
$emailsById = array_column($users, 'email', 'id');
/*
$emailsById will be:
[
1 => '[email protected]',
2 => '[email protected]',
3 => '[email protected]'
]
*/
print_r($emailsById);
?>
How it works: The `array_column()` function is highly efficient for extracting values from a specific column (key) in a multi-dimensional array or an array of objects. It can return a simple list of values or create an associative array using another column's values as keys, simplifying common data transformations, especially when dealing with database results.