Convert XML data to SQL Insert

Asked

Viewed 47 times

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 take this massive data and convert to an example SQL INSERT model:

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

I’m parsing for PHP

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.