Kevin the Linux User wrote:
To the PHP Database Mailing-List:

I joined the mailing list for this one question I just can't figure out.

nice, we help you and then you bugger off? - community spirit are go!

I used the phpMyAdmin to create table. I placed one row in this table, I used 
the ENCRYPT function. How do I De-Crypt the data I just encrypted to use in my 
PHP code. I encrypted it, for security.

        If it's not a bother, can you also give a sniplet of example code, on 
just the part of de-crypting it, I know everything about connecting, and 
displaying, it's just the de-crypting I am having trouble with.


the mysql manual states:

"ENCRYPT() ignores all but the first eight characters of str, at least on some systems. "


this is probably not what you want, besides which AFAICS its one way encryption.


---

as you don't state what it is your trying to achieve (e.g. storing a passwd - in which there is NO reason to want to decrypt it - instead you should test a user given value against the DB by encrypting the user value), you also don't state what version of MySQL your using therefore its impossible to determine which encryption functions you have at your disposal in MySQL.

here is a couple of pairs of enc/dec funcs that might help:

AES_ENCRYPT(str,key_str)
AES_DECRYPT(crypt_str,key_str)

DECODE(crypt_str,pass_str)
ENCODE(str,pass_str)

try reading this page:
http://dev.mysql.com/doc/mysql/en/Encryption_functions.html

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to