Using PASSWORD() function in PHP scripts

[lstephane]

Hi,

I need to encrypt my passwords into the databse.

How can I compare the password entry from the html form with the encrypted one from the database ???

Thanks ! Stéphane Lambert, Analyst/Programmer - BI Specialist
Info Quest (IQ), Data Warehouse System
McKesson Canada Corporation

EMail: stephane.lambert@mckesson.ca

 

[buspass]

if you have used the password() function when inserting the record, you could compare the user's entry by somerthing like:

$rs = "SELECT * from TABLE where password = password(\"$mypassword\&quot";

this would return records where the password the user had entered (mypassword) matched the encrypted entry (password) in the table.

You could also look at md5() function which apparently is much more secure and done iin the same way.