Ok basically what's happening is that I have a database entry page that has a menu break down. The user needs to make a selection then hit submit. that works, but what I need to happen is when the user comes back from the submission page everything needs to be reset. I hope that makes sense.
Here's the code I have for the submission page:
<?php
$FName = $_POST['FName'];
$LName = $_POST['LName'];
$PHON = $_POST['PHON'];
mysql_connect ("localhost", "projectc_testuse", "password") or die ('Error: ' . mysql_error());
mysql_select_db ("projectc_Test");
$query="INSERT INTO TestTable VALUES ('NULL','".$."','".$."','".$."')";
mysql_query($query) or die ('Error updating database');
echo "Dtabase Update With: " .$FName. " ".$LName." ".$PHON ;
?>
<!DOCTYPE html PUBLIC"-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<script type="text/javascript" language="JavaScript" src="flipmenu.js">
/***********************************************
* Flip Menu- by Osem Websystems (Osem Websystems)
* Visit JavaScript Kit at JavaScript Kit- Your comprehensive JavaScript, DHTML, CSS, and Ajax stop for this script and 100s more
***********************************************/
</script>
</head>
<body>
<div id="menu">
<form method="post" action="updatetree.php">
<ul class="flipMenu">
<li>Golf
<ul>
<li>GPS Operation
<ul>
<li style="list-style-image: url(flip_google.gif)">
<input type="checkbox" name="FName" />Code 1</li>
<li><input type="checkbox" name="FName" />Code 2</li>
<li><input type="checkbox" name="FName" />Code 3</li>
<li><input type="checkbox" name="FName" />Code 4</li>
<li><input type="checkbox" name="FName" />Code 5</li>
</ul>
</li>
<li>GPS Installation
<ul>
<li style="list-style-image: url(flip_google.gif)">
<input type="checkbox" name="FName" />Code 1</li>
<li><input type="checkbox" name="FName" />Code 2</li>
<li><input type="checkbox" name="FName" />Code 3</li>
<li><input type="checkbox" name="FName" />Code 4</li>
<li><input type="checkbox" name="FName" />Code 5</li>
</ul>
</li>
<li>GPS Usage
<ul>
<li style="list-style-image: url(flip_google.gif)">
<input type="checkbox" name="FName" />Code 1</li>
<li><input type="checkbox" name="FName" />Code 2</li>
<li><input type="checkbox" name="FName" />Code 3</li>
<li><input type="checkbox" name="FName" />Code 4</li>
<li><input type="checkbox" name="FName" />Code 5</li>
</ul>
</li>
<li>GPS Misc
<ul>
<li style="list-style-image: url(flip_google.gif)">
<input type="checkbox" name="FName" />Code 1</li>
<li><input type="checkbox" name="FName" />Code 2</li>
<li><input type="checkbox" name="FName" />Code 3</li>
<li><input type="checkbox" name="FName" />Code 4</li>
<li><input type="checkbox" name="FName" />Code 5</li>
</ul>
</li>
</ul>
</li>
<li>Rifle Scopes
<ul>
<li>Scope 1
<ul>
<li style="list-style-image: url(flip_google.gif)">
<input type="checkbox" name="FName" />Code 1</li>
<li><input type="checkbox" name="FName" />Code 2</li>
<li><input type="checkbox" name="FName" />Code 3</li>
<li><input type="checkbox" name="FName" />Code 4</li>
<li><input type="checkbox" name="FName" />Code 5</li>
</ul>
</li>
<li>Scope 2
<ul>
<li style="list-style-image: url(flip_google.gif)">
<input type="checkbox" name="FName" />Code 1</li>
<li><input type="checkbox" name="FName" />Code 2</li>
<li><input type="checkbox" name="FName" />Code 3</li>
<li><input type="checkbox" name="FName" />Code 4</li>
<li><input type="checkbox" name="FName" />Code 5</li>
</ul>
</li>
<li>Scope 3
<ul>
<li style="list-style-image: url(flip_google.gif)">
<input type="checkbox" name="FName" />Code 1</li>
<li><input type="checkbox" name="FName" />Code 2</li>
<li><input type="checkbox" name="FName" />Code 3</li>
<li><input type="checkbox" name="FName" />Code 4</li>
<li><input type="checkbox" name="FName" />Code 5</li>
</ul>
</li>
</ul>
</li>
<li>Spotting Scopes
<ul>
<li>Scope 1
<ul>
<li style="list-style-image: url(flip_google.gif)">
<input type="checkbox" name="FName" />Code 1</li>
<li><input type="checkbox" name="FName" />Code 2</li>
<li><input type="checkbox" name="FName" />Code 3</li>
<li><input type="checkbox" name="FName" />Code 4</li>
<li><input type="checkbox" name="FName" />Code 5</li>
</ul>
</li>
<li>Scope 2
<ul>
<li style="list-style-image: url(flip_google.gif)">
<input type="checkbox" name="FName" />Code 1</li>
<li><input type="checkbox" name="FName" />Code 2</li>
<li><input type="checkbox" name="FName" />Code 3</li>
<li><input type="checkbox" name="FName" />Code 4</li>
<li><input type="checkbox" name="FName" />Code 5</li>
</ul>
</li>
<li>Scope 3
<ul>
<li style="list-style-image: url(flip_google.gif)">
<input type="checkbox" name="FName" />Code 1</li>
<li><input type="checkbox" name="FName" />Code 2</li>
<li><input type="checkbox" name="FName" />Code 3</li>
<li><input type="checkbox" name="FName" />Code 4</li>
<li><input type="checkbox" name="FName" />Code 5</li>
</ul>
</li>
</ul>
</li>
<li><a href="javascript:closeAllFlips()">Hide All</a></li>
<li><a href="javascript:openAllFlips()">Show All</a></li>
</ul>
<input type="submit" value="Update Database" />
</form>
</div>
</body>
</html>
And here's the code for the confirm page:
<!DOCTYPE html PUBLIC"-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<script type="text/javascript" language="JavaScript" src="flipmenu.js">
/***********************************************
* Flip Menu- by Osem Websystems (Osem Websystems)
* Visit JavaScript Kit at JavaScript Kit- Your comprehensive JavaScript, DHTML, CSS, and Ajax stop for this script and 100s more
***********************************************/
</script>
</head>
<body>
<div id="menu">
<form method="post" action="tree.html">
<p> Database Updated. Thank you.</p>
<input type="submit" value="Return to Entry Page" />
</form>
</div>
</body>
</html>
Does anyone have any ideas?
Webpage with database entry
Started by Matt0116, Aug 18 2010 10:15 AM
1 reply to this topic
#1
Posted 18 August 2010 - 10:15 AM
|
|
|
#2
Guest_johnny.dacu_*
Posted 26 August 2010 - 08:13 AM
Guest_johnny.dacu_*
If you want to reset form elements after submit, just add for every element a default value, like:
for text inputs : value ="";
for radio: selected = "false" //please recheck if this is the right syntax;
etc.
This way, every time the page is loaded, every field has no value..
for text inputs : value ="";
for radio: selected = "false" //please recheck if this is the right syntax;
etc.
This way, every time the page is loaded, every field has no value..


Sign In
Create Account

Back to top









