How do I grab user input from text boxes on a Python/Tkinter form and use it to build a query to a MySQL db?
Posted on 2009-04-16
I need to build or find a Tkinter form that can be used to grab input from a user and use that to query a mysql database.
For this task, let's say the db has a table called 'user' and contains the following fields:
fld1, fld2, fld3
Initially, if we can just build it around basic textbox type widgets. We can improve and upgrade the form after we learn to build it.
The main area I'm having trouble with is how to iterate through the entry fields on the form and then populate the corresponding field in the database.
I AM able to make a connection to the db - no trouble there.
This problem is really impeding progress, so I'll award high points to whomever can enlighten me :-)