storing encrypted data

[nexzt]

Hey guys/gals,

I've ran into a problem storing encrypted data.. i use mcrypt_ecb to encrypt the data.. but when i insert it and then take it out of a db it doesn't come out right... any special settings the table needs to be? also it works fine if i encrypt/decrypt on the same page but it doesn't like to be stored and then decrypted. any hints or code snipplets to help me out please?

Best Regards,
Zak Thompson

[Anon]

Make sure you aren't having problems with addslashes, etc... As a test, perform something similar to the following:

<?PHP
echo "<pre>";
$data = encrypt( $string );
echo "<li>$data";
$sql = "INSERT INTO ... ( $data )";
$sql = "SELECT data FROM ...";
echo "<li>$read_from_database";
echo "</pre>";
?>

...make sure that all quotes, slashes, backslashes, percent signs, asterisks, etc... match up- I'd be willing to bet it's a difficulty with one of those that's caused by "magic_quotes".

--Robert

[Anon]

the encrypted result data maybe binary data which may cause errors in sql query.

Try using the base64_encode/base64_decode function with mcrypt()

e.g.

base64_encode(mcrypt_ecb(MCRYPT_BLOWFISH,$key,$input,MCRYPT_ENCRYPT));

mcrypt_ecb(MCRYPT_BLOWFISH,$key,base64_decode($input),MCRYPT_DECRYPT);

** the following was cribbed from php.net