Maison >développement back-end >tutoriel php >php prepare error
php mysqli prepare 错误,不知道什么原因
代码如下:
<code> $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');} ?></code>
php mysqli prepare 错误,不知道什么原因
代码如下:
<code> $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');} ?></code>
用的哪个database呀。