MySQL and PHP – insert NULL rather than empty string

by

To pass a NULL to MySQL, you do just that.

INSERT INTO table (field,field2) VALUES (NULL,3)

So, in your code, check if $intLat, $intLng are empty, if they are, use NULL instead of '$intLat' or '$intLng'.

$intLat = !empty($intLat) ? "'$intLat'" : "NULL";
$intLng = !empty($intLng) ? "'$intLng'" : "NULL";

$query = "INSERT INTO data (notes, id, filesUploaded, lat, lng, intLat, intLng)
          VALUES ('$notes', '$id', TRIM('$imageUploaded'), '$lat', '$long', 
                  $intLat, $intLng)";

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, how to insert null dates
  3. How can I do ‘insert if not exists’ in MySQL?
  4. PHP/MySQL Insert null values
  5. PHP MYSQL UPDATE if Exist or INSERT if not?
  6. How to store NULL values in datetime fields in MySQL?
  7. using nulls in a mysqli prepared statement
  8. PHP Check for NULL
  9. What is the best way to insert multiple rows in PHP PDO MYSQL?
  10. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  11. How to update multiple MySQL table entries with different id?
  12. Can’t insert data into mysql database using PHP [closed]
  13. which is better every user have a table or just a row [closed]
  14. How can I use PDO to fetch a results array in PHP?
  15. MySQL check if a table exists without throwing an exception
  16. HTML – Change\Update page contents without refreshing\reloading the page
  17. Calculate age based on date of birth
  18. How to write a stored procedure using phpmyadmin and how to use it through php?
  19. Doing calculations in MySQL vs PHP
  20. Geo-Search (Distance) in PHP/MySQL (Performance)
  21. PHP mysql search multiple tables using a keyword
  22. Best practice: Import mySQL file in PHP; split queries
  23. Connecting to remote MySQL server using PHP
  24. Using PHP to execute multiple MYSQL Queries
  25. Why I am getting an error when using w3school tutorial? [duplicate]
  26. adding 30 minutes to datetime php/mysql
  27. Remotely connecting to a MySQL database
  28. Create table with PHP and populate from MySQL
  29. SQLSTATE[HY000] [1698] Access denied for user ‘root’@’localhost’
  30. Which MySQL datatype to use for an IP address? [duplicate]

Leave a Comment