If we follow the instructions at: http://www.asprunner.com/forums/topic/15692-encrypt-and-decrypt-data-in-the-database-with-phprunner-5-3/
Data encrypted and decrypted in PHP code works as described.
I have ran into a wall for the following actions in order to utilize "Data encrypted and decrypted in PHP code". I am hoping for some input from experienced users with encryption.
My Problem: I have three tables. TABLE 1 "field_A" is encrypted. Table 2 "field" has dropdown selection for TABLE 1 "field_A" in the ADD and EDIT pages.
TABLE 1 "field_A" is encrypted, and not legible.
I need code that will render the encrypted field_A from TABLE 1 to be decrypted on TABLE 2 when adding or editing a record.
I have tried $data["field_A"]=decrypt($data["field_A"]); in many different ways, but this is like fishing in backyard puddle after rain. No Success.
I have also searched and read many words from forum, search google, and http://php.net/manual/en/ref.mcrypt.php. I am still without the knowledge to fix my problem.
Additional thoughts: What should we do with MySql Data Field Type and Number of Characters? Current Fields are varchar. I read BLOB is best for encryption.
I tried blob and the data is not legible at all.
How many more characters should we add/allow based on current non-encrypted fields. Is there a specific multipler we should use?
Thanks for all feedback.