|
|
Posted by Paul on 08/30/07 21:37
"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:nqKdndvPlILL9k7bnZ2dnUVZ_ojinZ2d@comcast.com...
> Paul wrote:
>> I want to add a binary element (AES_ENCRYPT()) to a $_POST array. I need
>> to make it binary because it is going into a BLOB field.
>>
>> $results = $dbr->Execute('select * from table1 where id='.$_GET['id']);
>> ...
>> // validation take place and now is processed
>> $_POST["field1"] = $dbr->GetOne('select
>> AES_ENCRYPT('.trim($_POST['field1']).', \'salt*&)#\')');
>> // there are other $_POST fields that are in cluded in the next line
>> // GetInsertSQL is a function that eventually calls $dbr->Execute()
>> $dbr ->GetInsertSQL($results, $_POST, true);
>> It decrypts most records (field1) but not all. After researching it, I
>> think
>> the problem lies in how I am adding the encrypted field.
>>
>> I think I need to make the $_POST["field1"] binary, somehow.
>>
>> If so, how do I do that?
>>
>> Any other ideas?
>>
>> (the $dbr is an ADODB element.)
>
> First of all, why are you changing the $_POST variable? It really should
> be considered read only, even though it isn't. Otherwise you can get
> other problems when you have code which expects it to be unchanged.
>
> And why do you think you need to make it binary? There is no real
> "binary" type in PHP.
I inherited this code and trying to make it work without rewriting it.
It needs to be binary because, as you see, it uses MySQL's AES_ENCRYPT()
which returned binary and goes to a BLOB field.
Thanks.
Navigation:
[Reply to this message]
|