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; }