无法在数据库中保存facebook登录用户的详细信息

Unable to save facebook login user details in database

本文关键字：登录 用户 详细信息 facebook 保存 数据库      更新时间：2023-09-26

登录facebook后，我正试图将用户详细信息保存在数据库中。我使用的是javascript SDK。我已经通过"onlogin"进行了回调。我认为问题出在我的javascript代码上。请参阅下面的代码。

请帮忙！！

HTML:

<html>
<head>
<title>Facebook Login JavaScript Example</title>
<meta charset="UTF-8">
<script type="text/javascript">
$(document).ready(function(){
    function std() {
        FB.api('/me', function(response) {
            var details = JSON.stringify(response);
            var name = details.first_name + details.last_name;
            var email = details.email;
            var gender = details.gender;
        });
        $.ajax({
            type: "POST",
            url: "std.php",
            data: "&name="+name+ "&email=" +email+ "&gender=" +gender,
            success: function(){
                alert("Success");
            }
        });
    }
});
</script>
</head>
<body>
<div id="fb-root"></div>
<div id="fb-root"></div>
<script>
(function(d, s, id) {
    var js, fjs = d.getElementsByTagName(s)[0];
    if (d.getElementById(id)) return;
    js = d.createElement(s);
    js.id = id;
    js.src = "//connect.facebook.net/en_GB/sdk.js#xfbml=1&version=v2.5&appId=AppID";
    fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));
</script>
<div class="fb-login-button" data-max-rows="3" data-size="large" data-show-faces="false" data-auto-logout-link="true" scope="public_profile,email" onlogin="std();">
</div>
</body>
</html>

PHP:

$servername = "localhost";
$username = "username";
$password = "password";
$connection = mysql_connect($servername, $username, $password);
if (!$connection){
    die('Could not connect: ' . mysql_error());
}
mysql_select_db("database", $connection);
$name = $_POST['name'];
$name = mysql_real_escape_string($name);
$email = $_POST['email'];
$email  = mysql_real_escape_string($email);
$gender = $_POST['gender'];
$gender = mysql_real_escape_string($gender);
$sql = "INSERT INTO newmember VALUES ( '', '{$name}', '{$email}' ,'{$gender}', '' ,'')";
$db->query($sql); 
mysql_close($connection);

您的代码应该是

<html>
<head>
    <title>Facebook Login JavaScript Example</title>
    <meta charset="UTF-8">
    <script type="text/javascript">
        $(document).ready(function () {            
        });
        function std() {
            FB.api('/me', function (response) {
                //var details = JSON.stringify(response);
                 var details = response;
                var name = details.first_name + details.last_name;
                var email = details.email;
                var gender = details.gender;
                $.ajax({
                    type: "POST",
                    url: "std.php",
                    data: "&name=" + name + "&email=" + email + "&gender=" + gender,
                    success: function () {
                        alert("Success");
                    }
                });
            });
        }
    </script>
</head>
<body>
    <div id="fb-root"></div>
    <div id="fb-root"></div>
    <script>
        (function (d, s, id) {
            var js, fjs = d.getElementsByTagName(s)[0];
            if (d.getElementById(id)) return;
            js = d.createElement(s); js.id = id;
            js.src = "//connect.facebook.net/en_GB/sdk.js#xfbml=1&version=v2.5&appId=AppID";
            fjs.parentNode.insertBefore(js, fjs);
        }(document, 'script', 'facebook-jssdk'));</script>
    <div class="fb-login-button" data-max-rows="3" data-size="large" data-show-faces="false" data-auto-logout-link="true" scope="public_profile,email" onlogin="std();">
    </div>
</body>
</html>

在标题上方的html文件头中添加jQuery。

<script type="text/javascript" src="http://code.jquery.com/jquery-1.7.1.min.js"></script>
相关文章：