In the digital age, where security and convenience are paramount, implementing a robust password reset mechanism is essential for any web application. This article delves into the intricacies of crafting a forgot password system using PHP and MySQL. 

We’ll discuss setting up PHPMailer for email communication, creating and managing token-based verification, and integrating these components into your user registration system. 

Whether you’re a seasoned developer or new to PHP, this guide will provide valuable insights and practical steps to enhance your application’s security and user experience.

Forgot Password Recovery (Reset) using PHP and MySQL

This extensive guide focuses on constructing a robust mechanism for users to regain access to their accounts in scenarios where their login credentials are forgotten. 

The process involves intricate steps such as setting up scripts for user registration and login, alongside incorporating PHPMailer for efficient email communication. Beginners in this domain are advised to first familiarize themselves with the basics of user registration and login script creation in PHP and MySQL.

Laying the Groundwork for Account Access Restoration

To effectively implement an account access restoration feature, it’s beneficial to commence with an existing user registration framework. While this is not a strict requirement for more experienced developers, it helps streamline the integration process. A key aspect here is to utilize the ‘users’ table from existing registration systems to confirm user identities.

Leveraging PHPMailer for Email Distribution

Email dispatch plays a pivotal role in the account access restoration process. PHPMailer stands out as a highly capable library for handling email dispatch in PHP environments. For those unfamiliar with PHPMailer, a detailed exploration of its features and application will prove beneficial.

Implementing Account Access Restoration Steps

The process to enable users to restore access to their accounts involves multiple stages:

  • Initiating a Temporary Token Table: This includes executing SQL commands to create a database table designed for holding temporary access tokens.
CREATE TABLE `password_reset_temp` (
  `email` varchar(250) NOT NULL,
  `key` varchar(250) NOT NULL,
  `expDate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Configuring Database Connectivity: Establish a MySQL database connection, ensuring proper configuration of access credentials.

$con = mysqli_connect("localhost","root","","register");
    if (mysqli_connect_errno()){
	echo "Failed to connect to MySQL: " . mysqli_connect_error();
	die();
	}

date_default_timezone_set('Asia/Karachi');
$error="";
  • Designing an Index File for Email Dispatch: Craft a PHP script responsible for processing email inputs and triggering emails for account access restoration.
<?php
include('db.php');
if(isset($_POST["email"]) && (!empty($_POST["email"]))){
$email = $_POST["email"];
$email = filter_var($email, FILTER_SANITIZE_EMAIL);
$email = filter_var($email, FILTER_VALIDATE_EMAIL);
if (!$email) {
   $error .="<p>Invalid email address please type a valid email address!</p>";
   }else{
   $sel_query = "SELECT * FROM `users` WHERE email='".$email."'";
   $results = mysqli_query($con,$sel_query);
   $row = mysqli_num_rows($results);
   if ($row==""){
   $error .= "<p>No user is registered with this email address!</p>";
   }
  }
   if($error!=""){
   echo "<div class='error'>".$error."</div>
   <br /><a href='javascript:history.go(-1)'>Go Back</a>";
   }else{
   $expFormat = mktime(
   date("H"), date("i"), date("s"), date("m") ,date("d")+1, date("Y")
   );
   $expDate = date("Y-m-d H:i:s",$expFormat);
   $key = md5(2418*2+$email);
   $addKey = substr(md5(uniqid(rand(),1)),3,10);
   $key = $key . $addKey;
// Insert Temp Table
mysqli_query($con,
"INSERT INTO `password_reset_temp` (`email`, `key`, `expDate`)
VALUES ('".$email."', '".$key."', '".$expDate."');");

$output='<p>Dear user,</p>';
$output.='<p>Please click on the following link to reset your password.</p>';
$output.='<p>-------------------------------------------------------------</p>';
$output.='<p><a href="https://www.allphptricks.com/forgot-password/reset-password.php?
key='.$key.'&email='.$email.'&action=reset" target="_blank">
https://www.allphptricks.com/forgot-password/reset-password.php
?key='.$key.'&email='.$email.'&action=reset</a></p>';		
$output.='<p>-------------------------------------------------------------</p>';
$output.='<p>Please be sure to copy the entire link into your browser.
The link will expire after 1 day for security reason.</p>';
$output.='<p>If you did not request this forgotten password email, no action 
is needed, your password will not be reset. However, you may want to log into 
your account and change your security password as someone may have guessed it.</p>';   	
$output.='<p>Thanks,</p>';
$output.='<p>AllPHPTricks Team</p>';
$body = $output; 
$subject = "Password Recovery - AllPHPTricks.com";

$email_to = $email;
$fromserver = "noreply@yourwebsite.com"; 
require("PHPMailer/PHPMailerAutoload.php");
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = "mail.yourwebsite.com"; // Enter your host here
$mail->SMTPAuth = true;
$mail->Username = "noreply@yourwebsite.com"; // Enter your email here
$mail->Password = "password"; //Enter your password here
$mail->Port = 25;
$mail->IsHTML(true);
$mail->From = "noreply@yourwebsite.com";
$mail->FromName = "AllPHPTricks";
$mail->Sender = $fromserver; // indicates ReturnPath header
$mail->Subject = $subject;
$mail->Body = $body;
$mail->AddAddress($email_to);
if(!$mail->Send()){
echo "Mailer Error: " . $mail->ErrorInfo;
}else{
echo "<div class='error'>
<p>An email has been sent to you with instructions on how to reset your password.</p>
</div><br /><br /><br />";
	}
   }
}else{
?>
<form method="post" action="" name="reset"><br /><br />
<label><strong>Enter Your Email Address:</strong></label><br /><br />
<input type="email" name="email" placeholder="username@email.com" />
<br /><br />
<input type="submit" value="Reset Password"/>
</form>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<?php } ?>
  • Developing an Account Restoration File: Assemble a PHP script that allows users to input and confirm their new login credentials.
<?php
include('db.php');
if (isset($_GET["key"]) && isset($_GET["email"]) && isset($_GET["action"]) 
&& ($_GET["action"]=="reset") && !isset($_POST["action"])){
  $key = $_GET["key"];
  $email = $_GET["email"];
  $curDate = date("Y-m-d H:i:s");
  $query = mysqli_query($con,
  "SELECT * FROM `password_reset_temp` WHERE `key`='".$key."' and `email`='".$email."';"
  );
  $row = mysqli_num_rows($query);
  if ($row==""){
  $error .= '<h2>Invalid Link</h2>
<p>The link is invalid/expired. Either you did not copy the correct link
from the email, or you have already used the key in which case it is 
deactivated.</p>
<p><a href="https://www.allphptricks.com/forgot-password/index.php">
Click here</a> to reset password.</p>';
	}else{
  $row = mysqli_fetch_assoc($query);
  $expDate = $row['expDate'];
  if ($expDate >= $curDate){
  ?>
  <br />
  <form method="post" action="" name="update">
  <input type="hidden" name="action" value="update" />
  <br /><br />
  <label><strong>Enter New Password:</strong></label><br />
  <input type="password" name="pass1" maxlength="15" required />
  <br /><br />
  <label><strong>Re-Enter New Password:</strong></label><br />
  <input type="password" name="pass2" maxlength="15" required/>
  <br /><br />
  <input type="hidden" name="email" value="<?php echo $email;?>"/>
  <input type="submit" value="Reset Password" />
  </form>
<?php
}else{
$error .= "<h2>Link Expired</h2>
<p>The link is expired. You are trying to use the expired link which 
as valid only 24 hours (1 days after request).<br /><br /></p>";
            }
      }
if($error!=""){
  echo "<div class='error'>".$error."</div><br />";
  }			
} // isset email key validate end


if(isset($_POST["email"]) && isset($_POST["action"]) &&
 ($_POST["action"]=="update")){
$error="";
$pass1 = mysqli_real_escape_string($con,$_POST["pass1"]);
$pass2 = mysqli_real_escape_string($con,$_POST["pass2"]);
$email = $_POST["email"];
$curDate = date("Y-m-d H:i:s");
if ($pass1!=$pass2){
$error.= "<p>Password do not match, both password should be same.<br /><br /></p>";
  }
  if($error!=""){
echo "<div class='error'>".$error."</div><br />";
}else{
$pass1 = md5($pass1);
mysqli_query($con,
"UPDATE `users` SET `password`='".$pass1."', `trn_date`='".$curDate."' 
WHERE `email`='".$email."';"
);

mysqli_query($con,"DELETE FROM `password_reset_temp` WHERE `email`='".$email."';");
	
echo '<div class="error"><p>Congratulations! Your password has been updated successfully.</p>
<p><a href="https://www.allphptricks.com/forgot-password/login.php">
Click here</a> to Login.</p></div><br />';
	  }		
}
?>
  • Styling with CSS: Develop a CSS stylesheet to ensure the interface for account access restoration is both visually pleasing and user-friendly.
.error p {
	color:#FF0000;
	font-size:20px;
	font-weight:bold;
	margin:50px;
	}

Comprehensive Process for Account Access Restoration

The step-by-step process includes:

  • Creating a database table for temporary tokens, valid for a limited time;
  • Implementing a form for users to submit their email addresses;
  • Confirming the existence of the submitted email in the database;
  • Generating and dispatching a temporary token via email;
  • Providing a link in the email for users to create new login credentials, valid for a limited duration;
  • Introducing a secondary form for users to finalize their new credentials and updating these in the user database;
  • Eradicating the temporary token from the database upon successful update.

In-Depth Technical Implementation

  • Temporary Token Table: Employ SQL to forge a ‘password_reset_temp’ table with specific fields for email, key, and expiration date;
  • Database Connectivity File: Construct a ‘db.php’ file with your database details, setting the correct timezone for precise data recording;
  • Index File for Email Transmission: Develop an ‘index.php’ file comprising a form for email input, token creation, and email dispatch utilizing PHPMailer.

Considerations and Best Practices

  • Ensure that your PHPMailer settings are correctly configured for reliable email delivery;
  • Replace placeholder URLs in the email script with the actual URL of your project for proper redirection;
  • Handle user input securely to prevent SQL injection and other security vulnerabilities;
  • Make sure the user interface for the password reset process is intuitive and accessible;
  • Regularly update your PHP and MySQL versions to ensure compatibility and security.

Crafting an Account Restoration File

Building an account restoration file is a critical component of this process. Its chief role is to verify the token from the database, ensuring it matches the user’s email and is within its validity period. Upon confirmation, users are guided to establish new login credentials, followed by an update in the user database and removal of the token to avoid repeated use.

In the ‘reset-password.php’ script, incorporate functionalities such as:

  • Token and Email Verification: Initially, check the presence and validity of the token and email in the database;
  • New Credential Entry Form: Present a form for users to enter and reconfirm their new login credentials upon successful token validation;
  • Credential Update Mechanism: Post-form submission, the script should authenticate the new credentials, secure them via encryption, and update them in the user database, while also discarding the associated token.

Ensure the script’s URLs are aligned with your web application’s directory structure.

Designing a User-Friendly CSS Interface

To craft an interface that is both professional and easy to use, develop a ‘style.css’ file and house it in a dedicated CSS folder. The styling should focus on:

  • Error Message Visualization: Employ distinctive colors and fonts to highlight error messages, aiding users in easily identifying and resolving any encountered issues during the account restoration process.

Security Considerations and Best Practices

When implementing a password reset system using PHP and MySQL, it’s crucial to prioritize security and efficiency. Consider the following points:

  • Secure Data Handling: Use prepared statements to prevent SQL injection attacks;
  • Strong Password Requirements: Enforce password complexity requirements to enhance account security;
  • Email Validation: Ensure the email entered by the user is valid and registered in the database;
  • Token Expiry and Uniqueness: Tokens should be unique for each request and have a short expiry period to minimize security risks;
  • Error Handling: Provide clear error messages without revealing sensitive information that could be exploited by attackers.

Enhancing Password Reset Functionality

Beyond the basics, there are ways to enhance the password reset feature for better user experience and security:

  • Multi-factor Authentication (MFA): Integrate MFA as an additional security layer, especially for applications handling sensitive data;
  • Customizable Email Templates: Use customizable email templates for password reset communications to maintain brand consistency and improve user engagement;
  • User Activity Logging: Implement logging mechanisms to track password reset requests and completions for security audits;
  • Responsive Design: Ensure the password reset pages are responsive and accessible on various devices and screen sizes.

Incorporating PHP’s generator functions can be a powerful tool for creating sequences and managing iterative processes efficiently. To explore this further, consider reading about using PHP’s generator functions in various applications.

Conclusion

This article has provided a comprehensive overview of setting up a password reset system using PHP and MySQL, from the initial steps of creating a temporary token table and establishing a database connection to the intricate details of developing a reset password file and designing a user-friendly CSS file. We emphasized the importance of security best practices, such as token validation, secure password handling, and error management. 

Additionally, we explored advanced enhancements like multi-factor authentication and responsive design to further bolster the system’s security and usability. By following these guidelines, developers can implement a robust and secure password reset feature, enhancing the overall security and user experience of their web applications.

Published On
By Jeffrey Morrison

Leave a Reply

Your email address will not be published. Required fields are marked *