Convert data in XML to SQL Insert

1

I have a file with some data in XML format example:

<Row>
    <Data>BARRA DIRECAO AXIAL REGULAVEL</Data>
    <Data>000216</Data>
    <Data>FORD - EXPLORER  95/    RANGER  98/</Data>
   </Row>

I need to get this massive data and convert to an SQL INSERT model example:

INSERT INTO produtos (title,prodid,description) VALUES ('BARRA DIRECAO AXIAL REGULAVEL','000216','FORD - EXPLORER  95/    RANGER  98/')

I'm doing the parser through PHP

    
asked by anonymous 25.09.2017 / 00:18

0 answers