PHP Form Post and Insert into multiple rows

Question

I'm stumped. I've looked this up on multiple answers on Stackoverflow, but just can't get it. Maybe I'm just not seeing something.

I'm making a Family Feud game and using PHP and MySQL databases to store and retrieve information. For the Fast Money Round, I have a database with a Table called "FastMoney1" I'm using an HTML5 form and PHP to post the data in the form to that table, which has two columns: answer and score

I'm running my query through a for loop, but it's not posting anything to the table. I'm wondering what I'm doing wrong.

HTML:

<form method="post" class="form-horizontal">
    <div class="form-group">
        <div class="col-xs-9">
            <input type="text" class="form-control" id="question1answer" name="answer[0]" placeholder="Question 1">
        </div>
        <div class="col-xs-3">
            <input type="number" class="form-control" id="question1score" name="score[0]" placeholder="0">
        </div>
    </div>
    <div class="form-group">
        <div class="col-xs-9">
            <input type="text" class="form-control" id="question1answer" name="answer[1]" placeholder="Question 2">
        </div>
        <div class="col-xs-3">
            <input type="number" class="form-control" id="question1score" name="score[1]" placeholder="0">
        </div>
    </div>
    <div class="col-xs-4 col-xs-offset-4" align="center">
        <input type="submit" class="btn btn-success" name="Submit" />
    </div>
</form>

PHP:

<?php

    if(isset($_POST['submit'])){

        require "config.php";

        for ($i = 0; $i<count($_POST); $i++){
            $answer = $_POST['answer'][$i];
            $score = $_POST['score'][$i];
            $sql = "INSERT INTO `fastMoney1`(`answer`, `score`) VALUES ('$answer','$score')";
            if ($conn->query($sql) === TRUE) {
                echo "";
            } else {
                echo $conn->error;
            }
        }

        $conn->close();
        echo "<meta http-equiv='refresh' content='0'>";

    }

?>

All of this lives on the same PHP page, which is why I do not have an action attached to the form.

The config.php is an include that calls the host, username, password and database and opens the connection

Are you getting any error?

B. Desai
– B. Desai

2017-08-05 06:21:24 +00:00
Commented Aug 5, 2017 at 6:21 — B. Desai
– B. Desai, Commented Aug 5, 2017 at 6:21
No, I am not...

Murphy1976
– Murphy1976

2017-08-05 06:22:00 +00:00
Commented Aug 5, 2017 at 6:22 — Murphy1976
– Murphy1976, Commented Aug 5, 2017 at 6:22

B. Desai · Accepted Answer · 2017-08-05 06:36:43Z

2

Remember that PHP variables as case sensitive you have given name Submit in form while in php you are checking if(isset($_POST['submit'])){ which never become true. change it to

if(isset($_POST['Submit'])){ //<----- S in upper case

EDIT You also need to change your loop to

for ($i = 0; $i<count($_POST['answer']); $i++){

edited Aug 5, 2017 at 6:36

answered Aug 5, 2017 at 6:29

B. Desai

16.4k5 gold badges28 silver badges48 bronze badges

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

1 Comment

Murphy1976 Over a year ago

I actually have a total of 6 pairs of fields, answer and score - but the submit is only posting the first three to the database, not all six.

Anand Bhatnagar · Accepted Answer · 2017-08-05 06:26:05Z

-1

see your sql statement you don't need those ampersand in table name and column names INSERT INTO fastMoney1(answer, score) VALUES ('$answer','$score')

answered Aug 5, 2017 at 6:26

Anand Bhatnagar

35 bronze badges

Comments

andreas karimi · Accepted Answer · 2017-08-05 06:29:34Z

-2

 <input type="submit" class="btn btn-success" name="submit" />

i changed

 name="Submit"

to

 name="submit"

"Submit" to "submit" ----->"S" to "s"

and it works fine

edited Aug 5, 2017 at 6:29

answered Aug 5, 2017 at 6:23

andreas karimi

1907 bronze badges

1 Comment

Murphy1976 Over a year ago

I stated why in the issue. because I have the isset($_POST['submit']) AND the php and html live on the same page

Collectives™ on Stack Overflow

PHP Form Post and Insert into multiple rows

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related