Encrypt and Decrypt data in PHP

Question

Hi I want to know how to encrypt and decrypt data in MySql in PHP ? Please tell me anyone with an example ? Thanks

Senthilkumar · Answer

Hi Vineet For example of encrypt and decrypt the urls: function encrypt($sData $sKey='mysecretkey'){ $sResult = ''; for($i=0;$i $sChar = substr($sData $i 1); $sKeyChar = substr($sKey ($i % strlen($sKey)) - 1 1); $sChar = chr(ord($sChar) + ord($sKeyChar)); $sResult .= $sChar; } return encode_base64($sResult); } function decrypt($sData $sKey='mysecretkey'){ $sResult = ''; $sData = decode_base64($sData); for($i=0;$i $sChar = substr($sData $i 1); $sKeyChar = substr($sKey ($i % strlen($sKey)) - 1 1); $sChar = chr(ord($sChar) - ord($sKeyChar)); $sResult .= $sChar; } return $sResult; } function encode_base64($sData){ $sBase64 = base64_encode($sData); return strtr($sBase64 '+/' '-_'); } function decode_base64($sData){ $sBase64 = strtr($sData '-_' '+/'); return base64_decode($sBase64); } similarly there are lot of examples http://www.99points.info/2010/06/php-encrypt-decrypt-functions-to-encrypt-url-data/ http://www.codingforums.com/showthread.php?t=187938

Satyapriya Nayak · Answer

Hi Vineet Please refer the below links http://www.website-security-tools.com/index.php/Secure-Persisted-Data-With-PHP/encrypt-and-decrypt-data-stored-in-a-mysql-database-using-php-and-two-way-encryption.html http://techpad.co.uk/content.php?sid=82 Thanks