Build XML Page from DB

Permalink
This question is semi-directed at Remo since he has already done this with the Music Player.

How do you create and XML sheet that flash can use based on a block's ID?

I wrote a PHP script that grabs the content from the DB by creating a new connection, but I have to send the DB info to the XML generator and thats a serious security issue.

What would be a safer way to do this?

ijessup
 
ScottC replied on at Permalink Reply
ScottC
same idea. It needs a controller set to return the xml, otherwise mimicking it would just bring up a page not found error or not give you access to sets or any sort of loader method since those have to pass through the dispatcher.
ijessup replied on at Permalink Reply
ijessup
Good idea. I'll check that out! :D
ijessup replied on at Permalink Reply
ijessup
It's working! I may finish this block after all. :)
ijessup replied on at Permalink Reply
ijessup
I've got the XML generator working... well at the very least spitting out a static XML file.

However, flash doesn't seem to want to use it.

Gunna have to play around with it some more, but it shouldnt take too much longer. :)
ijessup replied on at Permalink Reply
ijessup
It wasn't Flash it was me. Seems I forgot about the flashvars syntactics. Fixed it though.

All that is left is to convert what is in the database to an XML format and this puppy is g2g.