蒸汽登录Lightopenid

Question

我用steam为我的登录创建了一个index.php，让用户使用steam登录我的网站，以获得像他们的名字、头像和steam id这样的信息，我有的问题是数据没有发送到我的数据库中，我已经制作了一个包含所有正确细节的db.php文件，只是它没有存储在我的数据库中。

$db = mysql_connect("localhost", "username", "password");
$db = mysql_select_db("mydbname");



echo "
                <br/>SmallAvatar: <img src='$player->avatar'/>
                <br/>Player ID: $player->steamid
                <br/>Player Name: $player->personaname
                <br/>Profile URL: $player->profileurl 
                ";
            $sql_fetch_id = "SELECT * FROM users_steam WHERE steamid = '$player->steamid'";
            $query_id = mysqli_query($db, $sql_fetch_id);

            $_SESSION['name'] = $player->personaname;
            $_SESSION['steamid'] = $player->steamid;
            $_SESSION['avatar'] = $player->avatar;

            if (mysqli_num_rows($query_id) == 0) {
                $sql_steam = "INSERT INTO users_steam (name, steamid, avatar) VALUES  ('$player->personaname', '$player->steamid', '$player->avatar')";
                mysqli_query($db, $sql_steam);
            }

Answer 1

试试这个：

require 'openid.php';

include_once("db.php");

$_STEAMAPI = "";

try {
    $openid = new LightOpenID('www.audiochat.xyz/index.php');
    if(!$openid->mode) {
        if(isset($_GET['login'])) {
            $openid->identity = 'http://steamcommunity.com/openid/?l=english';
            header('Location: ' . $openid->authUrl());
        } else {
            echo "<h2>Connect to Steam</h2>";
            echo "<form action='?login' method='post'>";
            echo "<input type='image' src='http://cdn.steamcommunity.com/public/images/signinthroughsteam/sits_small.png'>";
            echo "</form>";
        }
    } elseif($openid->mode == 'cancel') {
        echo 'User has canceled authentication!';
    } else {
        if($openid->validate()) {
            $id = $openid->identity;
            $ptn = "/^http:\/\/steamcommunity\.com\/openid\/id\/(7[0-9]{15,25}+)$/";
            preg_match($ptn, $id, $matches);

            $url = "http://api.steampowered.com/ISteamUser/GetPlayerSummaries/v0002/?key=$_STEAMAPI&steamids=$matches[1]";
            $json_object= file_get_contents($url);
            $json_decoded = json_decodemysql_select_db($json_object);

        foreach ($json_decoded->response->players as $player)
        {
                $sql_fetch_id = "SELECT * FROM users_steam WHERE steamid = $player->steamid";
                $query_id = mysqli_query($db, $sql_fetch_id);

                if (mysqli_num_rows($query_id) == 0) {
                    $sql_steam = "INSERT INTO users_steam (name, steamid, avatar) VALUES  ('$player->personaname', '$player->steamid', '$player->avatar')";
                    mysqli_query($db, $sql_steam);
                }
            }
        } else {
                        echo "User is not logged in.\n";
        }
    }
} catch(ErrorException $e) {
    echo $e->getMessage();
}