How do I parse xml to insert it into a mysql database?

Question

How would I parse a very large xml file and insert it into a mysql database? I know PHP and I know javascript

possible duplicate of Bulk Insertion in MYSQL from XML Files. — Gordon
– Gordon, Commented Mar 31, 2011 at 7:14

Robert van der Linde · Accepted Answer · 2011-03-31 06:29:29Z

4

If it's a very large XML file you might not want to use DOM / SimpleXML as these load the complete XML tree into memory before allowing you to do any manipulation. If you are only interested in read operations you might want to look at XMLReader http://www.php.net/manual/en/class.xmlreader.php

XMLReader works by reading node by node, thus keeping speed up and memory usage down. There are a few interesting examples in the PHP documentation.

You can also look at SAX, an event based parser: http://php.net/xml_parser_create

answered Mar 31, 2011 at 6:29

Robert van der Linde

3461 silver badge4 bronze badges

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

Comments

Devart · Accepted Answer · 2011-03-31 06:23:08Z

1

Another way (for MySQL 5.5) is a LOAD XML statement.

answered Mar 31, 2011 at 6:23

Devart

120k23 gold badges172 silver badges189 bronze badges

Comments

alex · Accepted Answer · 2011-03-31 05:36:31Z

0

You would use an XML parser such as SimpleXML.

$xml = simplexml_load_string($yourXml);

// Do what you need to do...

answered Mar 31, 2011 at 5:36

alex

492k205 gold badges890 silver badges992 bronze badges

Collectives™ on Stack Overflow

How do I parse xml to insert it into a mysql database?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related