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 Quote 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. Quote 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?! Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.