English
English
array_column is a very useful function in PHP that allows you to extract the value of a specified column from a multidimensional array. In some cases, specific columns of certain elements in an array may contain null values, and understanding how PHP handles these null values is important to avoid unexpected errors.
In this article, we will discuss how PHP will handle these null values when you use the array_column function to extract values in an array, if the value of a column is null , and whether there is special behavior to pay attention to.
First, let's briefly review the basic usage of the array_column function. It accepts the following parameters:
Array : The input multidimensional array.
Column name or column index : Specifies the column to be extracted.
Indexed Column (optional): If this parameter is provided, the returned array will be reconstructed based on this indexed column.
Here is a simple example using array_column :
<?php
$array = [
['id' => 1, 'name' => 'Alice', 'email' => 'alice@example.com'],
['id' => 2, 'name' => 'Bob', 'email' => null],
['id' => 3, 'name' => 'Charlie', 'email' => 'charlie@example.com']
];
// extract email List
$emails = array_column($array, 'email');
print_r($emails);
?>
Output:
Array
(
[0] => alice@example.com
[1] =>
[2] => charlie@example.com
)
In this example, we extract the email column and find that the email value of the second element is null . PHP converts it to an empty string ( "" ) when processed, and does not completely remove the value from the array.
When you extract a column in array_column and the column contains a null value, PHP will automatically convert the null value to an empty string. It should be noted that this is not to delete the value, but to store null as an empty string into the returned array.
In the example above, the email column of the second element is null , and the final output array shows an empty string. If it is another value (such as an integer or a boolean), it will be returned as is.
Replace null values with strings : As shown above, PHP replaces null values with empty strings. This means that if you are working with arrays, you may need to pay special attention to how to distinguish between null values and empty strings. Empty strings and null are different types in PHP, and they can cause logical errors in some cases, especially when it comes to conditional judgments.
Processing of unset columns : If the column you are trying to extract does not exist in the array, array_column will return an empty array. So, when using array_column , make sure that the columns to be extracted do exist in the array structure, avoiding returning unnecessary empty arrays.
In case of index column null : If you provide an index column (the third parameter) and the column's value is null , array_column will ignore it and will not include the element in the final result. For example:
<?php
$array = [
['id' => 1, 'name' => 'Alice', 'email' => 'alice@example.com'],
['id' => null, 'name' => 'Bob', 'email' => null],
['id' => 3, 'name' => 'Charlie', 'email' => 'charlie@example.com']
];
// extract email List，according to id List作为索引
$emails = array_column($array, 'email', 'id');
print_r($emails);
?>
Output:
Array
(
[1] => alice@example.com
[3] => charlie@example.com
)
In this example, elements with id null are ignored, and only elements with id 1 and 3 are included in the result.
When using the array_column function, if the extracted column contains null values, PHP converts these nulls to empty strings. This behavior may bring some special considerations when dealing with arrays containing null values, especially when distinguishing between null and empty strings in conditional judgments. If you need to deal with the difference between null and empty strings, you can consider further processing of the array after extracting the columns to avoid logical errors.
I hope this article can help you better understand the behavior of the array_column function in PHP when processing null values!
