Tkinter Application to connect to MySQL database using user inputs

b1=tk.Button(my_w,text='Connect',width=10,command=lambda:disp_data())

str1="mysql+mysqldb://"+userid.get()+":" \
        +pw.get()+"@"+host.get()+"/"+db.get()

try:
        my_conn=create_engine(str1)  
        r_set=my_conn.execute("SHOW TABLES")  

        for i in r_set:
            my_output=my_output + str(i[0]) + '\n'
        t1.config(bg='white')
    except SQLAlchemyError as e:
        error = str(e.__dict__['orig'])
        my_output=error
        t1.config(bg='yellow',font=('times',18,'normal'))

r_set=my_conn.execute("SHOW TABLES")

from sqlalchemy import create_engine
from sqlalchemy.exc import SQLAlchemyError
import tkinter as tk
from tkinter import END
def show_data():
    #create the mysql connection string by using entry box inputs 
    str1="mysql+mysqldb://"+userid.get()+":" \
        +pw.get()+"@"+host.get()+"/"+db.get()
    #print(str1) # check the string 
    t1.delete('1.0',END)# Remove the previous data 
    t1.update()    
    my_output='' # set a blank string 
    try:
        my_conn=create_engine(str1) # try to connect
        r_set=my_conn.execute("SHOW TABLES") #query to run

        for i in r_set:
            my_output= my_output + str(i[0]) + '\n'
        t1.config(bg='white') # update background colour 
    except SQLAlchemyError as e:
        error = str(e.__dict__['orig'])
        my_output=error
        t1.config(bg='yellow',font=('Times',16,'normal'))#error format
        #print(error)    
    t1.insert(tk.END, my_output) # add the output to Entry widget

### layout design of the widgets in window ##
my_w = tk.Tk()
my_w.geometry("600x420") # width & hieght of window
l1=tk.Label(my_w,text='Host')
l1.grid(row=1,column=1,padx=5)
host=tk.StringVar()
host.set('localhost') # default value, change if required
e1=tk.Entry(my_w,textvariable=host,width=10)
e1.grid(row=1,column=2)

l2=tk.Label(my_w,text='Database')
l2.grid(row=1,column=3,padx=5)
db=tk.StringVar()
db.set('')
e2=tk.Entry(my_w,textvariable=db,width=10)
e2.grid(row=1,column=4)

l3=tk.Label(my_w,text='userid')
l3.grid(row=1,column=5,padx=5)
userid=tk.StringVar()
userid.set('')
e3=tk.Entry(my_w,textvariable=userid,width=10)
e3.grid(row=1,column=6)

l4=tk.Label(my_w,text='Password')
l4.grid(row=1,column=7,padx=5)
pw=tk.StringVar()
pw.set('')
e4=tk.Entry(my_w,textvariable=pw,show='*',width=10)
e4.grid(row=1,column=8)

b1=tk.Button(my_w,text='Connect',width=10,command=lambda:show_data())
b1.grid(row=1,column=9)
t1=tk.Text(my_w,height=20,width=40)
t1.grid(row=2,column=1,columnspan=8)
my_w.mainloop()

Creating the windows Application

Adding SQL window

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author   Watch on YouTube

Connect: