Thank you in advance for the replies I will be getting.. Much appreciated.

Basically I am running the following mysql query using PDO

UPDATE users SET password = AES_ENCRYPT(:password,:supersalt)

Now the issue is..

on one computer I am getting ¶z8Ibﶘé®òŒd­Y in the password field but on another its blank. or sometimes

not sure what is causing the different results.

mysql version: 5.6.15
PHP: 5.6.16
Apache: 2.4.7

same versions on both PCs


1 Week
Discussion Span
Last Post by ryantroop

The issue I am having is that one computer its working and another computer its not .. so not sure what could be different..

fields on both computers are varchar(200) but works in one and not in other..

not sure if I need to set anything in mysql config file or any other config files such as Apache config or PHP config.


when you say blank, do you mean null or an empty string?

Also, have you tried just running a hash by itself and seeing what the output is? (ie, select AES_ENCRYPT("string", "foo"); )


Also, since you're passing through PDO I assume you migrated machines or something like that - are you sure your PDO vars are being set correctly? If you pass in an err val for one of the parse vars, it's possible that would explain the empty value as well.

Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.