Learn practical skills, build real-world projects, and advance your career
Created 4 years ago
import tkinter as tk
from tkinter import ttk
class SampleApp(tk.Tk):
def __init__(self):
tk.Tk.__init__(self)
self._frame = None
self.switch_frame(StartPage)
self.geometry("1350x750+0+0")
self.configure(bg="cadet blue")
def switch_frame(self,frame_class):
new_frame=frame_class(self)
if self._frame is not None:
self._frame.destroy()
self._frame=new_frame
self._frame.pack()
class StartPage(tk.Frame):
def __init__(self,master):
tk.Frame.__init__(self,master)
tk.Label(self,text="Start Page",width=20).pack()
tk.Button(self,text="Go to page one ",command=lambda: master.switch_frame(PageOne) ).pack(side="left")
tk.Button(self,text="Go to page two ",command=lambda: master.switch_frame(PageTwo) ).pack()
class PageOne(tk.Frame):
def __init__(self,master):
tk.Frame.__init__(self,master)
tk.Frame.configure(self,bg='blue')
tk.Label(self,text="page one").grid()
tk.Button(self,text="Go to start page ",command=lambda: master.switch_frame(StartPage) ).grid()
class PageOne(tk.Frame):
def __init__ (self,master):
tk.Frame.__init__(self,master)
tk.Frame.configure(self,bg='blue')
tk.Label(self,text="page one").pack()
tk.Button(self,text="Go to start page ",command=lambda: master.switch_frame(StartPage) ).pack()
class PageTwo(tk.Frame):
def __init__ (self,master):
tk.Frame.__init__(self,master)
tk.Frame.configure(self,bg='red')
tk.Label(self,text="page two").pack()
tk.Button(self,text="Go to start page ",command=lambda: master.switch_frame(StartPage) ).pack()
app = SampleApp()
app.mainloop()
try:
# Python2
import Tkinter as tk
except ImportError:
# Python3
import tkinter as tk
root = tk.Tk()
root.title('background image')
# pick a .gif image file you have in the working directory
fname = "web.gif"
bg_image = tk.PhotoImage(file=fname)
# get the width and height of the image
w = bg_image.width()
h = bg_image.height()
# size the window so the image will fill it
root.geometry("%dx%d+50+30" % (w, h))
cv = tk.Canvas(width=w, height=h)
cv.pack(side='top', fill='both', expand='yes')
cv.create_image(0, 0, image=bg_image, anchor='nw')
# add canvas text at coordinates x=15, y=20
# anchor='nw' implies upper left corner coordinates
cv.create_text(15, 20, text="Python Greetings", fill="red", anchor='nw')
# now add some button widgets
btn1 = tk.Button(cv, text="Click")
btn1.pack(side='left', padx=10, pady=5, anchor='sw')
btn2 = tk.Button(cv, text="Quit", command=root.destroy)
btn2.pack(side='left', padx=10, pady=5, anchor='sw')
root.mainloop()
import tkinter as tk
from tkinter import*
import sqlite3 as sq
class SampleApp(tk.Tk):
def __init__(self):
tk.Tk.__init__(self)
self._frame = None
self.switch_frame(StartPage)
self.geometry("1600x1000+0+0")
self.configure(bg="cadet blue")
def switch_frame(self,frame_class):
new_frame=frame_class(self)
if self._frame is not None:
self._frame.destroy()
self._frame=new_frame
self._frame.pack()
class StartPage(tk.Frame):
def __init__(self,master):
tk.Frame.__init__(self,master)
tk.Label(self,text="Studet Database Management",width=30,height=25,bg="green",font=("Vineta BT",20,"bold","italic","underline")).pack()
tk.Button(self,text="Add Record",command=lambda: master.switch_frame(PageOne) ).place(relx=0.3,rely=0.7,relwidth=0.2)
tk.Button(self,text="View Record",command=lambda: master.switch_frame(PageTwo) ).place(relx=0.5,rely=0.7,relwidth=0.2)
tk.Button(self,text="Delete Record",command=lambda: master.switch_frame(PageTwo) ).place(relx=0.3,rely=0.8,relwidth=0.2)
tk.Button(self,text="Update Record",command=lambda: master.switch_frame(PageTwo) ).place(relx=0.5,rely=0.8,relwidth=0.2)
tk.Button(self,text="Search record",command=lambda: master.switch_frame(PageTwo) ).place(relx=0.3,rely=0.9,relwidth=0.2)
tk.Button(self, text="Quit App", command=master.destroy).place(relx=0.5,rely=0.9,relwidth=0.2)
class PageOne(tk.Frame):
def __init__ (self,master):
tk.Frame.__init__(self,master)
tk.Frame.configure(self,bg='PeachPuff')
label=tk.Label(self,text=" ",bd=12,width=50,height=15,bg="yellow",fg="blue",font=("times",12,"bold","italic")).pack()
label0=tk.Label(self,text="Add Student Records Here",bg="red",fg="yellow",pady=4,width=50,)
label0.place(relx=-0.2,rely=0.0)
label0.config(font=("Vineta BT",10,"bold","italic"))
w = Canvas(self,bg="red", width=500, height=100)
w.pack()
e1 = tk.StringVar(self)
e2 = tk.StringVar(self)
e3 = tk.StringVar(self)
label1=tk.Label(self,text="Student Name",width=20)
label1.place(relx=0.1,rely=0.1)
nentry=tk.Entry(self,textvariable=e1)
nentry.place(relx=0.5,rely=0.1,relwidth=0.3)
label2=tk.Label(self,text="Father's Name",width=20)
label2.place(relx=0.1,rely=0.2)
fentry=tk.Entry(self,textvariable=e2)
fentry.place(relx=0.5,rely=0.2,relwidth=0.3)
label3=tk.Label(self,text="Age",width=20)
label3.place(relx=0.1,rely=0.3)
aentry=tk.Entry(self,textvariable=e3)
aentry.place(relx=0.5,rely=0.3,relwidth=0.3)
label4=tk.Label(self,text="Gender",width=20)
label4.place(relx=0.1,rely=0.4)
""""s = tk.IntVar()
radiobutton1=tk.Radiobutton(self,text="male",value=1,variable=s,command="ShowChoice").place(relx=0.5,rely=0.4)
radiobutton2=tk.Radiobutton(self,text="Female",value=2,variable=s,command="ShowChoice").place(relx=0.7,rely=0.4)"""
con = sq.connect('std.db')
c = con.cursor()
comp = tk.StringVar(self)
comp.set('----')
def get():
print("You have submitted a record")
c.execute('CREATE TABLE st (sname TEXT,sfname TEXT,age INTEGER)')
c.execute('INSERT INTO st (sname, sfname, age) VALUES (?, ?, ?)',
(e1.get(),e2.get(),e3.get()))
con.commit()
tk.Button(self,text="Submit",bg="ghost white",font=("Helvetica",9,"bold","italic"),command=get()).place(relx=0.2,rely=0.8,relwidth=0.3)
tk.Button(self,text="Go to start page ",bg="ghost white",font=("Helvetica",9,"bold","italic"),command=lambda: master.switch_frame(StartPage) ).place(relx=0.5,rely=0.8,relwidth=0.3)
class PageTwo(tk.Frame):
def __init__ (self,master):
tk.Frame.__init__(self,master)
tk.Frame.configure(self,bg='red',height=400,width=600)
label0=tk.Label(self,text="Student Records View Point",bd=12,width=30,height=1,bg="yellow",fg="blue",font=("Helvetica",12,"bold","italic"))
label0.place(relx=0.2,rely=0.0)
tk.Button(self,text="View Record",bg="ghost white",font=("Helvetica",9,"bold","italic") ).place(relx=0.2,rely=0.8,relwidth=0.3)
tk.Button(self,text="Go to start page ",bg="ghost white",font=("Helvetica",9,"bold","italic"),command=lambda: master.switch_frame(StartPage) ).place(relx=0.5,rely=0.8,relwidth=0.3)
app = SampleApp()
app.mainloop()
File "<ipython-input-41-a7f4a8bb1811>", line 79
print("You have submitted a record")
^
IndentationError: expected an indented block
insert_info="INSERT INTO mydb1(username,password) VALUES('shakti','swarup')"
cursor.execute(insert_info)
---------------------------------------------------------------------------
OperationalError Traceback (most recent call last)
<ipython-input-28-df36810e66a7> in <module>
1 insert_info="INSERT INTO mydb1(username,password) VALUES('shakti','swarup')"
----> 2 cursor.execute(insert_info)
OperationalError: database is locked
import tkinter as tk
from tkinter import ttk
import sqlite3 as sq
root=tk.Tk()
root.title("mySecondApp")
root.geometry("1200x1000")
e1 = tk.StringVar(root)
e2 = tk.StringVar(root)
e3 = tk.StringVar(root)
frame=tk.Frame(root,bg="blue",width=100,height=150)
frame.place(relx=0.2,rely=0.1,relheight=0.5,relwidth=0.5)
label=tk.Label(frame,text="Name",bg="green yellow",width=20)
label.place(relx=0.1,rely=0.1)
entry=tk.Entry(frame,textvariable=e1)
entry.place(relx=0.5,rely=0.1,relwidth=0.3)
label1=tk.Label(frame,text="Age",bg="green yellow",width=20)
label1.place(relx=0.1,rely=0.3)
entry1=tk.Entry(frame,textvariable=e3)
entry1.place(relx=0.5,rely=0.3,relwidth=0.3)
label4=tk.Label(frame,text="weight",bg="green yellow",width=20)
label4.place(relx=0.1,rely=0.2)
entry2=tk.Entry(frame,textvariable=e2)
entry2.place(relx=0.5,rely=0.2,relwidth=0.3)
label3=tk.Label(frame,text="Add record Here!!",bg="red",fg="yellow",pady=4,width=50,)
label3.place(relx=-0.1,rely=0.0)
label3.config(font=("Vineta BT",10,"bold","italic"))
button=tk.Button(frame,text="Submit",activeforeground = "red",activebackground = "pink",pady=2,relief="raised",command=get)
button.place(relx=0.3,rely=0.4,relwidth=0.2)
button1=tk.Button(frame,text="Reset",activeforeground = "red",activebackground = "pink",pady=2,relief="raised",command=root.destroy)
button1.place(relx=0.5,rely=0.4,relwidth=0.2)
con = sq.connect('data.db')
c = con.cursor()
def get():
print("You have submitted a record")
c.execute('CREATE TABLE IF NOT EXISTS stud(name TEXT,weight INTEGER,age INTEGER)')
c.execute('INSERT INTO stud(name,weight,age) VALUES(?, ?, ?)',e1.get(),e2.get(),e3.get())
con.commit()
con.close()
root.mainloop()
You have submitted a record