Ir para conteúdo

Felipe.xavier

Members
 Perfil  Explorar Conteúdo

  • Total de itens

    1

  • Registro em

  • Última visita

Posts postados por Felipe.xavier

  1. Postado 

    tabela do banco
pagina o web de importa o arquivo xml.



Dados do emitente XML.
<emit>
<CNPJ>1111111111111</CNPJ>
<xNome>DISTRIBUIDORA DE GAS LTDA.</xNome>
<xFant>CARIACICA</xFant

     

    dados do destinatario XML.

    <dest> <CPF>11111111111</CPF>

    <xNome>ROCHA </xNome>

     

    dados do produto XML.

    <prod> <cProd>CB0010</cProd>

    <cEAN>SEM GTIN</cEAN>

    <xProd>ONU 1075,GAS LIQUEFEITO PETROLEO (GRANEL),2.1</xProd>

    <NCM>22222</NCM>

     

    código index.php 

    <?php
//index.php
?>
<!DOCTYPE html>
<html>
 <head>
  <title>How to Import XML Data into Mysql Table Using Ajax PHP</title>
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
 </head>
 <body>
  <br />
  <div class="container">
   <div class="row">
    <h2 style="text-align:center;">Como importar dados XML para a tabela Mysql usando Ajax PHP</h2>
    <br />
    <div class="col-md-9" style="margin:0 auto; float:none;">
     <span id="message"></span>
     <form method="post" id="import_form" enctype="multipart/form-data">
      <div class="form-group">
       <label>Seleciona XML</label>
       <input type="file" name="file" id="file" />
      </div>
      <br />
      <div class="form-group">
       <input type="submit" name="submit" id="submit" class="btn btn-info" value="Importa" />
      </div>
     </form>
    </div>
   </div>
  </div>
 </body>
</html>
<script>
$(document).ready(function(){
 $('#import_form').on('submit', function(event){
  event.preventDefault();

  $.ajax({
   url:"import.php",
   method:"POST",
   data: new FormData(this),
   contentType:false,
   cache:false,
   processData:false,
   beforeSend:function(){
    $('#submit').attr('disabled','disabled'),
    $('#submit').val('Importing...');
   },
   success:function(data)
   {
    $('#message').html(data);
    $('#import_form')[0].reset();
    $('#submit').attr('disabled', false);
    $('#submit').val('Import');
   }
  })

  setInterval(function(){
   $('#message').html('');
  }, 5000);

 });
});
</script>

     

      

    import.php

      

    <?php
//import.php
sleep(3);
$output = '';

if(isset($_FILES['file']['name']) &&  $_FILES['file']['name'] != '')
{
 $valid_extension = array('xml');
 $file_data = explode('.', $_FILES['file']['name']);
 $file_extension = end($file_data);
 if(in_array($file_extension, $valid_extension))
 {
$data = simplexml_load_file($_FILES['file']['tmp_name']);
$connect = new PDO('mysql:host=localhost;dbname=testing','root', '');
$query = "
INSERT INTO employee 
    (name, address, gender, designation, age) 
    VALUES(:name, :address, :gender, :designation, :age);
";
$statement = $connect->prepare($query);
for($i = 0; $i < count($data); $i++)
{
    $statement->execute(
    array(
    ':name'   => $data->employee[$i]->name,
    ':address'  => $data->employee[$i]->address,
    ':gender'  => $data->employee[$i]->gender,
    ':designation' => $data->employee[$i]->designation,
    ':age'   => $data->employee[$i]->age
    )
    );

  }
  $result = $statement->fetchAll();
  if(isset($result))
  {
   $output = '<div class="alert alert-success">Import Data Done</div>';
  }
 }
 else
 {
  $output = '<div class="alert alert-warning">Invalid File</div>';
 }
}
else
{
 $output = '<div class="alert alert-warning">Please Select XML File</div>';
}

echo $output;

?>

     

     

    image.png

×

Informação importante

Ao usar o fórum, você concorda com nossos Termos e condições.

  Aceito