rendered paste bodyif(isset($_POST['submit'])){
$uploaddir = '../uploads/';
$uploadfile = $uploaddir .$_FILES['file']['name'];
move_uploaded_file($_FILES['file']['tmp_name'], $uploadfile);
$fisier = '../uploads/'.$_FILES['file']['name'];
$handle = fopen($fisier, "r");
$continut = fread($handle, filesize($fisier));
$continut = str_replace("\"",'', $continut);
$rand = explode("\n",$continut);
foreach($rand as $value){
$x2 = explode(";", $value);
$categorie = $x2[0];
$marca = $x2[1];
$last = count($x2);
$nume = $x2[2];
for($i=1;$i<$last-2;$i++)
$nume .= $x2[$i];
$pret = $x2[$last-1];
if(exists($nume,'produse','nume'))
$sql2 ='UPDATE produse SET pret = "'.$pret.'" WHERE nume ="'.$nume.'"';
else
$sql2= 'INSERT into produse (categorie,marca,nume,pret) VALUES ("'.$categorie.'","'.$marca.'","'.$nume.'","'.$pret.'")';
$query2= mysql_query($sql2);
}
echo '<META HTTP-EQUIV=Refresh CONTENT="0; URL=produse.php">';
}
else{
echo '
<form name="mod" action="excel.php" method="post" enctype="multipart/form-data">
Lista: </br>
<input name="file" type="file" /></br><td/><br /><br />
<input type="submit" name="submit" value="Introdu Lista" /><br />
</form>';
}