Load XML to MySQL

[Vic Spainhower]

Hello,

I am trying to post xml data into a MySQL database and I'm stuck on what to
do on the web site. The xml is built using a ado recordset on an Access
database and then I'm using xmlHTTPPost(strPostToURL, strXML). However, I
don't know how to write the php program to process the xml so that it loads
the data into a MySQL database. Could anyone supply me with some sample
code to do this? I've searched high and low but I've not been successful in
coming up with anything.

Thanks very much,

Vic

[Daniel Tryba]

Vic Spainhower <vi*@showsec.com> wrote:

I am trying to post xml data into a MySQL database and I'm stuck on what to
do on the web site. The xml is built using a ado recordset on an Access
database and then I'm using xmlHTTPPost(strPostToURL, strXML). However, I
don't know how to write the php program to process the xml so that it loads
the data into a MySQL database. Could anyone supply me with some sample
code to do this? I've searched high and low but I've not been successful in
coming up with anything.

You'll need to get the _raw post data_

See the ini:
; Always populate the $HTTP_RAW_POST_DATA variable.
;always_populate_raw_post_data = On

That should help ypu get the values.