Decrypting PASSWORD() from MySQL
| From: | Zach Curtis | Date: | Wed, 19 Dec 2001 19:24:02 +0000 |
| Subject: | Decrypting PASSWORD() from MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15113@lists.php.net to get a copy of this message | ||
I have a form for a user to request their forgotten username and password by
entering their email address. I then process this and use mail() to send
them their username and password. However, the password is stored in an
encrypted PASSWORD('password') field in the MySQL table. How can I retrieve
the decrypted password in a SELECT statement?
For example, the following results in retrieving the encrypted password.
$result = mysql_query("SELECT userName,password,email FROM members WHERE
email='$email'");
if (!$result)
echo "<p>Could not execute database query:<br>" .
mysql_error() . "</p>";
$row = mysql_fetch_array($result);
$userName = "$row[userName]";
$password = "$row[password]";
$email = "$row[email]";
Thank you.
Zach Curtis
Programmer/Analyst
POPULUS