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?
PHP+FLASH+MYSQL
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.
Flashkit also has tons of good articles on the subject.
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
might want to look at the source code examples and the message board over at
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.