Notes

#maximize thge gui window
#add name to the box and id to the second
#click on the hello button once to insert data
#use and change the database "manobhav" accordingly

import pymysql
from Tkinter import *
# Open database connection

def func():
db = pymysql.connect("localhost","root","test","manobhav" )
# prepare a cursor object using cursor() method
cursor = db.cursor()

# execute SQL query using execute() method.

sql = "INSERT INTO EMPLOYEE(ID,NAME) VALUES ("+E1.get()+",'"+E2.get()+"')"
print(sql)
try:
# Execute the SQL command
cursor.execute(sql)
# Commit your changes in the database
db.commit()
except:
# Rollback in case there is any error
db.rollback()
# disconnect from server
db.close()

db = pymysql.connect("localhost","root","test","manobhav" )
# prepare a cursor object using cursor() method
cursor = db.cursor()
# execute SQL query using execute() method.
cursor.execute("SELECT VERSION()")
# Fetch a single row using fetchone() method.
data = cursor.fetchone()
print ("Database version : %s " % data)


cursor.execute("DROP TABLE IF EXISTS EMPLOYEE")
# Create table as per requirement
sql = """CREATE TABLE EMPLOYEE (
ID INT PRIMARY KEY,
NAME CHAR(20) NOT NULL)"""
cursor.execute(sql)
db.close()
top = Tk()
L1 = Label(top, text="ID")
L1.pack( side = LEFT)
E1 = Entry(top, bd =5)
E1.pack(side = RIGHT)
L2 = Label(top, text="name")
L2.pack( side = LEFT)
E2 = Entry(top, bd =10)
E2.pack(side = RIGHT)
B = Button(top, text ="Hello", command = func)
B.place(x=100,y=100)
top.mainloop()