Re: [PHP-DB] Storing sensitive information in MySQL

2001-03-01 Thread Ted Rolle
Ahhh my favorite subject. Privacy. There are two PHP functions that do _exactly_ what you're looking for. Mcrypt_encrypt and mcrypt_decrypt. If you're looking for just enough encryption to keep the curious out, use a single password for all encryption. If you want military-grade encryption

[PHP-DB] Storing sensitive information in MySQL

2001-02-28 Thread Dreamvale
Hi, I have a situation where some sensitive information need to be stored in a database, eg salary, medical info, etc. the data are only meant for the particular employees. however, the root user will have all the power to retrieve both the key (stored somewhere either in a file, or php scripts