The Script - PHP

In the last article, we discussed in detail the user creation script. We looked at what information the script gets from the form and how it "cleans" and verifies form values, and then looked at how the user is informed about his or her log-in credentials. In this article, the conclusion to our four-part series, we'll finish the discussion.

TABLE OF CONTENTS:

By: David Web

Poor Best

Rating:

/ 1

August 18, 2008

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

Script: password.php

<?php

session_start();

include "dbcon.php";

include "functions.php";

//initialise variables

$err="";

$errmsg=false;

//is form submitted?

if(isset($_POST['submit'])){

//check that the form values are not empty, if so, set errormsg value

if(empty($_POST['uname'])){

$errmsg="The username field is empty, please enter a username";

$err=true;

}

if(empty($_POST['email'])){

$err=true;

$errmsg .="The email address field is empty, please enter a email address";

}

//check that the username is in correct format

if(!$err){

if(!checkformat($_POST['uname'])){

$err=true;

$errmsg .="The username that you entered has a incorrect format.";

}

//check that the email is in correct format

if(!$err){

if(!checkmailformat($_POST['email'])){

$err=true;

$errmsg .="The email address that you entered has a incorrect format.";

}

//check to see if the user exist

if(!$err){

$cleanuname = mysql_escape_string($_POST['uname']);

$cleanemail = mysql_escape_string($_POST['email']);

$unamecheck = "SELECT email,name,sname FROM users WHERE username='".$cleanuname."' and email = '".$cleanemail."'";

$result=mysql_query($unamecheck);

$num=mysql_num_rows($result);

if($num > 0){

$row = mysql_fetch_assoc($result);

$thepass = $row['upass'];

$theName = $row['name'];

//build email headers

//this text will appear in the subject line of the email

$subject = "Project Management - Password Recovery";

//this is the recipient of the email

$to = $cleanemail;

//sender name

$from_name = "Project Management Application";

//sender address

$from_email = "website@mywebsite.com";

$headers = "From: " . $from_name . " <" . $from_email . ">";

//build message

$msg = "<html>

<head>

<title>Project Management</title>

</head>

<body>

<tr>

<td><p>Dear <b>".$theName."</b></p>

Below is the password you requested:<br />

<br />

<b>Password:</b> ".$thepass.";

</td>

</tr>

</table>";

$msg .= "</body>

</html>";

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

}else{

$err=true;

$errmsg .="The information you entered is incorrect or does not exists. ";

}

}//end submit

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

<head>

<title>Untitled Document</title>

</head>

<body>

<tr>

<td bgcolor="#6699CC" class="headertxt">Project Management:: User Authentication </td>

</tr>

<tr>

<tr>

<td colspan="2" class="loginheader">Password Recovery </td>

</tr>

<?php if(isset($errmsg)){?>

<tr>

</tr>

<tr>

</tr>

<tr>

<?php

}

<tr>

<td>Username:</td>

</label></td>

</tr>

<tr>

<td>Email Address: </td>

</label></td>

</tr>

<tr>

</label></td>

</tr>

</table>

</form>

</td>

</tr>

<tr>

</tr>

</table>

</body>

</html>

Let's look at the PHP code in detail. After including the database connection files, and initializing some variables, the code runs the usual checks on the form values.

session_start();

include "dbcon.php";

include "functions.php";

//initialise variables

$err="";

$errmsg=false;

//is form submitted?

if(isset($_POST['submit'])){

//check that the form values are not empty, if so, set errormsg value

if(empty($_POST['uname'])){

$errmsg="The username field is empty, please enter a username";

$err=true;