How to code mysql PASSWORD encryption!

Chrysanthus

Hi i wounder how i code mysql password encryption in to my code on the password section....

require ('mysqlcondbrr.php');
mysql_query("INSERT INTO reg_info (username, password, email) VALUES ('$str', '$password','$email')");
$register_username = "Thanks! - Your registration was succesfull!";
$goto = "<p>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp To goto next page <a href=\"registerduser.php\">click here</p>";
mysql_close($starta);

furious5

You may want to have a look at PHP.net for the md5 function.

http://uk2.php.net/manual/en/function.md5.php

Chrysanthus

but if some one forgetts the password how do i mange to get a new password?

Chrysanthus

a stupid question how do i get md5 function into my
code.

im not shore where i ganna put the md5 function
in the fiste section oft the code or in the defined value fields!

("INSERT INTO reg_info (username, password, email) VALUES ('$str', '$password','$email')");

furious5

Regarding passwords, that in itself is a bit of a problem. MD5 is almost unreversible as you would need to know the actual key length of the password itself.

The only other way would be to RSA private key or similar.

To be honest, you are better of doing a search through the previous topics on the subject as there is a wealth of information, which would probably pay you to know.

Have a look through this little lot, should keep you occupied for a while:

http://www.phpbuilder.com/board/search.php?s=&action=showresults&searchid=426520&sortby=lastpost&sortorder=descending

furious5

In answer to your other question, the md5 function would have been executed prior to the SQL statement and you would simply put it in as a variable e.g as $password.