Still I’m strugling fixing my as2 script to integrate to my “register.php” and “login.php”
stop();
logged = new LoadVars();
registered = new LoadVars();
//error messages
err = new Array();
err[0] = "Login Failed.";
err[1] = "Login Successful.";
err[2] = "Register Failed.";
err[3] = "Register Successful.";
err[4] = "Connection Failed.";
//getmyDB pass the params: reguser.text, regpass,text, loadvars name, php file name
function getmyDB(user, pass, varname, phpname) {
if (user.length>0 && pass.length>0) {
varname.user = user;
varname.pass = pass;
varname.regname = regname.text;
varname.regmidname = regmidname.text;
varname.reglastname = reglastname.text;
varname.regcountry = regcountry.text;
varname.regstate = regstate.text;
varname.regdatejoined = regdatejoined.text;
varname.regemail = regemail.text;
varname.regtestimonies = regtestimonies.text;
varname.sendAndLoad(phpname,varname,"GET");
//if loadVars success, flash will display data from string sent by php file with resultData()
//if loadVars failed, throw error err[4] = "Connection Failed."
varname.onLoad = function(success) {
if (success) {
resultData(this);
} else {
regerr.text = err[4];
}
};
} // you can add else here such as, "please fill the form"
}
//this function will display message from err array, depends on "valid" string dan php's message
//if this.valid == 0, it means "Login Failed"
//valid == 3 means "Register success".. so on
//please check out the php file
function resultData(theloadvar) {
res = parseInt(theloadvar.valid); //or Number(theloadvar.valid);
//if login failed, go to "registration" frame
if (res == 0) {
gotoAndStop(1);
}
//if login valid, go to content
if (res == 1) {
gotoAndStop(2)
}
//registration done
if (res == 3) {
gotoAndStop(1)
// or gotoAndStop("login")
}
}
//// button register //////
regbtn.onRelease = function() {
getmyDB(reguser.text,regpass.text,registered,"register.php");
};
//// button login //////
logbtn.onRelease = function() {
getmyDB(reguser.text,regpass.text,logged,"login.php");
};
and here is my php codes for “register.php”
<?phpsession_start();include_once('dbconnect.php');
$user = $_GET['user'];$pass = $_GET['pass'];
$result = mysql_query("SELECT * FROM db452173471 WHERE users = '$users'");$num = mysql_num_rows($result);
if($num > 0){ $string = "&valid=2"; } else { mysql_query("INSERT INTO db452173471 (id,user,pass)VALUES (NULL,'$user','$pass')"); $string = "&valid=3&user=$user";
}echo $string; ?>
and here my php codes for “login.php”
<?phpsession_start();include('dbconnect.php');
$user = $_GET[''];$pass = $_GET[''];
/////$afterLoginRedirect = 'index.html';
$result=mysql_query("SELECT * FROM db452173471 WHERE users = '$user' AND pass ='$pass'");$num = mysql_num_rows($result);
$string = "&valid=$num&user=$user";echo $string; ?>
If anyone knows how to fix this, kindly help me please…I already connected to the database, the only problem i have is how my as2 scripts interact with my php scripts the register and login.