public static function prepareEncryptFields($encryptFieldsArray, $encryptValuesArray)
{
$encOn = KeyHandler::KeyExists();
$valuesArray = array();
$encryptFieldsArrayCount = count($encryptFieldsArray);
for ($i = 0; $i < $encryptFieldsArrayCount; $i++) {
if ($encOn && self::isEncField($encryptFieldsArray[$i])) {
$key = KeyHandler::readKey();
if ($encryptValuesArray[$i] == null) {
$valuesArray[$i] = null;
} else {
$valuesArray[$i] = "AES_ENCRYPT({$encryptValuesArray[$i]}, '{$key}')";
}
} else {
$valuesArray[$i] = $encryptValuesArray[$i];
}
}
return $valuesArray;
}
function simpleSelect($selectTable, $selectFields, $selectConditions = null, $selectOrderBy = null, $selectOrder = null, $selectLimit = null)
{
/* For Encryption : Begins */
$encOn = KeyHandler::KeyExists();
if ($encOn && CryptoQuery::isEncTable($this->table_name)) {
$selectFields = CryptoQuery::prepareDecryptFields($selectFields);
}
/* For Encryption : Ends */
$query = $this->_buildSelect($selectFields) . " FROM {$selectTable} ";
if (isset($selectConditions)) {
$query .= $this->_buildWhere($selectConditions);
}
if (isset($selectOrderBy)) {
$query .= " ORDER BY {$selectOrderBy} {$selectOrder}";
}
if (isset($selectLimit)) {
$query .= " LIMIT {$selectLimit}";
}
return $query;
}
