MySQL, how to insert null dates

by

Try this:

$query = "INSERT INTO table (column_s1, column_s2, column_d1, column_d2) 
          VALUES ('$string1', '$string2', " . ($date1==NULL ? "NULL" : "'$date1'") . ", " . ($date2==NULL ? "NULL" : "'$date2'") . ");";

so for example if you put this into query:

$string1 = "s1";
$string2 = "s2";
$date1 = NULL;
$date2 = NULL;

result should be:

INSERT INTO table (column_s1, column_s2, column_d1, column_d2) VALUES ('s1', 's2', NULL, NULL);

More Related Contents:

  1. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  2. MySQL and PHP – insert NULL rather than empty string
  3. Php date() Date and time is stuck [closed]
  4. How can I do ‘insert if not exists’ in MySQL?
  5. PHP mysql insert date format
  6. PHP/MySQL Insert null values
  7. Calculate age based on date of birth
  8. PHP MYSQL UPDATE if Exist or INSERT if not?
  9. How to store NULL values in datetime fields in MySQL?
  10. Set timezone in PHP and MySQL
  11. using nulls in a mysqli prepared statement
  12. PHP Check for NULL
  13. How to convert ISO8601 to Date format in php
  14. What is the best way to insert multiple rows in PHP PDO MYSQL?
  15. How to display a date as iso 8601 format with PHP
  16. Date in a URL dd/mm/yyyy
  17. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  18. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  19. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  20. Formatting an SQL timestamp with PHP
  21. adding 1 day to a DATETIME format value
  22. Fixing broken UTF-8 encoding
  23. Export MySQL data to Excel in PHP
  24. MySQL – ignore insert error: duplicate entry
  25. Call to a member function execute() on boolean in [duplicate]
  26. SQLSTATE[HY000] [1045] Access denied for user ‘username’@’localhost’ using CakePHP
  27. Connecting to remote MySQL server using PHP
  28. Base table or view not found: 1146 Table Laravel 5
  29. Check for duplicates before inserting
  30. How to write a stored procedure in phpMyAdmin?

Leave a Comment