php - 无效对象或资源 mysqli_stmt 错误

Question

这个问题已经有答案了:

warning :: invalid object or resource mysqli_stmt. What is the meaning and solution(s)? (1 个回答)

已关闭 3 年前。

我试图获取每台机器的 IP 地址并将其插入到我网站上的数据库中，但由于某种原因出现以下错误:

Warning: mysqli_stmt_bind_param(): invalid object or resource mysqli_stmt...

Warning: mysqli_stmt_execute(): invalid object or resource mysqli_stmt...

Warning: mysqli_stmt_store_result(): invalid object or resource mysqli_stmt...

Warning: mysqli_stmt_num_rows(): invalid object or resource mysqli_stmt...

Warning: mysqli_stmt_execute(): invalid object or resource mysqli_stmt in..

警告:mysqli_stmt_execute():无效对象或资源 mysqli_stmt...

这是我的代码:

<?php
$deviceip=$_SERVER['REMOTE_ADDR'];
//check if ip is already in database
if(isset($deviceip)){
    $sql = "SELECT * FROM users WHERE deviceip=?";
    $resstmt = mysqli_stmt_init($db);
    mysqli_stmt_bind_param($resstmt,"s",$deviceip);
    mysqli_stmt_execute($resstmt);
    //did we get a match?
    mysqli_stmt_store_result($resstmt);
    $resultCheck = mysqli_stmt_num_rows($resstmt);
    if($resultCheck ==0){
        $sql = "INSERT INTO deviceips(deviceip) VALUES (?)";
        $resstmt = mysqli_stmt_init($db);
        mysqli_stmt_prepare($resstmt,$sql);
        mysqli_stmt_bind_param($resstmt,"s",$deviceip);;
        mysqli_stmt_execute($resstmt);
    }
}?>

Answer 1

由于您收到如此多的错误，我认为没有与数据库的连接。如果您已发布所有代码，那么您可能错过了建立连接的机会。在查询之前尝试以下几行:


$db = mysqli_connect(SERVER_DNS_OR_IP, DATABASE_USER, USER_PASSWORD, DATABASE_NAME);
如果(mysqli_connect_errno())
{
...做一些错误处理...
}


将大写的数据替换为您自己的数据库数据。