How to Properly Insert NULL Values into MySQL Using Prepared Statements in PHP?

Insert NULL Values in PHP/MySQL with Prepared Statements

Your issue arises from trying to insert NULL values into a MySQL database using the mysql_query function. To successfully insert NULL values, you need to explicitly specify them in your INSERT statement or omit the field.

However, this approach requires additional branching to handle both NULL and non-NULL values. A more elegant solution is to utilize prepared statements with the mysqli extension.

Prepared statements automatically differentiate between string(0) and NULL values. They also escape fields for you, ensuring data integrity. Here's an example using prepared statements:

<code class="php">$stmt = $mysqli->prepare("INSERT INTO table2 (f1, f2) VALUES (?, ?)");
$stmt->bind_param('ss', $field1, $field2);

$field1 = "String Value";
$field2 = null;

$stmt->execute();</code>

By using prepared statements, you can insert NULL values effortlessly without any branching or additional code. Additionally, prepared statements prevent SQL injection attacks and improve performance. It's highly recommended to use mysqli and its prepared statements for improved security, performance, and ease of development.

The above is the detailed content of How to Properly Insert NULL Values into MySQL Using Prepared Statements in PHP?. For more information, please follow other related articles on the PHP Chinese website!