|||||| "Forgotten your Password?" script

Gary_Kambic

I've been trying to find a PHP script that will perform a "Forgotten you Password?" routine.

I just want my clients to be able to enter their e-mail address and the script would validate it against a list of valid adresses and send out the password to the e-mail address they specified if the address is a valid one.

Is there such a script? Anywhere? I've checked most if not all the depositories.

Thanks much,

Gary

benkillin

it would be very easy to make, just do a query in the db, and if the email matches any of the ones in the table, then send the email with the password retrieved from that row in the table.

batman

$email = $_POST['email'];
$sql = mysql_query("SELECT * FROM table WHERE email='$email'");
$result = mysql_fetch_array($sql);
$email2 = $result['email'];
$pass = $result['password'];

if($email != $email2)
{
//do error here.
}
else
{
$sendto = $email2;
$from = "bla@url.com";
$subject = "Forgotten Password";
$message = "Dear $email,

Your password is $pass.

Regards, 
Webmaster";

$headers = "From: $from\r\n";

mail($sendto, $subject, $message, $headers);
}

Gary_Kambic

Thanks for the info guys. I'm sure the script will work great once I get the table built. Since I haven't built one before, I'm not sure how to go about it. My Web Hosting Service has a MySQL table building section. I assume this is where I build the DB?

Any place I can go on the web to help me through this? When I try to enter the info for the table I receive an error:

Database tnevni - table addresses
Error
SQL-query : [Edit]

CREATE TABLE addresses (email TEXT(30) BINARY not null ) TYPE = MYISAM
MySQL said: You have an error in your SQL syntax near '(30) BINARY not null ) TYPE = MYISAM' at line 1

Thanks for the help,

Gary

batman

I would suggest you get and use phpmyadmin. It is a very good script that will help in all your database needs.

Gary_Kambic

Hey guys,

Thanks for the help. I'be made good progress with the script and with creating the data baewss in MySQL.

I have a question with one of my scripts, listed below. I have a routine that checks to see if the search name entered by the client is actually in the data base. The section with the error is below in between the dashed lines. I can't find the error. Any thoughts? $name is the search name passed from the calling *.htm page. The error occurs at line 92 which is at the very bottom of the script. But I've isolated the problem to the section between the dashed lines.

Thanks, gary

<HR width="100%" color=blue> 
<?php

$user="tnevni";
$password="terraka";
$database="tnevni";
mysql_connect(mysqldb,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
mysql_query($query);

if ($name == "") {
echo "Please Enter Valid AGENT NAME . . . ";
echo "<a href=\"" . $redirectlink . "\">RETURN to MySQL Data Base</a> ";
//echo "<HR width="100%" color=blue>";
mysql_close();
return;
}

$query="SELECT * FROM clients";
$result=mysql_query($query);
$num=mysql_numrows($result);

$status = "no";
$i=0;

while ($i < $num) {
$name_table = mysql_result($result,$i,"agent_name");
if ($name_table == $name) {
$status = "yes";
$i = $num; }
else {

++$i; }

if ($status == "no") {
echo "Agent Name NOT FOUND . . . ";
echo "<a href=\"" . $redirectlink . "\">RETURN to MySQL Data Base</a> ";
//echo "<HR width="100%" color=blue>";
mysql_close();
return; }

echo "Database Output [table | clients] ";
$query = "SELECT * FROM clients WHERE agent_name = '$name'";
$result=mysql_query($query);

$agency_name=mysql_result($result,$i,"agency_name");
$agency_telephone=mysql_result($result,$i,"agency_telephone");
$agency_telephone_800=mysql_result($result,$i,"agency_telephone_800");
$agency_fax=mysql_result($result,$i,"agency_fax");
$agency_address_1=mysql_result($result,$i,"agency_address_1");
$agency_address_2=mysql_result($result,$i,"agency_address_2");
$agency_city=mysql_result($result,$i,"agency_city");
$agency_state=mysql_result($result,$i,"agency_state");
$agency_postal_code=mysql_result($result,$i,"agency_postal_code");
$agency_website_url=mysql_result($result,$i,"agency_website_url");
$agent_name=mysql_result($result,$i,"agent_name");
$agent_direct_line=mysql_result($result,$i,"agent_direct_line");
$agent_mobile_line=mysql_result($result,$i,"agent_mobile_line");
$agent_other_line=mysql_result($result,$i,"agent_other_line");
$agent_email_current=mysql_result($result,$i,"agent_email_current");
$agent_email_new=mysql_result($result,$i,"agent_email_new");
$web_host_name=mysql_result($result,$i,"web_host_name");
$web_host_userid=mysql_result($result,$i,"web_host_userid");
$web_host_password=mysql_result($result,$i,"web_host_password");

echo "Agency Name:  $agency_name ";
echo "Agency Telephone:  $agency_telephone ";
echo "Agency Telephone 800:  $agency_telephone_800 ";
echo "Agency Fax:  $agency_fax ";
echo "Agency Address 1:  $agency_address_1 ";
echo "Agency Address 2:  $agency_address_2 ";
echo "Agency City:  $agency_city ";
echo "Agency State:  $agency_state ";
echo "Agency Postal Code:  $agency_postal_code ";
echo "Agency Web Site:  $agency_website_url ";
echo "Agent Name:  $agent_name ";
echo "Agent Direct Line:  $agent_direct_line ";
echo "Agent Mobile Line:  $agent_mobile_line ";
echo "Agent Other Line:  $agent_other_line ";
echo "Agent E-mail (Current):  $agent_email_current ";
echo "Agent E-mail (New):  $agent_email_new ";
echo "Web Host Name:  $web_host_name ";
echo "Web Host UserID:  $web_host_userid ";
echo "Web Host Password:  $web_host_password ";

mysql_close();

batman

The code inbetween the dashed lines is missing a "}" closing bracket.
Try this:

while ($i < $num) { 
$name_table = mysql_result($result,$i,"agent_name"); 
if ($name_table == $name) { 
$status = "yes"; 
$i = $num; }}
else { 
++$i; }