This article mainly introduces the password retrieval function of PHP Mysql jQuery. Interested friends can refer to it. I hope it will be helpful to everyone.

The commonly-known password retrieval function cannot really retrieve forgotten passwords, because our passwords are encrypted and stored. Generally, developers will generate a new password through a program after verifying the user information or Generate a specific link and send an email to the user's mailbox, and the user will reset a new password from the email link to the reset password module of the website.

Of course, some websites now also use mobile phone text messages to retrieve passwords. The principle is to verify your identity by sending a verification code. Just like sending an email for verification, you still have to reset your password to complete the password retrieval. process.

The general steps are:

1. Enter the email address during registration in the form;
2. Verify that the user's email address is correct. If the user's email address does not exist in the user table of the website, the user will be prompted. The mailbox is not registered;
3. Send an email. If the user's mailbox does exist in the user table, combine the string used to verify the user information, and construct a URL and send it to the user's mailbox;
4. The user logs in to the mailbox to collect Email, click the URL link to the website verification program;
5. The website program queries the local user table through the string requested by the user, and compares whether the user information is correct;
6. If correct, go to the reset password page and try again Set a new password, otherwise it will prompt the user that the verification is invalid.

HTML

We place a page on the password retrieval page that requires the user to enter the email address used for registration, and then submit the front-end js to handle the interaction.

 <p><strong>輸入您注冊的電子郵箱，找回密碼：</strong></p> 
<p><input type="text" class="input" name="email" id="email"><span id="chkmsg"></span></p> 
<p><input type="button" class="btn" id="sub_btn" value="提 交"></p>

jQuery

After the user enters the email address and clicks submit, jQuery first verifies whether the email format is correct. If correct, it sends an Ajax request to the background sendmail.php. , sendmail.php is responsible for verifying whether the mailbox exists and sending emails, and will return the corresponding processing results to the front page. Please see the jQuery code:

 $(function(){ 
  $("#sub_btn").click(function(){ 
    var email = $("#email").val(); 
    var preg = /^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*/; //匹配Email 
    if(email=='' || !preg.test(email)){ 
      $("#chkmsg").html("請?zhí)顚懻_的郵箱！"); 
    }else{ 
      $("#sub_btn").attr("disabled","disabled").val('提交中..').css("cursor","default"); 
      $.post("sendmail.php",{mail:email},function(msg){ 
        if(msg=="noreg"){ 
          $("#chkmsg").html("該郵箱尚未注冊！"); 
          $("#sub_btn").removeAttr("disabled").val('提 交').css("cursor","pointer"); 
        }else{ 
          $(".demo").html("<h3>"+msg+"</h3>"); 
        } 
      }); 
    } 
  }); 
})

The jQuery code used above is very convenient and concise to complete the front-end interactive operation. , if you have a certain jQuery foundation, the above code is clear at a glance and requires no explanation.
Of course, don’t forget to load the jQuery library file in the page. Some students often ask me why they can’t use the demo downloaded from jb51.net. 80% of the time it’s because the loading path of jquery or other files is wrong and the necessary files are not loaded. document.

PHP

sendmail.php needs to verify whether the email exists in the system user table. If so, read the user information and wake up the user id, username and password to md5 Encryption generates a special string as a verification code to retrieve the password, and then constructs the URL. At the same time, in order to control the timeliness of the URL link, we will record the operation time when the user submits the password retrieval action, and finally call the email sending class to send the email to the user's mailbox. The sending email class smtp.class.php has been packaged, please download it.

 include_once("connect.php");//連接數(shù)據(jù)庫 
 
$email = stripslashes(trim($_POST['mail'])); 
   
$sql = "select id,username,password from `t_user` where `email`='$email'"; 
$query = mysql_query($sql); 
$num = mysql_num_rows($query); 
if($num==0){//該郵箱尚未注冊！ 
  echo 'noreg'; 
  exit;   
}else{ 
  $row = mysql_fetch_array($query); 
  $getpasstime = time(); 
  $uid = $row['id']; 
  $token = md5($uid.$row['username'].$row['password']);//組合驗(yàn)證碼 
  $url = "http://www.jb51.net/demo/resetpass/reset.php?email=".$email." 
&token=".$token;//構(gòu)造URL 
  $time = date('Y-m-d H:i'); 
  $result = sendmail($time,$email,$url); 
  if($result==1){//郵件發(fā)送成功 
    $msg = &#39;系統(tǒng)已向您的郵箱發(fā)送了一封郵件<br/>請登錄到您的郵箱及時重置您的密碼！&#39;; 
    //更新數(shù)據(jù)發(fā)送時間 
    mysql_query("update `t_user` set `getpasstime`=&#39;$getpasstime&#39; where id=&#39;$uid &#39;"); 
  }else{ 
    $msg = $result; 
  } 
  echo $msg; 
} 
 
//發(fā)送郵件 
function sendmail($time,$email,$url){ 
  include_once("smtp.class.php"); 
  $smtpserver = ""; //SMTP服務(wù)器，如smtp.163.com 
  $smtpserverport = 25; //SMTP服務(wù)器端口 
  $smtpusermail = ""; //SMTP服務(wù)器的用戶郵箱 
  $smtpuser = ""; //SMTP服務(wù)器的用戶帳號 
  $smtppass = ""; //SMTP服務(wù)器的用戶密碼 
  $smtp = new Smtp($smtpserver, $smtpserverport, true, $smtpuser, $smtppass); 
  //這里面的一個true是表示使用身份驗(yàn)證,否則不使用身份驗(yàn)證. 
  $emailtype = "HTML"; //信件類型，文本:text；網(wǎng)頁：HTML 
  $smtpemailto = $email; 
  $smtpemailfrom = $smtpusermail; 
  $emailsubject = "jb51.net - 找回密碼"; 
  $emailbody = "親愛的".$email."：<br/>您在".$time."提交了找回密碼請求。請點(diǎn)擊下面的鏈接重置密碼 
（按鈕24小時內(nèi)有效）。<br/><a href=&#39;".$url."&#39;target=&#39;_blank&#39;>".$url."</a>"; 
  $rs = $smtp->sendmail($smtpemailto, $smtpemailfrom, $emailsubject, $emailbody, $emailtype); 
 
  return $rs; 
}

Okay, at this time your mailbox will receive a password retrieval email from helloweba. There is a URL link in the email content. Click the link to reset.php of jb51.net for verification. Mail.

 include_once("connect.php");//連接數(shù)據(jù)庫 
 
$token = stripslashes(trim($_GET['token'])); 
$email = stripslashes(trim($_GET['email'])); 
$sql = "select * from `t_user` where email='$email'"; 
 
$query = mysql_query($sql); 
$row = mysql_fetch_array($query); 
if($row){ 
  $mt = md5($row['id'].$row['username'].$row['password']); 
  if($mt==$token){ 
    if(time()-$row['getpasstime']>24*60*60){ 
      $msg = '該鏈接已過期！'; 
    }else{ 
      //重置密碼... 
      $msg = &#39;請重新設(shè)置密碼，顯示重置密碼表單，<br/>這里只是演示，略過。&#39;; 
    } 
  }else{ 
    $msg = &#39;無效的鏈接&#39;; 
  } 
}else{ 
  $msg = &#39;錯誤的鏈接！&#39;;   
} 
echo $msg;

reset.php first accepts the parameters email and token, and then queries whether the email exists in the data table t_user based on the email. If it exists, obtain the user's information, and the token combination method is the same as sendmail.php Construct the token value and then compare it with the token passed by the URL. If the difference between the current time and the time when the email is sent is more than 24 hours, it will prompt "The link has expired!". Otherwise, it means that the link is valid and it will be redirected to the reset page. Set password page, and finally the user sets a new password by himself.

Summary: Through registered email verification and password retrieval through this article’s email, we know the application of sending emails in website development and its importance. Of course, SMS verification applications are also popular now, which require related SMS interfaces. Just connect.
Finally, attach the data table t_user structure:

 CREATE TABLE `t_user` ( 
 `id` int(11) NOT NULL auto_increment, 
 `username` varchar(30) NOT NULL, 
 `password` varchar(32) NOT NULL, 
 `email` varchar(50) NOT NULL, 
 `getpasstime` int(10) NOT NULL, 
 PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Summary: The above is the entire content of this article, I hope it will be helpful to everyone's learning.

Related recommendations:

PHP jQuery MySql implementation of red and blue voting examples

The basics of Yii framework in PHP Usage

Basic knowledge and application of php design patterns

The above is the detailed content of PHP+Mysql+jQuery realizes password retrieval function. For more information, please follow other related articles on the PHP Chinese website!