# Forgot password email only code tweak help

**URL:** https://forum.kirupa.com/t/forgot-password-email-only-code-tweak-help/198782
**Category:** Uncategorized
**Created:** [August 28, 2006, 4:30pm UTC](https://forum.kirupa.com/t/forgot-password-email-only-code-tweak-help/198782 "2006-08-28T16:30:54Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![mikal](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/mikal/32/1503_2.png) [@mikal](https://forum.kirupa.com/u/mikal)
#### Post date: [August 28, 2006, 4:30pm UTC](https://forum.kirupa.com/t/forgot-password-email-only-code-tweak-help/198782/1 "2006-08-28T16:30:54Z")

</div>

I have a working flash and php script combo that works in sending user and password info via requests for forgotton passwords.

I did not build it and my skill is limited. I only want the user to submit thier email and then the script sends user the password to thier email. or send both user and a password as is now…but the only requirment is email.

Currently user has to submit user both user name and email… I only want email reqirment. Can someone look at the code and help me out a bit? FLASH AND PHP CODE BELOW.

## php is:

\<?php  
include(“conn.php”);

$success = 1;

$username = $HTTP\_POST\_VARS[‘username’];  
$email = $HTTP\_POST\_VARS[‘email’];

$sql = “SELECT vchPassWord FROM tUser WHERE vchUserName = '”.$username."’ AND vchEmail = ‘".$email."’";

$rs = mysql\_query($sql, $conn) or die(mysql\_error());  
$row = mysql\_fetch\_assoc($rs);

if(!$row){  
//The user dont exists  
$success = 0;  
$msg = ‘The user doesn´t exists or the username and e-mail don´t match.’;  
echo ‘&success=’.$success.’&msg=’.$msg.’&’;  
} else {  
//The user exists  
$password = $row[“vchPassWord”];

```
$subject = "Your MyCompany.com user information";
$message = "Here is your user information for MyCompany.com:

```

";  
$message .= "Username: “.$username.”  
";  
$message .= "Password: “.$password.”  
";  
$message .= "E-mail: “.$email.”

";  
$message .= "Log on to: [http://www.mycompany](http://www.mycompany)  
";  
$footer = “From: [MyCompany.com](http://MyCompany.com)”;

```
$formsent = mail($email, $subject, $message, $footer);

if($formsent == 1) {
    $msg = "Thank you, your password has been sent to ".$email;
} else {
    $success = 0;
    $msg = "We are sorry, but your password could not be sent to ".$email;
}
echo '&success='.$success.'&msg='.$msg.'&';

```

}

mysql\_close($conn);

## ?\>

## flash is:

Selection.setFocus(inpUserName);  
this.inpUserName.tabIndex = 0;  
this.inpEmail.tabIndex = 1;

this.btnSubmit.onRelease = function(){  
this.\_parent.submit();  
}

this.btnClose.onRelease = function(){  
gRoot.loadContent(“home.swf”, null, false);  
}

function submit(){  
if(this.inpUserName.text != “” && this.inpEmail.text != “”){  
if(gRoot.checkEmail(this.inpEmail.text)){  
this.txtResponse.text = “Sending message…”;  
var tVars = new LoadVars();  
tVars.owner = this;  
tVars.username = this.inpUserName.text;  
tVars.email = this.inpEmail.text;  
tVars.onLoad = function(){  
this.owner.txtResponse.text = this.msg;  
}  
tVars.sendAndLoad(gSystemPath + “forgot\_password.php”, tVars, “POST”);  
} else {  
this.txtResponse.text = “Please enter a valid email address.”;  
}  
} else {  
this.txtResponse.text = “Please fill in all fields and try again.”;  
}  
}

stop();

* * *

Any help would be greatly appreciated.

Thank you

m.