Building Out The GUI for our Database App - Python Tkinter GUI Tutorial #20

Building Out The GUI for our Database App. In this video we'll begin to build out the graphical user interface (GUI) for our database app with Tkinter. We'll add input boxes and buttons to add data to our database, and retrieve that data and output it onto the screen.

In this series I'll show you how to create graphical user interfaces for Python with Tkinter.

✅ Watch The Other Videos In This Python Playlist:

▶️ See More At:

✅ Join My Facebook Group:

✅ Subscribe To My YouTube Channel:

Take $22 off with coupon code: youtube

[Codemycom]

▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My YouTube Channel:
▶️ See More At: ✅ Join My Facebook Group:

[webstuff]

Thank you! I’ve been on the sidelines about whether to learn python. My interests are in database / API’s and data visualization. Watching you, just made Python feel comfortable and the right thing to do, especially with all the AI stuff.

[aaryansarnaik]

Sometimes I wish I wasn't broke just to support amazing teachers like these

[livenere]

Great video, this is exactly what I was looking for. There is 1 thing I would like to do different that I'm unsure how to do.
I would like to enter a oid into a text box, use the query button to look through the table for that oid, and populate the other input fields ( f_name, Zip, ect....). With the data that associated the the oid.

[hamakhdir]

Object identifiers (OIDs) are used internally by SQLite as primary keys for various system tables. Also, an OID system column is added to user-created tables. Type oid represents an object identifier.

[Lennardish]

Hello John,
I am a psychlogist and I collect data from large groups of students. Such as names, scores on various subjects, testscores, etc, etc. I am playing now with your program, using only first name and all kinds of scores. After that I use statistics to calculate sums per category, as well as standard deviation, percentile scores. So, this all means that I can benefit enormously from your basic database program. Thank you very much!!! :) Paul

[cameronmclaughlin]

Proud owner of lifetime membership, keep up the good work! 👍👍

[lettherebelightfixtures]

Hi. Great tutorial. I would like to point out that at 20:30 where you create the variable "print_records" in the for loop, we actually don't need it. You can write the for loop like this:


for record in records:
print(record[0])
It will workout exactly how you want it to without printing the first record twice.

[lifeisdead]

🎯 Key points for quick navigation:

00:00:00 *🖥️ The video aims to enhance a database app by building out its GUI using Tkinter and Python, following up from the previous video where a database and table were created.*
00:01:02 *📝 The tutorial covers creating text entry boxes for user input such as first name, last name, address, city, state, and zip code using Tkinter's entry widget.*
00:02:53 *🔄 Labels are added next to entry boxes for clarity, aligning them properly using Tkinter's grid system.*
00:05:29 *💾 A submit button is introduced to gather user input and prepare it for database insertion, with a focus on clearing the input fields after submission.*
00:07:14 *⌨️ The submit function is defined to clear text boxes after data entry is submitted using the "delete" method on each entry widget.*
00:08:36 *🗃️ Inside the submit function, the database connection is reiterated, ensuring data is correctly inserted into the table.*
00:13:22 *📊 A query button is added to display records from the database, implementing a method to fetch and print the database records onto the GUI.*
00:15:29 *🔍 The query function is initiated, detailing how to handle database queries and display results in Tkinter, including fetching all records.*
00:17:27 *💡 A for-loop is used to iterate over records and format them for display in the GUI, showcasing dynamic data visualization using Tkinter labels.*
00:20:27 *🔧 Demonstrates how to manage primary keys and record displays effectively within the Tkinter app, focusing on practical database interactions.*
00:26:37 *📜 The tutorial concludes by emphasizing formatting options for data display and announces plans for adding a delete function in an upcoming video.*
00:27:44 *📚 Additional resources and courses on SQLite and Python database management are introduced, inviting viewers to further their learning.*

Made with HARPA AI

[tumpalmichaels]

This channel is helpful for me cause this is the solution for my error in my thesis app. Thankyou😄

[yusufergin]

It's amazing! Just what I'm looking for for days! Thank you sooo much, man! Keep doing it, you are great!

[creativecore]

this guy has taught me more about data science than all four of my college professors this semester

[viktor]

Those of you having problems with entering records to the table, try triple quotes around the INSERT INTO addressess function instead of single quotes.

[terrywright]

Thanks for this video. I have created a small database app to keep and manipulate golf scores and wanted a GUI front end. Plenty of stuff found about creating pretty screens and placing buttons etc but none that connect the GUI to the working program. Really good thanks. I shall be watching a lot more.

[alfiehammer]

Just what I've been looking for. Thanks!

[viktor]

John goes: "So we add this variable here, go up here, create a function, then we pass this into the string, go over here place the label, name this text box, enter the database and BOOM"

Me: "Okey.... he said something about boom, where do I find boomy-thingy?!"
😂😂😂

Great videos man, just the playlist I've been looking for. 👍

[strawberrysugarcookies]

USING THIS FOR MY GRADUATE FINAL PROJECT THNAK YOU

[travisblack]

John, thank you for all of your great learning material provided at zero cost here on youtube. Beautiful content and amazing results. Hope its a good day in Vegas. Have a good day!

[IceTheCoder]

7:36 You could've placed each label in a list and iterated through each one and clear it with a for loop

[dheerajchouhan]

Hello Sir I am Dheeraj from India I follow whatever you said in this video and write exactly same code but I am getting 1 error which I don't understand how to solve I am new in this so can you please help me to resolve this problem.
File "d:\pyn\TinkierGUI\T.24.py", line 27, in SUBMIT
c.execute('''INSERT INTO addresses VALUES(f_name, l_name, address, city, state, Zipcode)''',
sqlite3.OperationalError: no such table: addresses
can you please help ....