404

D7net
:/ proc / thread-self / cwd / adm /
Filename : importa_dcb.php
back
<?php
set_time_limit(0); 
include_once("conecta.php");
error_reporting(E_ALL ^ E_NOTICE);
?>
 <form id="saldo"  name="saldo" action="?go=gravar" method="POST" enctype="multipart/form-data">
 <title>Importação</title>
 <h1>IMPORTAÇÃO DADOS ROSARIO</h1>
 <br><p>	<input type="file" name="arquivo" value="selecionar" />
<br><p>	<input type="submit" id="confirma" value="CONFIRMAR" />
</p>
</p>
       <p>
         <a href="../index.php">Pagina Principal</a>
        </p>  
 </form>
</body>
</div>
</html>
<?php
if(@$_GET['go'] == 'gravar') {
	$dir = $_SERVER['DOCUMENT_ROOT']."/rosario/";
	$nome = $_FILES['arquivo']['name']; 
	print_r();
	$uploadfile = $dir.$_FILES['arquivo']['name'];
	$mv = move_uploaded_file($_FILES['arquivo']['tmp_name'], $uploadfile);
	if ($mv) {
		$handle = fopen($nome, "r");
		$rowli = 0;
		while ($line = fgetcsv($handle, 10000, ";")) {
			if ($rowli++ == 0) {
				continue;
			}
			
		}
		$handle = fopen($nome, "r");
		$row = 0;
		while ($line = fgetcsv($handle, 10000, ";")) {
			$num = count($line);
			if ($row++ == 0) {
				continue;
			}
			$sql .= "('{$line[0]}'
                      ,'{$line[1]}'			
			 		  ,'{$line[2]}'
					  ,'{$line[3]}')";
			if($rowli == $row){
				$sql .=";";
			}else{
				$sql .=",";
			}
			 
				
			//	echo $sql."<br>";
			//$res= mysql_query($sql) or die (mysql_error());
		}
	
	echo "Linhas ".$rowli."- ". $row;
	$sql1 = "INSERT INTO ro_dcb(dcb_cod,
								dcb_descr,
								dcb_apres,	
								dcb_cod_oficial)
				VALUES {$sql}
				
			";
	//echo "<PRE>";		
	//echo $sql1;
   // echo	"</PRE>";
	$res= mysql_query($sql1) or die (mysql_error());		
		
echo "<b>               **  DADOS IMPORTADO COM SUCESSO !! ****";
exit();		
	//print_r($people);
	fclose($handle);

	
	
} else {
    echo "Possível ataque de upload de arquivo!\n";
}

}
?>