404

D7net
:/ proc / thread-self / cwd / adm /
Filename : importa_desconto.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 DESCONTOS 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'];	
	
	$uploadfile = $dir.$_FILES['arquivo']['name'];
	
		$inipath = php_ini_loaded_file();

		//if ($inipath) {
		//echo 'Loaded php.ini: ' . $inipath;
		//} else {
	//	echo 'A php.ini file is not loaded';
	//	}
	
	//print_r($_FILES);
	$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());
		
	}
		$sql1 = "INSERT INTO ro_desconto( 
									filial_id, 
									produto_id, 
									percentual, 
									data 
									)
				VALUES {$sql}
				
			";
	//echo "<PRE>";		
	//echo $sql1;
    //echo	"</PRE>";
	$res= mysqli_query($link,$sql1);		
		
	echo "Linhas ".$rowli."- ". $row.'<br>';
echo "<b>               **  DADOS IMPORTADO COM SUCESSO !! ****";
exit();		
	//print_r($people);
	fclose($handle);
    mysqli_close($link);
} else {
    echo "Possível ataque de upload de arquivo!\n";
}
}
?>