www.flasharcadia.com.">
First time here? First time here? Newsletter Signup Newsletter
Login | Register | 651326 Members and growing!
Search tutorials
Author: Nick Kuh | Website: http://www.flasharcadia.com

Setting up the second section of the PHP script

The second section of the php script is executed when a user finishes the game and goes to the game over screen. When then enter their name and press the submit button the command variable is sent to the php script with a value of "update". The php script checks for this value and then executes the second section of code below. The name entered is sent as the value to variable "name" and the users final score is sent as the value to variable "score".

if ($command=="update"){
$link = @mysql_connect("localhost", "YOURUSERNAME","YOURUSERPASSWORD");

if (!$link){
print "&players=Error connecting to database";
exit;
}

if (!@mysql_select_db("YOURDATABASENAME")){
print "&players=Couldn't select database";
exit;
}

$players = "";
$scores = "";
$query = "SELECT scores FROM highscores where players = '$name'";
$result = @mysql_query($query);
if(@mysql_num_rows($result)>0){
$oldScore = mysql_result($result,"scores");
if($score>$oldScore){
$query = "UPDATE highscores SET scores = '$score' where players = '$name'";
$result = @mysql_query($query);
}
else{
exit;
}
}

else {
$query ="INSERT INTO highscores (players, scores) VALUES ('$name', '$score')";
$result = @mysql_query($query);
}

$innerquery = "SELECT * FROM highscores ORDER BY scores DESC";
$innerresult = @mysql_query($innerquery);
$numPlayers=mysql_num_rows($innerresult);
for($loop=0;$loop<$numPlayers; $loop++) {
$newPlayer = mysql_result($innerresult,$loop,"players");
$newScore = mysql_result($innerresult,$loop,"scores");
$players = "$players
$newPlayer"; $scores = "$scores
$newScore"; } printf("&players=%s", $players); printf("&scores=%s", $scores); mysql_close($link); } ?>

Let's breakdown the code

I'll only be annotating the new code in this section of the php script as there is a lot of code in the second section which I've already covered

$query = "SELECT scores FROM highscores where players = '$name'";
$result = @mysql_query($query);
Here the SQL command attempts to select the past score of the user who submitted his/her name.
if(@mysql_num_rows($result)>0){
$oldScore = mysql_result($result,"scores");
if($score>$oldScore){
$query = "UPDATE highscores SET scores = '$score' where players = '$name'";
$result = @mysql_query($query);
}
If the users name is found in the mySQL table then the oldScore variable is created with a value of the users score in the database. The code then tests to see if the new score is higher than the old score. If it is higher then the an SQL statement is executed which replaces the old score with the new.
else {
$query ="INSERT INTO highscores (players, scores) VALUES ('$name', '$score')";
$result = @mysql_query($query);
}
If the name value sent from the Flash game is not found in the database then a new row is added to our database and the new data is inserted.

The rest of the code in this section is identical to the code in the first section which builds the high scores data, only this time the new users data will be included in the refreshed results. This is the php close tag.

» Level Intermediate

Added: 2002-04-21
Rating: 6 Votes: 22
(10 being the highest)
» Author
Nick is a Flash Developer for London based web design agency Edition Interactive. His main role is online games design and development for clients such as Channel Four Television.
» Download
Download the files used in this tutorial.
» Forums
More help? Search our boards for quick answers!

Comments

  • There are no comments yet. Be the first to comment!

  • You must have javascript enabled in order to post comments.

Leave a Comment
  • Your email address will not be published. All fields are required.
Featured Flash FLA
» Author: Inocreato
» Title: RaiseTheBlocks
» Description: Raise all the blocks to win the game
Featured Sound Loops
Image for equalize

Audio Player

» Author: TomCat Carty
» Title: The Wood
» Description: Just a little game ending or it can maybe be looped. Recorders with music box and percussion to give the feel of well, I don't know, the woods? Free to use, just credit me. thank you
Latest Font
» Author: Fábio FAFERS
» Description: I created this font for free use. Everyone can apply it in personal or business texts. Its free, but I want to be communicated in case of business use. Donations are accepted to keep the project of free fonts alive! Thank you all
Featured Sound Fx
Image for equalize

Audio Player

» Author: Davisigner
» Description: Hmm... what to say about this one? It's reminiscent of the closing notes of the opening music from the Three Stooges done in a church organ style with a closing cymbal crash. I'll give this one away gratis, but feel free to check out my free loops and potential upcoming license-mandated ones over in the respective part of Flashkit.