How to encrypt password in database?

[sulin]

Hello,

Is there a function in MySQL to encrypt password field?
If so, pls give me the sample code to do it.

This is how is just insert a record into the table

$sql_insert = "INSERT INTO login (id, password) VALUES ('$id', '$password')";
$result_insert = mysql_query($sql_insert) or die ("Couldn't execute query.");

You could test out my login at and tell me what other checking needs to be done.
http://tsldesigns.com/php/login.htm

thanks and regards,
Su Lin

[Anon]

Read about these in the php manual.

md5(), crypt(), mcrypt().

Richie

geocities.com/akindele/

[sulin]

ok, thanks

[luxfx]

additionally, MySQL also has a password() function, but it's one-way. You can't decrypt an encrypted string, but you can match against it, like this:

mysql_query("INSERT INTO login (id, password) VALUES ('$id', PASSWORD('$password'))";

and then to compare and retrieve, something like this:

mysql_query("SELECT * FROM login WHERE id='$id' AND password=PASSWORD('$password')");

[sulin]

Thanks David,

I will try it out...

regards,
Su Lin
http://tsldesigns.com