AES-256 encryption, PHP to MySQL

Question

I'm attempting to use this encryption system with PHP.

It comes with this code from the download.

$salt = 'nala321';
$password = 'Alan';
 include('./crypt/Crypt/AES.php');
 $aes = new Crypt_AES();
 $aes->setKey('abcdefghijklmn');

 $size = 10 * 1024; 

***EDIT***
 $plaintext = $password.$salt;
***EDIT***

 for ($i = 0; $i < $size; $i++) {
     $plaintext.= 'a';
 }
 $enc = $aes->encrypt($plaintext);
 echo $enc;

This results in a very long output. How do I go about storing this into mysql? I've looked at different ideas saying to do

EDIT

It returns characters like this

¸ÂØwÕ·›óöŽfjËëªû ÒÚCÂF I3T{öËY_Œ:4$¯Ÿ´

EDIT

VARCHAR(16) CHARSET ascii COLLATE ascii_bin

Which is for an md5 encryption password. I'm not sure if I should put down the size to

$size = (16*16)-1; // for 255 limit on varchar

Thanks for the comments to come!

You should really hash passwords rather than encrypt them... — eggyal
– eggyal, Commented May 30, 2012 at 0:15
If you do encryption right you can have essentially a military grade salted hash. — None
– None, Commented May 30, 2012 at 0:20
If it's solved, post an answer, and accept it, instead of editing *SOLVED* into the title. — CodesInChaos
– CodesInChaos, Commented May 30, 2012 at 21:29

AlanPHP · Accepted Answer · 2012-05-31 18:05:14Z

1

I took out the for loop entirely.

Stored the password as just a varchar(30) and it works just fine.

The final codes looks like this

$password = 'Alan';
include('./crypt/Crypt/AES.php');
$aes = new Crypt_AES();
$aes->setKey('abcdefghijklmn');
$enc = $aes->encrypt($plaintext);
echo $enc;

answered May 31, 2012 at 18:05

AlanPHP

1882 gold badges3 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

AES-256 encryption, PHP to MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related