#45504 [Opn->Bgs]: aes_decrypt will not work in my php page

ID: 45504 Updated by: felipe@php.net Reported By: james at jpsgraphics dot co dot uk -Status: Open +Status: Bogus Bug Type: *Encryption and hash functions Operating System: ubuntu PHP Version: 5.2.6 New Comment: Not PHP bug. See about 'aliases': http://dev.mysql.com/doc/refman/5.0/en/identifiers.html Previous Comments: ------------------------------------------------------------------------ [2008-07-13 23:07:53] james at jpsgraphics dot co dot uk 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 john@email.com 'password should be here' UK Actual result: -------------- 123456johnjohn@email.comUK ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=45504&edit=1