from tkinter import *
import mysql.connector
window = Tk()
window.title("GUI Title")
# Add your GUI components here
window.mainloop()
# Create a label
label = Label(window, text="Enter your name:")
label.pack()

# Create an entry field
entry = Entry(window)
entry.pack()

# Create a button
button = Button(window, text="Submit")
button.pack()
# Connect to MySQL database
db = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)
# Create a cursor object to execute SQL queries
cursor = db.cursor()

# Example: Insert data into a table
name = entry.get()  # Get the value entered in the entry field
query = "INSERT INTO your_table (name) VALUES (%s)"
values = (name,)
cursor.execute(query, values)
db.commit()
cursor.close()
db.close()