2

I have a table column that contains XML string. I need to parse the data from each row (XML string column) and insert it into a different table where columns are actually the tags from that XML.

so lets say "tableA.xmlcolumn" contains:

<xml>
    <tag-a>bla bla bla</tag-a>
    <tag-b>bla bla bla</tag-b>
    <tag-c>bla bla bla</tag-c>
</xml>

Into

"tableB"

tag-a       | tag-b       | tag-c
---------------------------------------
bla bla bla | bla bla bla | bla bla bla

TableA have 300K~ rows

How would you approach this using PHP/MySQL?

Thanks!

Improve this question
6
  • You can use xml_parse_into_struct to get XML into an associative array and then you can add to your database table. Commented Jun 19, 2017 at 10:33
  • Thanks! actually I was aiming to get if there's a bit more "sophisticated" way than just select > parse in php > insert Commented Jun 19, 2017 at 10:35
  • "sophisticated" means? Do you want me to write the whole code for you? Commented Jun 19, 2017 at 10:37
  • no. I meant maybe by doing in all using SQL (no php) if possible... or maybe it would be faster/efficient to select all the data and and write a procedure to parse and insert at the same time. I know how to do it, I just think it would take a long time or maybe I'll run out of memory by doing each row with select > php > insert Commented Jun 19, 2017 at 10:40
  • ohh.. Let me look for that, if there is SQL option to parse XML. Commented Jun 19, 2017 at 10:41
Related questions
2325
How do you parse and process HTML/XML in PHP?
1500
Can I concatenate multiple MySQL rows into one field?
1292
Reference - What does this error mean in PHP?
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.