php - 致命错误：未捕获的错误：在 C:\xampp\htdocs\Powerpoint Learner Pro\php\Course_Action.php:27 中调用 bool 上的成员函数 bind_param()

Question

我已经尝试了一切，但没有任何效果，这是我的代码：

    if(mysqli_connect_error()) {
        die('Connect Error('. mysqli_connect_errno(). ')' . mysqli_connect_error());
    } else {
        $SELECT = "SELECT email From register Where email = ? Limit 1";
        $INSERT = "INSERT Into register(FirstName, LastName, Password, Email, gender) values(? , ? , ? , ? , ?)";

        // Prepare Statement
        $stmt = $conn->prepare($SELECT);
        $stmt-> bind_param("s" , $email);
        $stmt-> execute();
        $stmt-> bind_result($Email);
        $stmt-> store_result();
        $rnum = $stmt->num_rows;

        if($rnum == 0) {
            $stmt-> close();

            $stmt = $conn-> prepare($INSERT);
            $stmt-> bind_param("sssss" , $Firstname , $Lastname , $Email , $password , $gender);
            $stmt-> execute();
                echo "New record inserted sucessfully";
            } else {
                echo "Someone already registered using this email";
            }

            $stmt-> close();
            $conn-> close();
        }
    }

有人可以帮助我吗？如果有人对这个 8 天的卡住代码提供纯粹的帮助，那将是一种乐趣。

标签： phpdatabase