XML+PHP

<!-------------------XML------------------------------------------------------------------------------------>
<?xml version="1.0" encoding="UTF-8"?>
  <nfes>
    <nfe>
        <numero>269971</numero>
        <xnome>Jose</xnome>
        <cnpj>7157</cnpj>
        <demi>2015</demi>
        <icmstot>800</icmstot>
        <destcnpj>85364</destcnpj>
        <razao>ABC System</razao>
    </nfe>
    <nfe>
        <numero>252694</numero>
        <xnome>Jose</xnome>
        <cnpj>7157</cnpj>
        <demi>2015</demi>
        <icmstot>800</icmstot>
        <destcnpj>85364</destcnpj>
        <razao>ABC System</razao>
    </nfe>
  </nfes>


<!------------------------------------------------Arquivo para mostrar os dados em tela e salvar no banco ------------------------->

<?php

$xmlDoc = new DOMDocument();
$xmlDoc->load("arquivo.xml");
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "trabalhoxml";

$dbh = new PDO("mysql:dbname={$mysql_database};host={$mysql_hostname};port=3306", $mysql_user, $mysql_password);

$xmlObject = $xmlDoc->getElementsByTagName('nfe');
$itemCount = $xmlObject->length;

for ($i=0; $i < $itemCount; $i++){
   $numero = $xmlObject->item($i)->getElementsByTagName('numero')->item(0)->childNodes->item(0)->nodeValue;
   $xnome = $xmlObject->item($i)->getElementsByTagName('xnome')->item(0)->childNodes->item(0)->nodeValue;
   $cnpj = $xmlObject->item($i)->getElementsByTagName('cnpj')->item(0)->childNodes->item(0)->nodeValue;
   $demi = $xmlObject->item($i)->getElementsByTagName('demi')->item(0)->childNodes->item(0)->nodeValue;
   $icmstot = $xmlObject->item($i)->getElementsByTagName('icmstot')->item(0)->childNodes->item(0)->nodeValue;
   $destcnpj = $xmlObject->item($i)->getElementsByTagName('destcnpj')->item(0)->childNodes->item(0)->nodeValue;
   $razao = $xmlObject->item($i)->getElementsByTagName('razao')->item(0)->childNodes->item(0)->nodeValue;


   $sql = $dbh->prepare("INSERT INTO 'tabela'(numero, 'xnome', cnpj, demi, icmstot, destcnpj, 'razao') VALUES (?, ?, ?, ?, ?, ?, ?)");
   $sql->execute(array($numero,$xnome,$cnpj,$demi,$icmstot,$destcnpj,$razao));
   print "$numero.$xnome.$cnpj.$demi.$icmstot.$destcnpj.$razao<br/>";
}

?>