Hey guys,
First post here - thanks for providing such a great resource.
Having a bit of trouble with this tutorial.
I’ve gone through it exactly and it doesn’t seem to work for me.
MySQL database is working fine as I can connect to it using the PHP page provided and add users to it.
Therefore there must be something wrong with the PHP / Flash Communication.
The code im using is the same as the tutorial but i’ll post it anyway:
First Frame
stop();
userinput.restrict="a-zA-Z0-9";
Selection.setFocus(userinput);
passinput.restrict="a-zA-Z0-9";
status="Enter your information and submit";
this.onEnterFrame = function () {
if(_root.checklog == 1){
_root.gotoAndStop(2);
}
if(_root.checklog == 2){
_root.gotoAndStop(3);
}
}
on ‘submit’ button:
on (release, keyPress "<Enter>") {
if (user != "" && pass != "") {
status = "Begin Login Process - Wait...";
loadVariablesNum("newlogin.php", 0, "POST");
}
}
The php file:
<?
//this pulls the variables from the flash movie when the user
//hits submit. Use this when your global variables are off.
//I don't know how to toggle global variables, so I just put
//it in all the time ;)
$user=$_GET['user'];
$pass=$_GET['pass'];
//connect to database
if ($user && $pass){
mysql_pconnect("*mydatabaseaddress*","*myuser*","*mypassword*") or die ("didn't connect to mysql");
mysql_select_db("*mydatabase*") or die ("no database");
//make query
$query = "SELECT * FROM auth WHERE username = '$user' AND userpassword = '$pass'";
$result = mysql_query( $query ) or die ("didn't query");
//see if there's an EXACT match
$num = mysql_num_rows( $result );
if ($num == 1){
print "status=You're in&checklog=1";
} else {
print "status=Sorry, but your user name and password did not match a user name/password combination in our database. Usernames and passwords are entered in from a different file. Thank you for visiting test login script!!&checklog=2";
}
}
?>
As I said the php file provided with the tutorial worked fine after i tweaked the ‘post’ and ‘get’ statements for my server so communication there seems to be fine. However when I run the flash movie I type in the login details in accordance with my database and the whole thing just sticks on the first frame. I have had it skip to the last frame to inform me my details were wrong several times but it seems to have stopped doing that now.
Im developing it in CS3 instead of the labelled MX - could this be a problem?
Thanks.