我正在尝试准备好的语句,但下面的代码不起作用.我收到错误:
Fatal error: Call to a member function execute() on a non-object in
/var/www/prepared.php on line 12
$mysqli = new mysqli("localhost", "root", "root", "test");
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: " . $mysqli->connect_error;
}
$stmt = $mysqli->prepare("INSERT INTO users (name, age) VALUES (?,?)");
// insert one row
$stmt->execute(array('one',1));
// insert another row with different values
$stmt->execute(array('two',1));
?>
另外,我是否需要使用mysqli来准备语句?任何人都能指出我从连接到插入到错误处理选择的预准备语句的完整示例吗?