From: james at jpsgraphics dot co dot uk
Operating system: ubuntu
PHP version: 5.2.6
PHP Bug Type: *Encryption and hash functions
Bug description: aes_decrypt will not work in my php page
Description:
------------
in my php pages i am using aes_encrypt which works fine. The issue i am
having is with aes_decrypt. I have been searching for days to try and
resolve this problem but need more help. The following string in my php
will not bring any results back at all. I know it does work because running
it in mysql direct works.
simple sql string:
SELECT AES_DECRYPT(password, 'keyhere') FROM accounts where id = '11';
Reproduce code:
---------------
$sql = "SELECT userId, name, email, aes_decrypt(password,'keyhere'),
country FROM accounts where id='". $_SESSION['member_ID'] ."'";
$result = mysql_query($sql);
if (!$result) {
echo "Could not successfully run query ($sql) from DB: " .
mysql_error();
exit;
}
if (mysql_num_rows($result) == 0) {
echo "No rows found, nothing to print so am exiting";
exit;
}
while ($row = mysql_fetch_array($result))
{
echo $row["userId"];
echo $row["name"];
echo $row["email"];
echo $row["password"];
echo $row["country"];
}
mysql_free_result($result);
mysql_close($conn);
Expected result:
----------------
123456 john [EMAIL PROTECTED] 'password should be here' UK
Actual result:
--------------
[EMAIL PROTECTED]
--
Edit bug report at http://bugs.php.net/?id=45504&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=45504&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=45504&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=45504&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=45504&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=45504&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=45504&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=45504&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=45504&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=45504&r=support
Expected behavior: http://bugs.php.net/fix.php?id=45504&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=45504&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=45504&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=45504&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=45504&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=45504&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=45504&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=45504&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=45504&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=45504&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=45504&r=mysqlcfg
