if(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 ''; } else{ echo '
Lista:




'; }