Forgot Password?

[d99kg]

I am establishing a mail ordering website and I want a Forgot Password link, whereby the user has to enter their user name and their password is sent to them via their e-mail. The username, password and their e-mail address are stored in a MySQL database.

I am fairly new to PHP so any help ideas would be greatly appreciated!

Cheers

[jnuneznyc]

Well assuming that you have the HTML form requesting all of the info required... let's begin!

$sql = 'SELECT email, password FROM users WHERE username=\''. mysql_escape_string( $_POST['$username'] ) .'\''
$result = mysql_query( $sql );
if( mysql_errno() == 0 && mysql_num_rows( $result ) == 1 ){
    $dbRow = mysql_fetch_row( $result );
    mail( $dbRow[0], 'Lost Password', 'Here is your password:'.$dbRow[1],'' );
}else{
    echo 'Error has occurred!';
}

This is very rough with little error checking and ugly output but use it as a basis for your final product.

[Random_Design]

sorry to get off subject but hey jnun, what editor do you use to write php?

[jnuneznyc]

For the code posted above... none but I am using PHPEdit on Windows and BBEdit on my Mac OS X