| Server IP : 20.75.53.88 / Your IP : 216.73.217.72 [ Web Server : Apache System : Linux VMRALP-3 4.4.0-256-generic #290~14.04.1-Ubuntu SMP Thu Jun 20 09:24:50 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29+esm15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Domains : 3 Domains MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/apitce/dev/ |
Upload File : |
<?php
//connect to the database
$connect = mysql_connect("localhost","root","jklsr0xx");
mysql_select_db("auditoria",$connect); //select the table
//
// $grupo = $_POST['cod_itemgrupo'];
// $subgrupo = $_POST['cod_subgrupo'];
if ($_FILES[csv][size] > 0) {
//get the csv file
$file = $_FILES[csv][tmp_name];
$handle = fopen($file,"r");
$table = "notas_pagamentos";
//$arquivo = 'itemlimpeza.csv';
//$objeto = fopen($handle, 'r');
while (($dados = fgetcsv($handle, 1024, ";","'")) !== FALSE) {
$data_emissao_empenho = date("Y-m-d H:i", strtotime($dados[4]));
$data_referencia = date("Y-m-d H:i", strtotime($dados[8]));
$data_nota_pagamento = date("Y-m-d H:i", strtotime($dados[10]));
$sql = "INSERT INTO $table (codigo_municipio, exercicio_orcamento, codigo_orgao, codigo_unidade, data_emissao_empenho, numero_empenho, numero_sub_empenho, numero_nota_pagamento, data_referencia, nu_documento_caixa, data_nota_pagamento, valor_nota_pagamento, valor_empenhado_a_pagar, estado_de_estornado, cpf_pagador, nome_pagador) VALUES ('$dados[0]','$dados[1]','$dados[2]','$dados[3]','$data_emissao_empenho','$dados[5]','$dados[6]','$dados[7]',
'$data_referencia','$dados[9]','$data_nota_pagamento','$dados[11]','$dados[12]','$dados[13]','$dados[14]','$dados[15]')".";";
//mysql_query($sql) or die(mysql_error());
//$re = mysql_insert_id();
//return $re;
echo $sql."<br>";
}
header('Location: test2.php?success=1'); die;
//fclose($dados);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Import a CSV File with PHP & MySQL</title>
</head>
<body>
<?php if (!empty($_GET[success])) { echo "<b>Your file has been imported.</b><br><br>"; } //generic success notice ?>
<form action="" method="post" enctype="multipart/form-data" name="form1" id="form1">
<select name="cod_itemgrupo" class='text' >
<option value="BC">BC-MATERIAL DE CONSUMO</option>
</select><BR>
<select name="cod_subgrupo" class='text' >
<option value="22">LIMPEZA</option>
</select><BR>
<input name="csv" type="file" id="csv" />
<input type="submit" name="Submit" value="Submit" />
</form>
</body>
</html>