I played around with Tim Wilson’s Press Connect php package. The PHP is open source, but the Flash template is not, so you either buy it, or you figure out how to communicate with the PHP. I did the figuring out.

PressConnect manages the connection to your wordpress database, completely without calling any of the native WordPress functionality. It doesn’t deal with the wordpress framework at all.
In essence it’s a bunch of SQL queries you call from Flash by sending XML formated requests to the xmlListener.php in the package.

To send and receive the requests and responses, you will be using URLRequest and URLRequestMethod.POST of the ActionScript 3 library.

As my wordpress database has some Danish characters hidden around the place, I had to add some utf8 encoding to prevent the php functions from failing.

It’s still early days for my Flash-front-end-for-wp project, but I have complete access to my wp content (almost) in Flash. Now I need to add some creation code that generates the menu from the XML:

http://www.njanga.com/ITU/blog/wp-content/uploads/swf/pressconnectDemo/pcdemo.swf

Flash source code will be posted on request.