PHP+FLASH+MYSQL

Anon

What i want is an interaction of PHP,MYSQL & Flash. I want to create a flash movie that takes contents from MYSQL database with the help of PHP scripts. I want to show this flash movie with .exe extension and in full screen of the computer. Can anyone help me?

sonicphpr

I don't think flash will be able to query a database when it is a projector file (.exe).

I have been successful at sending variables from flash to a php script that retrieves data from mysql and formats a page in html so flash can then retrieve new variables, but it is quite clunky and slow.

If you however are interested in this type of interactivity, there is a great book called "Server-Side Flash" by Sanders and Winstanley, published by Hungry-Minds.

nashirak

Flashkit also has tons of good articles on the subject.

http://www.flashkit.com

jamie_webstart

The cleanest way I've found of getting interaction without reloading the page is to use a hidden frame with a controlling php page that writes out FScommand javascript. If you only need to pass values once, writing them into the src url is pretty transparent speedwise, ie, src=movie.swf?param=value

Anon

might want to look at the source code examples and the message board over at

http://www.phpforflash.com

Anon

or get the book related to this website;
Foundation PHP for Flash by Steve Webster published by Friends of ed.

I'm not sure whether a exe Flash file can query an online database and return results without the swf file being embedded into a webpage. This book explores everything to do with MySQL, PHP and Flash so it will give you an answer. Will look into it more when i have more time.

Let us know if you find an answer, it would be fantastic if it could do this.