OraFAQ Forum: MySQL » Encrypt error using PHP

Home » Open Source » MySQL » Encrypt error using PHP

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Encrypt error using PHP [message #490711]

Wed, 26 January 2011 21:37

simy202
Messages: 1
Registered: January 2011
Location: United States

Junior Member

HI
I am in trouble now. Just tried lots of different versions of AES_ENCRYPT / AES_DECRYPT scripts but cannot get it working. I've even tried putting the mySQL directly in via the phpAdmin query window where it works fine. I generated the following code from the 'generate php' button on there.

Can anybody tell me what I'm doing wrong, please.

The PHP encryption script on the site: phpkode.com/scripts/category/php-cryptography/ is:

mysql_connect($dbhostname,$username,$password);
@mysql_select_db($database) or die( "databaseConnection=0");

$query = "INSERT INTO encodeit (id,card_number) VALUES (\'8\',AES_ENCRYPT(\'Anthony\',\'xk8\'))";

$successful = mysql_query($query);
echo $query;
echo $successful;
mysql_close();

This generates a record in my database, but the 'card_number' field is a blob so I can't view the data in there (unless someone can tell me otherwise???).

Thanks for any help in advance
Simy

Report message to a moderator