in reply to Re^2: decrypt problems with Crypt::Rijndael (datasize not multiple of blocksize)
in thread decrypt problems with Crypt::Rijndael (datasize not multiple of blocksize)

I can't imagine that's the problem, but I guess it's possible. Here's the update: 
$sql_update = "UPDATE accounts SET data = '" . $data . "', encrypted =
+ '1' WHERE account_id = '" . $account_id . "'";
$qry_update = $dbh->prepare($sql_update);
$qry_update->execute();

[download]
$data is the encrypted piece
  • Comment on Re^3: decrypt problems with Crypt::Rijndael (datasize not multiple of blocksize)
  • Download Code

Replies are listed 'Best First'.
Re^4: decrypt problems with Crypt::Rijndael (datasize not multiple of blocksize)
by ikegami (Patriarch) on Sep 29, 2008 at 19:14 UTC

    Use placeholders! 

    $sql_update = 'UPDATE accounts SET data = ?, encrypted = 1 WHERE accou
+nt_id = ?';
$qry_update = $dbh->prepare($sql_update);
$qry_update->execute($data, $account_id);

    [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom