Hi Absolute Newb here,
I am having trouble submitting my data to mysql database.
"Error inserting data" - comes from the code written in below.
Can anyone help? Thank you!
<html>
<body>
<h2>Enter Company Invoice</h2>
<STYLE>
.error {padding: 10px; color: #cc0000; font-weight: bold;}
</STYLE>
<?
if ($_POST) {
$msg = "";
foreach($_POST as $k => $v) {
$v = trim($v) ;
$k = $v ;
if ($v=="") {
$msg = "Please fill in both fields Bec!";
}
}
if ($msg=="") {
$insert = "INSERT INTO digitalp_receivables
(company, invoice_number, amount, due_date)
VALUES ('$co', '$inv', '$amt', '$dd')";
$link =
mysqli_connect('localhost','digitalp_rec','6Xl0T@ZB,{~f','digitalp_receivables');
if (!mysqli_query($link, $insert)) {
$msg = "Error inserting data";
} Else {
$msg = "Record successfully added";
$co = $inv = $amt = $dd = "";
}
mysqli_close($link);
}
echo "<div class=\"error\">$msg</div>";
} else {
$co = $inv = $amt = $dd = "";
}
?>
<FORM METHOD="post" ACTION="<? echo
$_SERVER['PHP_SELF']?>">
<TABLE BORDER="1" CELLPADDING="5">
<TR>
<TH>Company</TH>
<TH>Invoice</TH>
<TH>Amount</TH>
<TH>Due</TH>
</TR>
<TR>
<TD><INPUT TYPE="text" NAME="$co" VALUE="<?
echo $co ?>" /></TD>
<TD><INPUT TYPE= "text" NAME="$inv" VALUE="<?
echo $inv ?>" /></TD>
<TD><INPUT TYPE= "text" NAME="$amt" VALUE="<?
echo $amt ?>" /></TD>
<TD><INPUT TYPE= "text" NAME="$dd" VALUE="<?
echo $dd ?>" /></TD>
</TR>
</TABLE>
<BR/>
<INPUT TYPE= "SUBMIT" VALUE= "Add Invoice"/>
<INPUT TYPE= "RESET" VALUE="Cancel"/>
</FORM>
</body>
