2. PHPRunner General questions
  3. Encrypting Fields
This topic is locked

Encrypting Fields

 		8/26/2005 12:11:15 PM
PHPRunner General questions
pplaut author

I read the other topic regarding the encryptioin of the login id.
I will have a need, I think, to encrypt certain fields. It would be lovely if I could just select that as a property of the field in phprunner. Since, it looks like that is currently not an option, how would you go about encrypting a field so that if somebody broke into the database, they would only see the encrypted information.
I suppose if that is not possible, how about just encoding a field.
Thanks

Peer
prleo1 8/26/2005

If you are using MySQL, you can use the sha1 or md5 encyrption function. However, you cannot decrypt md5 only compare it to a value.
sha1 -
Update equipment

set ssn=sha1(ssn);
Here is a ref from MySQL. If the db is not MySQL, post again with the db type.
http://dev.mysql.com/doc/mysql/en/encrypti...-functions.html