What is the best practice for handling empty values in an array filled from a database in PHP?

When retrieving data from a database into an array in PHP, it's common to encounter empty values, which can cause issues when processing the data. To handle empty values in an array filled from a database, you can use a conditional check to replace empty values with a default value or handle them in a specific way based on your requirements. 

// Retrieve data from the database into an array
$data = array('John', '', 'Doe', '', 'Smith');

// Loop through the array and handle empty values
foreach ($data as $key => $value) {
    if ($value === '') {
        $data[$key] = 'N/A'; // Replace empty value with 'N/A'
    }
}

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

Keywords

array database empty values handling PHP

Related Questions