RDBMSResolver, Remoting (AMFPHP), and Database Management

I know this is “server-side” but it’s very FMX04 specific.

Gods of Kirupa - could someone PLEASE write a tutorial that covers the following (step 4 is my main concern):

Management of a mySQL database with Flash MX Professional 2004 - specifically:

  1. How to load information from a database using the new Remoting connection component and AMFPHP (I know how to do this part).

  2. How to get that information into a dataSet (I know how to do that too).

  3. How to manipulate the items in a dataSet (I can do that).

  4. How to use the XML deltaPacket produced by the RDBMSResolver component to INSERT, UPDATE, and DELETE records from the server-side database using AMFPHP. This is the part that I can’t do. I know that it involves the creation of an AMFPHP method that can parse the nodes, but I don’t know where to start on that, and thought that maybe someone had already found a good way to do it. Also, I don’t know /how/ the dataPacket is “delivered to the server” (e.g. GET or POST?).

  5. How to handle the result returned by an update packet.

It seems like this kind of tutorial would help a LOT of people, and I’m sure some of the more FMX04 capable people in here have already conquered it.

I’ve looked all over and I STILL haven’t found one FULL tutorial or example of how to handle all of these issues.

Thank you! :s:

(ps - forgive me for posting a similar question in some other site forums - this one was down)

lol dude if someone writes this tutorial for you please let me know!

No kidding.

I can do almost all of it, I just need help with writting the AMFPHP service that can recieve+parse the deltaPacket from the RDBMSResolver.

post on the forums here
http://www.sephiroth.it/
and here
http://www.flash-db.com/

hehe, way ahead of you eyez!

flash-db post

sephiroth post

:smiley:

Ok I’ll get this ball rolling…

/begins typing steps 1 through 4.5