encrypt certain fields on insert

I am capturing and displaying information fine with chronoforms but we have been asked to encrypt the field values in the database.

any advice on the best way to do this?

I found forum posts around the password fields and using joomla functions but this is beyond that.

Rob

Hi Rob,

Neither CF nor Joomla! has built in support for encryption. You could do it with Custom Code actions using the MySQL encryption methods but I think it's probably simpler to encrypt using PHP in a custom code action, then saving the encrypted version of the data plus a key. Of course, you'd have to reverse this after a DB Read action.

I found this StackOverFlow answer that seems to have most of what you'd need.

Bob

Bob,

Thanks for the information. I was thinking about this as a possible solution but I wanted to see if there were any other ways available.

PS, I really like chronoforms. Thank you and your teams hard work.

Rob