My form will not accept "null" values

[sokaris]

I hope I'm posting in the right spot. I'm working on a form where the PHP script was created by Dreamweaver's data wizard. It works great excepts that the "phone" and "commentMLS" data fields won't accept empty (null?) values. "name" and "email" fields have spry validation; "beds","baths", "priceRange" are menus, they work fine; the loan checkbox also works fine.

 

This is the error I get with an empty "phone" data field: "Column 'phone' cannot be null"

 

Thanks in advance for any help fixing this problem.

 

Here's the PHP script:

 

<?php require_once('Connections/rocklin3_client.php'); ?>

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

  if (PHP_VERSION < 6) {

    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  }

 

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

 

  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;   

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}

 

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

 

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {

  $insertSQL = sprintf("INSERT INTO client (name, email, phone, commentIndex, loan) VALUES (%s, %s, %s, %s, %s)",

                      GetSQLValueString($_POST['name'], "text"),

                      GetSQLValueString($_POST['email'], "text"),

                      GetSQLValueString($_POST['phone'], "text"),

                      GetSQLValueString($_POST['commentIndex'], "text"),

                      GetSQLValueString(isset($_POST['loan']) ? "true" : "", "defined","1","0"));

 

  mysql_select_db($database_rocklin3_client, $rocklin3_client);

  $Result1 = mysql_query($insertSQL, $rocklin3_client) or die(mysql_error());

 

  $insertGoTo = "thank.php";

  if (isset($_SERVER['QUERY_STRING'])) {

    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";

    $insertGoTo .= $_SERVER['QUERY_STRING'];

  }

  header(sprintf("Location: %s", $insertGoTo));

}

?>

[requinix]

Your database doesn't agree with what you want to do. Change it so the column accepts null values.

[sokaris]

Simple fix. Thank you so much requinix, you saved me hours of troubleshooting. I didn't think the problem was in my database.