How to integrate recordset with encryption?

I use your mySQLi recordsets religiously, and on a new site, I need to include blowfish encryption/decryption on this site. I'm including sample code below of encryption that I have working - but it creates its own connection each time, and I'm going to have like 10 recordsets on this page. How can I re-code your mySQLi recordset code, and integrate this decryption code so they work together? Sample decryption code attached as PM.

Does your algorithm, mode, or iv value change on a page by page or row by row basis?

If they stay the same, then you can just reference them as variables on the page with the key variable. Then in your bindings you can call the mcrypt_decrypt function when displaying their values and use mcrypt_encrypt on insert and update pages.

It wouldn't seem you would need to use a recordset at all for those values as I doubt they would change on a row by row basis.

Yes, and that's essentially what I'm doing when I manually create the decrypt process, but I'd rather not have to spell out the database connection for each group of data. Can you show me how you'd integrate that call to the Connections file?

I can help you with this in a premier support ticket. You can just add the variable declarations to the connection file and then use the encrypt and decrypt calls to the bindings when necessary.

PM

Please contact me via phone, email, or skype and we can schedule a meeting.