The things you need to be familiar with, in Flash.... LoadVars(), understand of scope, and for the love of god dont use scenes. This is a very basic sample script which checks if a username already exists, if it does send that message back to flash, if it doesnt, register that user and send email notifacation.
<?php
$table = "YourTableNameHere";
$username = "YourDatabaseUserNameHere";
$password = "YourDatabasePasswordHere";
$database = "YourDatabaseNameHere";
//-------connect to database
mysql_connect("localhost", $username, $password) or die("Could not connect to database");
mysql_select_db($database) or die("Could not select database");
$colum = $_POST['username'];
$query = "SELECT * FROM $table WHERE username='" . $colum . "'";
$myQuery = mysql_query($query);
$row = mysql_fetch_array($myQuery);
echo "&name=".$colum;
echo "&count=".count($row);
if ( count($row) > 1 ) {
echo "&mess=User Name Exists, Try Again&";
exit();
} else {
mysql_connect("localhost", $username, $password) or die("Could not connect to database");
mysql_select_db($database) or die("Could not select database");
$uname = $_POST['username'];
$pass = $_POST['pword'];
$query = "INSERT INTO temp_register VALUES ('$pass', '$uname')";
mysql_query($query);
//-------------------------------------
// the below code set the headers. There can be a bit difficult to understand fully.
// Information about them and all the commands below can be found at the PHP manual
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= "From: Some Person <addy@domain.com>" . "\r\n";
//------------------------------
// gets variables for email
$to = "addy@domain.com"; //inset the email address it goes to here
$subject = "New Registered User";
$message = "You have a new registered user.";
if ($message != "") { //this checks to make sure someone didn't visit the page manually by making sure message_txt is not empty
$ok = mail($to, $subject, $message, $headers); //this line sends the mail and returns true or false
if ($ok) {
echo "&mess=ok&"; //if mail was send print to the screen "&server_mes=ok"
} else {
echo "&mess=fail&"; // if mail was NOT sent, print to the screen "&server_mes=fail"
}
}
//Email to User
// gets variables from flash
$toa = $email; //inset the email address it goes to here
$subjecta = "New Registered User";
$messagea = "Thank you for your registration";
if ($messagea != "") { //this checks to make sure someone didn't visit the page manually by making sure message_txt is not empty
$ok = mail($toa, $subjecta, $messagea, $headers); //this line sends the mail and returns true or false
if($ok) {
echo "&mess=ok&"; //if mail was send print to the screen "&server_mes=ok"
} else {
echo "&mess=fail&"; // if mail was NOT sent, print to the screen "&server_mes=fail"
}
}
}
?>
Its not perfect but it gets the job done. In Flash you'd have a loadvars() object sending a username and password.