Form and Input Sumbit Button Question

KariAnn0

Hi, I am pretty new to PHP and I am having a bit of a problem. I am trying to submit some data and then insert it into a MySQL database. My question really has to do with the way forms work. Right now I have it coded as:

<form action="<?=$PHP_SELF?>" method="POST">
Enter the First Name: <input type="text" name="Fname" /> </br>
Enter the Last Name: <input type="text" name="Lname" /> </br>
Enter the Address Number: <input type="text" name="Address" /> </br>

<input type="submit" name="sumbit" value="ENTER"/>

</form>

<?php

if ($submit == "ENTER")
{
$databaseconnect = @mysql_connect("localhost", "root");

 if (!$databaseconnect) 
 { 
    echo( "<p>Unable to connect to the database server at this time.</p>" ); 
    exit(); 
 } 

 if (! @mysql_select_db("mydb")) 
 { 
    echo( "<p>Unable to locate the mydb database at this time.</p>" ); 
    exit(); 
 } 


 $sql = "INSERT INTO address SET FIRST='$Fname', LAST='$Lname', ADDRESS='$Address' "; 

 if (@mysql_query($sql))     
 {  
    echo("<p>Your Name and Address has been added.</p>"); 	
 }
 else 
 { 
echo("<p>Error adding submitted Name and Address: " . mysql_error() . "</p>"); 
 }

}

</body>
</html>

But it is giving me an error of:

Notice: Undefined variable: submit in c:\inetpub\wwwroot\MyWeb\address.php on line 16

Line 16 is
if ($submit == "ENTER")

Several tutorials show this example, but no of them work.
Any help is appericated. I would just like to know what I am doing wrong.

Thanks

KariAnn0

fizzwizz

a syntax error here perhaps?

ie sumbit and submit !!!

KariAnn0

I just typed it wrong here, but I double checked it and change it to "ok" and it still doesn't work. Any ideas?

Notice: Undefined variable: ok in c:\inetpub\wwwroot\MyWeb\address.php on line 16

this is the same error, and the syntax is right now, right?

KariAnn0

I just typed it wrong here, but I double checked it and change it to "ok" and it still doesn't work. Any ideas?

Notice: Undefined variable: ok in c:\inetpub\wwwroot\MyWeb\address.php on line 16

this is the same error, and the syntax is right now, right?

KariAnn0

fizzwizz

All looks fine to me. Maybe a guru can offer more insight.

Are you sure that you have copied your code exactly?

try this

instead of-- if ($submit == "ENTER")

try-- if ($submit)

see if that has any effect.

KariAnn0

It is still not working, I don't understand why the variable would come back as undefined. Grrr. I tried your suggestion, no effect. I have copied and pasted the code exactly as I have it in the .php file.

<input type="submit" name="ok" value="ENTER"/>

</form>

<?php

if ($ok)
{
$databaseconnect = @mysql_connect("localhost", "root");

 if (!$databaseconnect) 
 { 
    echo( "<p>Unable to connect to the database server at this time.</p>" ); 
    exit(); 
 } 

 if (! @mysql_select_db("mydb")) 
 { 
    echo( "<p>Unable to locate the mydb database at this time.</p>" ); 
    exit(); 
 } 


 $sql = "INSERT INTO address SET FIRST='$Fname', LAST='$Lname', ADDRESS='$Address' "; 

 if (@mysql_query($sql))     
 {  
    echo("<p>Your Name and Address has been added.</p>"); 	
 }
 else 
 { 
echo("<p>Error adding submitted Name and Address: " . mysql_error() . "</p>"); 
 }


 $result = @mysql_query("SELECT FIRST, LAST, ADDRESS FROM address");


 while ($row = mysql_fetch_array($result)) 
 {

   echo("<p>" . $row["FIRST"] . " "
              . $row["LAST"] . "</br> " 
              . $row["ADDRESS"] . "</p>");

 }

}

</body>
</html>

Anymore more ideas or suggestions much appericated.

csousley

The problem is likely your php version. The newer versions of php do not define variables for you anymore, you need to get them. So submit is not defined as it's typed now. You need to call to it like this:

if ($_POST['submit'] == "ENTER")

Now all the other variables from the form will need to be set the same way. Or you can set the variable submit like this:

$submit = $_POST['submit'];
if ($submit == "ENTER")

You could also walk through the array and set every variable. I've seen examples of that in the form, search for '$key' if you want to see how.

Good Luck

fizzwizz

why did you change this line to this
<input type="submit" name="ok" value="ENTER"/>
?

why is name="ok" it should be name="submit"

KariAnn0

tried it with
if ($_POST['submit'] == "ENTER")

but it is still not working, but this is the error I get now:

Undefined index: submit in c:\inetpub\wwwroot\MyWeb\address.php on line 16

any other ideas? Thanks for the help

fizzwizz

Yep ... get linux 🙂

bharath

$submit is not recogonized becauce the register_globals is off,make it on in the php.ini file

bharath

none of the control names pertaining to one page will be available when passed to anothor page if the register_global if off in the php.ini file,so make that on befoe u start coding.

csousley

OK, don't turn register_globals on, it's off for a reason. The problem is you changed the name of your submit button to 'ok' and now the variable 'submit' doesn't exist... again.

Now this should be what you need:

$submit = $_POST['ok'];

csousley

I found this while browsing the forum, have a look. It will explain things better:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10245251