MySQL AES decryption problem
Posted: Fri Jan 23, 2015 4:17 pm
Hello, again members of the PHP Technorati! I come to you with a pressing problem concerning AES decryption script. it is not returning any value, hence resulting in a Notice: unidentified variable error for all array values. Here is the code:
I suspect that the decrypt is yielding an empty array of values. Please enlighten me as to the error of my ways.
Thanks in advance,
Batoe
Code: Select all
mysql_select_db('mdo_db');
$query = "SELECT AES_DECRYPT(c_f_lbl_1, '.$fvek_1.'),
AES_DECRYPT(c_f_lbl_2, '.$fvek_1.'),
AES_DECRYPT(c_f_lbl_3, '.$fvek_1.'),
AES_DECRYPT(c_f_lbl_4, '.$fvek_1.'),
AES_DECRYPT(c_f_lbl_5, '.$fvek_1.'),
AES_DECRYPT(c_f_lbl_6, '.$fvek_1.'),
AES_DECRYPT(c_f_lbl_7, '.$fvek_1.'),
AES_DECRYPT(c_f_lbl_8, '.$fvek_1.'),
AES_DECRYPT(c_f_lbl_9, '.$fvek_1.'),
AES_DECRYPT(c_f_lbl_10, '.$fvek_1.'),
AES_DECRYPT(c_f_lbl_11, '.$fvek_1.'),
AES_DECRYPT(c_f_lbl_12, '.$fvek_1.'),
AES_DECRYPT(c_f_lbl_13, '.$fvek_1.')
FROM `form_tbl` WHERE `form_id` = 757577554";
$result = mysql_query($query) or die(mysql_error());
$get_form = mysql_fetch_array($result);
$get_form['c_f_lbl_1'] = $c_f_lbl_1;
$c_f_lbl_2 = $get_form['c_f_lbl_2'];
$c_f_lbl_3 = $get_form['c_f_lbl_3'];
$c_f_lbl_4 = $get_form['c_f_lbl_4'];
$c_f_lbl_5 = $get_form['c_f_lbl_5'];
$c_f_lbl_6 = $get_form['c_f_lbl_6'];
$c_f_lbl_7 = $get_form['c_f_lbl_7'];
$c_f_lbl_8 = $get_form['c_f_lbl_8'];
$c_f_lbl_9 = $get_form['c_f_lbl_9'];
$c_f_lbl_10 = $get_form['c_f_lbl_10'];
$c_f_lbl_11 = $get_form['c_f_lbl_11'];
$c_f_lbl_12 = $get_form['c_f_lbl_12'];
$c_f_lbl_13 = $get_form['c_f_lbl_13'];
Thanks in advance,
Batoe