PHP, Mysql, and jQuery implementation code for password retrieval

PHP, Mysql, and jQuery implementation code for password retrieval

Enter your registered email address and retrieve your password: After you enter your email address and click submit, jQuery first verifies that the email address format is correct. If yes, it sends the email address to the backend. php sends Ajax requests, sendmail. php is responsible for verifying whether the mailbox exists and sending emails, and returning corresponding processing results to the front-end page. JQuery code: $ (Function (){ $ ("# Sub_btn"). click (function (){ Var email = $ ("# email"). val (); Var preg =/^ \ w + ([-+.] \ w +) * @ \ w + ([-.] \ w + )*\. \ w + ([-.] \ w +) */; // Match Email If (email = ''|! Preg. test (email )){ $ ("# Chkmsg" cmd.html ("Enter the correct email address! "); } Else { $ ("# Sub_btn"). attr ("disabled", "disabled" ).val('submit..'hangzhou.css ("cursor", "default "); $. Post ("sendmail. php", {mail: email}, function (msg ){ If (msg = "noreg "){ $ ("# Chkmsg" cmd.html ("This email has not been registered! "); $ ("# Sub_btn"). removeAttr ("disabled"). val ('submit your CSS ("cursor", "pointer "); } Else { $ (". Demo" ).html ("" + msg + ""); } }); } }); }) The above jQuery code is convenient and concise to complete front-end interaction operations. if you have a certain jQuery Foundation, the above code is clear and not explained. Of course, do not forget to load the jQuery library file on the page. Sendmail. php needs to verify whether the Email exists in the system user table. if there is, read the user information and wake up the user ID, user name, and password with md5 encryption to generate a special string as the verification code for password retrieval, then construct the URL. In addition, in order to control the timeliness of URL links, the operation time for users to submit password retrieval operations is recorded, and finally the Mail sending class is called to send an email to the user's mailbox. Send mail class smtp. class. php, in the source code package provided in this article. Example: Include_once ("connect. php"); // connect to the database $ 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) {// This email address is not registered yet! Echo 'noreg '; Exit; } Else { $ Row = mysql_fetch_array ($ query ); $ Getpasstime = time (); $ Uid = $ row ['id']; $ Token = md5 ($ uid. $ row ['username']. $ row ['password']); // combined verification code $ Url = "http://bbs.it-home.org/demo/resetpass/reset.php? Email = ". $ email ." & Token = ". $ token; // Construct a URL $ Time = date ('Y-m-d H: I '); $ Result = sendmail ($ time, $ email, $ url ); If ($ result = 1) {// The email is successfully sent. $ Msg = 'The system has sent an email to your mailbox Please log on to your mailbox and reset your password in time! '; // Update the data sending time Mysql_query ("update't _ user 'set' getpasstime '=' $ getpasstime 'where id =' $ uid '"); } Else { $ Msg = $ result; } Echo $ msg; } // Send an email Function sendmail ($ time, $ email, $ url ){ Include_once ("smtp. class. php "); $ Smtpserver = ""; // SMTP server, such as smtp.163.com $ Smtpserverport = 25; // SMTP server port $ Smtpusermail = ""; // user email address of the SMTP server $ Smtpuser = ""; // User account of the SMTP server $ Smtppass = ""; // SMTP server user password $ Smtp = new Smtp ($ smtpserver, $ smtpserverport, true, $ smtpuser, $ smtppass ); // Here, "true" indicates that authentication is used; otherwise, authentication is not used. $ Emailtype = "HTML"; // mail type, text: text; webpage: HTML $ Smtpemailto = $ email; $ Smtpemailfrom = $ smtpusermail; $ Emailsubject = "jbxue.com-retrieve password "; $ Emailbody = "dear". $ email .": You submitted a password retrieval request in ". $ time. Click the link below to reset the password. (The button is valid within 24 hours ). ". $ Url .""; $ Rs = $ smtp-> sendmail ($ smtpemailto, $ smtpemailfrom, $ emailsubject, $ emailbody, $ emailtype ); Return $ rs; } At this time, the mailbox will receive a password retrieval email from jbxue, which contains a URL link, click the link to jbxue.com's reset. php to verify the mailbox. Example: Include_once ("connect. php"); // connect to the database $ 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 = 'this link has expired! '; } Else { // Reset the password... $ Msg = 'set the password again. The password reset form is displayed, This is just a demonstration, skipped. '; } } Else { $ Msg = 'invalid link '; } } Else { $ Msg = 'invalid link! '; } Echo $ msg; Reset. php first accepts the parameter email and token, and then queries whether the email exists in the t_user data table based on the Email. if so, it obtains the information of the user and sendmail. in php, the token combination method is the same as the token value, and then compare it with the token passed in the url. if the current time differs from the time when the email is sent by more than 24 hours, the message "This link has expired!" is displayed! ", Otherwise, the link is valid, and is transferred to the password reset page. Finally, the user sets the new password. Conclusion: through email registration verification and password retrieval in this article, we know the application of email sending in website development and its importance. of course, text message verification is also popular now, this requires the connection of related SMS interfaces. T_user structure of the data table: 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;