Password function error in Mysql
Posted 24 March 2003 - 03:28 PM
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
Posted 24 March 2003 - 04:28 PM
i.e if u have used ENCODE(str,pass_str) to store the password
then I guess have to \"DECODE\" them
Hope this helps!
Posted 24 March 2003 - 04:42 PM
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!
Posted 24 March 2003 - 05:18 PM
u have to do
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.
Posted 24 March 2003 - 05:20 PM
Thanks a lot.
Posted 01 April 2003 - 03:57 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users