Code php for make forgot password

Code php for make forgot password and send password to email member.

Make file with name:
1. forgot_password.php
2. send_password_ac.php

Make database with name member:
Syntax
$email_to
=$_POST['email_to']; "SELECT password FROM table_name WHERE email='$email_to'"
Create table "members"
This is our databasetable "Members" gspot password is "checkpass" and his e-mail is "gspot@yahoo.co.id"
 CREATE TABLE `members` (
`
idint(4NOT NULL auto_increment,
`
namevarchar(65NOT NULL default '',
`
lastnamevarchar(65NOT NULL default '',
`
emailvarchar(65NOT NULL default '',
`
passwordvarchar(65NOT NULL default '', PRIMARY KEY (`id`)
ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=;

-- 
-- 
Dumping data for table `test_mysql`
-- 
INSERT INTO `membersVALUES (1'Anderson''pass1''email_1@gmail.com''789789'); INSERT INTO `membersVALUES (2'Billy''pass2''email_2@gmail.com''654123ddf'); INSERT INTO `membersVALUES (3'Andy''pass3''email_4@gmail.com''951412dwe');
* replace email_1, 2 , 3 with your email for testing..

forgot_password.php
Make form with text field, name that text file and point with "email_to" action at "send_password_ac.php"
<table width="380" border="0" cellpadding="3" cellspacing="1" >
<tr>
<td width="33%"><strong>Enter your email : </strong></td>
<td width="67%"><form name="form1" method="post" action="send_password_ac.php">
<input name="email_to" type="text" id="mail_to" size="25">
<input type="submit" name="Submit" value="Submit">
</form>
</td>
</tr>
</table>
 send_password_ac.php

<?

$host="localhost"// Host name
$username=""// Mysql username
$password=""// Mysql password
$db_name=""// Database name


//Connect to server and select databse.
mysql_connect("$host""$username""$password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

// value sent from form
$email_to=$_POST['email_to'];

// table name
$tbl_name=members;

// retrieve password from table where e-mail = $email_to(mark@phpeasystep.com)
$sql="SELECT password FROM $tbl_name WHERE email='$email_to'";
$result=mysql_query($sql);

// if found this e-mail address, row must be 1 row
// keep value in variable name "$count"
$count=mysql_num_rows($result);

// compare if $count =1 row
if($count==1){

$rows=mysql_fetch_array($result);

// keep password in $your_password
$your_password=$rows['password'];

// ---------------- SEND MAIL FORM ----------------

// send e-mail to ...
$to=$email_to;

// Your subject
$subject="Your password here";

// From
$header="from: your name <your email>";

// Your message
$messages"Your password for login to our website \r\n";
$messages.="Your password is $your_password \r\n";
$messages.="more message... \r\n";

// send email
$sentmail mail($to,$subject,$messages,$header);

}

// else if $count not equal 1
else {
echo "Not found your email in our database";
}

// if your email succesfully sent
if($sentmail){
echo "Your Password Has Been Sent To Your Email Address.";
}
else {
echo "Cannot send password to your e-mail address";
}

?>

This script just for learn you can make it better...