Learn practical skills, build real-world projects, and advance your career
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