Python MySQL

fb.py

#!/usr/bin/python
# -*- coding: utf-8 -*-
 
import facebook

# 引入 MySQL 模組
import MySQLdb
 
# 連接到 MySQL
db = MySQLdb.connect(host="x.x.x.x", user="yume", passwd="xxxx", db="xData",charset="utf8",use_unicode = True)
cursor = db.cursor()
#cursor.execute("SELECT fid from memberlist")
cursor.execute("SELECT * from memberlist")
result = cursor.fetchall()

graph = facebook.GraphAPI()
for record in result:
    #graph = facebook.GraphAPI()
    #user = graph.get_object(record)
    #cursor.execute("update memberlist set FBID = '%s' where fid = '$%s' "%(record,user[id]))
    #if(record[0] == 43):
    try:
        user = graph.get_object(record[3])
        #print user
        sql = "update memberlist set FBID = '%s' where fid = '%s' "%(user['id'],record[3])
        cursor.execute(sql)
        sql = "update memberlist set facebookname = '%s' where fid = '%s' "%(user['name'],record[3])
        cursor.execute(sql)
    except:
        print "Number : ",record[0]
    #print "Number : ",record[0]
    #print "DB : ",record
    #print "fb : ",user
    #print (record[3],user['id'])