I am using SendCollectedData to send the following properties to my webserver
Username
Companyname
User_email
PIDKEY
When I check my database on the server All is working as expected with correct values inserted into the fields, apart from PIDKEY (MaskedEdit serial code edit box).
The serial code entered in this example was:
08595-12348-81035-08964-55974
but yet the field in the database contains -149726
Is this a datatype issue or something? I have all database fields as VarChars
Any help would be greatly appreciated
Code: Select all
// get the user's serial
$serial = $_POST['PIDKEY'];
// connect to database
$db_conn = @mysqli_connect($db_host, $db_user, $db_pass, $db_name);
if(!$db_conn)
{
// issue error response
die();
}
// prepare SQL statement
$sn_query = "INSERT INTO `registration` (`user_name`, `company`, `email`, `serial`) VALUES ('" .
mysqli_real_escape_string($db_conn, $username) . "', '" . mysqli_real_escape_string($db_conn, $company) . "', '" .
mysqli_real_escape_string($db_conn, $email) . "', " . mysqli_real_escape_string($db_conn, $serial) . ");";