//Får detta meddelande samma som jag fick i skolan fast nu sitter jag hemma,

/*Warning: mysqli_stmt::bind_result() [mysqli-stmt.bind-result]: Number of bind variables doesn't match number of fields in prepared statement in B:\php\login2\LoginHandler.php on line 43*/

public function DoLogIn($uName, $password)
    {
        $ret = false;
        /* create a prepared statement */
        if ($stmt = $this->m_database->PrepareStatement("SELECT * FROM User WHERE UserName = ? AND Password = ?"))
        {
            $stmt->bind_param("ss", $uName, md5("mh22mk" . $password . "mh22mk"));

            /* execute query */
            $stmt->execute();

            $stmt->bind_result($dbUser, $dbUserName, $dbPassword, $comments);



            while ($stmt->fetch())
            {
                $_SESSION['loggedin'] = true;
                $_SESSION['UID'] = $dbUser;
                $_SESSION['uName'] = $dbUserName;
                $ret = true;
            }

            /* close statement */
            $stmt->close();
        }

        return $ret;
    }



Warning: mysqli_stmt::bind_result() [mysqli-stmt.bind-result]: Number of bind variables doesn't match number of fields in prepared statement in B:\php\login2\RegisterModel.php on line 36


public function DoesUserNameExist($uName)
    {

        $ret = false;
        /* create a prepared statement */
        if ($stmt = $this->m_database->PrepareStatement("SELECT * FROM User WHERE UserName = ?"))
        {

            $stmt->bind_param("s", $uName);

            /* execute query */
            $stmt->execute();

            $stmt->bind_result($pk, $name, $age, $comments);
            while ($stmt->fetch()) {
                 $ret = true;
                 break;
            }

            /* close statement */
            $stmt->close();
        }




        return $ret;
    }