PDA

Click to See Complete Forum and Search --> : Need help on sending data to mysql

jahsymon
08-08-2006, 04:49 AM
hI AM NEW TO PHP. I have a perfect script according to tutorials yet it cant update my database.
It connects and returns that data has been added but when i go to the table there is nothing
Form

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
<meta name="Microsoft Theme" content="indust 000, default">
<meta name="Microsoft Border" content="none">
</head>

<body>

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns="http://www.w3.org/TR/REC-html40">

<p>
<center>
<form method="post" action="script.php">
<input type="hidden" name="entryid" value="null">
<table>
<tr><td align="left">DRN</td>
<td><input type="int" name="documentsreceivednote" size="20"></td>
</tr>
<tr><td align="left">Loading Date</td>
<td><input type="date" name="loadingdate" size="20"></td>
</tr>
<tr><td align="left">Loading Order Number</td>
<td><input type="int" name="loadingorderno" size="20"></td>
</tr>
<tr><td align="left">Ginnery</td>
<td><input type="text" name="ginnery" size="20"></td>
</tr>
<tr><td align="left">Country of Origin</td>
<td><input type="text" name="origincountryofgoods" size="10"></td>
</tr>
<tr><td align="left">Supplier</td>
<td><input type="text" name="supplier" size="20"></td>
</tr>
<tr><td align="left">Consignee</td>
<td><input type="text" name="consignee" size="25"></td>
</tr>
<tr><td align="left">Delivery Number</td>
<td><input type="text" name="deliverynumber" size="20"></td>
</tr>
<tr><td align="left">Lot Number</td>
<td><input type="text" name="lotnumber" size="20"></td>
<tr>
<td align="left">Number of Bales</td>
<td><input type="int" name="lotnumber" size="20"></td>
</tr>
<tr>
<td align="left">Type</td>
<td><input type="text" name="type" size="10"></td>
</tr>
<tr>
<td align="left">Truck Reg No.</td>
<td><input type="text" name="truckregnumber" size="20"></td>
</tr>
<tr>
<td align="left">Truck Reg Owner</td>
<td><input type="text" name="truckregowner" size="20"></td>
</tr>
<tr>
<td align="left">Contracted Transporter</td>
<td><input type="text" name="contractedtransporter" size="20"></td>
</tr>
<tr>
<td align="left">Container Number</td>
<td><input type="text" name="containernumber" size="20"></td>
</tr>
<tr>
<td align="left">Seal Number</td>
<td><input type="text" name="sealnumber" size="20"></td>
</tr>
<tr>
<td align="left">Arrival at Malaba</td>
<td><input type="date" name="arrivalatmalaba" size="20"></td>
</tr>
<tr>
<td align="left">Crossing Date</td>
<td><input type="date" name="crossingdate" size="20"></td>
</tr>
<tr>
<td align="left">FCR Number</td>
<td><input type="text" name="fcrnumber" size="20"></td>
</tr>
<tr>
<td align="left">FCR Date</td>
<td><input type="date" name="crossingdate" size="20"></td>
</tr>
<tr><td colspan="2">
<p align="center">
<input type="submit" value="Enter record"> </td>
</tr>
</table>
</form>
</center>

</body>

</html>

SCTIPT
----------------------------------------------------------------------
<?
$DBhost = "*************";
$DBuser = "8888888888";
$DBpass = "dadadadada";
$DBName = "livercot";
$table = "cotton";
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 cotton ( `$entryid` , `$documentsreceivednote` , `$loadingdate` , `$loadingorderno` , `$ginnery` , `$origincountryofgoods` , `$supplier` , `$consignee` ,`$deliverynumber` ,`$lotnumber` , `$noofbales` , `$type` , `$truckregnumber` , `$truckregowner` , `$contractedtransporter` , `$containernumber` , `$sealnumber` , `$arrivalatmalaba` , `$crossingdate` , `$fcrnumber` , `$fcrdate` , `$mombasaid` )";

$results = mysql_query($sqlquery);

mysql_close();

print "<html><body><center>";
print "<p>You have just entered this record<p>";
print "DRN : $documentsreceivednote<br>";
print "Loading Date : $loadingdate<br>";
print "L/O Number:$loadingorderno<br>";
print "Ginnery : $ginnery<br>";
print "Origin Country :$origincountryofgoods<br>";
print "Supplier :$supplier<br>";
print "Consignee :$consignee<br>";
print "Delivery Number :$deliverynumber<br>";
print "Lot Number :$lotnumber<br>";
print "Number of Bales :$noofbales<br>";
print "Type :$type<br>";
print "Truck Reg. Number :$truckregnumber<br>";
print "Truck Registered Owner :$truckregowner<br>";
print "Contracted Transporter :$contractedtransporter<br>";
print "Container Number :$containernumber<br>";
print "Seal Number :$sealnumber<br>";
print "Arrival at Malaba :$arrivalatmalaba<br>";
print "Crossing Date :$crossingdate<br>";
print "FCR Number : $fcrnumber<br>";
print "FCR Date : $fcrdate<br>";
print "Leave Blank : $mombasaid<br>";
print "</body></html>";
?>


PLEASE HELP
-------------------------------------------------------------------------- :confused:
chazzy
08-08-2006, 06:50 AM
you probably have register globals on when this script is expecting them to be off. you need to set all of those variables to something like $_POST['<<form field name>>'];
pcthug
08-08-2006, 07:33 AM
http://www.php.net/register_globals
Please wrap your php code in tags