php prepare error-PHP Tutorial-php.cn

php prepare error

WBOY

Release： 2016-06-06 20:17:10

Original

1411 people have browsed it

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>

Copy after login

回复内容：

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>

Copy after login

用的哪个database呀。