Can't Insert Values into MySQL, Blank Fields!!

fxmaster

Hi All,

I am a newbie so please bare with me, Thanks! - I am trying to create a simple INSERT throug a FORM and I am getting empty fields into the DataBase, it inserts a record line but no DATA, the proccess is: 1 Form Page calls 1 Process Page here:

Form Page : additem.php

<html>
<head>
<title>xxxxxxxxxxxx</title>
<style type="text/css">

</style>
<link rel="STYLESHEET" type="text/css" href="zi3.css">

	
<?PHP

function WriteDateSelect($BeginYear = 1998, 
                     $EndYear = 2007, 
                     $IsPosted = true,
                     $Prefix = '')
{
  if (! $BeginYear)
  {
    $BeginYear = date('Y');
  }

  if (! $EndYear)
  {
    $EndYear = $BeginYear;
  }

  $Year = $IsPosted 
          ? (int) $_POST[$Prefix . 'Year']
          : (int) $_GET[$Prefix . 'Year'];
  $Month = $IsPosted 
          ? (int) $_POST[$Prefix . 'Month']
          : (int) $_GET[$Prefix . 'Month'];
  $Day = $IsPosted 
          ? (int) $_POST[$Prefix . 'Day']
          : (int) $_GET[$Prefix . 'Day'];

  echo '<select name="', $Prefix, 'Year">
         ';

  for ($i = $BeginYear; $i <= $EndYear; $i++)
  {
    echo '<option ';

if ($i == $Year)
  echo 'selected="yes"';

echo '>', $i, '</option>
     ';
  }

  echo '</select>-
        <select name="', $Prefix, 'Month">
          ';	

  for ($i = 1; $i <= 12; $i++)
  {
    echo '<option ';

if ($i == $Month)
  echo 'selected="yes"';

echo '>', $i, '</option>
     ';
  }

  echo '</select>-
        <select name="', $Prefix, 'Day">
          ';	

  for ($i = 1; $i <= 31; $i++)
  {
    echo '<option ';

if ($i == $Day)
  echo 'selected="yes"';

echo '>', $i, '</option>
     ';
  }

  echo '</select>
       ';
  return;
}


?>

</head>

<h3>Please enter the information below to ADD the new item</h3>

<FORM NAME="additem" ACTION="itemADD.php" METHOD="POST">
<table align="left" cellspacing="2" cellpadding="2" border="0">
<tr>
<td><span class="contents">Services Type: </span></td>
<td><select name="servicestype" size="1" >
<option value="">-- Select Type --</option>
<option value="C">Connectivity</option>
<option value="D">Data Center</option>
<option value="H">Hosting</option>
<option value="N">Network</option>
<option value="O">Office</option>
<option value="W">Wireless</option>
</select></td>
</tr>
<tr>
<td><span class="contents">Asset Type: </span></td>
<td><select name="assettype" size="1">
<option value="">-- Select Type --</option>
<option value="Antenna">Antenna</option>
<option value="Hub/Switch">Hub/Switch</option>
<option value="Modem">Modem</option>
<option value="PC">PC</option>
<option value="Peripherals">Peripherals</option>
<option value="Phone">Phone</option>
<option value="Router">Router</option>
<option value="Server">Server</option>
<option value="Software">Software</option>
<option value="W. Hardware">W. Hardware</option>
<option value="Other">Other</option>
</select></td>
</tr>
<tr>
<td><span class="contents">Manufacturer: </span></td>
<td><input type="Text" name="manufacturer" required="No" size="30" maxlength="50" ></td>
</tr>
<tr>
<td><span class="contents">Model: </span></td>
<td><input type="Text" name="model" required="No" size="30" maxlength="50"></td>
</tr>
<tr>
<td><span class="contents">Date Purchased: </span></td>
<td>

<? WriteDateSelect(1998, 2007, true, 'purchased'); ?>

</td>
</tr>
<tr>
<td><span class="contents">Purchased Price: </span></td>
<td><input type="Text" name="price" message="Please enter a Purchased Price!" validate="integer" required="Yes" size="10" maxlength="10"> <span class="contents">(CAD)</span></td>
</tr>
<tr>
<td><span class="contents">Leased / Owned: </span></td>
<td><select name="leaseown" size="1">
<option value="">-- Select --</option>
<option value="leased">Leased</option>
<option value="owned">Owned</option>
</select></td>
</tr>
<tr>
<td><span class="contents">Location: </span></td>
<td><select name="location" size="1">
<option value="">-- Select Location --</option>
<option value="Client">Client</option>
<option value="DataCenter">Data Center</option>
<option value="Network">Network</option>
<option value="Office">Office</option>
<option value="StoreRoom">Store Room</option>
</select></td>
</tr>
<tr>
<td><span class="contents">Assigned to: </span></td>
<td><input type="Text" name="userid" required="No" size="30" maxlength="50"></td>
</tr>
<tr>
<td><span class="contents">Date Assigned: </span></td>
<td>

<? WriteDateSelect(2001, 2007, true, 'dateassigned'); ?>

</td>
</tr>
<tr>
<td><span class="contents">Client Address: </span></td>
<td><input type="Text" name="clientaddress" required="No" size="30" maxlength="50"></td>
</tr>
<tr>
<td><span class="contents">Client Status: </span></td>
<td><select name="leaseown" size="1">
<span class="contents"><option value="">-- Select --</option>
<option value="Active">Active</option>
<option value="Deactivated">Deactivated</option>
</select></span></td>
</tr>
<tr>
<td valign="top"><span class="contents">Comments: </span></td>
<td><textarea name="comments" rows="7" cols="23"></textarea></td>
</tr>
<tr>
<tr>
<td valign="top" colspan="2" align="center"><input type="Submit" value="ADD">   <input type="Reset" value="CLEAR"></td>
</tr>
<tr>
<td colspan="2" align="center"><span class="bot">xxxxx

<?=date("Y")?>

</body>

</html>

Process Page: itemADD.php

<?
$DBhost = "xx.xxx.xxx.xx";
$DBuser = "userOK";
$DBpass = "passOK";
$DBName = "DBnameOK";
$table = "tableOK";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

@mysql_select_db("$DBName") or die("Unable to select
database $DBName");

$date = date(Y-m-d);

$sqlquery = "INSERT INTO $table (Service_Type,Asset_Type,Manufacturer,Model,Date_Purchased,Price,Location,Date_Assigned,Client_Address,Status,User_ID,Comments,Leaseown,Date_entered)
VALUES('$servicetype','$assettype','$manufacturer','$model','$purchased',$price,'$location','$assigned','$clientaddress','$status','$userid','$comments','$leaseown','$date') ";

$results = mysql_query($sqlquery);

mysql_close();

print "<HTML><TITLE> PHP and MySQL </TITLE><BODY
BGCOLOR=\"#FFFFFF\"><center><table border=\"0\"
width=\"500\"><tr><td>";
print "<p><font face=\"verdana\" size=\"+0\"> <center>You
Just Entered This Information Into the
Database<p><blockquote>";
print "AssetType : $assettype<p>Model : $model<p>Comments :
$comments</blockquote></td></tr></table>
</center></BODY></HTML>";
?>

----------------------------

Please HELP!!!, Gift Certificates for BEER available!! he he

Thanks!

Fxmaster:p

cgraz

All I looked at was your insert statement, this may be your error

'$date = date(Y-m-d)') ";

What exactly are you trying to do? If you're trying to insert the date, you could do a few things.


// define variable outside of INSERT statement
$date = date(Y-m-d);

$sqlquery = "INSERT INTO $table  (Service_Type,Asset_Type,Manufacturer,Model,
Date_Purchased,Price,Location,Date_Assigned,Client_Address,Status,User_ID,
Comments,Leaseown,Date_entered)  VALUES
('$servicetype','$assettype','$manufacturer' ,'$model','$purchased',$price,
'$location','$assigned','$clientaddress','$status','$userid','$comments',
'$leaseown','$date')";

The other method would be to use MySQL's NOW() function to insert the current date and format it the way you want using DATE_FORMAT()

$sqlquery = "INSERT INTO $table  (Service_Type,Asset_Type,Manufacturer,Model,
Date_Purchased,Price,Location,Date_Assigned,Client_Address,Status,User_ID,
Comments,Leaseown,Date_entered)  VALUES
('$servicetype','$assettype','$manufacturer' ,'$model','$purchased',$price,
'$location','$assigned','$clientaddress','$status','$userid','$comments',
'$leaseown',DATE_FORMAT(now(), '%Y-%m-%d'))";

Code hasn't been tested but something to that extent.

Cgraz

fxmaster

Hi Cgraz,

Yeah nope that's not it I actually had the variable set outside the INSERT for the Date, I have edited my posting to reflect that. I have also tried a very simple INSERT form and it still doesn't add the Values to the DB.

ALSO tried this as a test:

addME.php

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>xxxxxxxxxx</title>
<style type="text/css">

</style>
<link rel="STYLESHEET" type="text/css" href="zi3.css">

</head>

<h3>Please enter the information below to ADD the new item</h3>

<FORM NAME="additem" ACTION="addMEdo.php" METHOD="POST">
<table align="left" cellspacing="2" cellpadding="2" border="0">
<tr>
<td><span class="contents">Name: </span></td>
<td><input type="Text" name="name" required="No" size="30" maxlength="50" ></td>
</tr>
<tr>
<td><span class="contents">Lat Name: </span></td>
<td><input type="Text" name="lname" required="No" size="30" maxlength="50"></td>
</tr>
<tr>
<td valign="top"><span class="contents">Comments: </span></td>
<td><textarea name="comments" rows="7" cols="23"></textarea></td>
</tr>
<tr>
<tr>
<td valign="top" colspan="2" align="center"><input type="Submit" value="ADD">   <input type="Reset" value="CLEAR"></td>
</tr>
<tr>
<td colspan="2" align="center"><span class="bot">xxxxxxx

<?=date("Y")?>

</body>
</html>

addMEdo.php

$DBhost = "xx.xxx.xxx.xx";
$DBuser = "xxxxx";
$DBpass = "xxxxxx";
$DBName = "xxxxxxx";
$table = "xxxxxx";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

@mysql_select_db("$DBName") or die("Unable to select
database $DBName");

$sqlquery = "INSERT INTO $table (name,lname,comments)
VALUES('$name','$lname','$comments') ";

$results = mysql_query($sqlquery);

mysql_close();

print "<HTML><TITLE> PHP and MySQL </TITLE><BODY
BGCOLOR=\"#FFFFFF\"><center><table border=\"0\"
width=\"500\"><tr><td>";
print "<p><font face=\"verdana\" size=\"+0\"> <center>You
Just Entered This Information Into the
Database<p><blockquote>";
print "Name : $name<p>Last Name : $lname<p>Comments :
$comments</blockquote></td></tr></table>
</center></BODY></HTML>";

Even that doesn't INSERT in the DB it does INSERT a record line but no DATA, what am I doing wrong??, I think I may not be passing the VALUE strings properly to the process page!!!

Fxmaster

cgraz

On this example:

$sqlquery = "INSERT INTO $table (name,lname,comments)
VALUES('$name','$lname','$comments') ";

you should echo $name, $lname, and $comments somewhere on the page and see if they even have values.

echo "Name " . $name . "<br>";
echo "Last Name " . $lname . "<br>";
echo "Comments " . $comments . "<br>";

If that returns no value, try


echo "Name " . $_POST['name'] . "<br>";
echo "Last Name " . $_POST['lname'] . "<br>";
echo "Comments " . $_POST['comments'] . "<br>";

If your form used get, then $_get['fieldname']

Let me know how that works.

Cgraz

fxmaster

Hey Cgraz,

First of all thanks for all your help, and I now DO GET values showing in the next page when I use:

echo "Name " . $_POST['name'] . "<br>";
echo "Last Name " . $_POST['lname'] . "<br>";
echo "Comments " . $_POST['comments'] . "<br>";


$sqlquery = "INSERT INTO $table (name,lname,comments)
VALUES ('$name', '$lname','$comments') ";

but how do I use them in the INSERT query still nothing gets written in the DB, I KNow... I am fairly new to PHP and MySQL, I think with your next reply, I can make it work!! (crossing fingers) 🙂

Thanks!

Fxmaster

cgraz

Here's how you can plug those values into your query:

$name = $_GET['name'];
$lname = $_GET['lname'];
$comments $_GET['comments'];

$sqlquery = "INSERT INTO $table (name,lname,comments)
VALUES ('$name', '$lname','$comments') ";

Let me know how that works.

Cgraz

fxmaster

Hello Cgraz,

Thanks for all your HELP, the plaintext fields are INSERTING now in the DB 😃 , with the following:

$name = $_POST['name'];
$lname = $_POST['lname'];
$comments $_POST['comments'];

$sqlquery = "INSERT INTO $table (name,lname,comments)
VALUES ('$name', '$lname','$comments') ";

the only thing that I am having an issue with is inserting the date, I have 2 Date Fields in my ORIGINAL form which calls a function for the dropdown of the date, you can view it in the very first posting but somehow I don't know why those values are not being sent.

If you can help me with this last thing, it would be much appreciated, if not I understand!!

Thanks again!!

Cheers!

Fxmaster😃

cgraz

Does the visitor need to see the date or do you just want to record the date in the database when the visitor filled out that form? If you just want to input the date when the visitor filled out the form,

Use MySQL's NOW() function to insert the current date and format it the way you want using DATE_FORMAT(). Both of these can be found at http://www.mysql.com/doc/en/Date_and_time_functions.html

If you want to display the date, then just make a variable called $current_date and use php's date functions to get the date the way you want it displayed. Then on your INSERT page, call the $current_date variable using

$current_date = $_GET['current_date'];

or just use php to get the current date again. Then INSERT.

Cgraz

fxmaster

Thanks for all your HELP Cgraz!! 🆒