SQL Server FAQ - PHP MSSQL - Inserting Data with NULL Values

Home >> FAQs/Tutorials >> SQL Server FAQ

By: FYIcenter.com

PHP MSSQL - How To Insert Data with NULL Values?

There are two ways to provide NULL value to a column in an INSERT statement:

Include the column in the statement, but specify keyword NULL as the value.
Exclude the column from the statement.

The following tutorial exercise inserts two rows. Both of them have NULL values. But they were inserted differently:

<?php
  $con = mssql_connect('LOCALHOST','sa','FYIcenter');
  mssql_select_db('FyiCenterData', $con);

  $sql = "INSERT INTO fyi_links" 
      . " (id, url, notes, counts, time)"
      . " VALUES (101, 'dev.fyicenter.com',"
      . " NULL, NULL, NULL)";
  $res = mssql_query($sql,$con);
  if (!$res) {
    print("SQL statement failed with error:\n");
    print("   ".mssql_get_last_message()."\n");
  } else {
    print("One data row inserted.\n");
  }

  $sql = "INSERT INTO fyi_links (id, url) VALUES ("
      . " 102, 'dba.fyicenter.com')";
  $res = mssql_query($sql,$con);
  print("Another data row inserted.\n");

  mssql_close($con); 
?>

If you run this script, you will get:

One data row inserted.
Another data row inserted.

(Continued on next topic...)