Integrating PHP, Flash and MySQL

**egdcltd** · 04-17-2007, 05:56 AM

Can anyone recommend any resources for integrating PHP and MySQL with Flash movies? I've found a few resources, but nothing really useful yet.

**BruceWayne** · 04-17-2007, 07:08 AM

have a look webdesign.org

**mtishetsky** · 04-18-2007, 12:22 AM

What exactly do you mean with "integrating"? MySQL is nothing more than a data storage. PHP is server-side tool to fetch data from that engine and send it away, flash is client-side tool to fetch data from server (obviously through php) and display it to user in some way. What you need to do is:
1. Write a php application for fetching data from and putting data into the db according to arguments it was called with.
2. Write flash application that will call the certain URL (where your php script resides) and read some data from it.

**egdcltd** · 04-18-2007, 04:54 AM

Quote:

Originally Posted by mtishetsky

What exactly do you mean with "integrating"? MySQL is nothing more than a data storage. PHP is server-side tool to fetch data from that engine and send it away, flash is client-side tool to fetch data from server (obviously through php) and display it to user in some way. What you need to do is:
1. Write a php application for fetching data from and putting data into the db according to arguments it was called with.
2. Write flash application that will call the certain URL (where your php script resides) and read some data from it.

What I'm trying to do, if I can explain it correctly, is use the existing database and functions etc of a script I'm using with a Flash file. I want the Flash file to use the data from the MySQL database in it.

**mtishetsky** · 04-18-2007, 07:59 AM

You cannot query the DB directly from your flash movie (or at least there is no straightforward ability to do it without doing tricks and increasing size of your movie to 1Mb). You can fetch data from a webpage which is generated by your script and send data by calling that script with certain GET parameters.

**egdcltd** · 04-18-2007, 08:10 AM

I know you can do something using LoadVars, but I can't seem to find many explanations of how to go about it.

To be honest, what I'm trying to do may be well beyond my programming skills, but if I can refine and explain what I'm after better, using more knowledge, it should help.