PHP/MySQL with Flash Lite Tutorial

I’ve written a small tutorial on Flash Lite interacting with a MySQL database using PHP as a middle language. You can read the tutorial here.

Please feel free to leave a comment here if you wish to add feedback or suggestions.

Mariam

About Mariam Dholkawala 188 Articles
Part geeky part quirky, I love writing games, travelling the world, trying new food and learning new languages. I am sometimes the designer, programmer and artist for some of my own games.

12 Comments Posted

  1. Hi. I’m new in using Adobe Flash Lite. I have to develop a mobile game that can change the object’s shape in it. The object’s shape can be changed whenever the user wants to change it through the CHANGE SHAPE menu. Each different shape is store in a database that can be retrieved later.

    My problems are:-

    1) Can Adobe Flash Lite support any database?
    2) If can, is there any database that can store vector images?

    I hope you can give the answers A.S.A.P. Thank you…^_^

  2. Hi Sesaje, Flash Lite can interact with an external database to retrieve and send data as the tutorial explains. Local databases may also be possible, but I haven’t worked on it, so cannot comment.

    External swf files (vector image formats like ai, svg is not supported) can also be loaded at runtime. These can be saved on a website (for which your app on the phone will need to connect to the GPRS/WiFi network to download) or can be packaged with your main swf file and loaded locally from the phone itself (requiring no network connection).

    I hope this was the answer you were looking for.

    Mariam

  3. Hi,Mariam thanks for the tutorial but when I run the tutorial file it shows ‘undefined’ and it doesn’t update the database as well.

  4. Hello Naz,

    The database in the tutorial is a dummy file that does not exist.

    You will have to create your own database and accordingly change the Flash file and PHP file with the username/password/database name/table name etc that you set for your database.

    Hope this helps

    Mariam

  5. Hi Joanne,

    Yes, Flash Lite is able to connect to a database. If you read the tutorial in the post above, it would help you understand the working of Flash Lite with MySQL.

    Mariam

  6. Hi Mariam, thx for this tutorial. But, i have a problem.
    With your tutorial, i able to insert record to gameentry table, but my hp shows ‘undefined’, not ‘entry successful’.
    How can i solve this problem?

    thx

  7. hi mariam,
    thanks for this great tutorial, but i have a little bit problem. the problem is i have my hp show ‘undefined’ although i have successfully insert new record.
    how can i solve this problem?

  8. I suggest you debug the PHP file first by catching the error if any. You can do this by typing the php file name appended with the values you need to enter inside the database from your browser itself. If this returns no error, then maybe your call from Flash is incorrect.

  9. hi mariam …

    thx for the great tutorial..

    can i ask u somethin’ it is possible to write database within .fla file for flash lite 3.1?

Leave a Reply to naz Cancel reply

Your email address will not be published.


*


%d bloggers like this: