Issues: PHP Forms -Clearing
Posted on
16th Feb 2014 07:03 pm by
admin
I've tried looking online before actually asking for help, but I've been looking for about the past 3-5 hours and have found nothing that'll help me.
This is a project for school, and well I have to use Access as a database. I am using PHP for coding, and I'm fairly new to PHP. Now for the problem...
When I type in a Name in my Text Field all is good, I hit submit it works, if I hit reset it resets. My issue happens after I hit submit once the item is added, then if I refresh the page the item is added again, and it happens as many times as I hit refresh. I've tried numerous ways to make my text fields clear. I'm not coming up with anything. I started out having two files a PHP and HTML, I combined them hoping I could figure out a way to fix this, but to no avail.
If you look at my code you'll find that "odbc_exec($conn,$input);" is missing I took it out cause I have no idea where to put it, or what to do with it, or how to clear the fields upon having that executed.
If anyone could help me even the tiniest bit that'd be great
Code: <?php
$conn=odbc_connect('database','','');
if (!$conn)
{exit("Connection Failed: " . $conn);}
$Name = $_POST["Name"];
$Submit = $_POST["Submit"];
$Reset = $_POST["Reset"];
$input="INSERT INTO Registry (FirstName) VALUES('$Name')";
$sql="SELECT * FROM Registry";
$rs=odbc_exec($conn,$sql);
?>
<html>
<body>
<form name="TestForm" method="POST" action="<?php echo $_SERVER['PHP_SELF'] ?>">
Name: <input type="text" name="Name" maxlength=50/>
<p>
<input type="submit" name="Submit" value="Submit">
<input type="reset" name="Reset" value="Reset">
</form>
</body>
</html>
<?php
if (!$rs)
{exit("Error in SQL");}
echo "<table><tr>";
echo "<th>FirstName</th>";
echo "<th>LastName</th></tr>";
//Writes Table Values
while (odbc_fetch_row($rs))
{
$firstname=odbc_result($rs,"FirstName");
$lastname=odbc_result($rs,"LastName");
echo "<tr><td>$firstname</td>";
echo "<td>$lastname</td></tr>";
}
odbc_close($conn);
echo "</table>";
?>
No comments posted yet
Your Answer:
Login to answer
226 
42 
Other forums
Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I
Echo-ing MySQL content and Keep Formatting?
I have data in my MySQL such as:
QuoteBlah blah
Blah blah
etc
but when i ech
help with contest script
I would like to code a contest script to my site but i don't know how. Could someone just give me pu
isset undefined variable
Hi all,
Hope someone can point out the obvious. I've a log in script, if you dont enter a use
Pagination
Hi All,
I think I'm finally getting somewhere with pagination!
I can now submit a quer
Having a problem get the selected item from a drop down menu
I have been looking at this for days now.
I have a drop down menu that get it's values from a
Need help to identify this error please
:confused:Can anyone help me tell what this error message means? Maybe tell me where to look to fix
Calling a Procedure with IN & OUT Parameters
Hello,
I usually call my procedures using the following way
declare variable e
Filtering Tables
Hello Thanks for any help any one can give Im very new to PHP..
I need to pull data for clien
Help With editting and deleting form
Hallo !!
So look at this image :
http://img194.imageshack.us/img194/8272/snapshot5f.pn
