PHP8.1.21版本已发布
vue8.1.21版本已发布
jquery8.1.21版本已发布

php prepare error

原创
2016-06-06 20:17:10 1138浏览

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

声明:本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn核实处理。