[PHP] ENCRYPT() in MySQL
Hi all, Sorry to be slightly OT, but I've prolly answered 1000 OT posts in the last year, and this IS related for all those without mycrypt, so... I'm on a shared server which does not have mcrypt... not good, since i want to temporarily store credit card numbers in an encrypted manner, either in a MySQL database, or in a text file. So I started google'ing for a class or something that someone may have written for two-way encryption WITH A KEY TO UNLOCK. Couldn't find much, then did a search on MySQL.com, and found the ENCRYPT(), DECRYPT(), ENCODE() and DECODE() functions. Am I barking up the wrong tree, or can these be used for storing sensitive information (credit card, etc etc) in a mysql table? The MySQL manual isn't particularly in-depth about it all: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html I AM running in a linux environment (RedHat I think)... Thanks in advance, Justin French -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ENCRYPT() in MySQL
On Mon, Jul 29, 2002 at 10:06:29PM +1000, Justin French wrote: I'm on a shared server which does not have mcrypt... not good, since i want to temporarily store credit card numbers in an encrypted manner, either in a MySQL database, or in a text file. Uh, what are you going to do with the cc data that you need to store it? Couldn't find much, then did a search on MySQL.com, and found the ENCRYPT(), DECRYPT(), ENCODE() and DECODE() functions. Am I barking up the wrong tree, or can these be used for storing sensitive information (credit card, etc etc) in a mysql table? Should work. --Dan -- PHP classes that make web design easier SQL Solution | Layout Solution | Form Solution sqlsolution.info | layoutsolution.info | formsolution.info T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ENCRYPT() in MySQL
on 30/07/02 1:05 AM, Analysis Solutions ([EMAIL PROTECTED]) wrote: On Mon, Jul 29, 2002 at 10:06:29PM +1000, Justin French wrote: I'm on a shared server which does not have mcrypt... not good, since i want to temporarily store credit card numbers in an encrypted manner, either in a MySQL database, or in a text file. Uh, what are you going to do with the cc data that you need to store it? I don't want to send it around in an email. So, when I get an order, I notify the staff via email, they jump online, go to a password protected part of the site, and retrieve the order, complete with decrypted CC#. THEN I can trash the CC# off the server. If there's a smarter way, I'm ALL EARS :) Justin French -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php