This incredibly simple tool takes 5 minutes to set up and allows you to run mySQL queries and return results to flash using Actionscript 2 just as you can in PHP or any other language. Just 3 lines at the top of your flash document make mySQL queries a single function call away. You can loop through the results, trace them all to the output panel and even display them in a datagrid (a flash table) on the stage.
Check it out, easy as pie:
mysqlQuery("SELECT * FROM newsdemo", onQueryComplete)
The onQueryComplete parameter is your own function to run after results are returned. Click image below for full examples with notes & instructions:
flashconnect.php: A php file which gets the database results and sends them to flash
mysql2as.as: The main function library for this package
mysql2as.fla: Flash CS3 project with full demos and comments
Instructions.txt: Simple step by step setup instructions.
You will need:
Basic-Intermediate knowledge of actionscript 2.0
PHP enabled web server with a mySQL database already set up (tutorial here)
connect.php: A php file on your server which connects to your database. (tutorial here)
Buy using PayPal for USD$9:
$9 for use on unlimited commercial or personal projects.
Flash loadVars is not particularly secure. I would not advise sending sensitive information via this package and I am not responsible for the security of your data.