php prepare error
程序员文章站
2022-05-12 16:13:30
...
php mysqli prepare 错误,不知道什么原因
代码如下:
代码如下:
$mysqli = new mysqli($mysql_server_name, $mysql_username, $mysql_password);
if (mysqli_connect_errno()) {
die(sprintf("Connect failed: %s\n", mysqli_connect_error()));
}
$sql = "SELECT name FROM table1 WHERE name=? OR first=?";
if ($stmt = $mysqli->prepare($sql)) {
$stmt->bind_param("ss", 'zzz','zzz');
$stmt->execute();
while ($row = $stmt->fetch()) {
$categories[] = $row;
}
$json=json_encode($categories);
$mysqli->close();
echo $json;
}else{$mysqli->close();die('Prepare error');}
?>
回复内容:
php mysqli prepare 错误,不知道什么原因
代码如下:
$mysqli = new mysqli($mysql_server_name, $mysql_username, $mysql_password);
if (mysqli_connect_errno()) {
die(sprintf("Connect failed: %s\n", mysqli_connect_error()));
}
$sql = "SELECT name FROM table1 WHERE name=? OR first=?";
if ($stmt = $mysqli->prepare($sql)) {
$stmt->bind_param("ss", 'zzz','zzz');
$stmt->execute();
while ($row = $stmt->fetch()) {
$categories[] = $row;
}
$json=json_encode($categories);
$mysqli->close();
echo $json;
}else{$mysqli->close();die('Prepare error');}
?>
用的哪个database呀。