rove.php

<html>
<?php
	//Apro la sessione e...
	session_start();
?>
<head><title>Il mio account</title></head>
<body>
<?php
	$conn=mysql_connect("localhost","my_giacomogreggio","samsung");
	if (!$conn)
		die('Impossibile connettersi: '.mysql_error());
		mysql_select_db("my_giacomogreggio") or die('Impossibile aprire il database:'.mysql_error());
?>
<?php
	/*recupero le sessioni */
	$username = $_SESSION['username'];
	$password = $_SESSION['password'];
	$nome = $_SESSION['nome'];
?>
	<center>
	<h1>Benvenuto <?php echo $nome ?>!</h1>
	<br/><br/>
	<table border="4" style=" border-color:black; border-style:solid;">
	<tr><td><center>Carica file:</center></td></tr>
	<tr><td><form action="<?php $_SERVER['PHP_SELF'] ?>" method="POST">
		<input type="file" name="sfoglia" value="Sfoglia..." />
		<input type="submit" value="Carica" name="carica" /></td></tr>
	</form>
	</table>
	<br/><br/>
	<table align="center" border="3">
	<tr><th>Nome Brano</th><th>Nome file</th><th>Caricato da</th><th>...</th></tr>
<?php
	/*Tabella totale dei brani*/
	$risultato=mysql_query("SELECT * FROM DISCOTECA");
	while($riga = mysql_fetch_array($risultato)){
		print("<tr>");
		print("<td>".$riga["nomeBrano"]."</td>");
		print("<td>".$riga["nomeFile"]."</td>");
		print("<td>".$riga["emailProp"]."</td>");
		$ioproprietario=$riga["emailProp"];
	}
	if($ioproprietario==$username){
		print("<td><input type=\"submit\" value=\"Elimina\" name=\"elimina\"</td>");
		print("</tr>");
	}else{
		print("<td>Non e' tuo</td>");
		print("</tr>");
	}
	if(isset($_POST['carica'])){
		$nomeBrano = $_FILES['sfoglia']['name'];
		$nomeFile  = $_FILES['sfoglia']['tmp_name'];
		$dimensione  = $_FILES['sfoglia']['size'];
		$tipoDiFile = $_FILES['sfoglia']['type'];
		/*$caricamenti = fopen($tmpName, 'r');
		$content = fread($caricamenti, filesize($tmpName));
		$content = addslashes($content);
		fclose($caricamenti);
		print $content;*/
		print $nomeBrano;
		print (" ".$dimensione);
		print (" ".$tipoDiFile);
	}
		/*$caricaBrano="INSERT INTO "*/
?>
	</table>
	<br/><br/>
	<form action="<?php $_SERVER['PHP_SELF'] ?>" method="POST">
		<align="bottom"><input type="submit" value="Logout" name="logout" /></align>
	</form>
	</center>
<?php
	if(isset($_POST['logout'])){
		echo "<script> alert('Logout avvenuto con successo!')</script>";
		header("Refresh:0.5; url=./HomepageBrani.php");
	}


	mysql_close($conn);
?>

</body>
</html>