var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Please help in decrypt info contained in a few columns in database
I have a PHP script that uses a mcryptkey (which I have available) to encrypt/decrypt info like email addresses, phone numbers, etc. I basically need to get the info to a SQL
The key is "XYZ."
I tried as below:
SELECT AES_DECRYPT( phone, '"XYZ."' ) AS phone
WHERE phone IS NOT NULL
gettting some un known results as :
Is there any options to know the original data from database using SQL Statement ?
Please help me .
let me know if you need any other info
Last edited by irk; 02-01-13 at
The key is everything. Without the correct key you data will always be encrypted. However, first thing I would do is look closely at these records to see if by any chance they were added unencrypted in the first place. If not then you will have to guess the key.
Tags for this Thread