Load XML to MySQL

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View


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,


Re: Load XML to MySQL

Quoted text here. Click to load it

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.

Site Timeline