md5() and mysql
| From: | Mike Baerwolf | Date: | Fri, 29 Aug 2003 01:03:22 +0000 |
| Subject: | md5() and mysql | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-30204@lists.php.net to get a copy of this message | ||
Hello,
I'm looking at using md5() and mysql for user auth to some of the data in a table. I found the following on the php md5 manual page,
$query = "INSERT INTO user VALUES ('DummyUser',md5('DummyPassword'))";
$password = md5($password);
$query = "SELECT * FROM user WHERE username='DummyUser' AND password='DummyPassword'";
I see that nobody will be able to view the password once it's in the database, but I'm thinking that the plain text password is sent to and from the server and someone might be able to snoop the plain text password. Is that right?
Thanks for the help,
Mike