feel free to keep it strictly simple...

encrypt/decrypt data in your database

In LEPTON 4.1.0 we introduce functions/methods to encrypt and decrypt the data in table_fields of the database.

 

In addition to methods

 

there are some new methods to save encrypted data into your database and read decrypted data from your database:

  • secure_execute_query
  • secure_prepare_and_execute

 

All you have to do is to write the table_fields you want to be encrypted in an array and pass it as an parameter with the method.

Details can be seen in the documentation: lepton_secure_database.

 

Please keep in mind that you need openssl enabled in your php-release (standard from PHP 7.2x). Please also take care that the fields to encrypt have a length of varchar = 128 to fit with the encrypted values.