Password Reset Not Working

jayuhazie · December 31, 2012

This was working and now stopped? Any help would be great!!

<?php require_once('../Connections/quantum_hub.php'); ?>

<?php

//Establish output variable - For displaying Error Messages

$msg = "";

//Check to see if the form has been submitted

if (mysql_real_escape_string($_POST['submit'])):

//Establish Post form variables

$username = mysql_real_escape_string($_POST['username']);

$password = mysql_real_escape_string($_POST['password']);

$npassword = mysql_real_escape_string($_POST['npassword']);

$rpassword = mysql_real_escape_string($_POST['rpassword']);

// Connect to the database

mysql_select_db($database_quantum_hub, $quantum_hub) or die(mysql_error());

// Query the database - To find which user we're working with

$sql = "SELECT * FROM users WHERE userLogin = '$username' ";

$query = mysql_query($sql);

$numrows = mysql_num_rows($query);

//Gather database information

while ($rows = mysql_fetch_array($query)):

$dbusername = $rows['userLogin'];

$dbpassword = $rows['userPassword'];

$dbfirstname = $rows ['userFirstName'];

$dblastname = $rows ['userLastName'];

$email = $rows ['userEmail'];

endwhile;

//Validate The Form

if (empty($username) || empty($password) || empty($npassword) || empty($rpassword)):

$msg = "All fields are required";

elseif ($numrows == 0):

$msg = "This username does not exist";

elseif ($password != $dbpassword):

$msg = "The CURRENT password you entered is incorrect.";

elseif ($npassword != $rpassword):

$msg = "Your new passwords do not match";

elseif ($npassword == $password):

$msg = "Your new password cannot match your old password";

else:

//$msg = "Your Password has been changed.";

mysql_query("UPDATE users SET userPassword = '$npassword' WHERE userLogin = '$username'");

$to = $email;

$subject = "YOUR PASSWORD HAS BEEN CHANGED";

$message = "Hello $dbfirstname $dblastname. You've received this E-Mail

because you have requested a PASSWORD CHANGE. If you did not submit a password

change request, and believe this account modification to be fraudulant, please

Quantum IT Support at 717-123-45678";

$from = "[email protected]";

$headers = "From: $from";

//Mails the username and unencrypted password to the user

mail($to,$subject,$message,$headers);

endif;

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Quantum: Hub</title>

</head>

<body>

</div>

<div id="body_container"><div id="breadcrumbs">Extranet : <a href="main-menu.php" class="header_links">Main</a> : <span class="header_red">Change Password</span></div>

<tr>

<td align="right" bgcolor="#A80532" class="form_headers_white">Logon:</td>

</tr>

<tr>

<td align="right" bgcolor="#A80532" class="form_headers_white">Current Password:</td>

</tr>

<tr>

<td align="right" bgcolor="#A80532" class="form_headers_white">New Password:</td>

</tr>

<tr>

<td align="right" bgcolor="#A80532" class="form_headers_white">Confirm New Password:</td>

</tr>

<tr>

<td>

</tr>

</table>

</form>

</div>

</div>

</body>

</html>

Jessica · December 31, 2012

1. Use code tags.

2. Check for SQL errors.

3. Do some debugging on your own and find the actual part that isn't working.

Sign In

Password Reset Not Working

Recommended Posts

jayuhazie

Link to comment

Share on other sites

Jessica

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information