How to write the values of the XML elements to the MySQL database?

Question

I have to write the values of the XML elements to the MySQL database. For example, let's say, I have this XML document:

<users>
    <user>
        <name>John</name>
        <nick>nick1</nick>
    </user>
    <user>
        <name>Jack</name>
        <nick>nick2</nick>
    </user>
    <user>
        <name>Mike</name>
        <nick>nick3</nick>
    </user>
</users>

And I have to write the values to the members table in MySQL database. So, the members table must be like this:

+------+----------+
| name |  nick    |
+----+------------+
| John |  nick1   |
+------+----------+
| Jack |  nick2   |
+------+----------+
| Mike |  nick3   |
+------+----------+

And I want to do this process in PHP. If you have any idea, please comment.

possible duplicate of [Best XML Parser for PHP](http://stackoverflow.com/questions/188414/best-xml-parser-for-php) — Pekka, Dec 17 '11 at 18:55
Looks like a relatively straightforward process: Parse the XML using one of the parsers in the link above, then walk though it and insert each item into the database. — Pekka, Dec 17 '11 at 18:55

score 1 · Accepted Answer · answered Dec 17 '11 at 19:15

$xmlString="<users>
    <user>
        <name>John</name>
        <nick>nick1</nick>
    </user>
    <user>
        <name>Jack</name>
        <nick>nick2</nick>
    </user>
    <user>
        <name>Mike</name>
        <nick>nick3</nick>
    </user>
</users>
";

$xml=new SimpleXMLIterator($xmlString);
foreach($xml as $user){
    $name=$user->name;
    $nick=$user->nick;
    mysql_query("INSERT INTO members(name, nick) VALUES('$name', '$nick')");
}

The important part of the code is new SimpleXMLIterator($xmlString), this will create an object that you can loop over.

Runs fine, tested.

score 0 · Answer 2 · answered Dec 17 '11 at 18:56

0

To get data from xml documents you must parse the document first. There are a number of php xml parsers. THey provide an interface in which to access the data from the xml document.

answered Dec 17 '11 at 18:56

dm03514

54,664
18
108
145

score 0 · Answer 3 · edited May 23 '17 at 12:27

0

Use an XML parser to load the contents of the XML data onto a php object (most likely stdClass).

The loop through the results and perform each insert.

edited May 23 '17 at 12:27

Community

1
1

answered Dec 17 '11 at 18:57

0x6A75616E

4,696
2
33
57

How to write the values of the XML elements to the MySQL database?

3 Answers3