saads
07-04-2007, 06:17 AM
Hey, Im trying to get an integer value passed into php, but it's comming as 0 once it gets into php. Here is my code:
Flash:
var regVars = new LoadVars();
regVars.action = 'register';
regVars.username = userName.text;
regVars.pass = userPassword.text;
regVars.email = userMail.text;
regVars.question = secretQuestion.text;
regVars.answer = secretAnswer.text;
regVars.money = mymoney.text;
regVars.sendAndLoad(php_file, regVars, 'POST');
PHP:
function register($username,$pass,$email,$question,$answer, $money)
{
GLOBAL $db, $table;
$username = trim($username);
$pass = trim($pass);
$email = trim($email);
$money = trim($money);
if($money == 0)
{
$money = 100;
}
$question = addslashes(trim($question));
$answer = addslashes(trim($answer));
$validEmail = valid_email($email);
$validName = valid_userName($username);
$validPass = valid_password($pass);
if(!$validName) return "error=invalid name";
if(!$validPass) return "error=invalid password";
if(!$validEmail) return "error=invalid email";
$pass = md5(trim($pass));
// all checks ok
$query = @mysql_query("INSERT INTO $table (userName,userPassword,userMail,userQuestion,userA nswer,money) VALUES "
."('$username','$pass','$email','$question','$answer ','$money')");
if(!$query)
{
return "error=" . mysql_error();
} else {
return "user=ok";
}
}
in mysql money is an int(255) I made the if statement to see if it's zero to test what part of the code was wrong. In the mysql database money is always comming in as 100, even though I put in different values. What am I doing wrong, please help me.
Thanks
Flash:
var regVars = new LoadVars();
regVars.action = 'register';
regVars.username = userName.text;
regVars.pass = userPassword.text;
regVars.email = userMail.text;
regVars.question = secretQuestion.text;
regVars.answer = secretAnswer.text;
regVars.money = mymoney.text;
regVars.sendAndLoad(php_file, regVars, 'POST');
PHP:
function register($username,$pass,$email,$question,$answer, $money)
{
GLOBAL $db, $table;
$username = trim($username);
$pass = trim($pass);
$email = trim($email);
$money = trim($money);
if($money == 0)
{
$money = 100;
}
$question = addslashes(trim($question));
$answer = addslashes(trim($answer));
$validEmail = valid_email($email);
$validName = valid_userName($username);
$validPass = valid_password($pass);
if(!$validName) return "error=invalid name";
if(!$validPass) return "error=invalid password";
if(!$validEmail) return "error=invalid email";
$pass = md5(trim($pass));
// all checks ok
$query = @mysql_query("INSERT INTO $table (userName,userPassword,userMail,userQuestion,userA nswer,money) VALUES "
."('$username','$pass','$email','$question','$answer ','$money')");
if(!$query)
{
return "error=" . mysql_error();
} else {
return "user=ok";
}
}
in mysql money is an int(255) I made the if statement to see if it's zero to test what part of the code was wrong. In the mysql database money is always comming in as 100, even though I put in different values. What am I doing wrong, please help me.
Thanks