Data encrypt problem with PHP

  1. profile image52
    simy202posted 6 years ago

    Hi everyone,
    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);
    echo $query;
    echo $successful;

    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