douluan5738
2018-04-08 17:31 阅读 54
已采纳

在for / foreach循环中绑定pdo变量

I have looked at some other Stack Overflow questions on this, but I can't figure out how to loop through sql statements and bind variables to that. Here is how my queries look right now:

$db = dbCon();
$sql = "";
foreach($data as $d) {
    $sql .= "INSERT INTO required_fields (field_name) VALUES ($d)";
}
$stmt = $db->prepare($sql);
// Here is where I need to bind the variables
$stmt->execute();
$rowsChanged = $stmt->rowCount();
$stmt->closeCursor();
return $rowsChanged;

I can't figure out how to loop through because this is how I understand bindValue works:

$stmt->bindValue(':variableInQuery', $PHPVariable, PDO::PARAM_STR);

What's tripping me up is the colon in front of the variableInQuery and I can't figure out how to make the php variable name unique...what am I missing?

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

1条回答 默认 最新

  • 已采纳
    dsms21398 dsms21398 2018-04-08 17:38

    You need to move the code inside the loop:

    <?php
    $db = dbCon();
    $sql = "INSERT INTO required_fields (field_name) VALUES (:variableInQuery)";
    $stmt = $db->prepare($sql);
    $rowsChanged = 0;
    foreach($data as $d) {
        $stmt->bindValue(':variableInQuery', $d, PDO::PARAM_STR);
        $stmt->execute();
        $rowsChanged += $stmt->rowCount();
    }
    $stmt->closeCursor();
    return $rowsChanged;
    
    点赞 评论 复制链接分享

相关推荐