[RESOLVED] AES_ENCRYPT and AES_DECRYPT in queries

[Ali_baba]

Hi,

Could someone please check my queries, and let me know where I am making mistake?

Data type for SSN in table is BLOB

Data insertion:

mysql_query("INSERT INTO d_table (s_name,f_name,SSN) VALUES ('$s_name','$f_name',AES_ENCRYPT('$SSN','encrypt'))");

Data reterival:

$result = mysql_query("SELECT AES_DECRYPT(SSN,'encrypt'),* from sibl_table");
while ($array = mysql_fetch_array($result))  {
  echo $array['SSN'];
  echo $array['f_name'];
  echo $array['l_name'];
  }

I can't see the data when I retrieve.

[bretticus]

You need to set an alias for the result from your decrypt. Try this...

$result = mysql_query("SELECT AES_DECRYPT(SSN,'encrypt') AS 'SSN', f_name, l_name from sibl_table");
while ($array = mysql_fetch_array($result))  {
  echo $array['SSN'];
  echo $array['f_name'];
  echo $array['l_name'];
  } 

[Ali_baba]

Thanks bretticus, it works 🙂