LostPassword page:
<?php require_once('../Connections/conn_school.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_rs_lostpwd = "-1";
if (isset($_GET['user_id'])) {
$colname_rs_lostpwd = $_GET['user_id'];
}
mysql_select_db($database_conn_school, $conn_school);
$query_rs_lostpwd = sprintf("SELECT * FROM tbl_users WHERE user_id = %s", GetSQLValueString($colname_rs_lostpwd, "int"));
$rs_lostpwd = mysql_query($query_rs_lostpwd, $conn_school) or die(mysql_error());
$row_rs_lostpwd = mysql_fetch_assoc($rs_lostpwd);
$totalRows_rs_lostpwd = mysql_num_rows($rs_lostpwd);
mysql_select_db($database_conn_school, $conn_school);
$query_rs_lostpwd = "SELECT * FROM tbl_users";
$rs_lostpwd = mysql_query($query_rs_lostpwd, $conn_school) or die(mysql_error());
$row_rs_lostpwd = mysql_fetch_assoc($rs_lostpwd);
?>
<?php require_once("../WA_Universal_Email/mail_PHP.php"); ?>
<?php require_once("../WA_Universal_Email/MailFormatting_PHP.php"); ?>
<?php
if ((isset($_POST["SendPWD"]))) {
//WA Universal Email object="mail"
//Send Loop Once Per Entry
$RecipientEmail = "".((isset($_POST["EmailAddress"]))?$_POST["EmailAddress"]:"") ."";include("../WA_Universal_Email/WAUE_lost_password_1.php");
//Send Mail All Entries
if ("lost_password_sent.php"!="") {
header("Location: lost_password_sent.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>PVJA Home</title>
<style type="text/css">
<!--
body {
background-color: #7D7D7D;
}
PV-Font {
font-family: Verdana, Geneva, sans-serif;
font-size: 16px;
font-weight: bold;
color: #E83A00;
}
#Outer tr td table tr td #CenterBody tr td p {
font-family: "Comic Sans MS", cursive;
font-size: 14px;
color: #C51230;
}
#Outer {
background-color: #FFF;
font-size: 16px;
font-family: Verdana, Geneva, sans-serif;
color: #C51230;
font-weight: bold;
}
-->
</style>
<script type="text/javascript" src="../p7pm/p7popmenu.js"></script>
<style type="text/css" media="screen">
<!--
@import url("../p7pm/p7pmh4.css");
PV-Font {
font-family: Verdana, Geneva, sans-serif;
}
.red {
color: #C51230;
}
.prs2_style { font-weight: bold;
color: #00008c;
font-size: 14px;
}
.style8 { font-size: 12px;
color: #00008C;
font-weight: bold;
}
.prs3_style {font-family: Georgia, "Times New Roman", Times, serif;
font-size: 14px;
font-weight: bold;
color: #000093;
}
-->
</style>
</head>
<body onload="P7_initPM(1,4,1,-20,10)">
<table width="750" align="center" cellpadding="0" id="Outer">
<tr>
<td><table width="750" border="0" cellpadding="0">
<tr>
<td colspan="4"><h1>KY School Site<br />
</h1></td>
<td width="85"> </td>
</tr>
<tr>
<td width="158"> </td>
<td width="158"> </td>
<td width="188"> </td>
<td width="149"> </td>
<td> </td>
</tr>
<tr>
<td colspan="5"><table width="751" border="0" align="center" cellpadding="0">
<tr>
<td width="769"><ul id="p7PMnav">
<li><a href="../aboutus.php">About Us</a></li>
<li><a href="#" class="p7PMtrg">Calendar</a>
<ul>
<li><a href="#">Link 2.1</a></li>
<li><a href="#" class="p7PMtrg">Link 2.2</a>
<ul>
<li><a href="#">Link 2.2.1</a></li>
<li><a href="#">Link 2.2.2</a></li>
<li><a href="#">Link 2.2.3</a></li>
</ul>
</li>
<li><a href="#">Link 2.3</a></li>
</ul>
</li>
<li><a href="#" class="p7PMtrg">News</a>
<ul>
<li><a href="#">Link 3.1</a></li>
<li><a href="#">Link 3.2</a></li>
<li><a href="#">Link 3.3</a></li>
</ul>
</li>
<li><a href="#">Handbook</a></li>
<li><a href="../application.php">Application</a></li>
<li><a href="../contactus.php">Contact Us</a></li>
<!--[if lte IE 6]><style>#p7PMnav a{height:1em;}#p7PMnav li{height:1em;}#p7PMnav ul li{float:left;clear:both;width:100%}</style><![endif]-->
<!--[if IE 6]><style>#p7PMnav ul li{clear:none;}</style><![endif]-->
<!--[if IE 7]><style>#p7PMnav a{zoom:100%;}#p7PMnav ul li{float:left;clear:both;width:100%;}</style><![endif]-->
</ul></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="5"><table width="850" border="1" align="center" cellpadding="0" id="CenterBody">
<tr>
<td width="140"><p class="red"><a href="../index.php">HOME</a></p>
<p>To Login<br />
Click <span class="red"><a href="login.php">HERE</a></span></p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p></td>
<td width="554"><div align="center">
<table width="550" border="0" cellpadding="0">
<tr>
<td><h1 align="center">Lost Password</h1></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><form id="frm_login" name="frm_login" method="POST">
<table width="95%" border="1" align="center" cellpadding="0">
<tr>
<td colspan="2"><div align="center"><span class="prs3_style">If you have forgotten your
password, please enter the email address you used to register
in the text box below. Your user name and password
information
will be
e-mailed to that email address.</span></div></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td width="29%">Email Address</td>
<td width="71%"><input name="EmailAddress" type="text" id="EmailAddress" size="60" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="SendPWD" id="SendPWD" value="Send my login information" /></td>
</tr>
</table>
</form></td>
</tr>
<tr>
<td>
<div align="center"> </div></td>
</tr>
<tr>
<td><div align="center"></div></td>
</tr>
</table>
<h1> </h1>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</div>
<p> </p>
<p> </p>
<p> </p>
<p></p></td>
<td width="140"> </td>
</tr>
</table> <p> </p></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($rs_lostpwd);
?>