[PHP] ENCRYPT() in MySQL

2002-07-29 Thread Justin French

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

2002-07-29 Thread Analysis Solutions

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

2002-07-29 Thread Justin French

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