Using an HTML form on the same page of the PHP code

flash99

Hi, I have created an HTML form so that users can enter data into the database, I need the form and the PHP code on the same page so I had to use the line in BOLD. With all the methods I used I keep getting an error.

Notice: Undefined variable: submit in c:\apache\htdocs\test\php\employees.php on line 21

<form method="post" action=$SERVER['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>

</form>

<?PHP

If ($submit=="Submit"){
$db = mysql_connect("localhost", "root");

mysql_select_db("mydb",$db);

$sql = "INSERT INTO employees SET first='$POST[first]',last='$POST[last]',address='$POST[address]',position='$POST[address]'";

$result = mysql_query($sql);

echo "Thank you! Information entered.\n";
}

</body>
</html>

I have also used the following lines, but come up with the same error:

if($submit)
if(@$submit)
if ($REQUEST_METHOD=="POST")

Thanks for any help given!!!

Duey

$submit = $_POST['submit'];
hope it helps

flash99

Originally posted by Duey
$submit = $_POST['submit'];
hope it helps

Thanks, But unfortunatly I just tried it and I got this error:
Notice: Undefined index: submit in c:\apache\htdocs\test\php\employee.php on line 21

PondyPrem

You are trying to access a variable that is not yet available.

$submit will be available to the source only AFTER the user posts the form.

It is the same like $address $first $last will be available to the source only after posting the form.

You may want to split the logic into one html and another php file(xy.php) , action="xyz.php".

mahendrakalkura

if your php.ini file has "register_globals = on" you can use it as follows

<html> 
<body> 
<?php

if(!isset($submit)) {

?>

<form method="post" action=$_SERVER_['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="Submit"> 

</form> 

<?PHP 

} else {

$db = mysql_connect("localhost", "root"); 

mysql_select_db("mydb",$db); 

$sql = "INSERT INTO employees SET first='$_POST[first]',last='$_POST[last]',address=
'$_POST[address]',position='$_POST[address]'"; 

$result = mysql_query($sql); 

echo "Thank you! Information entered.\n"; 

} 

?> 

</body> 
</html>

if you still have any probs PM me ok or ask me

flash99

I have tried the following and it seems to work, whether it is right or worng I am not sure:

if ($_POST)

But already there are other problems occur with this, and there must be another way.

PondyPrem

You may want to try the following:

if ( $_REQUEST[submit] == "SubmitButton")

"$_REQUEST" is not specific to POST or GET... that way you need not bother what method you used for submitting the form.

Also the guidelines suggest that register_globals in php.ini should be "Off" for security reasons. And, one has to use the above way to access form variables.

Thanks
Prem