Kontaktformular.'; } else { // Bind result variables mysqli_stmt_bind_result($stmt, $userId, $userfirstname, $userlastname); if(mysqli_stmt_fetch($stmt)){ $email_err = ''; } } } else{ echo "Oops! Da ist etwas schief gegangen. Bitte versuchen Sie es später noch einmal."; } // Close statement mysqli_stmt_close($stmt); } if(empty($email_err)){ $timestamp = time(); $timestamp = date("Y-m-d H:i:s", $timestamp); // set temporary password $passwordEncrypted = password_hash(bin2hex(random_bytes(16)), PASSWORD_DEFAULT); $userToken = bin2hex(random_bytes(32)); $query = "UPDATE User SET userStatus = 99, userPassword = '" .$passwordEncrypted ."', userToken = '" .$userToken ."', userLastActivity = '" .$timestamp ."' WHERE userEmail = '" .$email ."'"; if (mysqli_query($link, $query)) { // store variables in Session $_SESSION["loggedin"] = false; $_SESSION["title"] = ''; $_SESSION["firstname"] = $userfirstname; $_SESSION["lastname"] = $userlastname; $_SESSION["email"] = $email; $_SESSION["userToken"] = $userToken; header("location: sendpasswordforgottenmail.php"); exit; } else { die ("Error: " . $query . "-" . mysqli_error($link)); } header("location: sendpasswordforgottenmail.php"); exit; } // Close connection mysqli_close($link); } } ?>