I have many SQLite databases that I want to get access to in Flash.
Currently I am running a Xitami server with PHP5 on my winXP box. PHP has native access to SQLite databases.
My PHP scripts read the data and form it into Name-Value pairs that are passed into Flash via the LoadVars class.
This is all working pretty good, but I am wondering if I am taking the right path keeping future updates and general flexibility in mind.
Currently the Flash program only needs to read data from the database, but the next version would need to send data as well.
Should I be using Flash Remoting or AMFPHP? AMFPHP concerns me because of the lack of recent development, and it willl only work with PHP4.
Should I be using XML to transfer my data instead of Name-Value pairs? I don’t know to much about XML, but it seems like many menu and other components are designed to run off of it.
Currently my Menu System is more SQL based in the sense that I ask the database to return to me all Buttons that have a parentID I sent it. I’ve dumped all the data into an 2D Array in flash and mirrored by search calls. Would an XML object be a better choice here?
Actually I’m converting almost all of the needed informatoin from the database into Arrays, and accessing that from my various other classes.
Basically I have something that is working. But this is one of those rare cases when I have the time available to actually do it RIGHT, and I want to learn as much as possible. The problem is I don’t know what RIGHT is.
Thank you very much for taking the time to read this. I would appreciate any advice or input you can offer me. Or let me know if you have any additional questions.
Thanks again!
Adam
