encryption/decryption, MySQLi, etc.

JEfromCanada · Post by **JEfromCanada** » Tue Sep 02, 2014 6:42 am

Hello,

I am particularly concerned about online security, and wish to encrypt many of the fields that hackers would find useful. From other posts, I've learned there are events that can be used to encrypt/decrypt data before display, before searches, etc.

Are there any built-in encryption/decryption functions and/or settings upon field creation that would ease this task, or is it left to the user of PHPMaker to add his/her own choice of encryption/decryption functions manually, as required?

Does PHPMaker generate MySQLi-compliant code, or only MYSQL code?

Does PHPMaker have any tools to support the definition of database schema and creation of databases, or must the database exist prior to using PHPMaker to build the user interface?

Is there an aftermarket for PHPMaker user interface templates (available either from the company or from other sources)?

Thank you for any information you can provide.

danielc · Post by **danielc** » Tue Sep 02, 2014 9:58 am

The generated page does not encrypt. But you can use Row_Inserting/Updating/Rendered server event (see Server Events and Client Scripts in help file) and functions (ew_Encrypt, ew_Decrypt) in phpfn*.php.
Enable [Use mysqli extension] in [PHP]->[General Options]. See PHP Settings in help file.
Need to build your database first before connect to PHPMaker.