roldahayes Posted December 4, 2009 Share Posted December 4, 2009 Hi, I have a database that stores information for me. A couple of the fields have sensitive phone numbers in them and when browsing in PHPMyadmin, the numbers can been seen. How do I get these fields to be encrypted like the "Password" fields normally are? Thanks Link to comment https://forums.phpfreaks.com/topic/183989-need-some-help-encrypting-a-field/ Share on other sites More sharing options...
fenway Posted December 4, 2009 Share Posted December 4, 2009 If it's encrypted, you'll need to decrypt it to get it back -- how you choose to encrypt is entirely up to you. Link to comment https://forums.phpfreaks.com/topic/183989-need-some-help-encrypting-a-field/#findComment-971324 Share on other sites More sharing options...
roldahayes Posted December 4, 2009 Author Share Posted December 4, 2009 Are there any "simple ways" to do this?! Link to comment https://forums.phpfreaks.com/topic/183989-need-some-help-encrypting-a-field/#findComment-971326 Share on other sites More sharing options...
MadTechie Posted December 4, 2009 Share Posted December 4, 2009 MySQL encryption functions Simple option is, INSERT INTO table (Phone) VALUES ('ENCODE("Hello World","Password") '); SELECT DECODE(Phone,'Password') as DecodedPhone, Phone FROM table Or encrypt/decrypt the data prior insert and display via PHP Link to comment https://forums.phpfreaks.com/topic/183989-need-some-help-encrypting-a-field/#findComment-971331 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.