PHP encrypt problem
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 is:
@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);
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
|All times are GMT -4. The time now is 12:53 AM.|
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.