Password recovery script

NameAlreadyInUse · June 22, 2010

Well, I'm at wits end. Thanks in advance for any help. Pulled this script out of nowhere, trying to modify it to provide a simply password recovery function. Having ZERO luck. Seems like I've tried everything. Obviously, I have not yet tried the right thing.

Login/registration scripts work fine, but this one, no...

The [database] connections all seem to work, but my error message is always "Your email address is not correct". The script seems to be talking to my database, but it only returns this error (and yes, my email is correct :-)). :wtf:

My table is tbl_members, the email field in the table is named "username", and the password field is named "pwd".

Thoughts?

<?

include "include/session.php";

include "include/z_db.php";

?>

<!doctype html public "-//w3c//dtd html 3.2//en">

<html>

<head>

<title>Password Check</title>

</head>

<?

$email=mysql_real_escape_string($email);

$status = "OK";

$msg="";

//error_reporting(E_ERROR | E_PARSE | E_CORE_ERROR)

if (!stristr($email,"@") OR !stristr($email,".")) {

$msg="Your email address is not correct ";

$status= "NOTOK";}

echo " ";

if($status=="OK"){ $query="SELECT username, pwd FROM tbl_members WHERE tbl_members.username = '$email'";

$st=mysql_query($query);

$recs=mysql_num_rows($st);

$row=mysql_fetch_object($st);

$em=$row->email;// email is stored to a variable

if ($recs == 0) { echo "<center>No Password Sorry Your address is not there in our database . You can signup and login to use our site. <a href='website_registration.php'> Register </a> </center>"; exit;}

$headers4="andy@space-explorers.org"; ///// Change this address within quotes to your address ///

$headers.="Reply-to: $headers4\n";

$headers .= "From: $headers4\n";

$headers .= "Errors-to: $headers4\n";

//$headers = "Content-Type: text/html; charset=iso-8859-1\n".$headers;// for html mail un-comment this line

if(mail("$em","Your Request for login details","This is in response to your request for login details at site_name \n \nLogin ID: $row->userid \n Password: $row->username \n\n Thank You \n \n siteadmin","$headers")){echo "<center>THANK YOU Your password is posted to your emil address . Please check your mail after some time. </center>";}

else{ echo " <center>There is some system problem in sending login details to your address. Please contact site-admin. <input type='button' value='Retry' onClick='history.go(-1)'></center>";}

}

else {echo "<center>$msg <input type='button' value='Retry' onClick='history.go(-1)'></center>";}

?>

</center>

</body>

</html>

Sign In

Password recovery script

Recommended Posts

NameAlreadyInUse

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information