Creating table using tkinter

Python Help
1

Hi
I’m trying to make a program using tkinter which will be useful in creating mySql table.
In python, I just need to get values like database name, table name, number of column, number of rows. I was successful in doing so.
But later on I need to get each column names in textboxes, while getting so, I also need a dropdown menu where user can select the datatype of value which will be in the column. But I dont know how to create multiple textbox and dropdown menue at same time using for loop…
I’ll be thankful if you could helpme out with this project…

from tkinter import *
from tkinter import messagebox
import tkinter
import random
import mysql.connector as mc

ws = Tk()
ws.title('My SQL Table Creator')
ws.geometry('1920x1080')

con=mc.connect(host='localhost',user='root',passwd='root@2')
cur=con.cursor()

def entry():
    global e1,e2,e3,e4
    p1=e1.get()
    p2=e2.get()
    p3=e3.get()
    p4=e4.get()
    cur.execute(f'create database {p1}')
    cur.execute(f'use {p1}')
    con.commit()

def register():
    global e1,e2,e3,e4
    (Label(ws,text="Enter the required details : ",font='arial 25 bold').pack)
    (Label(ws,text="Enter a new database name : ",font='arial 15 bold').place(x=10,y=30))
    e1=tkinter.Entry(ws)
    e1.place(x=350,y=35)
    (Label(ws,text="Enter a new table name : ",font='arial 15 bold').place(x=10,y=60))
    e2=tkinter.Entry(ws)
    e2.place(x=350,y=65)
    (Label(ws,text="Enter a number of Columns : ",font='arial 15 bold').place(x=10,y=90))
    e3=tkinter.Entry(ws)
    e3.place(x=350,y=95)
    (Label(ws,text="Enter a number of Rows : ",font='arial 15 bold').place(x=10,y=120))
    e4=tkinter.Entry(ws)
    e4.place(x=350,y=125)
    (Button(ws,text="Confirm", command=entry)).place(x=200,y=150)

register()
ws.mainloop()

Say if i give number of columns as 5, then a tkinter window must ask for 5 column names in individual text boxes with a drop-down menu containing options like (integer, float, characters, date)
Plz let me know if any more clarification is needed on the question… :slight_smile: