A Flash Developer Resource Site














Internet Commerce

Partners & Affiliates














Developer Channel

internet.com


Featured Flash FLA
Gallery Downloads 11336 Flash Movies | 2 New Flash Movies Added
What's New | Top 100

Featured FLA

» Author: Surjit Dhami
» Title: Book
» Description: Book
» More by Surjit Dhami


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

Featured Site

» Posted in the Flash Kit Links section
» Title: All-American Rejects
» Description: Get to know this great band by exploring their "practice room".


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

» Create xml slideshow with free template
» How to Insert a Multilingual Subtitle Into Your Flash Video Studio
» How to Create Cool Halloween Slideshow
» Debugging flash using the Firebug console
» Create Flash Slideshow on Blogger
» FLASH TRICKS IN WEB ADVERTISING: FLASH BANNERS
» HTML Photo Gallery Tutorial
» Create your first flash site – PART 1
» How to Make a Flash Photo Gallery
» Unknown Tag: Title10
Random Tutorial | Add Site

Sr Instructional Designer D2L-Moodle,Clearance
WSI Nationwide, Inc.
US-NJ-Fort Monmouth

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.61 Votes: 59
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
 
   
 

internet.commediabistro.comJusttechjobs.comGraphics.com

Search:

WebMediaBrands Corporate Info

Legal Notices, Licensing, Reprints, Permissions, Privacy Policy.
Advertise | Newsletters | Shopping | E-mail Offers | Freelance Jobs