help encrypting field with MySQL AES_encrypt before Adodb query

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Paul
    #1

    help encrypting field with MySQL AES_encrypt before Adodb query

    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('t ext', 'password')";

    It is a live system and I am hesitent to make changes without researching
    it.

    Any ideas?


    Tags: None
    • petersprc
      #2
      Re: help encrypting field with MySQL AES_encrypt before Adodb query

      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.c omwrote:
      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('t ext', 'password')";
      >
      It is a live system and I am hesitent to make changes without researching
      it.
      >
      Any ideas?

        Comment

        • Paul
          #3
          Re: help encrypting field with MySQL AES_encrypt before Adodb query

          beautiful - thanks!


          "petersprc" <petersprc@gmai l.comwrote in message
          news:1176517941 .711079.277500@ d57g2000hsg.goo glegroups.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.c omwrote:
          >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('t ext', 'password')";
          >>
          >It is a live system and I am hesitent to make changes without researching
          >it.
          >>
          >Any ideas?
          >
          >

            Comment

            Previous template Next
            Working...