Participating Frequently

Question

How do I create a "forgot password" and "forgot username" Form?

Forum|Forum|15 years ago
February 8, 2010
2 replies
6128 views

Good Day,

I am in need of assistance in learning how to create a "forgot password" and "forgot username" form in DW CS4. I have researched Adobe and the Internet and I am coming somewhat empty on tutorials or step-by-step instructions.

I would appreciate any step-by-step instructions, a link to a good online tutorial, or any other related source that can help me get from beginning to end.

Thank you.

Server side applications

This topic has been closed for replies.

Andoyo Andoyo

Participating Frequently

Hope this work for you...

What kind of web programming do you use for? If you use PHP MySQL, you can do it easily.

For example I use a MySQL Table called "admin":

CREATE TABLE IF NOT EXISTS `admin` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`email` varchar(64) NOT NULL,
`username` varchar(64) NOT NULL,
`password` varchar(64) NOT NULL,
`activation` varchar(64) NOT NULL,
`level` int(2) NOT NULL DEFAULT '0',
`date_registered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO `admin` (`id`, `name`, `email`, `username`, `password`, `activation`, `level`, `date_registered`) VALUES
(1, 'Andoyo', 'andoyoandoyo@gmail.com', 'andoyo', 'andoyo', '8e67d638c0d130a4d66b2888ffc8335b', 0, '2011-09-21 10:32:16');

Make two files, they are:

forgot_password.php, contain form and php mail function
error.php, a redirect page if the mail function doesn't work.

And then, use your Dreamweaver to make a recordset, called: rsForgotPassword

Click Insert > Data Objects > Recordset
Name: rsForgotPassword
Connection: adobe_cookbooks
Table: admin
Columns: All
Filter: email, Form variable, =, email. Use form variable to pass the value from the form.
Click OK

Use if function to make the forgot function work perfectly, for example:

If the email is entered correctly, the mail script will run
If the email doesn't exist in the database, the notification will come out
If they open the page directly, they have to type any keyword

Final example:

forgot_password.php

<?php require_once('Connections/adobe_cookbooks.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
}
return $theValue;
}
}
$colname_rsForgotPassword = "-1";
if (isset($_POST['email'])) {
$colname_rsForgotPassword = $_POST['email'];
}
mysql_select_db($database_adobe_cookbooks, $adobe_cookbooks);
$query_rsForgotPassword = sprintf("SELECT * FROM `admin` WHERE email = %s", GetSQLValueString($colname_rsForgotPassword, "text"));
$rsForgotPassword = mysql_query($query_rsForgotPassword, $adobe_cookbooks) or die(mysql_error());
$row_rsForgotPassword = mysql_fetch_assoc($rsForgotPassword);
$totalRows_rsForgotPassword = mysql_num_rows($rsForgotPassword);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<p>Forgot your password:</p>
<?php if (isset($_POST['email']) && ($row_rsForgotPassword['email']=="")) {
$colname_rsForgotPassword = $_POST['email']; ?>
<p>Email doesn't exist in our database</p>
<?php }elseif (isset($_POST['email'])) {
$colname_rsForgotPassword = $_POST['email'];
$username = $row_rsForgotPassword['username'];
$password =$row_rsForgotPassword['password'];
$to = $row_rsForgotPassword['email'];
// Mai function
$subject = "Your username dan password: ".$row_rsForgotPassword['name'];
$body = "<html><body>" .
                    "<h2>Thank you...</h2>" .
                    "<p>This is your username and password:</p>".
                    "<ul><li>Username=".$username."</li>".
                    "<li>Password= ".$password."".
                    "From: Webmaster www.javawebmedia.com";
$headers =           "From: Webmaster www.javawebmedia.com <contact@javawebmedia.com>\r\n" .
                              "MIME-Version: 1.0\r\n" .
                              "Content-type: text/html; charset=UTF-8";
if (!mail($to, $subject, $body, $headers)) {
          $redirect_error= "error.php"; // Redirect if there is an error.
header( "Location: ".$redirect_error ) ;
}
?>
<p>Thank you, your username and password has been sent to your email.</p>
<?php }else{ ?>
<p>Please type any keyword.</p>
<?php } ?>
<form id="form1" name="form1" method="post" action="">
<p>
    <label for="email">Your email:</label>
    <input type="text" name="email" id="email" />
    <input type="submit" name="Submit" id="submit" value="Submit" />
    <input type="reset" name="Reset" id="submit2" value="Reset" />
</p>
<p>The username and password will be sent to your email.</p>
</form>
<p></p>
</body>
</html>
<?php
mysql_free_result($rsForgotPassword);
?>

error.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
Oops, error page.
</body>
</html>

J

Jonathan_Fortis

Inspiring

should the text be viewable with regards to

Forgot your password:

Email doesn't exist in our database

Thank you, your username and password has been sent to your email.

Please type any keyword

or should they have php wrapped around it part

David_Powers

Inspiring

Mofrader wrote:
I am in need of assistance in learning how to create a "forgot password" and "forgot username" form in DW CS4. I have researched Adobe and the Internet and I am coming somewhat empty on tutorials or step-by-step instructions

It's good that you have done some research. Unfortunately, I can't suggest any quick or easy solution.

Basically, what you need is an online form that gathers details that identify the user, looks up the details in your database, and sends an email as a reply. Setting that up is relatively easy if you are familiar with building forms, searching a database, and sending emails. What makes it less straightforward is building in the necessary security to ensure that you don't reveal details to the wrong person. In fact, you shouldn't be storing unencrypted passwords, so it's better to create a system that regenerates a new password.

Since you're asking for step by step instructions, it sounds as though you're new to server-side development. There's a lot to it. Get familiar with the basics first, and then you can start putting things together to create the sort of applications you want.

M

MofraderAuthor

Participating Frequently

Thank you for your post.

You're right. I am relatively new to server-side development; however, I have experience with the following:

Setting up an sql database and tables
Connecting to an sql database in DW, using binding features (recordsets), and server-side behaviors (inserting records, user authentication)
creating forms and inserting server behavior (insert record)
Creating a login and log out page
working with SSL function

When I went online to learn how to create a "forgot password" form, I learned that Adobe had developer assistance extensions for DW to assist with that, but learned they discontinued it and are no longer providing support.

At this time, I already have my login and registration page created and connected to a record (dynamically). I have tested it using Apache and everything seems to work well. The login form is directing me to the assigned page. The registration form is directing me to the assigned page.

Do you feel I am ready to learn how insert the necessary dynamic functions for my users to obtain their password, user name (email address), as well as create an email to send out the user the required information?

Thank you.

David_Powers

Inspiring

If you have experience of building forms and working with recordsets, you should be able to create the system you want. However, I'm not aware of any online tutorials that will step you through the process. "Practical Web 2.0 Applications with PHP" by Quentin Zervaas does have a section that deals with reissuing passwords. Unfortunately, the book deals with building a complex application that uses the Zend Framework and Smarty, so even if you went out and bought it, I doubt whether you would find it very helpful.

Just to give you an idea of the amount of work involved, Quentin Zervaas devotes 9 pages to it. The book is aimed at the advanced level, so he doesn't go through it step by step. However, it's not a particularly complex process. You create a form that checks the user's credentials in some way, such as asking for the registered email address. If the email address is in your database, you generate a new password for the user and send it to the email address.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded