Encrypt/Decrypt entire model

[DBCreator]

I am wanting to encrypt/decrypt an entire model (maybe not the PK) and wondering what approach to take?

I dabbled a little and am encrypting individual columns

Yii::$app->getSecurity()->encryptByPassword();

I’m assuming I could use the model’s beforeSave, is that correct? But which event should I use to decrypt when the update/view views are used?

Any advice?

Thank you for your help!

[samdark (Alexander Makarov)]

It could be done at database level:

• https://mariadb.com/kb/en/data-at-rest-encryption-overview/#specifying-what-tables-to-encrypt
• https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
• https://www.postgresql.org/docs/8.3/pgcrypto.html

But it’s definitely doable your way. The event you’re looking for is afterFind.

[DBCreator]

The event you’re looking for is afterFind

Thank you for the links and the proper event. Some reading ahead of me.