php prepare error

WBOY
WBOYoriginal
2016-06-06 20:17:101432parcourir

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呀。

Déclaration:
Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn