# AS2 registration and login form unresolved

**URL:** <https://forum.kirupa.com/t/as2-registration-and-login-form-unresolved/330479>\
**Category:** flash\
**Created:** [January 28, 2013, 7:57am UTC](https://forum.kirupa.com/t/as2-registration-and-login-form-unresolved/330479 "2013-01-28T07:57:25Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![bracelett](https://avatars.discourse-cdn.com/v4/letter/b/ac8455/32.png) [@bracelett](https://forum.kirupa.com/u/bracelett)\
**Post date:** [January 28, 2013, 7:57am UTC](https://forum.kirupa.com/t/as2-registration-and-login-form-unresolved/330479/1 "2013-01-28T07:57:25Z")

</div>

Still I’m strugling fixing my as2 script to integrate to my “register.php” and “login.php”  
stop();

```auto
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”

```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”

```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.