from tkinter import *
import tkinter as tk
import tkinter.messagebox as tkMessageBox
import sqlite3
def Database():
global conn,cursor
conn=sqlite3.connect("regform.db")
cursor=conn.cursor()
cursor.execute('''
CREATE TABLE IF NOT EXISTS PERSON(
pr_id INT AUTO_INCREMENT PRIMARY KEY,
pr_name VARCHAR(50),
pr_age VARCHAR(10),
pr_gender VARCHAR(50),
pr_email VARCHAR(50),
pr_phone VARCHAR(50)
)
''')
def Registration():
Database()
name1=e1.get()
age1=e2.get()
gender1=e3.get()
email1=e4.get()
phone1=e5.get()
if name1=='' or age1=='' or gender1=='' or email1=='' or phone1=='':
tkMessageBox.showinfo("Warning","fill the empty field")
else:
cursor.execute('''
INSERT INTO PERSON (pr_name, pr_age, pr_gender, pr_email, pr_phone)
VALUES (?, ?, ?, ?, ?)
''', (name1, age1, gender1, email1, phone1))
conn.commit()
tkMessageBox.showinfo("Message","Stored successfully")
conn.close()
window=tk.Tk()
window.geometry('300x200')
window.title("Registration Portal")
l1=tk.Label(window,text='Person Details')
l2=tk.Label(window,text='Name')
l3=tk.Label(window,text='Age')
l4=tk.Label(window,text='Gender')
l5=tk.Label(window,text="Email")
l6=tk.Label(window,text="Phone")
l1.grid(row=1,column=1)
l2.grid(row=2,column=1)
l3.grid(row=3,column=1)
l4.grid(row=4,column=1)
l5.grid(row=5,column=1)
l6.grid(row=6,column=1)
e1=tk.Entry(window)
e2=tk.Entry(window)
e3=tk.Entry(window)
e4=tk.Entry(window)
e5=tk.Entry(window)
e1.grid(row=2,column=2)
e2.grid(row=3,column=2)
e3.grid(row=4,column=2)
e4.grid(row=5,column=2)
e5.grid(row=6,column=2)
b=tk.Button(window,text='Submit Here', command=Registration)
b.grid(row=7,column=1)
window.mainloop()
What I have tried:
form is submitted with database connectivity on window executable file