populate dropdown with sql python/tkinter

Question

i use python 3, tkinter and mysql connector. I want to make an optionMenu object with my sql data i tried to do like that :

     mongroupe3 = LabelFrame(app, text='nouvelle div 3').pack()
     Label(mongroupe3, text='groupe3').pack()
     select_Classes = ("select id,nom from classe")
     cursor.execute(select_Classes)
     result = cursor.fetchall()
     for row in result:
        id = row[0]
        nom = row[1]
        mongroupe3 = Label(app, text=nom).pack()
        v = StringVar()
        v.set(nom)
        om = OptionMenu(mongroupe3, v, nom)
        om.pack()

the code has to show a dropdown menu with a list of the "nom" on my "classe" table but my option menu is in my for loop and is executed as many time as i have records in my classe table .

for exemple if i have 3 record i got 3 option menu with 3 different value.

o tried to put my optionMenu out of my for loop like that :

     mongroupe3 = LabelFrame(app, text='nouvelle div 3').pack()
     Label(mongroupe3, text='groupe3').pack()
     select_Classes = ("select id,nom from classe")
     cursor.execute(select_Classes)
     result = cursor.fetchall()
     for row in result:
        id = row[0]
        nom = row[1]
        mongroupe3 = Label(app, text=nom).pack()
        v = StringVar()
        v.set(nom)
     om = OptionMenu(mongroupe3, v, nom)
     om.pack()

but i got only the last record i inserted on my table. i cant put my for loop inside my OptionMenu cause of the following shema OptionMenu(parent, default variable, var)

Billal BEGUERADJ · Accepted Answer · 2018-04-29 14:02:59Z

1

You got what you did not expect for this reason:

You create only one label and you override it in each iteration (the same about the class variable v). So by the end, it is logic you get only one row (because, again, you have only one label widget).

Apart from this, you have to care about the widgets and where you place them: for example, I believe mongroup3 must be the parent widget of the row you want to create, unlike what you did.

answered Apr 29, 2018 at 14:02

Billal BEGUERADJ

23k45 gold badges125 silver badges142 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Calvin Over a year ago

mongroup3 was just here to test my for loop and it return all my record of my table . If I understood correctly i need to put my for loop inside my option menu ?

Collectives™ on Stack Overflow

populate dropdown with sql python/tkinter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related