if(isset($_POST['login'])) {



        $username = $_POST['username'];
        $password = sha1($_POST['password']);

        $mysql = connect();
        $stmt = $mysql->prepare("SELECT username,password,fornavn,efternavn,level FROM users WHERE username = '$username' AND password = '$password'") or die(mysql_error());
        $stmt->bind_result($username,$password,$fornavn,$efternavn,$level);
        $stmt->execute();

        if($stmt)
        {
            echo "<pre>";
            print_r($stmt);
            echo "</pre>";
        } else {
            echo "Brugernavn eller password er forkert";
        }

}