crypt with login problem

[anolan13]

Hello,

 

I want to encrpyt a login name using PHP and MySQL. I've already done this, using the crypt() command but when the user tries to login with the name it says that name doesn't exist in the database. I think it's because it's encrypted and is reading it as something else. Is there a way to get this working?

 

Thanks!

[Ken2k7]

Hello,

 

I want to encrpyt a login name using PHP and MySQL. I've already done this, using the crypt() command but when the user tries to login with the name it says that name doesn't exist in the database. I think it's because it's encrypted and is reading it as something else. Is there a way to get this working?

 

Thanks!

Post your code please.

[eRott]

First off: http://ca3.php.net/crypt

 

I have never used the crypt() function before, but wouldn't you do the same thing as if you were using the md5 function or something similar?

 

So for example:

 

<?php
$my_username = $_POST['username']; //grabs the username posted from the form
$my_password = $_POST['password']; //grabs the password posted from the form

$crypt_password = crypt($my_password);

$sql = "SELECT password FROM users WHERE username='$my_username'";
$result = mysql_query($sql) or die(mysql_error());

while ($list = mysql_fetch_array($result)) {
     $stored_password = $list['password'];
}

if ($crypt_password == $stored_password) {
     //do whatever if the password matches
}
else {
     echo "Buzz off!";
}
?>