How to encrypt existing data in the database

Enterprise Edition of PHPRunner/ASPRunnerPro/ASPRunner.NET come with option to encrypt data from any table in the database. If you use this option new data added to the database will be encrypted automatically. In this article we'll show you how to encrypt data that were added to the database before encryption functionality was turned on.

Before starting this procedure make a backup of the database. You may perform the encryption of existing values only once. Double encryption will cause problems and it is not possible to determine definitely whether the data was encrypted or not before the procedure.

Data needs to be encrypted separately for each database table. To encrypt existing values in the database add following code to the List page: Before process event of your table:

PHPRunner

ASPRunnerPro

ASPRunner.NET

Then run you List page that contains encrypted fields with ciphcoding=1 parameter, eg:

PHPRunner

ASPRunnerPro

ASPRunner.NET

Once the data has been encrypted, it is necessary to delete the file ciphcoding.php in the output directory, remove the code from the List page: Before process event and re-upload application. We recommend to perform this procedure on the development machine or server without public access.

Applies to:

  • ASPRunnerPro
  • PHPRunner
  • ASPRunner.NET

Back to top