encryption of data stored in the database

CodeCharge Studio

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

encryption of data stored in the database

Author

Message

clubbing80s

Posts: 13

Posted: 08/13/2007, 4:37 AM

Hi
It there a wy of encrypting data stored in the databse , it text records, such that they may be decrypted. want to secure private data ..

_________________
Many Thanks
www.linuxpro.co.za

mamboBROWN

Posts: 1713

Posted: 08/13/2007, 5:09 PM

There definitely are ways to encrypt data but could you give us more information as to what language / database / language you are planning using??

clubbing80s

Posts: 13

Posted: 08/14/2007, 12:15 AM

I'm currently using PHP and ms sql server, I known there is and encryption / decryption function in PHP mcrypt() , but how does one apply this in CCS ?

Sorry if these Q's seem a bit basic, I'm an nubee to CCS..
Many Thanks
_________________
Many Thanks
www.linuxpro.co.za

mamboBROWN

Posts: 1713

Posted: 08/14/2007, 7:01 PM

clubbing80s
It depends on what you will be doing with the data. Which leads to my next question. Can you give us an idea of what you will be doing with the data?? Are you encypting all or part of the data. Is this for passwords or special keys? We need more information. ( More than likely you will be putting your custom code in Server Side Events)

Here are some links that may help you:
http://us.php.net/mcrypt
http://www.onlamp.com/pub/a/php/2001/07/26/encrypt.html

NOTE: You can also download the PHP chm file which will be very handy to have.

clubbing80s

Posts: 13

Posted: 08/14/2007, 11:11 PM

the data is text fields ... the application is supposed to store the notes for psychological assessments, for students, and I dont want the sysadmin to be able to view the content of the text fields ...

_________________
Many Thanks
www.linuxpro.co.za

mamboBROWN

Posts: 1713

Posted: 08/15/2007, 7:26 PM

clubbing80s
Please let me know if the links provided to you where of any usefulness.

lwismanuel

Posts: 39

Posted: 08/15/2007, 10:03 PM

If you are using CCS 3.2 you might want to take a look at these functions CCEncryptString($String, $Key) and CCDecryptString($String, $Key)

Quote peterr:
The CCEncryptString() function is based on an assumed RC4 algorithm and is similar to the ASP version at http://www.4guysfromrolla.com/webtech/010100-1.shtml
It's quite strong when we use with 128-bit keys, while AFAIK you can use it with longer keys like 512-bit and there are no limits on string size. This function is provided to implement quick two-way encryption (decryptable) without requiring the PHP Mcrypt library (PHP) or being limited by lack of encryption functions (ASP). For certain uses you can also use the MD5 function provided with PHP (one way encryption / hashing), which we often use for encrypting passwords. The Mcrypt library can also be useful.

This comes quite handy for my new project.

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login