Form inputs display on the actioned page

Report · Nov 17, 2012

Summary:

I have a working form. I would like to display the contents of the input form into the actioned page.I have the actioned page working too. So after input the page goes to this actioned page and display what has been input, pause awhile and then goes back to the form input page.

Question:

I understand this is 2 issues. Issue 1 is to capture the input variables and display in the actioned page. Do I just referenced the named input fields? Referenced them in the actioned page. Right?

How is it coded in the referenced page?

Where?

Source code - of form

<?php require_once('Connections/dbAttendance.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;

}

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form")) {

$insertSQL = sprintf("INSERT INTO attendlist (Windowsid, title, firstname, surname, extension, mobile, jobrole, course, cpg, mgrname, room) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",

GetSQLValueString($_POST['textfield'], "text"),

GetSQLValueString($_POST['select'], "text"),

GetSQLValueString($_POST['textfield2'], "text"),

GetSQLValueString($_POST['textfield3'], "text"),

GetSQLValueString($_POST['textfield4'], "text"),

GetSQLValueString($_POST['textfield5'], "text"),

GetSQLValueString($_POST['select5'], "text"),

GetSQLValueString($_POST['select2'], "text"),

GetSQLValueString($_POST['select4'], "text"),

GetSQLValueString($_POST['textfield7'], "text"),

GetSQLValueString($_POST['select3'], "text"));

mysql_select_db($database_dbAttendance, $dbAttendance);

$Result1 = mysql_query($insertSQL, $dbAttendance) or die(mysql_error());

$insertGoTo = "Thankyou.php";

if (isset($_SERVER['QUERY_STRING'])) {

$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";

$insertGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $insertGoTo));

}

mysql_select_db($database_dbAttendance, $dbAttendance);

$query_rsAttendance = "SELECT * FROM attendlist";

$rsAttendance = mysql_query($query_rsAttendance, $dbAttendance) or die(mysql_error());

$row_rsAttendance = mysql_fetch_assoc($rsAttendance);

$totalRows_rsAttendance = mysql_num_rows($rsAttendance);

?>

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

<head>

<title>Delegate Register</title>

</head>

<?php

$date = date(“format”, $timestamp);

?>

<body>

<h3>Register: <?php echo "Date - ".date("d/m/Y - H:ia")?></h3>

<form action="<?php echo $editFormAction; ?>" method="post" name="form">

<tr>

<span class="textfieldRequiredMsg">A value is required.</span></span></td>

</tr>

<tr>

<td><div align="right">Title *</div></td>

<option value="0">Select</option>

</select>

<span class="selectRequiredMsg">Please select an item.</span></span></td>

</tr>

<tr>

<td><div align="right">First name*</div></td>

<span class="textfieldRequiredMsg">A value is required.</span></span></td>

</tr>

<tr>

<td><div align="right">Surname *</div></td>

<span class="textfieldRequiredMsg">A value is required.</span></span></td>

</tr>

<tr>

<td><div align="right">Contact / Bleep *</div></td>

<span class="textfieldRequiredMsg">A value is required.</span></span></td>

</tr>

<tr>

<td><div align="right">Mobile no: (optional)</div></td>

</tr>

<tr>

</tr>

<tr>

<option value="0">Select </option>

<option value="1">Doctor</option>

<option value="2">Nurse IP</option>

<option value="3">Nurse OP</option>

<option value="4">Midwife</option>

<option value="5">Booking Clerk</option>

<option value="6">Medical Secretary</option>

<option value="7">OP Receptionist</option>

<option value="10">Tester</option>

</select>

<span class="selectRequiredMsg">Please select an item.</span></span></td>

</tr>

<tr>

<td><div align="right">Manager's Name *</div></td>

<span class="textfieldRequiredMsg">A value is required.</span></span></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td><div align="right">Course *</div></td>

<option value="0">Select</option>

<option value="2">Doctors</option>

<option value="3">Nurse IP</option>

<option value="4">Nurse OP</option>

<option value="5">Midwife</option>

<option value="6">Booking Clerk</option>

<option value="7">Medical Secretary</option>

<option value="8">OP Receptionist</option>

</select>

<span class="selectRequiredMsg">Please select an item.</span></span></td>

</tr>

<tr>

<td><div align="right">Location *</div></td>

<option value="0">Select </option>

<option value="1">CHX 12 Floor Rm 1</option>

<option value="2">CHX 12 Floor Rm 2</option>

<option value="5">HH W12 Conference</option>

</select>

<span class="selectRequiredMsg">Please select an item.</span></span></td>

</tr>

<tr>

<option value="0">Select </option>

<option value="1">CPG 1 - Medicine</option>

<option value="2">CPG 2 - Surgery and Cancer</option>

<option value="3">CPG 3 - Specialist Services </option>

<option value="4">CPG 4 - Circulatory Services and Renal Medicine</option>

<option value="5">CPG 5 - Womens and Children</option>

<option value="6">CPG 6 - Clinical and Investigative Sciences</option>

<option value="7">CPG 7 - Private Patients</option>

<option value="8">Others</option>

</select>

<span class="selectRequiredMsg">Please select an item.</span></span></td>

</tr>

<tr>

</tr>

<tr>

<td><div align="center">*Mandatory fields </div></td>

</tr>

</table>

</form>

</div>

<a href="http://validator.w3.org/check?uri=referer"><img

src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0 Transitional" height="31" width="88" /></a>

<p align="center"> Cerner@Imperial ICT Training Team </p>

</p>

</div>

</div>

var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1", "none", {validateOn:["blur", "change"]});

var spryselect1 = new Spry.Widget.ValidationSelect("spryselect1", {validateOn:["change", "blur"]});

var sprytextfield2 = new Spry.Widget.ValidationTextField("sprytextfield2", "none", {validateOn:["blur", "change"]});

var sprytextfield3 = new Spry.Widget.ValidationTextField("sprytextfield3", "none", {validateOn:["blur", "change"]});

var sprytextfield5 = new Spry.Widget.ValidationTextField("sprytextfield5", "none", {validateOn:["blur", "change"]});

var spryselect2 = new Spry.Widget.ValidationSelect("spryselect2", {validateOn:["change", "blur"]});

var spryselect3 = new Spry.Widget.ValidationSelect("spryselect3", {validateOn:["change", "blur"]});

var spryselect4 = new Spry.Widget.ValidationSelect("spryselect4", {validateOn:["change", "blur"]});

var sprytextfield4 = new Spry.Widget.ValidationTextField("sprytextfield4", "none", {validateOn:["blur", "change"]});

var spryselect5 = new Spry.Widget.ValidationSelect("spryselect5", {validateOn:["blur", "change"]});

</script>

</body>

</html>

<?php

mysql_free_result($rsAttendance);

?>

Source code of actioned page

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

<head>

<title>Acknowledge</title>

</head>

<body>

<h3>We have noted your attendance!</h3>

<tr>

<td>User account</td>

<td>$textfield</td>

</tr>

<tr>

<td>Title</td>

</tr>

<tr>

<td>First Name</td>

</tr>

<tr>

<td>Surname</td>

</tr>

<tr>

<td>Contact/Bleep</td>

</tr>

<tr>

<td>Mobile</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td>Manager's name</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</div>

<p>Footer</p>

</div>

</div>

</body>

</html>

Report · Nov 17, 2012

Hi

Still no takers on this post. Anybody?

Report · Nov 17, 2012

Hi

This one has gone cold!