Re: Encrypting a column (password column)
| From: | nuitari at darklands dot cx | Date: | Tue, 19 Dec 2000 02:14:47 +0000 |
| Subject: | Re: Encrypting a column (password column) | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5332@lists.php.net to get a copy of this message | ||
Noah Spitzer-Williams wrote:
>
> Hey, i have a user database in which one of the columns of a table is their
> password. however i would like to have this encrypted just so when i look at
> it using somethin like phpmyadmin, their password isnt visible. is there an
> easy way to do this?
Use the PASSWORD function when doing the insert.
eg:
mysql_db_query (db, "INSERT into User VALUES (\"username\",
PASSWORD(\"password\"))");