Online PHP editor | refs for nhJi7

<?php $string = '<xml version="1.0" encoding="utf-8"> <METADATA> <DATA> <FIELD_1>001</FIELD_1> <FIELD_2>ENTRY_2</FIELD_2> <FIELD_3>ENTRY_3</FIELD_3> <FIELD_4>ENTRY_4</FIELD_4> <FIELD_5>ENTRY_5</FIELD_5> <FIELD_6>000003</FIELD_6> <FIELD_7>ENTRY_7</FIELD_7> <FIELD_8>ENTRY_8</FIELD_8> <FIELD_9>ENTRY_9</FIELD_9> <FIELD_10>ENTRY_10</FIELD_10> <FIELD_11>ENTRY_11</FIELD_11> <FIELD_12>ENTRY_12</FIELD_12> <FIELD_13>ENTRY_13</FIELD_13> </DATA> </METADATA> </xml>'; $xml = simplexml_load_string($string); foreach ($xml->METADATA->DATA as $item) { foreach ($item->children() as $child) { $cols[] = $child->getName(); $params[] = $child->nodeValue; } if(!empty($params)){ $columns = implode(',', $cols); $placeholders = rtrim(str_repeat('?, ', count($params)), ', '); $sql = 'INSERT INTO dwh_xml ( ' . $columns . ') VALUES(' . $placeholders . ')'; echo $sql; unset($params, $cols); } }