import tkinter as tk
from tkinter import messagebox
import mysql.connector
def connect_MYSQL():
connection = mysql.connector.connect(
host="ithome.uk.to",
user="colab",
password="kerek564123",
database="colab"
)
cursor = connection.cursor()
query = "SELECT * FROM colab"
cursor.execute(query)
result = cursor.fetchall()
return result
def login():
username = username_entry.get()
password = password_entry.get()
if username == connect_MYSQL()[0][0] and password == connect_MYSQL()[0][1]:
show_content_page()
else:
messagebox.showerror("Login Failed", "Invalid username or password")
def show_content_page():
login_window.destroy()
content = tk.Tk()
content.resizable(False, False)
labels = ["Server:", "Port:", "Password:", "Encrypt Method:"]
for index, label_text in enumerate(labels, start=1):
label = tk.Label(content, text=label_text, font=("Arial", 20))
label.grid(row=index, column=0, padx=5, pady=5, sticky=tk.W)
entry = tk.Entry(content)
entry.insert(tk.END, str(connect_MYSQL()[0][index - 1]))
entry.config(font=("Arial", 16))
entry.grid(row=index, column=1, padx=5, pady=5)
content.mainloop()
# Create login window
login_window = tk.Tk()
login_window.geometry("320x180")
login_window.title("Login Page")
login_window.resizable(False, False) # Restrict the size of window
# input box for username
username_label = tk.Label(login_window, text="Username:", font=("Arial", 16))
username_label.pack()
username_entry = tk.Entry(login_window)
username_entry.config(font=("Arial", 14))
username_entry.pack()
# input box for password
password_label = tk.Label(login_window, text="Password:", font=("Arial", 16))
password_label.pack()
password_entry = tk.Entry(login_window, show="*")
password_entry.config(font=("Arial", 14))
password_entry.pack()
# Login button
login_button = tk.Button(login_window, text="Login", command=login)
login_button.config(font=("Arial", 14))
login_button.pack(pady=10)
login_window.mainloop()
============================================================================
Generation of .exe --- pip install pyinstaller
pyinstaller -F -w --icon=photo.ico test.py