1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| #!/usr/bin/env python
from Tkinter import *
import ttk
import MySQLdb
def insere() :
firstnamevar=firstname_entry.get()
lastnamevar=lastname_entry.get()
Phonevar=Phone_entry.get()
print '%s %s : %s'%(firstnamevar, lastnamevar, Phonevar)
db = MySQLdb.connect(host='localhost', user='root', passwd='', db='testbase',charset = "utf8" , use_unicode=True)
curs = db.cursor()
cur.execute("INSERT INTO testbase.testtable (Id, Phone, Prenom, Nom) VALUES (NULL, '%s', '%s', '%s');"%(firstnamevar, lastnamevar, Phonevar)) # correct
curs.close()
db.commit() |
Partager