Internet Commerce
Developer ChannelFlashKit.com
JavaScriptSource Developer Jobs ScriptSearch WebDeveloper.com Webreference HTMLGoodies HTML5 Dev Center Developer.com jGuru.com PHPBuilder
|
  Tutorials HomeWhat's NewTop RatedSubmitmyTutesRandom!
Search Tutorials
 Tutorials » Backend
User LoginPHP used in Login (Login.php)
$query = "SELECT * FROM $table WHERE Name = '$Name'";
$result = mysql_query($query);
$numR = mysql_num_rows($result);
#If the number of rows is not equal to one then it prints out an error statement - Name not in Database.
if ($numR == 1) {
print "_root.Status=Success Login Complete&_root.CheckLog=1";
}
else {
print "_root.Status=Failure - Your name was not found - Please register";
}
The first 2 lines of this code preforms the query on the database. It selects the record where the Name entered in the Flash movie is equal to a unique name found in the database. The next line of code (excluding the comment) checks to see if a record was returned. If a record is returned then the Login is a success. Then it prints out the results back to flash. I also pass back another variable to tell the movie if the Login was successful. In this case I named it CheckLog. The movie will keep looping the second and third frame until it successfully tests that the variable CheckLog is not equal to nothing ie it's now equal to 1. Actionscript used in Flash for Login
on (release) {
gotoAndPlay(2);
Status = "Beginning Login Process.. Please Hold";
loadVariablesNum ("Login.php?Name="+Name, "0");
}
This is the actionscript on the Login Button. Initially the movie stops at the first frame of the root of the movie. After you hit the Login button it goes to frame 2 and continues to Loop until it finds that there is a value for CheckLog. The Check part looks Like the following. if (CheckLog ne "") {
gotoAndPlay (4);
}else {
gotoAndPlay(2);
}
That's it. After a user has successfully Logged in we can Load the variables for the first Time. At first they won't have any values. So they come to rest at the default location.
|
||||||||||||||||||||||||||||||||||||||||||||||||
 |
|||||||||||||||||||||||||||||||||||||||||||||||||
mySQL and PHP - Login and Registration - Saving Movie Clip ('s) Position
|
 |
 |
|