What an excellent inquiry! However, what you're suggesting requires some knowledge of server-based coding, like PHP or ASP. (I highly suggest PHP, so I'll work with that.)
A high-score thing demonstrating flash to server
The key to the communication is in URL Request, which you can find under flash.net. By selecting the method POST and putting your strings into your URLRequest's data property, you can transfer the data from flash to php. From the PHP file, you can do whatever you want to it on the server! (You'll probably need to know PHP)
Here's a snippet of the code from the link above:
var variables:URLVariables = new URLVariables();
variables.playerTime = a;
if (round ==1) variables.roundNum = "roundOneTime";
else if (round==2) variables.roundNum = "roundTwoTime";
else variables.roundNum = "roundThreeTime";
var request:URLRequest = new URLRequest();
///////////////change this url to wherever you placed the file
request.url = "http://www.blinkdagger.com/tutorials/flash/targetPractice/getRankingFlashScores.php";
/////////////////////////////////////////////////////////////////////////////
request.data = variables;
var loader:URLLoader = new URLLoader();
loader.load(request);
loader.addEventListener(Event.COMPLETE,displayRanking)
Notice that the variables are put in a URLVariables object, which acts like an Actionscript Object. You can have the names of your strings on the URL Variables.
I know enough PHP that I can tell you what happens to those variables. If you've chosen the method POST (Which I HIGHLY suggest you do,) you can access your variables inside the requested PHP server page by typing $_POST["variablename"]. Here's the PHP snippet from the demonstration:
////////////////////////////////////// fill in info here //////////////////////////
$host = "";
$user = "";
$password = "";
$table = "";
$database = "";
/////////////////////////////////////////////////////////////////////////////////////
$one = $_GET['one'];
$two = $_GET['two'];
$three= $_GET['three'];
$four = $_GET['four'];
$five = $_GET['five'];
// Connect to the database server
$dbcnx = @mysql_connect($host,
$user, $password);
if (!$dbcnx) {
echo( "<P>Unable to connect to the " .
"database server at this time.</P>" );
exit();
}
// Select the database
if (! @mysql_select_db($database) ) {
echo( "<P>Unable to find database");
exit();
}
$query="INSERT into {$table} (name,roundOneTime, roundTwoTime, roundThreeTime, finalTime) VALUES ('$one', {$two}, {$three},{$four},{$five})";
mysql_query($query);
echo("The data has been written to the table!");
?>
Now, this may mean absolutely nothing for you, but what happens is:
1. He retrieves the variables via the "GET" method.
2. He connects to the MySQL table using a host name, root name, password, database name, and table name.
3. The MySQL connection is checked to make sure that it works.
4. He builds a query for the MySQL table.
5. He sends it out.
That's all! Of course, if you don't know PHP or MySQL, you'll probably need some help form the programming forum. Anyways, I hope I helped you, and best of luck on your future programming endeavors!
