ENCRYPT SCRIPT
#!/usr/bin/perl
use DBI;
use Crypt::Rijndael;

$iv = 'same_16_character_string';
$cipher = Crypt::Rijndael->new( "a" x 32, Crypt::Rijndael::MODE_CBC );
$cipher->set_iv($iv);

$data = $cipher->encrypt($some_data);

** $data is then inserted into a blob field in mysql (data in the accounts table)


DECRYPT SCRIPT
#!/usr/bin/perl
use DBI;
use Crypt::Rijndael;

$iv = 'same_16_character_string';
$cipher = Crypt::Rijndael->new( "a" x 32, Crypt::Rijndael::MODE_CBC );
$cipher->set_iv($iv);

$sql_data = "SELECT data FROM accounts WHERE account_id = '237' LIMIT 1";
$qry_data = $dbh->prepare($sql_data);
$qry_data->execute();
$data = $qry_data->fetchrow_hashref();
$data = $data->{data};
print $cipher->decrypt($data) . "\n\n";