Jump to content

Webpage with database entry

- - - - -

This topic has been archived. This means that you cannot reply to this topic.
1 reply to this topic

#1
Matt0116

Matt0116

    Newbie

  • Members
  • Pip
  • 1 posts
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?

#2
Guest_johnny.dacu_*

Guest_johnny.dacu_*
  • Guests
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..