password protected mysql entries with php

[farley99]

Does anyone have a simple example where i can insert PASSWORD to a mysql database encrypted and then decrypt it an read it in a file? when i try to call it back it give me the encrypted password instead of the real one.

 

[sleipnir214]

All of the encryption functions built into MySQL, such as password(), encrypt(), and mds(), are use one-way hashing algorithms. Once information is encrypted with these functions, there is no way to decrypt them.

Do you have the mcrypt libraries installed and available to PHP? You can then perform encryption using reversible algorithms on the PHP side. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[danielhozac]

Actually, MySQL's [tt]ENCRYPT[/tt] and [tt]DECRYPT[/tt] functions can be used for these purposes. I've used them before on a site where I had to be able to fetch the password. //Daniel

 

[sleipnir214]

Odd. The MySQL online manual says that encrypt() uses the Unix crypt() function, if available -- that function uses a one-way algorithm. It doesn't even mention a decrypt() function.

It does mention the aes_encrypt()/aes_decrypt() and des_encrypt()/des_decrypt() function pairs, though. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[danielhozac]

Oops, I meant the [tt]ENCODE[/tt] and [tt]DECODE[/tt] functions. //Daniel