First, we must assume that you are currently storing the username/login, password and the email address in a mySQL table. Once we know the username/login, we simply use that to locate the password and utilize the mail() function to send it.
Your snippet would be something like this :
$result = mysql_query ("SELECT password,email FROM yourtable WHERE username = '$username'");
if ($myrow = mysql_fetch_array($result))
{
$mailaddress = $myrow["email"];
$subject = "Important Message"; // don't say password in subject
$message = "Your password is: " . $myrow["password"] ;
$header = "Ancillary message or other stuff";
mail($mailaddress,$subject,$message,$header);
}
Hope this is helpful.
I'm new to PHP, and would like to know if there is a code snippet for emailing a lost password to a subcriber?
- 10 Users Found This Useful