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
"SEO" URLs
Hey, I'm wondering how to go about creating and using these types of URLs. I'm presuming it's PHP th
Displaying pictures
i have worked my way through storing images in directory and storing the location in mySQL db.Now i
apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?
OOP help
okay so i have a class im making it has everything setup i just need to randomize the 2 variables an
Only add new information from XML to MySQL
What I am doing, is taking a xml file, and adding the values to a database. However, what I want to
MFC GUI Programming
I am working on a project right now that requires me to create a MFC Windows GUI. Basically it need
Need help in Generating Combinations
Need help generating all possible combination of names in an array
Lets say i have the follow
trim function issues
Hi guys, total noob here...
So I've been tinkering around with a html and am using php to em
have trouble in a if condition
The if below is working ok, it check when indexes, name, zipcode and state are empty.
Code: &
How do I know when getBounds Method is ready to be called.
I have an application that changes out stylesheets client side. Once I change stylesheet the browse