$connessione = mysql_connect("canone.ce.unipr.it", "studsql", "basidati") or die("Connessione non riuscita: " . mysql_error()); mysql_select_db("ibislabdb") or die("Unable to connect to database"); if(isset($_POST['invia'])) { $mail=$_POST['mail']; $sqlquery = "SELECT username FROM logintable WHERE mail='$mail'"; $result = mysql_query($sqlquery) or die (mysql_error()); $number = mysql_numrows($result); $i = 0; if ($number) { $usr=mysql_result($result,$i,"username"); $psw= random_string(6); $oggetto="Password recovery"; $messaggio="Your new password is: ".$psw; $psw_sicura=MD5($psw); $sqlquery="UPDATE `ibislabdb`.`logintable` SET `password`='$psw_sicura' WHERE `username`='$usr'"; $result = mysql_query($sqlquery) or die (mysql_error()); mail($mail, $oggetto, $messaggio); } } ?>