Using Databases With TKinter - Python Tkinter GUI Tutorial #19
HTML-код
- Опубликовано: 20 июл 2024
- How to Use Use Databases With TKinter. In this video I'll start to show you how to use the SQLite3 database with Tkinter. Sqlite is a cool free database that comes with Python and is pretty easy to use!
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:
bit.ly/2UFLKgj
▶️ See More At:
Codemy.com
✅ Join My Facebook Group:
bit.ly/2GFmOBz
✅ Subscribe To My RUclips Channel:
bit.ly/2IGzvOR
▶️ Learn to Code at Codemy.com
Take $22 off with coupon code: youtube
![Tkinter Data Entry Form tutorial for beginners - Python GUI project [responsive layout]](/img/1.gif)
▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My RUclips Channel:
bit.ly/2UFLKgj bit.ly/2IGzvOR
▶️ See More At: ✅ Join My Facebook Group:
Codemy.com bit.ly/2GFmOBz
▶️ Learn to Code at Codemy.com ✅ Buy a Codemy T-Shirt!
Take $30 off with coupon code: youtube1 bit.ly/2VC9WUN
I hope u get rich with doing things like sharing this knowledge :). Thanks for sharing
That'd be great :-p
Wooo, database stuff! This is what I've been looking forward to. Makes me feel like I'm starting to build something bordering on useful.
For sure!
I have been going through many videos on youtube and came across many youtubers but my search stopped because I found simply the best!!! I really appreciate and your way to teach is simply WOW. for sure I will subscribe. which is INSANELY CHEAP :)
Thanks so much! I really appreciate your words!
4:45 this man just made me understand something so simple, but that nobody explains it this simple. Thanks man !
Happy to hear it!
I just love the way u ask "What's going on guys?!!!"😂😂❤️
Keep up the good work
Ha Thanks!
wow, literally this is the wonderful series of videos that i am really searching for. thank you sir you are sharing your knowledge a lot. it was really helping for my project.
Happy to hear it!
I love the way you simplify things! bless you
Glad you like them!
your videos are one of the few bests in YT , Bro code is awsome in detailed but fast learning and you make it as easy as possible i want to knopw how your work are meant to us , i really thank you
I appreciate it!
Thank you so much John for the amazing tutorial; it was really helpful.
Glad you liked it!
This series, like most all your tuts is well explained, but I found myself dallying over it. I've got DB experience in other areas, but this didn't really sink in right away for some reason. What I found to be the problem was, the db kept getting "lost" after I closed out the browser, which you address when you speak of it getting placed in the c:/gui directory you use. But I use different notebooks in different directories under Anaconda/Jupyter, which unfortunately makes things more complex sometimes, so the data would get "lost", change around, etc., once I moved to another notebook or tutorial.
FWIW, if anyone has a similar problem, I found it helpful to use os.getcwd() and os.listdir() before setting up the db, so you know where you are working and what's there; and, then, run a simplified (non-tkinter) script to setup, and finally run os.listdir() a second time to ensure the creation of the db file. Then you can just use tkinter to browse the db, make updates, etc.. This technique also lend itself to browsing the db itself with sqlite3 sans tkinter, so - when you return to work in tkinter - you can know the db better, check your work, etc... $.02 HTH... :)
since the database connection is before mainloop() does this mean that the connection to your database is happening every iteration? or is this not a while loop type situation?
I am a high school Spanish teacher that is learning Python. You have the best videos on RUclips and I'm addicted to this Tkinter series. I like that you periodically run the code for each project. In my experience, not a lot of coding RUclipsrs implement that. Thank you for everything.
Glad you're enjoying the videos!
Thanks John, these courses helped a great deal.
Glad you liked them!
Hi, thank you very much for your video. I just followed your video to connect to the database ... but you did not continue with MySQL or SQL. This is very unfortunate
Really good tutorial! One question - regarding the need to comment out the 'create table' code after it has been run once since the table has been created. How would you go about doing this if you made a program that was to be run by the public. Would you make an if statement to check if the table already exist and only create a table if it doesn't? Thanks heaps!
Just use. , if exists
It is command of database , will create a table if it does not exist and will not create if it exists, it will help u as we don't want multiple tables and error.
See more for how to use if exists on utube or google
Hello John,
With the help of this Sqlite3 tutorial and one video of yours in which to switch between windows, I succeeded to produce a "Menu" window in which two buttons. One button asking for a "def" to add data to a database, and one button, asking for a "def" to query.
I just now have to find out how to make disappear the "menu" window, when I move to the add data window, and how to make the "menu" window reappear by clicking some button in the add window. But. I am thrilled because you showed me the way. Thanks. I continue my quest :) Paul
Awesome, I have videos on that in the playlist :-p
@@Codemycom your explanation is very very clear, and to the point. You produced splendid study tutorials that more or less pave the way for better insight. Consider me to be your greatest fan 🙂
@@Lennardish Thanks!
Thanks so much !!! Clear & Well explained. Regards.
You are welcome!
Hey there, just came across this video in a google search and subscribed to you. I have a couple questions I'm hoping you can answer. I've just recently started learning python and have a decent grip on most of the basics. I'm currently working on a personal project and wondering if sqlite will work for this function. I've created a python program that scrapes web pages and converts the needed data to a clean json file. I'm now looking to add all json file data to sqlite database that I can query from my website. Is this possible to do with sqlite? I have about 5000 files (which would be index) and each file only contains text, with about 30 columns of data. Sorry for the long post, just wondering if I will be able to learn this within these videos. Also do you happen to have any videos about querying sqlite databases from websites? Thanks!
Thanks for this great tutorial
Welcome!
Sir you are great.
#sir can you make a video on,how to store data in pandas using GUI.
#only pandas and tkintrr
Don't use SQL database
#thank you
For teaching
#from india
Really helpful!
Glad it was helpful!
Why this channel has only 38k subs this channel deserves more and yes
Be sure to smash the like button
I agree! Tell your friends about it ;-)
Hey Baldy bro TNX.for this stuff
Sure thing
Your videos have been an absolute life saver for my Year 12 digital Technologies course. when I run this database it comes up with the error no module names 'PIL'. Do you have nay suggestions to how to fix this?
hi eliza. you've probably worked it out by now and graduated and moved on!! 😁 but just in case you haven't (joke) you need to import Pillow... Codemy talks about it here: ruclips.net/video/NoTM8JciWaQ/видео.html
Hello, do we still have to write code for creating tables and stuff if we have already created a table and inserted values in SQLite Studio? Or would it be okay if we only write the connect,sqlite3 code etc?
Once you create all that stuff once, you need to remove that code and not create them again.
Hi, thank you very much for your video.
Thank you too
thanks for this tuto :)
Sure thing!
Sir
I need to get messagebox error if identity already exists in database with aded function
Thanks a lot sir.you are the best
Thanks!
i m facing this issue when create connection kindly provide solution for it mysql.connector.error.interface:2003 : can't connect to mysql server on ' localhost:3306' (10061 np connection could be made because the target machine actively refused it)
Un big merci (:
can we add an entire values of a row from a table inside a label?. I am doing a Theatre management project using sql and python.
Not really sure what you mean, but give it a try to see.
@@Codemycom Got it figured out. Thanks a lot for your 6 hour tutorial. helped a ton.
sir, If i create a database in my system for my python app and send copies of my app to other systems, Will the systems connect with the database in my system when a 3rd user saves data in the database?
no. how could it? Your database is on your computer. Their database is on their computer.
Hey could anyone helps
.. i am making a python project on tyre shop management... with python and sql.. other than tkinter does we need any other library to manage our project??
No one can answer that, it depends entirely on what you're trying to do and what your needs are.
Wonderful, I need help to connect to Xampp SQL, can you help me with this or point me to a video which already exist?, Thanks and regards.
Turn on the MySQL and Apache on your Xampp and ready.
Can you give us tutorial on modern UI design using python like for c# we use metro framework also tell us how to add animations and sound for click event of button like when I press button bee bee sound will buzz of error sound will buzz
Not with TKinter
By the way zipcode should be treated as text
As no math applied to it
Any way keep going man
I like your videos 👍
Thank you😊
You're welcome!
What if i want date datatype and want to sort records by date or something?
Do it in the normal way
Sir how I can make a installer of python tkinter exe file which uses database
could this be done with postgreSQL instead of SQlite?
Sure, fairly easily
Please make a video on "Fetching data from mysql database randomly"
We have to do 'pip install pillow' before using PIL.
Anyway I really appreciate your great videoes.
Yes, of course.
Thanks a lot
Happy to help
how to do
analogue clock in tkinter
I just wanted to ask if you have a video about the user will input info and it will automatically be in the database. :)
Of course
@@Codemycom by any do you know why this errorr keeps on appearing when i'm following your code.
cannot import name 'imageTK' from 'PIL' (C:\Users\stephen antonio\anaconda3\lib\site-packages\PIL\__init__.py)
@@stephenaubreyantonio8110 You're using Anaconda instead of regular python..could be because of that
@@Codemycom I already install pip and it works just fine now, thank youuuu!!
Hello I know you have a great tutorial but I encounter some problem that I cannot understand and fixed it. I think i might miss out something very imporant while learning sql. Thank you in advance
Traceback (most recent call last):
File "G:\pythonprogramms\Project test.py", line 33, in
c.execute('''CREATE TABLE addresses (
sqlite3.OperationalError: table addresses already exists
Hey.. instead of just CREATE TABLE write CREATE TABLE IF NOT EXISTS.
You are getting the error message because you are asking the computer to create something you already had created.
Please I want a possible solution for these error on c.fetchall..... AttributeError: 'sqlite3.Connection' object has no 'fetchall'
you have a typo in your code
on click button redirect to another page in python using tkiner library...
how can it do sir?????
]
What do you mean by page? Tkinter doesn't have pages
Could you make a video about Json with tkinter python please thanks
I have videos where we deal with json from an API, just not with tkinter (but with python). Once you know how to deal with it in python, the tkinter part is irrelevant.
I dont have any knowledge of databases,so can i continue with the course or should i learn about basics of Database?
I would recommend understanding SQL syntax, like the meaning of the different statements and run through a tutorial on that first.
Then you could use SQLite to combine that and tkinter together.
@@KristoKorps Yeah,sure🙂
This video was very useful...but can you also do one with MySQL too
I have a python mysql course
@@Codemycom oh okay didn't see that...thank you keep it up bro
@@varman8048 will do
hi, im doing this on visual studio and its not working. is any one familiar with this issues and knows how to fix it?. the issue is with the create table section as it does not recognise the command?
I never recommend visual studio
@@Codemycom what IDE do you use in these videos
Sublime Text and the Git-scm.com terminal @@ryano699
how to connect our app to a server
plz tell us sir if u know plz i am waiting for this video plz and you are our only true teacher on the inter plz teach us how to connect our apps to a server.
connect to a server for what?
@@Codemycom if i created a heavy app then i need a server for user authentication and more things
@@ebaadkhan8501 what's a heavy app?
@@Codemycom like i build a game which needs an update so ill have to connect it to server for updates if not then how? BTW you are great i have been asking questions to many teachers but u are the only good teacher who replies to their students
Can you do one with SQL Server?
No sorry, that's a Microsoft thing
"ImportError: DLL load failed while importing _sqlite3: The specific module could not be found."
I have installed sqlite3.dll and all demanded files according to Python's site, but I still get the same error. I want to follow these database courses, but with this error I am forced to stay here. Any ideas?
sqlite3 comes with python, there's nothing to install
@@Codemycom Alright, I didn't know. But why do I get this error? I need to fix this, because I definitely want to make this database and keep following these awesome courses. Thank you.
@@kyanos-asteras I'd go back and watch the videos again and follow them exactly. I can't guess where you went wrong..
how can you get the oid of any table?
I think I have a video on that in the playlist somewhere...
@@Codemycom I don't see it, can you please tell the name of it?
hello while i am writing .....
c.execute("""CREATE TABLE addresses (
first_name text,
last_name, text
)""")
all appears as text in the (""" """) no commands!! what Is my syntax problem?
Same
@@Al-he6bs i found the solution!!! There is NO problem . by writing 3 quotation marks you can write comments in the next line and generally . With 1 quotation mark you can write comments only in 1 row . There is no any command !!! you simple write comments and it is working ! see next video and do the same with the quy and you will figure out
@@iliaspelekis1765 So basically, we just have to ignore them being a string. All green colors but working as what they are intended to.
@@Al-he6bs basically just tested ! the program still working if I put them as comments (#). i think we write them down for future use .
Pls tell me what does the database does
databases store data
@@Codemycom thank you.
Do I need to learn SQL before I learn database in Tkinter
Not really, you can follow along in the videos...but it couldn't hurt.
@@Codemycom Ok Sir,
Thanks for replying🙏
💯💯💯💯💯
Thanks!
I don't completly got why it's better to use sqlite3 than using a simple .txt file to store data.
Could anyone explain it in a few words? :D
databases are better in every conceivable way.
@@Codemycom Oh okay. Thanks for answering :)
It getting error as no module PIL.. what should I do ?
pip install Pillow
@@CodemycomThank you so much for answering my doubt. But I have already installed pip even it's not working.
@@pranalibansode3922 Some people just have trouble with it. You'll have to google it
@@CodemycomOk. Thank you so much. But your tutorials are excellent. Just thanks for sharing your knowledge heartly.
sorry,
what is meant by PIL import ImageTk, image. program doesn't work because of that
You must install Pillow from the terminal
@@Codemycom and I also have a problem with root.iconbitmap
is this error-checked?
lol
what the purpose of root.iconbitmap('c:/gui/codemy.ico')? thanks later
To add the icon to the top bar of the program
@@Codemycom. But if I don't add that to the codings, will the codings make it to the end?
@@teguh7201 You don't need to add an icon if you don't want to
@@Codemycom Okay... Thank you. Your channel so helpful.
@@teguh7201 Glad you like it!
Hi My Brother And My Good Teacher Who I Learned Many Lessons From Your Teaching Here And I Have One Question That Is About My New Program Thst Is A Phonebook I Am Writing And My Question Is About Checkbutton And Button That I Want To Make One List Of Numbers With Name And Familly And Address From Database That I Made That This List Have 1 Checkbutton For Each Number And Two Buttons For Edit And Delete Now I Am Looking One Way To Know How These All Checkbuttons And Buttons In List Have Conection To Each Other That This Mean Every Record From Database In List With One Checkbutton And To Buttons For That Be In One Conection That When That Checkbutton Is Selected These To Buttons For Edit And Delete Work For That Button So We Have To Conection Here Every Record In This List Need To Be Conect With Checkbutton And Buttons To Operate On It And This Change In Database Be In See.
Thank You Very Much God Belesed You And Your Love And Your Familly .
Why do you use "from tkinter import *" instead of just typing "import tkinter"?
Because that's how it needs to be.
@@Codemycom Does that apply to other internal functions like "os"?
@@ahmedelsayed3133 no, everything has it's own rules.
Traceback (most recent call last):
File "C:\gui\database.py", line 2, in
from PIL import ImageTk,Image
ModuleNotFoundError: No module named 'PIL'
sorry im noob pls help how to get into the ternimal
pip install pil
pip install pillow
same no module named pil
@@Codemycom my windows environment cmd prompt yielded no love
i just removed the pil and icon stuff more of a hassle than what its worth
@@kurtauerbach5883 I had the same problem :
Please try in terminal :
"pip install Pillow" with capital "P",
and then in head - "from PIL import ImageTK, Image
It works for me, hope it will for you
Have a good one
I copied the same code.. There was an error
then you don't have the same code...
You might have trouble with using integer for zipcode unless you can add leading zeros. Look at www.maphill.com/united-states/alaska/zip-codes-00001-00122/
CREATE TABLE IF NOT EXISTS addresses. then no need to comment out the code !
Yep
It says PIL module not found
did you pip install pillow?
Yes
Are you sure? are you using a virtual environment? Is it installed in there? Do you see it when you type: pip freeze
I installed python 3.8..my friend told me that pip would be there already.
@@leeganghalley6477 pip is there, but I asked about PIL not pip
Walter
lol
So Walter White teaches Python?
Apparently!