php - PDO 绑定(bind)参数不起作用

Question

我有这个代码:

$conn = new mysqli($servername, $username, $password, $dbname);
$jsonvprencode = json_encode($jsonvpr);
$stmt = $conn->prepare("UPDATE `wp_posts` SET  `post_content` = :val WHERE `ID` = $idvpr");
$stmt->bind_param(":val", $jsonvprencode);
$stmt->execute();

当尝试执行它时，它返回 fatal error :在第432行的/var/www/html/crawlnew.php中的非对象上调用成员函数bind_param()

我不明白这里发生了什么-_-

Answer 1

带有PreparedStatements的MySQLi

$stmt = $conn->prepare("UPDATE `wp_posts` SET  `post_content` = ? WHERE `ID` = ?");
$stmt->bind_param("si", $jsonvprencode,$idvpr);

带有准备好的语句的 PDO

$stmt = $conn->prepare("UPDATE `wp_posts` SET  `post_content` = :jsonvprencode WHERE `ID` = :idvpr");

$stmt->bindParam(':jsonvprencode', $jsonvprencode);

$stmt->bindParam(':idvpr', $idvpr);