dpnv33177
2018-03-04 13:48
浏览 36
已采纳

PDO插入BindParam mysql

Is it possible to use an array in the BindParam();? i mean like this:

$stmt = $this->Db->prepare("INSERT INTO test (name,age) VALUES (:name,:age)");
$stmt->BindParam(array(":name"=>"michael",
                       ":age"=>"21"
                 ));
$stmt->execute();

OR Do you have to bind them 1 by 1 like:

$stmt->BindParam(":name","Michael");
$stmt->BindParam(":age","21");
$stmt->execute();
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • down2323 2018-03-04 13:50
    已采纳

    No, you cannot use an array with bindParam. In these cases, it is best to refer to the manual: http://php.net/manual/en/pdostatement.bindparam.php

    However, you can use an array with execute:

    $stmt = $this->Db->prepare("INSERT INTO test (name,age) VALUES (:name,:age)");
    $stmt->execute(array(":name"=>"michael",
                         ":age"=>"21"
                   ));
    
    已采纳该答案
    打赏 评论

相关推荐 更多相似问题