";
echo "Connection failed. ";
die(mysql_error());
}
if (!mysql_select_db('exdb', $con)) {
die("Selecting DB failed: " . mysql_error());
}
mysql_query("SET NAMES utf8");
$rec1 = $_POST["fld_sid"];
$rec2 = $_POST["fld_telno"];
$rec3 = $_POST["fld_sname"];
$rec4 = $_POST["fld_regdate"];
$rec5 = $_POST["fld_reginvent"];
$rec6 = $_POST["fld_type"];
$rec7 = $_POST["fld_accid"];
$rec8 = $_POST["fld_uplevel"];
$rec9 = $_POST["fld_creditlimit"];
$rec10 = $_POST["fld_discount"];
$rec11 = $_POST["fld_contactid"];
$rec12 = $_POST["fld_identityid"];
$rec13 = $_POST["fld_comments"];
// data check
if ($rec1==NULL) {
echo "" . "0" . "
";
echo "" . "Missing Field" . "
";
echo "
";
die('Error: field SID is empty ');
}
// database access
$sql = 'INSERT INTO `exdb`.`tblclnt` (`sid`, `telno`, `sname`, `regdate`, `reginvent`, `type`, `accid`, `uplevel`, `creditlimit`, `discount`, `contactid`, `identityid`, `comments`) VALUES ("' . $rec1 . '", "' . $rec2 . '" ,"' . $rec3 . '" ,"' . $rec4 . '" ,"' . $rec5 . '" ,"' . $rec6 . '" ,"' . $rec7 . '" ,"' . $rec8 . '" ,"' . $rec9 . '" ,"' . $rec10 . '" ,"' . $rec11 . '" ,"' . $rec12 . '" ,"' . $rec13 . '");';
echo "
";
echo $sql;
if (!mysql_query($sql,$con))
{
echo "" . "0" . "
";
echo "" . mysql_error() . "
";
echo "
";
die('Error: ' . mysql_error());
}
mysql_close($con);
echo "" . "-1" . "
";
echo "" . "no errors" . "
";
?>