isset function not working with form submit and database insert statment

Question

I have 2 pages and there is a form in each page. the first form accepts user input and preview it on the second page (hidden form elements). on the second form the user clicks the submit button and it insert that data into mysql.

The problem, the second page insert data into mysql once I get to that page via the form POST method and I get empty fields in the database and the isset function for the form submit button not working.

First page (form):

<html>
    <body>    
        <form action="review.php" method="post">
            Name: <input type="text" name="name"><br>
            Age: <input type="text" name="age"><br>
            <input type="button" name="submit" value="submit">
        </form>    
    </body>
</html>

I get to the second page for review called review.php with this code:

<?php
if (isset($_POST['submit'])) {
    // Mysql insert statment
    echo "Form has been submitted";
}    
?>

<html>
    <body>    
        <form action="review.php" method="post">
            Name: <input type="hidden" name="name"><p><?php echo $_POST['name']; ?></p><br>
            Age: <input type="hidden" name="age"><p><?php echo $_POST['age']; ?></p><br>
           <input type="submit" name="submit">
        </form>    
    </body>
</html>

Once I click on the review button from the first form, it inserts that into mysql, so the isset function on the review.php is not working.

In first form, you should use name="submit".

Bora
– Bora

2013-09-07 08:56:07 +00:00
Commented Sep 7, 2013 at 8:56 — Bora
– Bora, Commented Sep 7, 2013 at 8:56

haibuihoang · Accepted Answer · 2013-09-07 08:55:15Z

1

Because you miss this line on the first file

<input type="submit" name="submit" value="Review">

answered Sep 7, 2013 at 8:55

haibuihoang

17110 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2751886 Over a year ago

The problem is the isset function is working with the first file submit button and i want it to work with the second file button instead?

haibuihoang Over a year ago

There should be no problem with the second file botton, because you already define that: <input type="submit" name="submit">

Moeed Farooqui · Accepted Answer · 2013-09-07 08:58:06Z

1

if (isset($_POST['submit'])) { //but there isn't any Html attribute with the name submit

It should be like this:

<input type="submit" name="submit"/>

Now you won't get empty values

answered Sep 7, 2013 at 8:58

Moeed Farooqui

3,6281 gold badge20 silver badges23 bronze badges

1 Comment

user2751886 Over a year ago

Hi, the if (isset($_POST['submit'])) is for the second form submit button called 'submit'. I don't want the first form button to do the database insertion

Guru · Accepted Answer · 2013-09-07 08:57:35Z

0

Put the Below code in Your First page

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

answered Sep 7, 2013 at 8:57

Guru

6191 gold badge4 silver badges12 bronze badges

Comments

MD SHAHIDUL ISLAM · Accepted Answer · 2013-09-07 09:09:48Z

0

In first page

Use:

<input type="submit" name='submit' value='Submit'>

Instead of

<input type="review">

answered Sep 7, 2013 at 9:09

MD SHAHIDUL ISLAM

14.5k6 gold badges84 silver badges93 bronze badges

Collectives™ on Stack Overflow

isset function not working with form submit and database insert statment

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related