Posted by Gustavo Narea on 11/26/05 19:47

Hi.

Yaswanth Narvaneni wrote:
> Hi!
>
> Is there a function (or a code snippet) in PHP for mysql password() function?
>
> I 'dont' want to use something like select * from table where
> table.passwd=password($passwd);
>
> Is there any other alternate way to do it?

Try this:

<?php
$mypassword="this is my password!!!";

$query=mysql_query("SELECT PASSWORD('$mypassword')");

list($mysql_pass)=mysql_fetch_array($query);

mysql_free_result($query);unset($query);

printf( "My password is &quot;%s&quot; and Its hash value ".
"is &quot;%s&quot; computed by the MySQL PASSWORD() function",
$mypassword, $mysql_pass);

?>

You don't need a MySQL connection.

Happy weekend.

--
Gustavo Narea.
PHP Documentation - Spanish Translation Team.
Valencia, Venezuela.

• Next in forum: Re: [PHP] Re: Wanna Join me for an open source PHP Project?
• Prev in forum: Re: [PHP] Re: Wanna Join me for an open source PHP Project?
• Thread view: Re: SQL Password() function

[Reply to this message]