Re[2]: [PHP-DB] Encrypting a column (password column)
| From: | Daniel Rezny | Date: | Tue, 19 Dec 2000 08:28:39 +0000 |
| Subject: | Re[2]: [PHP-DB] Encrypting a column (password column) | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5339@lists.php.net to get a copy of this message | ||
Hello Lourdes,
Tuesday, December 19, 2000, 9:17:38 AM, you wrote:
LG> nuitari@darklands.cx escribió:
>> 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\"))");
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
>> For additional commands, e-mail: php-db-help@lists.php.net
>> To contact the list administrators, e-mail: php-list-admin@lists.php.ne
LG> I am interested in that function so that it happens to me the same but not
LG> where is
LG> function " PASSWORD ". Please can you tell me where is this function? It is
LG> possible also to be used in ORACLE? THANKS
Try to use a md5 function of php. It is very useful.
--
Best regards,
Daniel mailto:dr@photo.digitallaut.at