使用PDO插入多行 [英] Insert multiple rows with PDO

问题描述

我在<form>标记中有一个多复选框，如下所示:

I have a multicheckbox in a <form> tag like this:

<input type="checkbox" name="del[]" value="<?php echo $menuItems['id']; ?>">

我要求使用以下代码填写此表单:

I ask this form with this code:

if (isset($_POST['subgruppe'])) {
        $ids = array();

    foreach ($_POST['del'] as $pval) {
        $ids[] = (int) $pval;
    }

    $ids = implode(',', $ids);
    echo "groupids";
    echo $ids;
    echo "userid:";
    echo $_POST['userid'];

这向我显示了这样的结果:

This shows me a result like this:

groupids13,9...userid:5 

我需要一个能给我这样的结果的陈述:

I need a statment that give me a result like this:

INSERT INTO user_groups (usergroup, userid) VALUE (13,5),(9,5)

... 你能给我一个提示，我如何检查呢? 我想我可以提出一个给我的解决方案: (13,5)，(9,5)...变成一个变量.

... Can you give me a hint how i can check this? I think I can handel a solution that give me: (13,5),(9,5)... into a variable.

非常感谢:)

推荐答案

在循环时，只需插入所有INSERTS，就不必构建单个字符串.

You don't have to build a single string for all of your INSERTS simply insert while you are looping.

例如:

$sql = "INSERT INTO user_groups (usergroup, userid) VALUE (:usergroup, :userid)";
$stmt = $pdo->prepare($sql);
foreach ($_POST['del'] as $pval) {
    $stmt->execute(array(':usergroup'=>(int) $pval, 
                         ':userid'=>$_POST['userid']
    ));
}

这篇关于使用PDO插入多行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！