Jump to content


Photo

Timer Before Going Back To Processing Form On Submit


  • Please log in to reply
No replies to this topic

#1 Code2Me

Code2Me

    Newbie

  • New Members
  • Pip
  • 1 posts

Posted 18 November 2012 - 08:12 AM

Hi,
My first post. curious and see if there is any help to my question on here.

Summary, I have developed a working form with the help of Dreamweaver CS6.0 12.1. I have a processing form to capture / record user details. On click submit the form goes away and display all details that have been written to the database. This includes the latest. The forms stops then.

Want to achieve this:
1. I want to display the contents of the input on next page instead of showing the entire contents of the database, pause momentarily then go back to the user input form.

Questions: I am aware I need to change the call for the next page.
I am not aware how to code using the input variable and just display it on the next page. Do I just call up the name input variables. For example textfield is one of the variables.

Do I code this like;

<p> <?php echo textfield?> </P>


Source code:

<?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...nsitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Delegate Register</title>
<link href="Registerpage.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryValidationselect.css" rel="stylesheet" type="text/css" />
<script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationselect.js" type="text/javascript"></script>
</head>
<?php
$date = date(“format”, $timestamp);
?>
<body>

<div class="container">
<div class="header"><img src="Cerner At Imperial2.jpg" width="960" height="150" alt="" /><!-- end .header --></div>
<div class="content">
<h3>Register: <?php echo "Date - ".date("d/m/Y - H:ia")?></h3>
<form action="<?php echo $editFormAction; ?>" method="post" name="form">
<table width="780" border="0">
<tr>
<td><div align="right">User ID<img src="Asterick.gif" width="10" height="10" alt="" /></div></td>
<td><span id="sprytextfield1">
<input name="textfield" type="text" id="textfield" tabindex="1" size="18" maxlength="10" />
<span class="textfieldRequiredMsg">A value is required.</span></span></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="right">Title <img src="Asterick.gif" width="10" height="10" alt="" /></div></td>
<td><span id="spryselect1">
<select name="select" id="select" tabindex="2">
<option value="0">Select</option>
<option value="1">Ms</option>
<option value="2">Mrs</option>
<option value="3">Mdm</option>
<option value="4">Dr</option>
<option value="5">Mr</option>
<option value="6">Prof</option>
</select>
<span class="selectInvalidMsg">Please select a valid item.</span></span></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="right">First name <img src="Asterick.gif" width="10" height="10" alt="" /></div></td>
<td><span id="sprytextfield2">
<input name="textfield2" type="text" id="textfield2" tabindex="3" size="30" maxlength="30" />
<span class="textfieldRequiredMsg">A value is required.</span></span></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="right">Surname <img src="Asterick.gif" width="10" height="10" alt="" /></div></td>
<td><span id="sprytextfield3">
<input name="textfield3" type="text" id="textfield3" tabindex="4" size="30" maxlength="30" />
<span class="textfieldRequiredMsg">A value is required.</span></span></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="right">Contact / Bleep <img src="Asterick.gif" width="10" height="10" alt="" /></div></td>
<td><span id="sprytextfield4">
<input name="textfield4" type="text" id="textfield4" tabindex="5" size="30" maxlength="30" />
<span class="textfieldRequiredMsg">A value is required.</span></span></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="right">Mobile no: (optional)</div></td>
<td><input name="textfield5" type="text" id="textfield5" tabindex="6" size="20" maxlength="20" /></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="right">Job Role <img src="Asterick.gif" width="10" height="10" alt="" /></div></td>
<td><span id="spryselect5">
<select name="select5" id="select5" tabindex="7">
<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="9">CNS/NP</option>
<option value="10">Tester</option>
</select>
<span class="selectInvalidMsg">Please select a valid item.</span></span></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="right">Manager's Name <img src="Asterick.gif" width="10" height="10" alt="" /></div></td>
<td><span id="sprytextfield5">
<input name="textfield7" type="text" id="textfield7" tabindex="8" size="30" maxlength="30" />
<span class="textfieldRequiredMsg">A value is required.</span></span></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="right">Course <img src="Asterick.gif" width="10" height="10" alt="" /></div></td>
<td><span id="spryselect2">
<select name="select2" id="select2" tabindex="9">
<option value="0">Select</option>
<option value="1">Demo</option>
<option value="2">Doctors</option>
<option value="9">CNS/NP</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="selectInvalidMsg">Please select a valid item.</span></span></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="right">Location <img src="Asterick.gif" width="10" height="10" alt="" /></div></td>
<td><span id="spryselect3">
<select name="select3" id="select3" tabindex="10">
<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="3">CHX 10 West </option>
<option value="4">HH N207 </option>
<option value="5">HH W12 Conference</option>
<option value="6">SMH Rm a</option>
<option value="7">SMH Rm b</option>
<option value="8">SMH Ming Wing Rm 5</option>
<option value="9">SMH Ming Wing Rm 3</option>
</select>
<span class="selectInvalidMsg">Please select a valid item.</span></span></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="right">CPG <img src="Asterick.gif" width="10" height="10" alt="" /></div></td>
<td><span id="spryselect4">
<select name="select4" id="select4" tabindex="11">
<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="selectInvalidMsg">Please select a valid item.</span></span></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input name="button" type="submit" id="button" value="Submit" /></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="center"> <img src="Asterick.gif" width="10" height="10" alt="" /> Mandatory fields </div></td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form" />
</form>
<!-- end .content --></div>
<div class="footer">
<p align="center">
<a href="http://validator.w3....i=referer"><img
src="http://www.w3.org/Ic.../valid-xhtml10" alt="Valid XHTML 1.0 Transitional" height="31" width="88" /></a>
<p align="center"> Cerner@Imperial ICT Training Team </p>
</p>

<!-- end .footer --></div>
<!-- end .container --></div>
<script type="text/javascript">
var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1", "none", {validateOn:["blur", "change"]});
var spryselect1 = new Spry.Widget.Validationselect("spryselect1", {validateOn:["change", "blur"], invalidValue:"-1", isRequired:false});
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"], invalidValue:"-1", isRequired:false});
var spryselect3 = new Spry.Widget.Validationselect("spryselect3", {validateOn:["change", "blur"], invalidValue:"-1", isRequired:false});
var spryselect4 = new Spry.Widget.Validationselect("spryselect4", {validateOn:["change", "blur"], invalidValue:"-1", isRequired:false});
var sprytextfield4 = new Spry.Widget.ValidationTextField("sprytextfield4", "none", {validateOn:["blur", "change"]});
var spryselect5 = new Spry.Widget.Validationselect("spryselect5", {validateOn:["blur", "change"], isRequired:false, invalidValue:"-1"});
</script>
</body>
</html>
<?php
mysql_free_result($rsAttendance);
?>

Thanks.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com