mysqli_stmt::bind_result(): 绑定变量的数量与 PHP 中准备好的语句中的字段数量不匹配

mysqli_stmt::bind_result(): Number of bind variables doesn't match number of fields in prepared statement in PHP

出现.

这是用于获取用户名和数据库的 PHP 文件:

<?php
    if($_GET['keyword'] && !empty($_GET['keyword']))
    {
        $conn = mysqli_connect('localhost','root','','loginsecure'); //Connection to my database
        $keyword = $_GET['keyword'];
        $search = $_GET['keyword'];
        $keyword="%$keyword%";
        $query = "SELECT * FROM users WHERE username like ? LIMIT 1";
        # When I tried to SELECT *, It gives me the error of: Warning: mysqli_stmt::bind_result(): Number of bind variables doesn't match number of fields in prepared statement in ...fetch.php on line 22
        $statement = $conn->prepare($query);
        $statement->bind_param('s',$keyword);
        $statement->execute();
        $statement->store_result();
        if($statement->num_rows() == 0) // so if we have 0 records acc. to keyword display no records found
        {
            echo '<div id="item">Sorry, but there is no user "'.$search.'" found in our database :(</div>';
            $statement->close();
            $conn->close();

        }
        else {
            $statement->bind_result($name); # There is a error i'm encountering when I try to Select * from the line 8.
            while ($statement->fetch()) //outputs the records
            {
                echo "<div id='item'><a href="../user/username.php?username=$name">$name</a></div>";
                # It supposed to show more information about the user, by using $name['first_name'] or $name['last_name']
            };
            $statement->close();
            $conn->close();
        };
    };
?>

推荐答案

您遇到的问题是 mysqli_stmt::bind_result 将尝试将结果集中的每一列绑定到一个变量.这意味着您需要与列相同数量的变量.如果有两列返回，则需要将它们绑定到两个变量.

SELECT name 

SELECT *