PHP
Extracting Specific Column Values from an Array of Arrays
Efficiently retrieve values from a specific key across an array of associative arrays or objects using `array_column()` in PHP, ideal for lists of records.
<?php
$users = [
['id' => 1, 'name' => 'Alice', 'email' => '[email protected]'],
['id' => 2, 'name' => 'Bob', 'email' => '[email protected]'],
['id' => 3, 'name' => 'Charlie', 'email' => '[email protected]'],
['id' => 4, 'name' => 'Alice', 'email' => '[email protected]'] // Example with duplicate name
];
// Extract only the 'name' column
$names = array_column($users, 'name');
echo "Names: " . print_r($names, true) . "
";
// Expected: ['Alice', 'Bob', 'Charlie', 'Alice']
// Extract 'name' column and use 'id' as the keys for the new array
$namesById = array_column($users, 'name', 'id');
echo "Names by ID: " . print_r($namesById, true) . "
";
// Expected: [1 => 'Alice', 2 => 'Bob', 3 => 'Charlie', 4 => 'Alice']
// Extract 'email' column and use 'name' as keys (duplicates overwrite)
$emailsByName = array_column($users, 'email', 'name');
echo "Emails by Name (with duplicates): " . print_r($emailsByName, true) . "
";
// Expected: ['Alice' => '[email protected]', 'Bob' => '[email protected]', 'Charlie' => '[email protected]']
?>
How it works: The `array_column()` function is highly efficient for extracting a single column (or field) from a multi-dimensional array or an array of objects. It takes the array, the key for the column to return, and optionally a key to use as the index for the new array. This is extremely useful when you have a list of records and only need a specific attribute from each, or need to re-index the array based on a specific field.