In this tutorial let’s write Python | MySQL Database Login Page GUI in Tkinter. Python provides numerous possibilities for creating a graphical user interface (GUI).
Tkinter is a Python wrapper for the Tk GUI toolkit. It is the standard Python interface to the Tk GUI toolkit to put it another way, Tkinter is a Python Graphical User Interface. Tkinter is likewise a native library which you do not need to install it externally. You can simply import it while using it.
Code to create MySQL Database Login Page GUI in Tkinter
app.py
import tkinter as tk
import mysql.connector
from tkinter import *
def submitact():
user = Username.get()
passw = password.get()
print(f"The name entered by you is {user} {passw}")
logintodb(user, passw)
def logintodb(user, passw):
if passw:
db = mysql.connector.connect(host ="localhost",user = user,password = passw,db ="College")
cursor = db.cursor()
else:
db = mysql.connector.connect(host ="localhost",user = user,db ="College")
cursor = db.cursor()
savequery = "select * from STUDENT"
try:
cursor.execute(savequery)
myresult = cursor.fetchall()
for x in myresult:
print(x)
print("Query Executed successfully")
except:
db.rollback()
print("Error occured")
root = tk.Tk()
root.geometry("350x350")
root.title("DBMS Login Page")
lblfrstrow = tk.Label(root, text ="Username -", )
lblfrstrow.place(x = 50, y = 20)
Username = tk.Entry(root, width = 35)
Username.place(x = 150, y = 20, width = 100)
lblsecrow = tk.Label(root, text ="Password -")
lblsecrow.place(x = 50, y = 50)
password = tk.Entry(root, width = 35)
password.place(x = 150, y = 50, width = 100)
submitbtn = tk.Button(root, text ="Login",
bg ='blue', command = submitact)
submitbtn.place(x = 150, y = 135, width = 55)
root.mainloop()
Output:
Similar Posts:
Python Script to Create Countdown Timer in Tkinter
Python Script to Create a Marksheet GUI in Tkinter
