Password Retrival

[Java_Script_user]

Hello:

I would like to how to retrieve a password from mySQL database using
PHP. I have a databse with user login and password. The login is in
the form of an email. I would like to know how to retreive the
password from the database based on the login.

Any help is appreciated.

Thank you

[Justin Koivisto]

Re: Password Retrival

Java_Script_use r wrote:
[color=blue]
> Hello:
>
> I would like to how to retrieve a password from mySQL database using
> PHP. I have a databse with user login and password. The login is in
> the form of an email. I would like to know how to retreive the
> password from the database based on the login.
>
> Any help is appreciated.
>
> Thank you[/color]

If the password is plain text, it's just a matter of a query:

SELECT password FROM table_name WHERE username = 'here@example.c om';

If the password has been hashed, you'll need to find out what type of
hash it is (how the salt is stored, etc.) and then use a brute force
password cracker like John the Ripper.... Put it this way, it's easier
to reset the password. ;)

--
Justin Koivisto - spam@koivi.com
PHP POSTERS: Please use comp.lang.php for PHP related questions,
alt.php* groups are not recommended.