douyong8801 2017-09-08 02:39
浏览 125
已采纳

“警告:mysqli_stmt_bind_param()要求参数1为mysqli_stmt,布尔值在”

I'm getting these warnings from web host which contains my database. I'm trying to get an android app developed in Android studio to send data from a Register user activity to a database. I think I'm having a PHP Script error..

Below is my PHP code for registering user:

<?php
$con = mysqli_connect("localhost", "user", "pass", "db");

if (isset($_POST["name"], $_POST["email"], $_POST["username"], $_POST["password"])) 
{
$name =     $_POST["name"];
$email =    $_POST["email"];
$username = $_POST["username"];
$password = $_POST["password"];
}

$statement = mysqli_prepare($con, "INSERT INTO user (name, username, email, password) VALUES (?, ?, ?, ?)");
mysqli_stmt_bind_param($statement, "siss", $name, $username, $email, $password);
mysqli_stmt_execute($statement);

$response = array();
$response["success"] = true;  

echo json_encode($response);
?>

The Register request URL used in android studio..

Android Logcat result during the error

  • 写回答

1条回答 默认 最新

  • douxiong3234 2017-09-08 02:49
    关注

    You have check for errors:-

    <?php
        //comment these two lines when code started working fine
        error_reporting(E_ALL);
        ini_set('display_errors',1);
    
        $con = mysqli_connect("localhost", "id2833909_split421", "pass123", "id2833909_splitw");
    
        /* check connection */
        if (mysqli_connect_errno()) {
            printf("Connect failed: %s
    ", mysqli_connect_error());
            exit();
        }
    
        if (isset($_POST["name"], $_POST["email"], $_POST["username"], $_POST["password"])) {
            $name =     $_POST["name"];
            $email =    $_POST["email"];
            $username = $_POST["username"];
            $password = $_POST["password"];
            $statement = mysqli_prepare($con, "INSERT INTO `user` (`name`, `username`, `email`, `password`) VALUES (?, ?, ?, ?)");
            mysqli_stmt_bind_param($statement, "ssss", $name, $username, $email, $password); // i need to be s
            $response = array();
            if(mysqli_stmt_execute($statement)){
                $response["message"] = "success";  
            }else{
                $response["message"] = "error";  
            }
            echo json_encode($response);
        }
    ?>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

    报告相同问题?

    悬赏问题

    • ¥30 哈夫曼编码译码器打印树形项目
    • ¥20 求完整顺利登陆QQ邮箱的python代码
    • ¥15 怎么下载MySQL,怎么卸干净原来的MySQL
    • ¥15 网络打印机Ip地址自动获取出现问题
    • ¥15 求局部放电案例库,用于预测局部放电类型
    • ¥100 QT Open62541
    • ¥15 stata合并季度数据和日度数据
    • ¥15 谁能提供rabbitmq,erlang,socat压缩包,记住版本要对应
    • ¥15 Vue3 中使用 `vue-router` 只能跳转到主页面?
    • ¥15 用QT,进行QGIS二次开发,如何在添加栅格图层时,将黑白的矢量图渲染成彩色