当输入是带有PHP PDO的数组时，从$ _POST插入行

Question

I have a dynamic form generated by a while loop that looks like this:

<form>
<?php while ($questions = $query->fetch(PDO::FETCH_ASSOC)) { ?>
<textarea name="reponse_text[]"></textarea>
<input type="hidden" name="question_id[]" value="<?php echo $questions['question_id']; ?>">
<?php } ?>
</form>

I am trying to insert each 'response' and 'question_id' into its own row. I believe using a forloop to do this is necessary but can't figure out how to access each POST array value:

$user_checkup_id = $db->lastInsertId();

$query = $db->prepare("INSERT INTO user_responses (user_response_text, question_id, user_checkup_id) 
VALUES (:user_response_text, :question_id, :user_checkup_id)");

foreach ($_POST as $key => $value) {

    $query->bindValue(':user_checkup_id', $user_checkup_id, PDO::PARAM_INT);

    if($key == "response_text") {
        $query->bindValue(':response_text', $value, PDO::PARAM_STR);
    } else if($key == "question_id") {
        $query->bindValue(':question_id', $value, PDO::PARAM_INT);
    }
}

$query->execute();

The value submitting to the database is "Array" for response_text. How do I access the actually text area value for each row?

Answer 1

$_POST['reponse_text'] is an array, access it like one. The match number of token error is because you have an if/else condition on one of the parameter being defined.

foreach ($_POST['reponse_text'] as $i => $value) {

    $query->bindValue(':user_checkup_id', $user_checkup_id, PDO::PARAM_INT);

    $query->bindValue(':response_text', $value, PDO::PARAM_STR);
    $query->bindValue(':question_id', $_POST['question_id'][$i], PDO::PARAM_INT);
    // here you do them at once or the other parameter won't be defined

    $query->execute(); // then you execute, for each different response text
}

be sure to put the execute() in the foreach or it will get executed after the whole thing, effectively only inserting the last response text having been bound to the query.