using nulls in a mysqli prepared statement

by

It’s possible to bind a true NULL value to the prepared statements (read this).

You can, in fact, use mysqli_bind_parameter to pass a NULL value to the database. simply create a variable and store the NULL value (see the manpage for it) to the variable and bind that. Works great for me anyway.

Thus it’ll have to be something like:

<?php
    $mysqli = new mysqli('localhost', 'my_user', 'my_password', 'world');

    // person is some object you have defined earlier
    $name = $person->name();
    $age = $person->age();
    $nickname = ($person->nickname() != '') ? $person->nickname() : NULL;

    // prepare the statement
    $stmt = $mysqli->prepare("INSERT INTO Name, Age, Nickname VALUES (?, ?, ?)");

    $stmt->bind_param('sis', $name, $age, $nickname);
?>

This should insert a NULL value into the database.

More Related Contents:

  1. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  2. How to use mysqli prepared statements?
  3. MySQLi prepared statements error reporting [duplicate]
  4. Example of how to use bind_result vs get_result
  5. mysqli: can it prepare multiple queries in one statement?
  6. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  7. Is mysql_real_escape_string() necessary when using prepared statements?
  8. How to prepare statement for update query? [duplicate]
  9. Using Prepared Statement, how I return the id of the inserted row?
  10. How to display errors for my MySQLi query? [duplicate]
  11. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  12. When should I use MySQLi instead of MySQL?
  13. mysqli::query(): Couldn’t fetch mysqli
  14. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  15. PHP MySQLI Prevent SQL Injection [duplicate]
  16. How to test if a MySQL query was successful in modifying database table data?
  17. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  18. How can I use mysqli_fetch_array() twice?
  19. PHP Commands Out of Sync error
  20. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  21. Updating from MYSQL to MYSQLI [duplicate]
  22. store_result() and get_result() in mysql returns false
  23. Use of PDO in classes [duplicate]
  24. Mysqli Prepare Statement – Returning False, but Why? [duplicate]
  25. How to run the bind_param() statement in PHP?
  26. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  27. How do I ensure I caught all errors from MySQLi::multi_query?
  28. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  29. How to get a list of databases?
  30. Why cannot the PHP hide the error message thrown by the MySQL connection?

Leave a Comment