MySQL password()
| From: | Liam MacKenzie | Date: | Tue, 30 Jul 2002 06:28:00 +0000 |
| Subject: | MySQL password() | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-110299@lists.php.net to get a copy of this message | ||
Hi all,
I do this:
dbconnect();
$query="SELECT * FROM users where username='$PHP_AUTH_USER'";
$result=mysql_query($query);
$list=mysql_fetch_array($result);
if ($PHP_AUTH_PW !== $list[passwd] || "" == $PHP_AUTH_PW || "all" !=
$list[domain]){
Header("WWW-authenticate: basic realm=\"EMM\"");
Header( "HTTP/1.0 401 Unauthorized");
unauthorized();
exit;
}
}
Noe this bit:
if ($PHP_AUTH_PW !== $list[passwd]
My problem is that the password stored in MySQL was done with password(), so
it comes out similar to this as plain text:
072g307j9236a82h3u
How do I Un password() it?
I have RTFM but to no avail.
If you tell me to RTFM again, at least tell me what to search for ;-)
Cheers,
Liam