A Flash Developer Resource Site
Become a FlashKit Partner












Internet Commerce

Partners & Affiliates














Developer Channel

FlashKit.com
JavaScript.com
JavaScriptSource
Developer Jobs
ScriptSearch
StreamingMediaWorld
Web Developer's Journal
Web Developer's Virtual Library
WebDeveloper.com
Webreference
Web Hosts
XMLfiles.com

internet.com

IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers

Featured Flash FLA
Gallery Downloads 11358 Flash Movies | 4 New Flash Movies Added
What's New | Top 100

Featured FLA

» Author: Sean
» Title: Customizable Flash Drop down menu
» Description: The native source files for building a customizable menu roll down.
» More by Sean


Random FLAs | Add Flash Movie
Featured Flash Site
Gallery Downloads 5709 Flash Sites | 4 New Flash Links
What's New | Top 100 Flash Site

Featured Site

» Posted in the Flash Kit Links section
» Title: Sandy 3D Engine for Flash
» Description: Sandy is a Flash 3D engine, available in 3 versions: AS2, AS3 and haXe


Random Links | Add your own Flash Related Links
Flash Tutorials 1302 Tutorials 7 New Tutorials Added!
What's New | Top100

» MySpace profile flash slideshow
» Display YouTube videos in self-customized Flash video player on website
» How to make cool 3D flash banners for your website?
» Make a Valentines Day Slideshow with Music
» How to remove red eyes from a photo?
» How to convert SWF to Animated GIF on Mac
» How to Make a Platform Game using AS 2 - Part 1
» How to make a flash Greeting e-card
» How to extract Youtube video to MP3 audio for Mac
» Unknown Tag: Title10
Random Tutorial | Add Site

Web Manager
University of Redlnads
US-CA-Redlands

Justtechjobs.com Post A Job | Post A Resume


Tutorials Home What's New Top Rated Submit myTutes Random!

Search Tutorials


Tutorials Tutorials » Dynamic_Content

Categories Integrating Flash and mySQL
Author: Vin | Website: http://www.nostamprequired.com |

 
Page 1
1

This tutorial makes use of the PHPObject code which can be found at: http://ghostwire.com/resources/phpobject/

Please download the PHPObject and try out the sample to better understand what's going on here.

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

The Flash Code:

#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.

The PHP Code (cards.php):

<?

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.

1

» Level Intermediate

Added: : 2003-05-12
Rating: 6.67 Votes: 60
Hits: 174
» Author
Young Web Developer trying to learn the latest technologies and apply them to practical projects. I'm looking for a job, email me.
» Download
Download the files used in this tutorial.
Download (0 kb)
Get conversion and unzipping tools for PC and Mac here!

» Forums
More help? Search our boards for quick answers!

Please rate this tutorial, 10 is the top rating, you can also click the comments link to read/write a review.
10 9 8 7 6 5 4 3 2 1
Read or Post Comments
 
   
 


The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers