尝试使用MySQLi执行准备好的语句时出现以下错误。
任何帮助确定我做错了什么的事,将不胜感激。
致命错误:在etc中的非对象上调用成员函数prepare()。
我使用以下语句正确连接:
<?php
$DBHost = "localhost";
$DBUser = "xxxxxx";
$DBPass = "xxxxxx";
$DBName = "creati38_chicos";
$dbconn = new mysqli($DBHost, $DBUser, $DBPass, $DBName);
// check connection
if ($dbconn->connect_error) {
//echo $dbconn->connect_error;
die('Sorry, we are having some problems right now. Please check back later.');
}
else{
echo "You have connected Successfully";
}
?>
然后,我使用以下语句:
<?php
if ((isset($_POST["update"])) && ($_POST["update"] == "Update Appliance")) {
$stmt = $mysqli->prepare("UPDATE appliances SET
category = ?,
make = ?,
model = ?,
description = ?,
price = ?
WHERE id = ?");
$stmt->bind_param('ssssdi',
$_POST['category'],
$_POST['make'],
$_POST['model'],
$_POST['description'],
$_POST['price'],
$_POST['id']);
$stmt->execute();
$stmt->close();
}
?>
这不是$mysqli->prepare(
你的情况$dbconn->prepare(
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句