douaikuai2715 2018-06-13 05:28
浏览 108

警告:mysqli_stmt_close()期望参数1为mysqli_stmt,给定布尔值

Warning: mysqli_stmt_close() expects parameter 1 to be mysqli_stmt, boolean given

I got that error, don't know why, spent 3 hours to check everything and can't find an issue

// Prepare a select statement
$sql = "SELECT countries.name AS country_name, customers.id, customers.name AS customer_name, surname, phone, email, address1, code FROM customers WHERE id = ? JOIN countries ON country_code = code";

if($stmt = mysqli_prepare($link, $sql)){
    // Bind variables to the prepared statement as parameters
    mysqli_stmt_bind_param($stmt, "i", $param_id);

    // Set parameters
    $param_id = trim($_GET["id"]);

    // Attempt to execute the prepared statement
    if(mysqli_stmt_execute($stmt)){
        $result = mysqli_stmt_get_result($stmt);

        if(mysqli_num_rows($result) == 1){
            /* Fetch result row as an associative array. Since the result set
            contains only one row, we don't need to use while loop */
            $row = mysqli_fetch_array($result, MYSQLI_ASSOC);

            // Retrieve individual field value
            $name = $row["customer_name"];
            $address1 = $row["address1"];
            $salary = $row["code"];
        } else{
            // URL doesn't contain valid id parameter. Redirect to error page
            header("location: error.php");
            exit();
        }

    } else{
        echo "Oops! Something went wrong. Please try again later.";
    }
}

// Close statement
var_dump($stmt);
mysqli_stmt_close($stmt);

// Close connection
mysqli_close($link);} 
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 如何用Labview在myRIO上做LCD显示?(语言-开发语言)
    • ¥15 Vue3地图和异步函数使用
    • ¥15 C++ yoloV5改写遇到的问题
    • ¥20 win11修改中文用户名路径
    • ¥15 win2012磁盘空间不足,c盘正常,d盘无法写入
    • ¥15 用土力学知识进行土坡稳定性分析与挡土墙设计
    • ¥70 PlayWright在Java上连接CDP关联本地Chrome启动失败,貌似是Windows端口转发问题
    • ¥15 帮我写一个c++工程
    • ¥30 Eclipse官网打不开,官网首页进不去,显示无法访问此页面,求解决方法
    • ¥15 关于smbclient 库的使用