column-level encryption

Hello,
​
I have Chronoforms 4 and plan to switch to 6 in the near future.
​
With the GDPR is going on and no experience with Chronoforms 6. I am wondering if Chronoforms 6 has a feature to encrypted data, especially personal data, when insert into database in case my website get data breaches.
​
Thankk you,
​
M

Hi nilubon03,
​
No, there is no encryption built in. I think that it would have to be added using custom PHP either (a) to encrypt/decrypt data before saving and after reading; or (b) to call the MySQL queries to save and read directly using the MySQLfunctions - see here
​
Bob

Hi Bob
I'm trying to use

aes_encrypt({data:name}, 'mysecretkey')

on insert, but it doesn't execute the SQL function "aes_encrypt"

How to invoke the SQL function is Read/Save Data action?

Regards

Hi touretteroma,
​
You can't run the aes_encrypt in the action box there. You would need to do that in a Custom PHP box before the Save Data action - the Custom PHP can return a value in the form data that you can then use in the Save Data action.
​
Bob