Best way to connect to mysql database

[Boombanguk]

Hi,

I'm in the middle of creating a Flash game that will need to use a mysql database and I need to know which is the best way to get and put data to that database from Flash.

From what I've seen online the way to do this is to either..

1) Use amfphp
2) Use something called phpobject
3) Just do it manually with a bit of php code
4) There's an component I bought/downloaded some time ago, from "P studios" ?? I can't find them anymore online, but I think it allows you to setup the php from inside Flash??

So my questions are, of all of the above, what's a) The fastest (in the sense of data to and from the server) of the above? b) Easiest to use? c) Most secure?

thanks for any help.

[MyFriendIsATaco]

Just use manual PHP code. If it's basic stuff, MySQL is easy. mysql_connect, mysql_select_db, mysql_query, mysql_result, and mysql_fetch_*. That's it. It'll be the fastest way to do something and probably easier than the learning curve for anything else.

[Boombanguk]

Just use manual PHP code. If it's basic stuff, MySQL is easy. mysql_connect, mysql_select_db, mysql_query, mysql_result, and mysql_fetch_*. That's it. It'll be the fastest way to do something and probably easier than the learning curve for anything else.

Is that secure though? If I used amfPHP or something similar wouldn't that give me security built in?

[MyFriendIsATaco]

Well, it depends on what you're doing. Explain the situation a bit more.

[Musicman]

Hi,

in case that funky component sends either database connection data or sql statements from flash to the server, get rid of it - that behavior IS a SEVERE risk

Musicman