Jump to content

Archived

This topic is now archived and is closed to further replies.

natasha

Password function error in Mysql

Recommended Posts

hi all,

I am using PHP-MySql and use the following code for login authentication:

 

<?

$res=@mysql_query(\"select * from users where login=(\'$txtlogin\') and password=password(\'$txtpassword\')\");

?>

 

$txtlogin and $password are the text field names. The database has stored the password in the encrypted format. But still it i snot authenticating.

The connection to mysql etc is working. Without the encryption, the logn authentication works...what can be possibly wrong?

a very very perplexed

Natasha. :?:

Share this post


Link to post
Share on other sites

Now if u have encoded the password

 

i.e if u have used ENCODE(str,pass_str) to store the password

 

then I guess have to \"DECODE\" them

 

Try using

 

DECODE(crypt_str,pass_str)

 

Hope this helps!

Share this post


Link to post
Share on other sites

hi

Hmm.. this may sound silly to u..but I am pretty new to mysql. I hv just used the function password(string) to encrypt the password field in the database. and I just using \'password=password(\'$txtpassword\') as part of my query. It just refuses to authenticate..very maddening!

natasha

Share this post


Link to post
Share on other sites

Now when the passowrd is encrytpted

 

u have to do

 

select PASSWORD(\'$password_value\');

 

This will return a encrypted value and u have to compare this value.

 

I dont think u can decrypt the password vale that has been stored.

 

I hope this helps you.

Share this post


Link to post
Share on other sites

yeah that is what I hv been doing the entire day today..will give it a shot tomorrow again!!

:lol:

Thanks a lot.

Share this post


Link to post
Share on other sites

Natasha, could you please stop stickying your posts unless it\'s really important? I noticed you did this on the PHP forums, too.

 

Thanks.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.