[help]how to print row table mysql to xbmcgui - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Development (https://forum.kodi.tv/forumdisplay.php?fid=32) +--- Forum: Add-ons (https://forum.kodi.tv/forumdisplay.php?fid=26) +--- Thread: [help]how to print row table mysql to xbmcgui (/showthread.php?tid=113148) |
[help]how to print row table mysql to xbmcgui - rushit - 2011-10-24 anyone can tell me how can i print row table mysql on xbmcgui ? i have table like this : import MySQLdb as mdb import sys try: conn = mdb.connect('192.168.200.16', 'ivan', 'ivan123', 'ivan'); cursor = conn.cursor() cursor.execute("CREATE TABLE IF NOT EXISTS \ nama(Id INT PRIMARY KEY AUTO_INCREMENT, Name VARCHAR(25))") cursor.execute("INSERT INTO nama(Name) VALUES('suginto')") cursor.execute("INSERT INTO nama(Name) VALUES('ivan')") cursor.execute("INSERT INTO nama(Name) VALUES('alif')") cursor.execute("INSERT INTO nama(Name) VALUES('sukoco')") cursor.execute("INSERT INTO nama(Name) VALUES('supiandi')") conn.commit() cursor.close() conn.close() except mdb.Error, e: print "Error %d: %s" % (e.args[0],e.args[1]) sys.exit(1) when i print on python : python panggil.py (1L, 'yulianto') (2L, 'ivan') (3L, 'alif') (4L, 'sukoco') (5L, 'supiandi') this is the code from panggil.py : import MySQLdb as mdb import sys con = mdb.connect('192.168.200.16', 'ivan', 'ivan123', 'ivan'); with con: cur = con.cursor() cur.execute("SELECT * FROM nama") rows = cur.fetchall() for row in rows: print row anyone can give me some suggestion for this case ? what step i must doing for calling mysql table information to xbmcgui like button , input text ? i use dharma version. |