How to parse XML in PHP, generating dynamic SQL insert statements

Question

I'm attempting to parse an XML file, and generate & insert the element data into a mysql database. Any pointers? The xml document in this case is deep nested and element data contained goes into one table.

Ben · Accepted Answer · 2011-01-14 05:39:47Z

1

You can start with using a SimpleXML object (really easy).

Here's the documentation: http://php.net/manual/en/book.simplexml.php

Here's a tutorial: http://www.willfitch.com/simplexml-tutorial-part1.html.

answered Jan 14, 2011 at 5:39

Ben

57.6k50 gold badges187 silver badges229 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Muniu Over a year ago

Thanks Steve, what I was actually looking for is a SAX parser. I have implemented the solution using DOM.

Collectives™ on Stack Overflow

How to parse XML in PHP, generating dynamic SQL insert statements

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related