|
|
Posted by Jerry Stuckle on 08/28/07 00:23
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.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|