Jump to content

Timer Before Going Back To Processing Form On Submit


Recommended Posts

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/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>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> </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> </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> </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> </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> </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> </td>

</tr>

<tr>

<td> </td>

<td> </td>

<td> </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> </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> </td>

</tr>

<tr>

<td> </td>

<td> </td>

<td> </td>

</tr>

<tr>

<td> </td>

<td> </td>

<td> </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> </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> </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> </td>

</tr>

<tr>

<td> </td>

<td><input name="button" type="submit" id="button" value="Submit" /></td>

<td> </td>

</tr>

<tr>

<td><div align="center"> <img src="Asterick.gif" width="10" height="10" alt="" /> Mandatory fields </div></td>

<td> </td>

<td> </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.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>

 

<!-- 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.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.