I have a registration form in which all the fields must be entered. If they are not entered a list of the fields not entered should be displayed.
Here is the coding I have without the form validation
<?php require_once('Connections/conJay.php'); ?>
<?php
// *** Redirect if username exists
$MM_flag="MM_insert";
if (isset($_POST[$MM_flag])) {
$MM_dupKeyRedirect="errorPage.html";
$loginUsername = $_POST['txtUserId'];
$LoginRS__query = "SELECT user_id FROM users WHERE user_id='" . $loginUsername
. "'";
mysql_select_db($database_conJay, $conJay);
$LoginRS=mysql_query($LoginRS__query, $conJay) or die(mysql_error());
$loginFoundUser = mysql_num_rows($LoginRS);
//if there is a row in the database, the username was found - can not add the
requested username
if($loginFoundUser){
$MM_qsChar = "?";
//append the username to the redirect page
if (substr_count($MM_dupKeyRedirect,"?") >=1) $MM_qsChar = "&";
$MM_dupKeyRedirect = $MM_dupKeyRedirect . $MM_qsChar
."requsername=".$loginUsername;
header ("Location: $MM_dupKeyRedirect");
exit;
}
}
function GetSQLValueString($theValue, $theType, $theDefinedValue = "",
$theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "formRegister")) {
$insertSQL = sprintf("INSERT INTO users (user_id, f_name, l_name, password,
security_answer, email, Staff_Key) VALUES (%s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['txtUserId'], "text"),
GetSQLValueString($_POST['txtFname'], "text"),
GetSQLValueString($_POST['txtLname'], "text"),
GetSQLValueString($_POST['txtPassword'], "text"),
GetSQLValueString($_POST['txtSecurity'], "text"),
GetSQLValueString($_POST['txtEmail'], "text"),
GetSQLValueString($_POST['txtKeyPhrase'], "text"));
mysql_select_db($database_conJay, $conJay);
$Result1 = mysql_query($insertSQL, $conJay) or die(mysql_error());
$insertGoTo = "registration_ok.html";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?><!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=iso-8859-1" />
<!-- TemplateBeginEditable name="doctitle" -->
<title>RegistrationForm</title>
<!-- TemplateEndEditable -->
<!-- TemplateBeginEditable name="head" --><!-- TemplateEndEditable -->
<style type="text/css">
<!--
.style9 {font-family: "Times New Roman", Times, serif}
.style10 {
font-family: "Times New Roman", Times, serif;
font-size: large;
font-weight: bold;
}
.style12 {font-size: large; font-weight: bold; }
.style14 {font-size: large}
.style15 {
font-size: xx-large;
font-family: "Times New Roman", Times, serif;
font-weight: bold;
}
.style19 {font-size: medium}
body {
background-image: url(images/center/pattern1.jpg);
background-repeat: repeat;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
-->
</style>
</head>
<body>
<form id="formRegister" name="formRegister" method="POST" action="<?php echo
$editFormAction; ?>">
<label>
<blockquote>
<p align="center"><label><span class="style15">Registration
Form</span></label>
<span class="style15"> </span></p>
<p> </p>
<table width="498" height="332" border="1" align="center">
<tr>
<td width="295"><div align="right" class="style12"><span
class="style9">First Name</span></div></td>
<td width="193"><div align="center">
<input name="txtFname" type="text" id="txtFname" />
</div></td>
</tr>
<tr>
<td><div align="right" class="style12"><span class="style9">Last Name
</span></div></td>
<td><div align="center">
<input name="txtLname" type="text" id="txtLname" />
</div></td>
</tr>
<tr>
<td height="26"><div align="right" class="style12"><span
class="style9">Email </span></div></td>
<td><div align="center">
<input name="txtEmail" type="text" id="txtEmail" />
</div></td>
</tr>
<tr>
<td height="32"><span class="style10">
<label> </label>
</span> <span class="style12">
<label> </label>
</span> <span class="style12">
<label></label>
</span> <span class="style14"><strong>
<label></label>
</strong>
<label></label>
</span>
<div align="right" class="style12"><span class="style9">Create a User
ID</span></div>
</td>
<td><div align="center">
<input name="txtUserId" type="text" id="txtUserId" />
</div></td>
</tr>
<tr>
<td><div align="right" class="style12"><span class="style9">Password
</span></div></td>
<td><div align="center">
<input name="txtPassword" type="password" id="txtPassword" />
</div></td>
</tr>
<tr>
<td height="30"><div align="right" class="style12"><span
class="style9">Re-enter Password</span></div></td>
<td><div align="center">
<input name="txtPassword2" type="password" id="txtPassword2" />
</div></td>
</tr>
<tr>
<td height="40"><div align="right" class="style12">
<p class="style9">Mothers maiden name</p>
</div>
<div align="right"><span class="style19">used to retrieve lost
password</span></div></td>
<td><div align="center">
<input name="txtSecurity" type="text" id="txtSecurity" />
</div></td>
</tr>
<tr>
<td height="45">
<div align="center" class="style10">
<div align="right">Staff enter key phrase </div>
</div></td>
<td><label>
<div align="center">
<input name="txtKeyPhrase" type="text" id="txtKeyPhrase" />
</div>
</label></td>
</tr>
<tr>
<td><div align="center"></div></td>
<td><div align="center">
<p>
<input name="btnSubmit" type="submit" id="btnSubmit" value="Submit"
/>
<input name="btnReset" type="reset" id="btnReset" value="Reset" />
</p>
</div></td>
</tr>
</table>
<p> </p>
</blockquote>
</label>
<label>
<p>
<label></label>
</p>
<p>
</label>
<label>
</p>
<blockquote> </blockquote>
</label>
<label>
<blockquote>
<p> </p>
<p> </p>
</blockquote>
<input type="hidden" name="MM_insert" value="formRegister">
</label>
</form>
</body>
</html>