How to Crypt entire MySQL DataBase
| From: | Augusto Cesar Castoldi | Date: | Thu, 26 Apr 2001 23:54:02 +0000 |
| Subject: | How to Crypt entire MySQL DataBase | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-50528@lists.php.net to get a copy of this message | ||
I want to crypt all my database.
I have in my scripts, a lot of mysql_querys, where I put and get data from
the database.
How can I insert crypt data in the database and then get the crypted data
from database and decrypt?
But I'd like to do some functions to do that. Because in case that I
change
the tables name I need to change the code just in "one" place.
Something like:
function Select ($columm, $tables, $where, $order) {
$sql="SELECT $columm FROM $tables WHERE $where ORDER BY $order";
$result=mysql_query($sql) or die ("Error 1.");
// now the crypt stuffs...
}
thanks for any help and/or idea,
Augusto Cesar Castoldi
Florianópolis - SC - Brazil