best way to access local mysql database from AS3?

[McFreaq]

Hi Guys,

I'm currently working on a flash project which will later run locally and offline on a PC. On this PC, there will also be a MySQL database which I need to access.

Now I'm looking for a proper way to do this. I have good skills in AS3, and have used PHP and MySQL alone in several web projects. But so far I have never used MySQL together with Flash.


So in which direction should I start looking for a good solution? What would be a good way to access a local MySQL database from a locally running SWF?

Any ideas highly appreciated!

[CyanBlue]

Howdy and Welcome...

You still need a middle man to talk to the database... That means that you'd need to make a local server that hosts database and the PHP that your SWF can call to get the data...

[McFreaq]

Hi CyanBlue, thx for your reply!

On the PC I mentioned, there will be XAMPP running as my local »webserver«, did you mean that? So I can run PHP files if that's necessary to access the database.

What I'm missing right now is a way to call for example a PHP file with AS3 and give it a certain MySQL query. And a way to get my data back from the PHP file. How would I do that?

[McFreaq]

I just found this one:
http://asql.mooska.pl/

It seems to be an AS3 library that enables direct access to a MySQL database without the need of PHP or a webserver, if I understand it right. I will check this one out and report back.

Has anyone used this so far?

[ggalan]

have you looked into amfphp?
http://www.amfphp.org/
gotoAndLearn has a tutorial
http://www.gotoandlearn.com/play?id=78

[Rossman]

Use adobe air and the database within it, perhaps?

[McFreaq]

THX gglan, I'm already watching the tutorial!

THX Rossman!
I have not worked with Adobe AIR so far. And I think I'm bound to using the MySQL database as there has already a browser-based interface been made to administrate the database…

[Rossman]

Fair enough. Air is just like Flash except there are a few more API's to let you do stuff like read and write files, store data in the built-in database, etc. Just thought I'd throw it out there in case it was a better solution for ya!

[McFreaq]

Yeah, THX in any case, Rossman!

I didn't want to be rude, just wanted to define my working situation for the project.
So out of interest but off the records, what kind of database is available through AIR?

[CyanBlue]

That'd be SQLite...