Password Encryption Issues
| From: | Lindsey Gregory | Date: | Thu, 17 Apr 2003 18:39:27 +0000 |
| Subject: | Password Encryption Issues | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27149@lists.php.net to get a copy of this message | ||
Hello all,
This is kinda hard to explain, but I am having a problem with pass
encryption/decryption stuff. I had a section of my website protected by a
cookie-based log in that authenticates from a database (mySQL) of user/pass
combinations... anyway, I am moving that website from one server to
another... The username and password are exactly the same in the new DB as
it was in the old one... and of course, I have them encrypted... but it
wont authenticate because the sql query is spitting out a different
encrypted pass from the login form so when I do the following query: SELECT
id FROM table WHERE ((username = '$username') AND (password =
PASSWORD('$password')) the encrypted password there is different than the
enctypted pass in the DB.
Any help with this would be appreciated! thanks!
-lindsey