I need to create a Flash based application than must store data (and read also) in a database.
It will be dealing with about 500 records to fill and update a data grid with four columns.
Can it be done with pure AS3/XML/PHP or it's better to use MySQL?
Could you point to me to good tutorials or book?
I did buy an adobepress book (ActionScript 3 for Flash CS5) a couple of years ago but it only covers XML reading.
Many thanks in advance.
UPDATE 1:
I have done the same as desktop app yet. The database is stored in a local XML file (My Documents/storage folder) that I can read/write without any problem.
I need to adapt the project for on-line use.
UPDATE 2:
I did find this files: http://www.kirupa.com/web/xml/examples/newseditor.htm
The tutorials has some errors but is very simple. I will test it's performance with 500 records (I need something like 250 records)
Cheers
I'll suggest to use MySQL. The idea is to use the PHP as bridge between AS3 and the database. Flash has native support of XML, but if it is possible for you use JSON. Here is a short article about that subject.