All pastes #393914 Raw Edit

Stuff

public text v1 · immutable
·published 2007-03-13 22:23 UTC
rendered paste body
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 '<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>';
	}