ENCRYPT() in MySQL

From: Date: Mon, 29 Jul 2002 12:06:29 +0000
Subject: ENCRYPT() in MySQL
Groups: php.general 
Request: Send a blank email to php-general+get-110150@lists.php.net to get a copy of this message
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

« previous php.general (#110150) next »