help encrypting field with MySQL AES_encrypt before Adodb query

[Paul]

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?

[petersprc]

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" <[e-mail]:

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?

[Paul]

beautiful - thanks!
"petersprc" <pe*******@gmail.comwrote in message
news:11**********************@d57g2000hsg.googlegr oups.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" <[e-mail]:

>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?