[SOLVED] AES_ENCRYPT / DECRYPT

[black.horizons]

Can somebody show me a simple implementation of how to use these two methods in PHP, when inserting and selecting data from a table in MySQL? I'm a bit confused with the mysql.com page on it all...

TIA!

[fenway]

The complicated bit about these ones, if I have to right ones, is the use of the key.

[black.horizons]

i'm lost...

[fenway]

Sorry, I've mixed this up with the DES functions.

[black.horizons]

so...how would i use these on any of my tables. if i needed to encrypt and decrypt several fields. could you show me an insertion, update and selection statement of these?

$insertinfo = mysql_query("INSERT INTO team_info VALUES ('NULL','$travel','$notes','$fixture,'$timestamp'')");

NULL is a mysql auto_increment value

$updateinfo = mysql_query("UPDATE team_info SET travel='$new_travel', notes='$new_notes', fixture='$new_fixture', TimeStamp='$timestamp' WHERE (team_id='$id')");

$selectinfo = mysql_query("SELECT travel, notes, fixture, TimeStamp FROM team_info WHERE (team_id='$id')");

[fenway]

Well, I believe that you would just wrap your value in AES_ENCRYPT( plaintext, key ).

[black.horizons]

thanks all, heres how i did it: (field names and key changed!)

$user_info = mysql_query("SELECT AES_DECRYPT(address1, 'yugbfmdhkdfk8657698') as address1, AES_DECRYPT(townland, 'yugbfmdhkdfk8657698') as townland, AES_DECRYPT(postcode, 'yugbfmdhkdfk8657698') as postcode, AES_DECRYPT(homephone, 'yugbfmdhkdfk8657698') as homephone, AES_DECRYPT(mobilephone, 'yugbfmdhkdfk8657698') as mobilephone FROM userinfo WHERE (id='$id')");

works super!