'Tutorial on How to use PHP/mySQL interactions

[ForumNewbie]

Hi,

For interested parties, a few folks have asked recently about a tutorial for creating interactions with databases.

Although I don't have time to do a full one at the moment, I'll share a few comments that I was going to make to Connelite, so that hopefully everyone can benefit.

The steps that are required to perform database interactions:

a. You need a server that will allow server side scripting, such as PHP.
b. You need a server that will allow database interactions. (eg. A mySQL server)
c. You will need to pass variables from your SWF file into the PHP script, so it can interact with the mySQL database.
d. You will need to interpret responses from the PHP script back into your swf, so that you can manipulate them to show what you like on screen.

I am assuming here that steps a and b are already complete, since these tend to be the tricky bits. Please don't ask me if you are unable to do these parts, since the forums for PHP and mySQL can answer better than I can.

Any questions about this later stuff, feel free to PM me. I'll make amendments to the thread as people point out what doesn't work quite right.