PDA

View Full Version : Reset Password From


Arif
12-25-2011, 09:10 PM
I am a beginner, I created login page. How an email can be sent to the registered email address of a user if he / she forgets the password. I will appreciate your help. Thanks

edbr
12-26-2011, 12:19 AM
in php? simplest way would be to make a form to add email address, and then write a script to conpare adresses with address in database and use an if condition to mail the extracted password to that address. Its not exactly beginners stuff though and beyond the ability of the built in wizard

Arif
12-26-2011, 04:05 AM
Thanks for your reply, I created the form to get the email, if you can just give me the Php script or tell me where I can find. I would be very thankful.

edbr
12-26-2011, 06:02 AM
try hotscripts.com

Arif
01-06-2012, 01:05 AM
I have made the form to capture the email and I have the following PHP script on the other page to generate the email but it seems that I am missing something because I am receiving no error but I receive the first message "Your email address is not correct". Can someone pls help me.


<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($email, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$email = get_magic_quotes_gpc() ? stripslashes( $email) : $email;
}

$email = function_exists("mysql_real_escape_string") ? mysql_real_escape_string( $email) : mysql_escape_string( $email);

switch ($theType) {
case "text":
$email = ( $email != "") ? "'" . $email . "'" : "NULL";
break;
case "long":
case "int":
$email = ( $email != "") ? intval( $email) : "NULL";
break;
case "double":
$email = ( $email != "") ? doubleval( $email) : "NULL";
break;
case "date":
$email = ( $email != "") ? "'" . $email . "'" : "NULL";
break;
case "defined":
$email = ( $email != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $email;
}
}
$email="";
mysql_select_db($database_conniBroker, $conniBroker);
$query_rsPW = "SELECT membership.Email FROM membership WHERE membership.Email = '$email' ";
$rsPW = mysql_query($query_rsPW, $conniBroker) or die(mysql_error());
$row_rsPW = mysql_fetch_assoc($rsPW);
$totalRows_rsPW = mysql_num_rows($rsPW);

$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<BR>";
$status= "NOTOK";}


echo "<br><br>";
if($status=="OK"){ $query_rsPW="SELECT membership.Email FROM membership WHERE membership.Email = '$email'";
$st=mysql_query($query_rsPW);
$recs=mysql_num_rows($st);
$row=mysql_fetch_object($st);
$em=$row->email;// email is stored to a variable
if ($recs == 0) { echo "<center><font face='Verdana' size='2' color=red><b>No Password</b><br> Sorry Your address is not there in our database . You can signup and login to use our site. <BR><BR><a href='Registration.php'> Sign UP </a> </center>"; exit;}

$headers4="info@website.com";
$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 detailst at site_name \n \nLogin ID: $row->userid \n Password: $row->password \n\n Thank You \n \n siteadmin","$headers")){echo "<center><font face='Verdana' size='2' ><b>THANK YOU</b> <br>Your password is posted to your email address . Please check your mail after some time. </center>";}
else{ echo " <center><font face='Verdana' size='2' color=red >There is some system problem in sending login details to your address. Please contact site-admin. <br><br><input type='button' value='Retry' onClick='history.go(-1)'></center></font>";}


}

else {echo "<center><font face='Verdana' size='2' color=red >$msg <br><br><input type='button' value='Retry' onClick='history.go(-1)'></center></font>";}
?>