Problem with entering data into database 2

likelylad · Oct 16, 2002

I was hoping someone could really help me on this one.
I have have been looking at it that long that I can not see the forest from the trees

I am trying to get the following code to work

<html>
<body>

<form method="post" action="

http://server/php/post11.php">

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

If ($submit=="Submit&quot

{
$db = mysql_connect("localhost", "root&quot

;

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 know the problem is with the "IF" statement as when I remove it, data will enter into the database. However with the "IF"statement gone I am getting an empty line every time I open the browser.

andreas57 · Oct 16, 2002

you have to use insert like this:

insert into table (name, last) values ('$first', $last)

you've mixed it up with update andreas owen
aowen@arcade.ch

likelylad · Oct 16, 2002

Sorry my mistake, I pasted the wrong code, the SQL statement is in the correct format; insert into table (name, last) values ('$first', $last) format.

As I said, if I remove the "IF" statement, the data will be passed into the database, but everytime I open up the browser, a blank line is obviously being passed into the database

sleipnir214 · Oct 16, 2002

Does your preferred MySQL management tool show the same thing? ______________________________________________________________________
TANSTAAFL!

likelylad · Oct 16, 2002

Yes the management tool is showing the same thing.

sleipnir214 · Oct 16, 2002

Show me the exact SQL statement you are using to perform the insert ______________________________________________________________________
TANSTAAFL!

GiffordS · Oct 16, 2002

I think I see your problem and it's not in the SQL. Assuming you've copied and pasted your code the problem is very simple. In your IF statement you ask for the value of the submit button as "Submit". Why? If you're processing the form then the user has obviously clicked the submit button. I'm not sure that submit button values are always posted. Do you have two different submit buttons for the same form with different values? If so, there's a much more effective way of handling that than a conditional statement that tries to catch the value of a button.

If you are processing the form on the same page as the form itself, and are using that statement to veryify that the submit button has been clicked, try using

if(isset('$name'))

or some other variable in the form. That way your script only gets processed if the form has been submitted. If you don't have any form elements that are certain to have values place a hidden element with a value in your form. Then you can check for that value with the isset() function rather than looking for a submit button value.

The only way you would be inserting empty rows is if the script is on the same page as the form and it's processing the if() statement before the form is completed, or if you are not properly describing your variables in the SQL. The fact that the if() statement causes the error should be a flashing red light.

hads · Oct 16, 2002

How about trying $_POST["submit"] in your if statement?

What is your register_globals setting? [smurf]

01101000011000010110010001110011

likelylad · Oct 17, 2002

Hi hads and GiffordS

I also posted the same question on the HTML forum and I got the same suggestion as you both had given.

What worked for me was the following
if(isset($_POST["submit"] ))

Thanks for your help

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Problem with entering data into database 2

likelylad

IS-IT--Management

andreas57

Technical User

likelylad

IS-IT--Management

sleipnir214

Programmer

likelylad

IS-IT--Management

sleipnir214

Programmer

GiffordS

Programmer

hads

Technical User

likelylad

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor