How to Insert NULL Values Instead of Empty Strings in MySQL using PHP?

Inserting NULL Values Instead of Empty Strings in MySQL using PHP

Inserting optional fields with an empty string as a value can lead to data integrity issues when those fields are expected to be null. Here's how to modify your query to explicitly insert null values for empty fields:

$query = "INSERT INTO data (notes, id, filesUploaded, lat, lng, intLat, intLng)
          VALUES (?, ?, ?, ?, ?, ?, ?)";
$data = [$notes, $id, $imageUploaded, $lat, $long, $intLat, $intLng];
$conn->prepare($query)->execute($data);

Prepared Statements:
Prepared statements automatically handle the insertion of null values for empty variables. If your variable already contains null, it will be written as a MySQL null value.

Manual Null Assignment:
If you prefer to manually check for empty strings, you can use the following code:

$intLat = ($intLat === '') ? null : $intLat;

This assigns a null value to $intLat if it contains an empty string, ensuring the empty field is inserted as null in the database.

The above is the detailed content of How to Insert NULL Values Instead of Empty Strings in MySQL using PHP?. For more information, please follow other related articles on the PHP Chinese website!