Posted by Paul on 04/16/07 17:12

beautiful - thanks!


"petersprc" <petersprc@gmail.com> wrote in message
news:1176517941.711079.277500@d57g2000hsg.googlegroups.com...
> Hi,
>
> You could generate the encrypted value:
>
> $_POST['field'] = $db->GetOne(
> 'select AES_ENCRYPT(?, ?)',
> array($_POST['field'], 'password'));
>
>
> On Apr 13, 10:24 am, "Paul" <l...@invalid.com> wrote:
>> I encrypted a database field using MySQL AES_ENCRYPT() from a mysql
>> command
>> prompt. But I need to encrypt and decrypt at will in the php code as
>> records are added and viewed.
>>
>> I can easily decrypt it because the code specifies a Query. But the
>> INSERT
>> is an ADODB insert:
>>
>> $_POST['is_here'] = 83;
>> ....
>> runQuery($db ->GetInsertSQL($rs, $_POST, true));
>>
>> I need to use MySQL AES_ENCRYPT() one of the $POST fields before it goes
>> into this but I don't see how? Mcrypt is not installed on server so MySQL
>> functions are what I need to use. Is there a way to have something like
>> :
>> $_POST['field'] = "AES_ENCRYPT('text', 'password')";
>>
>> It is a live system and I am hesitent to make changes without researching
>> it.
>>
>> Any ideas?
>
>

• Next in forum: Re: limit output to only php print/echo statements?
• Prev in forum: Re: Really hardcore question about PHP needed :)
• Thread view: Re: help encrypting field with MySQL AES_encrypt before Adodb query

[Reply to this message]