donjd86266
2014-07-25 18:28
浏览 57
已采纳

如何使用PHP PDO将未知数量的字段作为行插入

I have a form that looks like this:

<form>
<textarea name="text1"></textarea>
<textarea name="text2"></textarea>
<textarea name="text3"></textarea>
</form>

However, the number of textareas is determined dynamically so there will not always be just 3.

I want to insert the $_POST of each textarea into a different row with PDO. If they were all going in the same row, I would just use this:

$query = $db->prepare("INSERT INTO responses (text1, text2, text3) VALUES (:text1, :text2, :text3)");
$query->bindValue('text1', $_POST['text1'], PDO::PARAM_STR);
$query->bindValue('text2', $_POST['text2'], PDO::PARAM_STR);
$query->bindValue('text3', $_POST['text3'], PDO::PARAM_STR);
$query->execute();

Although the issue of a changing number of textareas is not addressed by that either.. I was considering using count($_POST) and iterating with a for loop?

How can I go about inserting an unknown number of fields into there own row with PDO?

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dongxue163536 2014-07-25 18:31
    已采纳

    Change your HTML to send it as an array:

    <textarea name="text[]"></textarea>
    <textarea name="text[]"></textarea>
    <textarea name="text[]"></textarea>
    

    Then you can just loop over the array $_POST['text']

    You could probably even do:

    $params = array_fill(0, count($_POST['text']), '(?)');
    $db->prepare("INSERT INTO responses (text) VALUES " . implode(", ", $params));
    $query->execute($_POST['text']);
    
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题