Facebook PHP SDK将所有'5's保存到mysql数据库字段而不是数据


facebook php sdk saves all '5's to mysql database fields instead of data

遵循本教程http://www.skwebdesigner.com/?p=586下面是我的fbconnect.php代码的摘录。

if($user){
    // Get logout URL
    $logoutUrl = $facebook->getLogoutUrl();
}else{
    // Get login URL
    $loginUrl = $facebook->getLoginUrl(array(
        'scope'         => 'read_stream, publish_stream, email, user_about_me',
        'redirect_uri'  => $site_url,
        ));
}
if($user){
    try{
    // Proceed knowing you have a logged in user who's authenticated.
    $user_profile = $facebook->api('/me');
    //Connecting to the database. You would need to make the required changes in the common.php file
    //In the common.php file you would need to add your Hostname, username, password and database name!
    mysqlc();
    $name = GetSQLValueString($user_profile['name'], "text");
    $email = GetSQLValueString($user_profile['email'], "text");
    $gender = GetSQLValueString($user_profile['gender'], "text");
    $bio = GetSQLValueString($user_profile['bio'], "text");
    $query = sprintf("SELECT * FROM newmember WHERE email = %s",$email);
    $res = mysql_query($query) or die('Query failed: ' . mysql_error() . "<br />'n$sql");
    if(mysql_num_rows($res) == 0)
    {
        $iquery = sprintf("INSERT INTO newmember values('',%s,%s,%s,%s,'yes')",$name,$email,$gender,$bio);
        $ires = mysql_query($iquery) or die('Query failed: ' . mysql_error() . "<br />'n$sql");
        $_SESSION['user'] = $user_profile['email'];
        $_SESSION['id'] = $user_profile['id'];
    }
    else
    {
        $row = mysql_fetch_array($res);
        $_SESSION['user'] = $row['email'];
        $_SESSION['id'] = $user_profile['id'];
    }
    }catch(FacebookApiException $e){
            error_log($e);
            $user = NULL;
        }
}
}
?>

连接到数据库正确,但保存facebook信息为5为每个字段。还请注意,今天早些时候它为每个字段保存了1。

What I've try

将$user更改为$user_profile

谢谢

非常确定插入的'sprintf'需要在%s周围加上引号。您可以通过打印$iquery.

来检查。