Flash Kit, A Flash Developer Resource for Macromedia Flash 8 and MX Tutorials SWF FLA images clipart Sounds WAVS Animations Help and Support

Featured Flash FLA

11401 Flash Movies | 5 New Flash Movies Added
What's New | Top 100

Featured FLA

»  Author Miguel Panos
»  Title: Tarta
»  Description: It is a circle graph or pie chart that takes the data entered by user
»  More by Miguel Panos

Random FLAs | Add Flash Movie

Featured Flash Site

4839 Flash Sites | 1 New Flash Links
What's New | Top 100 Flash Site

Featured Site

»  AuthorDeft Creative Ltd
»  Link: Home Page
»  Description: Portfolio site for .DeftCreative Ltd. A UK based web design studio specialising in flash websites, games and interactive CDROMs. With an emphasis on making things different.

Random Links | Add your own Flash Related Links

1484 Tutorials 7 New Tutorials Added!
What's New | Top100

» Making Automatic Training Screen Capture Easily
» Create Undersea Life Animation
» Making Deinterlace Video with a low bitrate Easily
» How To Make A Simple Animation Using Christmas Clips
» Simple Step by step flash game tutorial Spot the diffrence
» How To Make A Moving Text Slide
» Create Flash Banner With Text Float Effect
» How To Make Zoo Photos Slideshow
» How To Make A Dolphin Photos Slideshow
» Unknown Tag: Title10 Random Tutorial | Add Site

This is just a basic tutorial on how to display data in a mySQL database in flash quickly and easily. You can develop this code further to create dynamic Flash movies that feed off a mySQL database. In this example I'm using an eCard project I'm working on. The code will connect to my database to get the card information (the to, from, and message) and display this data in the flash movie. Also note that you should have dynamic text fields named as each of the variables your want to display in your flash movie

#include "PHPObject.as"

tmp = new PHPObject();
tmp.setDefaultGatewayKey("secret"); // CHANGE THIS TO WHATEVER SECRET KEY YOU SET IN Gateway.php
tmp.setDefaultGatewayUrl("http://www.yourdomain.com/pathto/Gateway.php"); // CHANGE THIS TO WHERE YOU PLACE Gateway.php
delete tmp;

myFoo = new PHPObject("cards"); // declare a new object and link it to a remote PHP class

// set up responder
myFoo.getcard_onResult = function(result) {

id.text = result[0];
sid.text = result[1];
s_name.text = result[2];
s_email.text = result[3];
r_name.text = result[4];
r_email.text = result[5];
message.text = result[6];
card.text = result[7];
uniqueid.text = result[8];
beenread.text = result[9];
}

// invoke method
myFoo.getcard("rJ7WP605");

So what we're doing is setting up the Gateway to the PHP file first. Then we set up the code in Flash to get the array PHP will return to us and to put each part of the array into seperate input text boxes on in the flash movie. The invoke method starts the process. It calls the php file "cards.php" as specified in the PHPObject function. Now we have to write the PHP to get the database info and return it to flash.

<?

class cards {
function getcard($getcard) {

$db_name = "yourdbname";
$connection = @mysql_connect("localhost", "username", "password") or die("Cound not connect to database");
mysql_select_db($db_name, $connection) or die("Count not select database");
$query = "SELECT * FROM ecards WHERE sid LIKE '$getcard'";
$q_result = mysql_query($query);
return mysql_fetch_row($q_result);

}
}

?>

This is just some basic PHP code to connect to a mySQL database and return the results. The getcard() function requires a parameter in this example. This parameter tells mySQL which record it wants to pull. In this case it's the id of the card. Once the SQL query has been run, we just send the row as an array and let flash parse it. You can manipulate the data however you want in the PHP, then just have Flash display it.

»Home	»Movies	»Tutorials	»Submissions	»Sound FX	»Graphics

»Forum	»Featured	»Links	»Reviews	»Sound Loops	»myFK

» Join	»Fonts	»The Lounge	»Feedback	»About FK	»Gallery

Internet Commerce

Developer Channel