Skip to Content

How to make Flash talk to a database

Author: Bill Trikojus

Everybody knows that Flash is cool.  Flash really becomes powerful though when it's combined with PHP and MySQL to create database driven web based applications.  There are numerous advantages to storing your website data inside a database rather than in the Flash movie, but the main one is the ease in which you can create a WSIWYG editor to update the content without ever needing to go back to the original source file.  This tutorial will introduce you to the basics of database driven Flash websites and will also work through the development of a basic PHP Content Management System.

 

This tutorial requires a server with MySQL and PHP installed.

Click here to download the php script that handles the database connection. Change the variables at the top of the script to match the host, username, password and database name for your database connection.

1

Part one

bullet Launch video

1

Part two

bullet Launch video

1

Part three

bullet Launch video

1

Part four

bullet Launch video

1

Part five

bullet Launch video

1

Part six

bullet Launch video

At this point the tutorial jumped a bit as content was covered in class. The next five parts attempt to fill in the parts that were originally skipped.

bullet Extra 1
bullet Extra 2
bullet Extra 3
bullet Extra 4
bullet Extra 5

1

Part seven

bullet Launch video

1

Part eight

bullet Launch video

9

Part nine

bullet Launch video

bulletBack


Share

Like this? Click a link below to share it...


Subscribe and Download

Subscribe to the Swinburne Faculty of Design Podcasts

Comments

2008-06-25: jeremy wyss said:
I found a much easier way to do this using an extension panel created by peakstudios.com It took me about 1/8th the time to do my last project and I wish i would have had it soon I did a project about 7 months ago that took me about a month of busy work that the panel would have done for me. I would have saved time if i just used the free version they have but since i used it so much I forked out the 20 bucks.. what can i say I am wearing about buying that kind of stuff.

2008-07-13: Tarun Kr Ghosh said:
Cannot view the Extra 5 video and the search engine video . Please give some other links and help me so that I can view these videos.

2008-07-22: Bill Trikojus said:
The extra parts work fine for me

2008-07-22: jeremy wyss said:
ya they work for me to

2008-07-29: electroarab.com said:
Excellent work

2009-03-11: Ralph said:
This is the most useful tutorial i have ever used! Part 5 is not working, but still, thank you!

2009-03-11: Bill Trikojus said:
seems to be fine for me. Please try relaunching it.

2009-03-11: Ralph said:
It is ok, basically what i need is in the first chapters. However for some weird reason, when in the returnData.php i send: echo "&theText=$theText";?>

I am not receiving in Flash the variable $theText...instead am recieving literally:

$theText";?>

Any push would be appreciated!

Post a comment

Garbage posts and SPAM will be deleted.

* Name:
* Email: (will not be made public)
* Comment:
* Reply Notification: