i need to save the images captured by the webcam but i m not able to save that images on Database, i m using mysql db
p, li { white-space: pre-wrap; }
# -*- coding: utf-8 -*-
from Tkinter import *
import MySQLdb
# DATA BASE CONNECTION
db = MySQLdb.connect("localhost","root","ivan","test" )
cursor = db.cursor()
root=Tk()
root.title("NEW STUDENT")
root.geometry("400x200")
#--------------Menu------------------------------
menu=Menu(root)
root.config(menu=menu)
submenu=Menu(menu)
menu.add_cascade(label="File", menu=submenu)
submenu.add_command(label="update")
submenu.add_command(label="Delete")
submenu.add_separator()
submenu.add_command(label="logout")
Edit=Menu(menu)
menu.add_cascade(label="Edit",menu=Edit)
Edit.add_command(labe="system",)
Edit=Menu(menu)
menu.add_cascade(label="Logout",menu=Edit)
Edit=Menu(menu)
#----------------form layout------------------------------------
def fun():
roll_no = int(stud_roll_no.get())
name = stud_name.get()
print type(roll_no)
print type(name)
sql = """INSERT INTO stud(roll_no, name) VALUES ('%d', '%s')"""%(roll_no, name)
cursor.execute(sql)
db.commit()
label1=Label(root, text="Student_RollNumber")
label2=Label(root, text="FirstName")
stud_roll_no=Entry(root)
stud_name=Entry(root)
button1=Button(root, text="SAVE",command = fun)
#-------------------------Arrangement--------------------------------
label1.grid(row=0, sticky=E)
label2.grid(row=1, sticky=E)
stud_roll_no.grid(row=0, column=1)
stud_name.grid(row=1, column=1)
button1.grid(row=18,column=1)
root.mainloop()