Code: Select all
<?php
$status=$_POST['status'];
$pd=$_POST['pd'];
$payrec=$_POST['payrec'];
$acctno=$_POST['acctno'];
$orderno=$_POST['orderno'];
$bname=$_POST['bname'];
$bstreet=$_POST['bstreet'];
$bcity=$_POST['bcity'];
$bstate=$_POST['bstate'];
$bzip=$_POST['bzip'];
$bemail=$_POST['bemail'];
$phone=$_POST['phone'];
$contact=$_POST['contact'];
$sname=$_POST['sname'];
$sstreet=$_POST['sstreet'];
$scity=$_POST['scity'];
$sstate=$_POST['sstate'];
$szip=$_POST['szip'];
$semail=$_POST['semail'];
$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'];
$descr=$_POST['descr'];
$charges=$_POST['charges'];
$tax=$_POST['tax'];
$paidamt=$_POST['paidamt'];
$dayslate=$_POST['dayslate'];
$checkno=$_POST['checkno'];
$amtdue=$_POST['amtdue'];
$stat = mysql_connect('localhost','root',' ') or die('Unable to connect to database: ' . mysql_error());
$stat = mysql_select_db('oodb') or die('Unable to select database: ' . mysql_error());
$query = "INSERT INTO oocust VALUES('$status','$pd','$payrec','$acctno','$orderno','$bname','$bstreet','$bcity','$bstate',
'$bzip','$bemail','$phone','$contact','$sname','$sstreet','$scity','$sstate','$szip','$semail','$terms','$fob','$shipdate','$shipamt',
'$dateord','$datecomp','$duedate','$datepaid','$qty','$descr','$charges','$tax','$paidamt','$dayslate','$checkno','$amtdue')";
echo "data inserted</font><br /><br />";
$stat = mysql_query($query) or die('Query failed: ' . mysql_error());
mysql_close();
?>