can someone help me figure out why this code doesn't insert data into the database ?
My other problem here is that I dont know how to determine a date a month in the future(duedate). It doesn't have to be concise.
<?php?>
<html><head>
<?php
include("getinvno.php"
;
?>
<script type="text/javascript">
var today = new Date();
var date = today.getMonth() + " / " + today.getDate() + " / " + today.getFullYear();
</script>
</head>
<body onload="document.form.ordernum.focus()">
<!--increment date to create due date (next month)-->
<br><script type="text/javascript">
document.write(date);
</script>
<form name="form">
<input type="text" size="5" name="ordernum" id="ordernum"MAXLENGTH=5
onkeyup="getResults();if(this.value.length==this.size)document.form.invnum.focus();" />Order No:
<input type="text" size="5" name="invnum" id="invnum" />Invoice No:
AR/AP: <SELECT name=payrec>
<OPTION class=highlight value=ar selected>R
<OPTION class=highlight value=ap>P
</OPTION></SELECT><br>
<b>Bill</b> - Name: <INPUT TYPE="text" name=bname>
Street: <INPUT TYPE="text" name=bstreet>
State: <SELECT name=bstate>
<OPTION class=highlight value=fl selected>Florida
<OPTION class=highlight value=ga>Georgia
<OPTION class=highlight value=al>Alabama
<OPTION class=highlight value=la>Louisiana
<OPTION class=highlight value=sc>South Carolina
</OPTION></SELECT>
City: <INPUT TYPE="text" name="bcity"><br>
</OPTION></SELECT>
Zip: <INPUT TYPE="text" size=5name="bzip" MAXLENGTH=5
onKeyUp="if(this.value.length==this.size)document.form.contact.focus();"><br>
<b>Contact: </b><INPUT TYPE="text" name=contact><BR>
<b>Ship</b> - Name:
<INPUT TYPE="text" name=sname>
Street <INPUT TYPE="text" name=sstreet>
State <SELECT name=sstate>
<OPTION class=highlight value=fl selected>Florida
<OPTION class=highlight value=ga>Georgia
<OPTION class=highlight value=al>Alabama
<OPTION class=highlight value=la>Louisiana
<OPTION class=highlight value=sc>South Carolina
</OPTION></SELECT>
City: <INPUT TYPE="text" name="scity"><br>
</OPTION></SELECT>
Zip: <INPUT TYPE="text" size=5name="szip" MAXLENGTH=5
onKeyUp="if(this.value.length==this.size)document.form.terms.focus();"><p>
Terms: <SELECT name=terms>
<OPTION class=highlight value=net 10 selected>Net 10
<OPTION class=highlight value=1_10_30ga>1 10 Net 30
<OPTION class=highlight value=2_10_30>2 10 Net 30
<OPTION class=highlight value=cash>Cash
</OPTION></SELECT>
FOB: <SELECT name=fob>
<OPTION class=highlight value=Destination selected>Destination
<OPTION class=highlight value=Origin>Origin
</OPTION></SELECT><p>
<b>Dates</b> - Ordered:
<INPUT TYPE="text" size=10 name="dateord" MAXLENGTH=10
onKeyUp="if(this.value.length==this.size)document.form.datecomp.focus();">
Completed: <INPUT TYPE="text" size=10 name="datecomp" MAXLENGTH=10
onKeyUp="if(this.value.length==this.size)document.form.duedate.focus();">
Due: <INPUT TYPE="text" size=10 name="duedate" MAXLENGTH=10
onKeyUp="if(this.value.length==this.size)document.form.datepaid.focus();">
Paid: <INPUT TYPE="text" size=10 name="datepaid" MAXLENGTH=10
onKeyUp="if(this.value.length==this.size)document.form.qty.focus();"><p>
Qty: <INPUT TYPE="text" size=5 name=qty>
Description: <INPUT TYPE="text" size=25 name=descr>
Charges: <INPUT TYPE="text" size=7 name=charges>
Paid Amt: <INPUT TYPE="text" size=7 name=paidamt>
Tax: <INPUT TYPE="text" size=6 name tax><p>
<b>Shipping</b> - Date:
<INPUT TYPE="text" size=10 name "shipdate" MAXLENGTH=10
onKeyUp="if(this.value.length==this.size)document.form.shipamt.focus();">
Amt:<INPUT TYPE="text" size=7 name shipamt><p>
<b>Amount Due</b>: <INPUT TYPE="text" size=7 name=amtdue><p>
<input type="submit" value="submit data" />
</p>
</form>
</body></html>
<?php
if (isset( $_POST['payrec']) )
{
$pd=$_POST['pd'];
$payrec=$_POST['payrec'];
$ordernum=$_POST['ordernum'];
$invnum=$_POST['invnum'];
$bname=$_POST['bname'];
$bstreet=$_POST['bstreet'];
$bstate=$_POST['bstate'];
$bcity=$_POST['bcity'];
$bzip=$_POST['bzip'];
$sname=$_POST['sname'];
$sstreet=$_POST['sstreet'];
$sstate=$_POST['sstate'];
$scity=$_POST['scity'];
$szip=$_POST['szip'];
$contact=$_POST['contact'];
$terms=$_POST['terms'];
$fob=$_POST['fob'];
$shipdate=$_POST['shipdate'];
$shipamt=$_POST['shipamt'];
$dateord=$_POST['dateord'];
$datecomp=$_POST['datecomp'];
$duedate=$_POST['duedate'];
$datepaid=$_POST['datepaid'];
$qty=$_POST['qty'];
$desc=$_POST['descr'];
$charges=$_POST['charges'];
$paidamt=$_POST['paidamt'];
$dayslate=$_POST['dayslate'];
$tax=$_POST['tax'];
$amtdue=$_POST['amtdue'];
$paidsum=$_POST['paidsum'];
}
mysql_connect(localhost,root,"";
mysql_select_db(oodb) or die( "Unable to select database";
$query = "
INSERT INTO oocust (pd,payrec,ordernum,invnum,bname,bstreet,bstate,bcity,bzip,sname,sstreet,sstate,scity,szip,contact,terms,fob,shipdate,shipamt,dateord,datecomp,duedate,datepaid,qty,descr,charges,paidamt,
dayslate,tax,amtdue,paidsum)
VALUES('$pd','$payrec','$ordernum','$invnum','$bname','$bstreet','$bstate','$bcity','$bzip','$sname','$sstreet','$sstate','$scity','$szip','$contact','$terms','$fob','$shipdate','$shipamt','$dateord','$datecomp','$duedate','$datepaid','$qty','$descr',
'$charges','$paidamt','$dayslate','$tax','$amtdue','$paidsum')";
echo "data inserted</font>
";
$stat = mysql_query($query) or die('Query failed: ' . mysql_error());
mysql_close();
?>
