Re: MsSQL PASSWORD()

My current project runs on Win2k, MsSQL 2k, and PHP 4.0.6 My problem is that i can not enable md5 extension because of "Unable to load dynamic library 'c:\windows\php\extensions/php_mcrypt.dll' - The specified procedure could not be found. in Unknown on line 0" So,... Valentin Petruchek (aki Zliy Pes) *** Cut the beginning *** http://zliypes.com.ua mailto:val@zliypes.com.ua ----- Original Message ----- From: "Michael Sims" <mhsims@midsouth.rr.com> To: <php-general@lists.php.net> Sent: Tuesday, February 12, 2002 2:29 AM Subject: Re: [PHP] MsSQL PASSWORD() > At 06:34 PM 2/11/2002 +0200, val petruchek wrote: > >Hello, list! > > > >I'm looking for analog of Mysql password() func in MsSQL. My goal is not to > >store certain field (i.e. user passwords) as a clear text. > > I don't know the equivalent off the top of my head, but a coworker of mine > has used it before. Let me know if no one gets back to you and I'll ask > him what it is. I do remember that he said it was "unsupported and > undocumented", at least in SQL Server 7. > > Alternatively you can do what I do and use the PHP md5() to hash the > password before you store it, and then md5() any supplied password and > compare it against the stored hash. In other words, you can accomplish the > exact same thing that MySQL does, only you do it in PHP and not MySQL... > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >