How does PHP handle 'NULL' values from a SQL database?

When retrieving data from a SQL database, PHP represents 'NULL' values as empty strings. To handle 'NULL' values correctly, you can check if the value is equal to NULL using the `is_null()` function and then handle it accordingly in your PHP code. 

// Retrieve data from SQL database
$result = $stmt->fetch();

// Check if the value is NULL
if (is_null($result['column_name'])) {
    // Handle NULL value
    echo "Value is NULL";
} else {
    // Use the value
    echo $result['column_name'];
}

Keywords

PHP NULL values SQL database handling data retrieval

Related Questions