PHP - Mysql Errors In Insert.php

When submitting the form, the records are sometimes inserted and sometimes not.  I receive no errors stating what the problem is.

Code: [Select]
<?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 customer_tbl (customer_first_name, customer_last_name, customer_company, customer_ac, customer_phone, customer_fax_ac, customer_fax_phone, customer_email) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['customer_first_name'], "text"),
                       GetSQLValueString($_POST['customer_last_name'], "text"),
                       GetSQLValueString($_POST['customer_company'], "text"),
                       GetSQLValueString($_POST['customer_ac'], "text"),
                       GetSQLValueString($_POST['customer_phone'], "text"),
                       GetSQLValueString($_POST['customer_fax_ac'], "text"),
                       GetSQLValueString($_POST['customer_fax_phone'], "text"),
                       GetSQLValueString($_POST['customer_email'], "text"));

$customer_id = false;
if(mysql_query($insertSQL, $connCid))
$customer_id = mysql_insert_id();
else
echo "There was an error.";
}
  
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO quote_request_tbl (customer_id, quote_trans_date, quote_from_company, quote_from_address, quote_from_city, quote_from_state, quote_from_zip, quote_to_company, quote_to_address, quote_to_city, quote_to_state, quote_to_zip, quote_comments) VALUES ('$customer_id', %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['quote_trans_date'], "text"),
                       GetSQLValueString($_POST['quote_from_company'], "text"),
                       GetSQLValueString($_POST['quote_from_address'], "text"),
                       GetSQLValueString($_POST['quote_from_city'], "text"),
                       GetSQLValueString($_POST['quote_from_state'], "text"),
                       GetSQLValueString($_POST['quote_from_zip'], "text"),
                       GetSQLValueString($_POST['quote_to_company'], "text"),
                       GetSQLValueString($_POST['quote_to_address'], "text"),
                       GetSQLValueString($_POST['quote_to_city'], "text"),
                       GetSQLValueString($_POST['quote_to_state'], "text"),
                       GetSQLValueString($_POST['quote_to_zip'], "text"),
                       GetSQLValueString($_POST['quote_comments'], "text"));
  
  $quote_id = false;
if(mysql_query($insertSQL, $connCid))
$quote_id = mysql_insert_id();
else
echo "There was an error.";
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1") && (isset($quote_id))) {
  $insertSQL = sprintf("INSERT INTO building_tbl (quote_id, building_quantity, building_width, building_length, building_height, building_overhang, slope_id, building_type_id, manufacture_id, foundation_id) VALUES ('$quote_id', %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['building_quantity1'], "int"),
                       GetSQLValueString($_POST['building_width1'], "int"),
                       GetSQLValueString($_POST['building_length1'], "int"),
                       GetSQLValueString($_POST['building_height1'], "int"),
                       GetSQLValueString($_POST['building_overhang1'], "int"),
                       GetSQLValueString($_POST['slope_id1'], "int"),
                       GetSQLValueString($_POST['building_type_id1'], "int"),
                       GetSQLValueString($_POST['manufacture_id1'], "int"),
                       GetSQLValueString($_POST['foundation_id1'], "int");

  mysql_select_db($database_connCid, $connCid);
  $Result1 = mysql_query($insertSQL, $connCid) or die(mysql_error());

header('Location: index.php?view=article&id=7');
}

mysql_select_db($database_connCid, $connCid);
$query_rsSlope = "SELECT * FROM slope_tbl ORDER BY slope_id ASC";
$rsSlope = mysql_query($query_rsSlope, $connCid) or die(mysql_error());
$row_rsSlope = mysql_fetch_assoc($rsSlope);
$totalRows_rsSlope = mysql_num_rows($rsSlope);
$query_rsSlope = "SELECT * FROM slope_tbl ORDER BY slope_id ASC";
$rsSlope = mysql_query($query_rsSlope, $connCid) or die(mysql_error());
$row_rsSlope = mysql_fetch_assoc($rsSlope);
$totalRows_rsSlope = mysql_num_rows($rsSlope);

mysql_select_db($database_connCid, $connCid);
$query_rsBuildingType = "SELECT * FROM building_type_tbl ORDER BY building_type_id ASC";
$rsBuildingType = mysql_query($query_rsBuildingType, $connCid) or die(mysql_error());
$row_rsBuildingType = mysql_fetch_assoc($rsBuildingType);
$totalRows_rsBuildingType = mysql_num_rows($rsBuildingType);

mysql_select_db($database_connCid, $connCid);
$query_rsManufacture = "SELECT * FROM manufacture_tbl ORDER BY manufacture_name ASC";
$rsManufacture = mysql_query($query_rsManufacture, $connCid) or die(mysql_error());
$row_rsManufacture = mysql_fetch_assoc($rsManufacture);
$totalRows_rsManufacture = mysql_num_rows($rsManufacture);

mysql_select_db($database_connCid, $connCid);
$query_rsFoundation = "SELECT * FROM foundation_tbl ORDER BY foundation_name ASC";
$rsFoundation = mysql_query($query_rsFoundation, $connCid) or die(mysql_error());
$row_rsFoundation = mysql_fetch_assoc($rsFoundation);
$totalRows_rsFoundation = mysql_num_rows($rsFoundation);
?>

I belve the problem is in this part of the code:

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

Many thanks in advance.

Hi, I"m trying to create insert images files name into the database and save images in folder, however, after i created databse connection, and excuted it... I'm getting error message said


Parse error: syntax error, unexpected $end in C:\xampp\htdocs\ourdeaf\uploadimages\upload.php on line 76

That line 76 is at end of code after </html>, what went wrong!


Code: [Select]
<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post" 
ENCTYPE="multipart/form-data">
Upload:<br><br>
<input type="file" name="image"><br><br>
<input type="hidden" name="uploaded" value="1">
<input type="submit" value="Upload">
</form>

<?
}else{
//if the form hasn't been submitted then:

//from here onwards, we are copying the file to the directory you made earlier, so it can then be moved 
//into the database. The image is named after the persons IP address until it gets moved into the database

//get users IP
$ip=$REMOTE_ADDR;

//don't continue if an image hasn't been uploaded
if (!empty($image)){

//copy the image to directory
copy($image, "./temporary/".$ip."");

//open the copied image, ready to encode into text to go into the database
$filename1 = "./temporary/".$REMOTE_ADDR;
$fp1 = fopen($filename1, "r");

//record the image contents into a variable
$contents1 = fread($fp1, filesize($filename1));

//close the file
fclose($fp1);

//encode the image into text
$encoded = chunk_split(base64_encode($contents1)); 

//insert information into the database
mysql_query("INSERT INTO images (img,data)"."VALUES ('NULL', '$encoded')");

//delete the temporary file we made
unlink($filename1);
}

//end
}
?>

I have a form with a series of text boxes where the User enters specific data, be it text, numeric, or date/time.  It is not mandatory to fill in every box, but when I submit the form to be put into a mysql table, I get errors such as

"Incorrect time value: '' for column 'starttime' at row 1"
"Incorrect decimal value: '' for column 'workkj' at row 1"


How can I setup the mysql table to accept blank answers?  Or is there something I need to do in php to fix this?

Sorry if this is simple... I'm still learning.
Thanks for the help!

I cannot get this INSERT to work. Not records are being added to the sys_city_dev table. No query errors are being thrown.

I am simply trying to add ALL records from all_illinois to sys_city_dev and Mid should have be add as 11 in all inserts. city_name of course will be field city_name from all_illinois.

Here is my code:

$query = "SELECT * FROM all_illinois";
      if ($results = mysqli_query($cxn, $query))
        {
          $row_cnt = mysqli_num_rows($results);
          echo $row_cnt . " Total Records in Query.<br /><br />";
          if (mysqli_num_rows($results))
            {
              while ($rows = mysqli_fetch_array($results))
                {
                  echo $rows['city_name'] . "<br />";
                  $mid_id = '11';
                  $insert_city_query = "INSERT INTO sys_city_dev (ID, Mid, cityName, forder, disdplay, cid) VALUES
(' ','" . $mid_id . "','" . $rows['city_name'] . "', '', '','')";
                  if (!$insert_city_query)
                      exit(mysql_error());
                }
            }
        }

Here is my insert table structure and 5 records dump:

--
-- Table structure for table `sys_city_dev`
--

CREATE TABLE IF NOT EXISTS `sys_city_dev` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Mid` int(11) NOT NULL DEFAULT '0',
  `cityName` varchar(30) NOT NULL DEFAULT '',
  `forder` int(4) NOT NULL DEFAULT '0',
  `disdplay` int(4) NOT NULL DEFAULT '0',
  `cid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=113970 ;

--
-- Dumping data for table `sys_city_dev`
--

INSERT INTO `sys_city_dev` (`ID`, `Mid`, `cityName`, `forder`, `disdplay`, `cid`) VALUES
(84010, 1, 'Dothan', 0, 0, 0),
(84011, 1, 'Alabaster', 0, 0, 0),
(84012, 1, 'Birmingham', 0, 0, 0),
(84013, 2, 'Flagstaff', 0, 0, 0),
(84014, 1, 'Auburn', 0, 0, 0);


And the all_illinois dump w/ 5 records:

--
-- Table structure for table `all_illinois`
--

CREATE TABLE IF NOT EXISTS `all_illinois` (
  `state_id` varchar(255) NOT NULL,
  `city_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `all_illinois`
--

INSERT INTO `all_illinois` (`state_id`, `city_name`) VALUES
('135', 'Abingdon'),
('135', 'Adair'),
('135', 'Addieville'),
('135', 'Addison'),
('135', 'Adrian');

Can anyone tell me why this is not INSERTing? My array data is coming out just fine.. I've tried everything I can think of and cannot get anything to insert.. Ahhhh!

<?php
  $query = "SELECT RegionID, City FROM geo_cities WHERE RegionID='135'";
  $results = mysqli_query($cxn, $query);
  $row_cnt = mysqli_num_rows($results);
  echo $row_cnt . " Total Records in Query.<br /><br />";
  if (mysqli_num_rows($results)) {
      while ($row = mysqli_fetch_array($results)) {
          $insert_city_query = "INSERT INTO all_illinois SET state_id=$row[RegionID], city_name=$row[City] WHERE id = null" or mysqli_error();
          $insert = mysqli_query($cxn, $insert_city_query);
          if (!$insert) {
              echo "INSERT is NOT working!";
              exit();
          }
          
          echo $row['City'] . "<br />";
          
          echo "<pre>";
          echo print_r($row);
          echo "</pre>";
      }
      //while ($rows = mysqli_fetch_array($results))
      
      } //if (mysqli_num_rows($results))
      
      else {
          echo "No results to get!";
      }
?>

Here is my all_illinois INSERT table structu

CREATE TABLE IF NOT EXISTS `all_illinois` (
  `state_id` varchar(255) NOT NULL,
  `city_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Here is my source table geo_cities structu

CREATE TABLE IF NOT EXISTS `1` (
  `CityId` varchar(255) NOT NULL,
  `CountryID` varchar(255) NOT NULL,
  `RegionID` varchar(255) NOT NULL,
  `City` varchar(255) NOT NULL,
  `Latitude` varchar(255) NOT NULL,
  `Longitude` varchar(255) NOT NULL,
  `TimeZone` varchar(255) NOT NULL,
  `DmaId` varchar(255) NOT NULL,
  `Code` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;