Gravar dados de um foreach no bando de dados mysql
Ola pessoal, tenho o seguinte probleminha... estou importando produtos de uma nota fiscal para o banco de dados, só que não estou conseguindo!
Quando passo os dados, so consigo pegar o valor do primeiro item da lista(tabela)... onde estou errando ?
$seq = 0;
foreach($xml->NFe->infNFe->det as $item)
{
$seq++;
$codigo = $item->prod->cProd;
$cEAN = $item->prod->cEAN;
$xProd = $item->prod->xProd;
$NCM = $item->prod->NCM;
$CFOP = $item->prod->CFOP;
$uCom = $item->prod->uCom;
$qCom = $item->prod->qCom;
$qCom = number_format((double) $qCom, 2, ",", ".");
$vUnCom = $item->prod->vUnCom;
$vUnCom = number_format((double) $vUnCom, 2, ",", ".");
$vProd = $item->prod->vProd;
$vProd = number_format((double) $vProd, 2, ",", ".");
$vBC_item = $item->imposto->ICMS->ICMS00->vBC;
$icms00 = $item->imposto->ICMS->ICMS00;
$icms10 = $item->imposto->ICMS->ICMS10;
$icms20 = $item->imposto->ICMS->ICMS20;
$icms30 = $item->imposto->ICMS->ICMS30;
$icms40 = $item->imposto->ICMS->ICMS40;
$icms50 = $item->imposto->ICMS->ICMS50;
$icms51 = $item->imposto->ICMS->ICMS51;
$icms60 = $item->imposto->ICMS->ICMS60;
$ICMSSN102 = $item->imposto->ICMS->ICMSSN102;
if(!empty($ICMSSN102))
{
$bc_icms = "0.00";
$pICMS = "0 ";
$vlr_icms = "0.00";
}
if (!empty($icms00))
{
$bc_icms = $item->imposto->ICMS->ICMS00->vBC;
$bc_icms = number_format((double) $bc_icms, 2, ",", ".");
$pICMS = $item->imposto->ICMS->ICMS00->pICMS;
$pICMS = round($pICMS,0);
$vlr_icms = $item->imposto->ICMS->ICMS00->vICMS;
$vlr_icms = number_format((double) $vlr_icms, 2, ",", ".");
}
if (!empty($icms20))
{
$bc_icms = $item->imposto->ICMS->ICMS20->vBC;
$bc_icms = number_format((double) $bc_icms, 2, ",", ".");
$pICMS = $item->imposto->ICMS->ICMS20->pICMS;
$pICMS = round($pICMS,0);
$vlr_icms = $item->imposto->ICMS->ICMS20->vICMS;
$vlr_icms = number_format((double) $vlr_icms, 2, ",", ".");
}
if(!empty($icms30))
{
$bc_icms = "0.00";
$pICMS = "0 ";
$vlr_icms = "0.00";
}
if(!empty($icms40))
{
$bc_icms = "0.00";
$pICMS = "0 ";
$vlr_icms = "0.00";
}
if(!empty($icms50))
{
$bc_icms = "0.00";
$pICMS = "0 ";
$vlr_icms = "0.00";
}
if(!empty($icms51))
{
$bc_icms = $item->imposto->ICMS->ICMS51->vBC;
$pICMS = $item->imposto->ICMS->ICMS51->pICMS;
$pICMS = round($pICMS,0);
$vlr_icms = $item->imposto->ICMS->ICMS51->vICMS;
}
if(!empty($icms60))
{
$bc_icms = "0,00";
$pICMS = "0 ";
$vlr_icms = "0,00";
}
$IPITrib = $item->imposto->IPI->IPITrib;
if (!empty($IPITrib))
{
$bc_ipi =$item->imposto->IPI->IPITrib->vBC;
$bc_ipi = number_format((double) $bc_ipi, 2, ",", ".");
$perc_ipi = $item->imposto->IPI->IPITrib->pIPI;
$perc_ipi = round($perc_ipi,0);
$vlr_ipi = $item->imposto->IPI->IPITrib->vIPI;
$vlr_ipi = number_format((double) $vlr_ipi, 2, ",", ".");
}
$IPINT = $item->imposto->IPI->IPINT;
{
$bc_ipi = "0,00";
$perc_ipi = "0";
$vlr_ipi = "0,00";
}
if($seq % 2 == 0)
$class = "class='cor2'";
else
$class = "class='cor1'";
?>
<tr <?php echo $class ?> >
<td align="center" ><input <?php echo $class ?> type="text" name="item" size="5" value="<?php echo $seq ?>"></td>
<td><input type="text" name="codigo[]" size="8" <?php echo $class ?> value="<?php echo $codigo ?>" readonly="readonly" /></td>
<td><input type="text" name="cEAN[]" <?php echo $class ?> size="20" value="<?php echo $cEAN ?>" readonly="readonly" /></td>
<td><input type="text" name="xProd[]" <?php echo $class ?> size="60" value="<?php echo $xProd ?>" readonly="readonly" /></td>
<td><input type="text" <?php echo $class ?> name="NCM[]" size="8" value="<?php echo $NCM ?>" readonly="readonly" /></td>
<td><input type="text" <?php echo $class ?> name="CFOP[]" size="4" value="<?php echo $CFOP ?>" readonly="readonly" /></td>
<td><input type="text" <?php echo $class ?> name="uCom[]" size="2" value="<?php echo $uCom ?>" readonly="readonly" /></td>
<td><input type="text" <?php echo $class ?> name="qCom[]" size="10" value="<?php echo $qCom ?>" readonly="readonly" /></td>
<td><input type="text" <?php echo $class ?> name="vUnCom[]" size="10" value="<?php echo $vUnCom ?>" readonly="readonly" /></td>
<td><input type="text" <?php echo $class ?> name="vProd[]" size="10" value="<?php echo $vProd ?>" readonly="readonly" /></td>
<td><input type="text" <?php echo $class ?> name="vVenda[]" id="pvenda" size="10" value="<?php echo $vProd ?>" /></td>
<td><input type="text" <?php echo $class ?> name="bc_icms[]" size="10" value="<?php echo $bc_icms ?>" readonly="readonly" /></td>
<td><input type="text" <?php echo $class ?> name="vlr_icms[]" size="10" value="<?php echo $vlr_icms ?>" readonly="readonly" /></td>
<td><input type="text" <?php echo $class ?> name="vlr_ipi[]" size="5" value="<?php echo $vlr_ipi ?>" readonly="readonly" /></td>
<td><input type="text" <?php echo $class ?> name="pICMS[]" size="5" value="<?php echo $pICMS ?>" readonly="readonly" /></td>
<td><input type="text" <?php echo $class ?> name="perc_ipi[]" size="5" value="<?php echo $perc_ipi ?>" readonly="readonly" /></td>
</tr>
<?php } ?>
</table>
Agora onde recebo dos dados!
<?php
session_start();
for( $i=0; $i<count($_POST['item']); $i++ )
{
echo 'Item: '.$_POST['item'][$i].'<br/>';
echo 'Codigo Barras: '.$_POST['cEAN'][$i].'<br/>';
echo 'Descrição: '.$_POST['xProd'][$i].'<br/>';
echo 'NCM: '.$_POST['NCM'][$i].'<br/>';
echo 'CFOP: '.$_POST['CFOP'][$i].'<br/>';
echo 'QTD: '.$_POST['qCom'][$i].'<br/>';
echo 'Vlr Compra: '.$_POST['vUnCom'][$i].'<br/>';
echo 'Vlr T Compra: '.$_POST['vProd'][$i].'<br/>';
echo 'Vlr de Venda: '.$_POST['vVenda'][$i].'<br/>';
echo "<br/>";
}
?>Discussão (6)
Carregando comentários...