Folks,
I am very new to PHP, and have been working through some tutorials. I have
been able to post data from mySQL, but when I tried to do a form page to
enter data into the database I get the following error:
PHP Warning: Undefined variable: submit in c:\inetpub\wwwroot\testform.php
on line 4 PHP Warning: Undefined variable: PHP_SELF in
c:\inetpub\wwwroot\testform.php on line 14
Here is the code:
<html>
<body>
<?php
if ($submit) {
// process form
$db = mysql_connect("localhost", "root");
mysql_select_db("mydb",$db);
$sql = "INSERT INTO employees (first,last,address,position) VALUES
('$first','$last','$address','$position')";
$result = mysql_query($sql);
echo "Thank you! Information entered.\n";
} else{
// display form
?>
<form method="post" action="<?php echo $PHP_SELF?>">
First name:<input type="Text" name="first"><br>
Last name:<input type="Text" name="last"><br>
Address:<input type="Text" name="address"><br>
Position:<input type="Text" name="position"><br>
<input type="Submit" name="submit" value="Enter information">
</form>
<?php
} // end if ?>
</body>
</html>
Does anyone have any ideas, or where I need to look more to learn what the
problem is here? TIA
Dan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
