当前位置:Gxlcms > PHP教程 > phpprepareerror

phpprepareerror

时间:2021-07-01 10:21:17 帮助过:17人阅读

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

人气教程排行