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

Did you know?Explore Trending and Topic pages for more stories like this.
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 Like 42 Dislike
Previous forums Next forums
Other forums

How to assign a textbox value to PHP variable??
Hi ! Can any one help me out as quickly as possible. As I m new to PHP.
Plz tell me how to assign

Code error with Index.php
Error: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/runevid/public_

question about header() security
is is safe to just use the header() function to redirect someone if they are, say, not logged in? or

Custom list order
Hi there,

I have checked this tutorial and it's great till the point where I want to display

Consuming third party Payment Gateway API from Procedure.
Hi All,

First of all i would like to thank all the people of the oracle forum for providi

Having Problem with Date
l have a submit buttom where user have the possibility to add a date to specify when his message s

Uploading Filetypes and placing them in seperate folders.
Hello,

first post , and asking for help im afraid. Very new to PHP, was making good progress

blank page.... nothing is happening.
I'm new to a lot of this but in the last 24hrs have learned a lot.
Installed latest version of my

Internal Server Error issues
This has been bothering me for weeks and I've been trying to solve it without asking for help, but e

small inaccuracies
I have this code to convert fractional base 10 into base 2:

while($num > 0)

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash