▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My KZread 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

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.

@Codemycom

4 жыл бұрын

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 :)

@Codemycom

4 жыл бұрын

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 !

@Codemycom

2 жыл бұрын

Happy to hear it!

I hope u get rich with doing things like sharing this knowledge :). Thanks for sharing

@Codemycom

4 жыл бұрын

That'd be great :-p

I love the way you simplify things! bless you

@Codemycom

3 жыл бұрын

Glad you like them!

I just love the way u ask "What's going on guys?!!!"😂😂❤️ Keep up the good work

@Codemycom

3 жыл бұрын

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.

@Codemycom

3 жыл бұрын

Happy to hear it!

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

@Codemycom

Жыл бұрын

I appreciate it!

Thank you so much John for the amazing tutorial; it was really helpful.

@Codemycom

3 жыл бұрын

Glad you liked it!

Thanks John, these courses helped a great deal.

@Codemycom

3 жыл бұрын

Glad you liked them!

I am a high school Spanish teacher that is learning Python. You have the best videos on KZread 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 KZreadrs implement that. Thank you for everything.

@Codemycom

3 жыл бұрын

Glad you're enjoying the videos!

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... :)

Thanks so much !!! Clear & Well explained. Regards.

@Codemycom

2 жыл бұрын

You are welcome!

Really helpful!

@Codemycom

3 жыл бұрын

Glad it was helpful!

Thanks for this great tutorial

@Codemycom

Жыл бұрын

Welcome!

Hey Baldy bro TNX.for this stuff

@Codemycom

3 жыл бұрын

Sure thing

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

Hi, thank you very much for your video.

@Codemycom

3 жыл бұрын

Thank you too

Thanks a lot sir.you are the best

@Codemycom

3 жыл бұрын

Thanks!

thanks for this tuto :)

@Codemycom

4 жыл бұрын

Sure thing!

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

@Codemycom

Жыл бұрын

Awesome, I have videos on that in the playlist :-p

@Lennardish

Жыл бұрын

@@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 🙂

@Codemycom

Жыл бұрын

@@Lennardish Thanks!

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?

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

Un big merci (:

Why this channel has only 38k subs this channel deserves more and yes Be sure to smash the like button

@Codemycom

3 жыл бұрын

I agree! Tell your friends about it ;-)

Thanks a lot

@Codemycom

4 жыл бұрын

Happy to help

Thank you😊

@Codemycom

4 жыл бұрын

You're welcome!

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!

@INSANE_-nj4xh

2 жыл бұрын

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

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!

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?

@nickpavlou5023

Жыл бұрын

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: kzread.info/dash/bejne/gKOIr5qDk8y9kbQ.html

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.

@Codemycom

Жыл бұрын

Yes, of course.

By the way zipcode should be treated as text As no math applied to it Any way keep going man I like your videos 👍

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?

@Codemycom

3 жыл бұрын

Once you create all that stuff once, you need to remove that code and not create them again.

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)

Sir I need to get messagebox error if identity already exists in database with aded function

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.

@luizportela2590

3 жыл бұрын

Turn on the MySQL and Apache on your Xampp and ready.

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.

@Codemycom

4 жыл бұрын

Not really sure what you mean, but give it a try to see.

@vagisangovindan7123

4 жыл бұрын

@@Codemycom Got it figured out. Thanks a lot for your 6 hour tutorial. helped a ton.

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

@Codemycom

4 жыл бұрын

Not with TKinter

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.

@Codemycom

3 жыл бұрын

connect to a server for what?

@ebaadkhan8501

3 жыл бұрын

@@Codemycom if i created a heavy app then i need a server for user authentication and more things

@Codemycom

3 жыл бұрын

@@ebaadkhan8501 what's a heavy app?

@ebaadkhan8501

3 жыл бұрын

@@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

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?

@Codemycom

Жыл бұрын

no. how could it? Your database is on your computer. Their database is on their computer.

could this be done with postgreSQL instead of SQlite?

@Codemycom

4 жыл бұрын

Sure, fairly easily

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??

@Codemycom

4 жыл бұрын

No one can answer that, it depends entirely on what you're trying to do and what your needs are.

This video was very useful...but can you also do one with MySQL too

@Codemycom

4 жыл бұрын

I have a python mysql course

@varman8048

4 жыл бұрын

@@Codemycom oh okay didn't see that...thank you keep it up bro

@Codemycom

4 жыл бұрын

@@varman8048 will do

Sir how I can make a installer of python tkinter exe file which uses database

Could you make a video about Json with tkinter python please thanks

@Codemycom

4 жыл бұрын

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 just wanted to ask if you have a video about the user will input info and it will automatically be in the database. :)

@Codemycom

3 жыл бұрын

Of course

@stephenaubreyantonio8110

3 жыл бұрын

@@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)

@Codemycom

3 жыл бұрын

@@stephenaubreyantonio8110 You're using Anaconda instead of regular python..could be because of that

@stephenaubreyantonio8110

3 жыл бұрын

@@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

@larslover6559

2 жыл бұрын

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.

What if i want date datatype and want to sort records by date or something?

@Codemycom

2 жыл бұрын

Do it in the normal way

I dont have any knowledge of databases,so can i continue with the course or should i learn about basics of Database?

@KristoKorps

3 жыл бұрын

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.

@pranavguptaa

3 жыл бұрын

@@KristoKorps Yeah,sure🙂

how to do analogue clock in tkinter

Please I want a possible solution for these error on c.fetchall..... AttributeError: 'sqlite3.Connection' object has no 'fetchall'

@Codemycom

3 жыл бұрын

you have a typo in your code

on click button redirect to another page in python using tkiner library... how can it do sir????? ]

@Codemycom

4 жыл бұрын

What do you mean by page? Tkinter doesn't have pages

Can you do one with SQL Server?

@Codemycom

3 жыл бұрын

No sorry, that's a Microsoft thing

💯💯💯💯💯

@Codemycom

Жыл бұрын

Thanks!

"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?

@Codemycom

3 жыл бұрын

sqlite3 comes with python, there's nothing to install

@kyanos-asteras

3 жыл бұрын

@@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.

@Codemycom

3 жыл бұрын

@@kyanos-asteras I'd go back and watch the videos again and follow them exactly. I can't guess where you went wrong..

Do I need to learn SQL before I learn database in Tkinter

@Codemycom

4 ай бұрын

Not really, you can follow along in the videos...but it couldn't hurt.

@four-xdimension2486

4 ай бұрын

@@Codemycom Ok Sir, Thanks for replying🙏

how can you get the oid of any table?

@Codemycom

4 жыл бұрын

I think I have a video on that in the playlist somewhere...

@generalpinochet9821

4 жыл бұрын

@@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?

@Al-he6bs

3 жыл бұрын

Same

@iliaspelekis1765

3 жыл бұрын

@@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

@Al-he6bs

3 жыл бұрын

@@iliaspelekis1765 So basically, we just have to ignore them being a string. All green colors but working as what they are intended to.

@iliaspelekis1765

3 жыл бұрын

@@Al-he6bs basically just tested ! the program still working if I put them as comments (#). i think we write them down for future use .

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?

@Codemycom

7 ай бұрын

I never recommend visual studio

@ryano699

7 ай бұрын

@@Codemycom what IDE do you use in these videos

@Codemycom

7 ай бұрын

Sublime Text and the Git-scm.com terminal @@ryano699

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 .

Pls tell me what does the database does

@Codemycom

2 жыл бұрын

databases store data

@asf196

2 жыл бұрын

@@Codemycom thank you.

It getting error as no module PIL.. what should I do ?

@Codemycom

3 жыл бұрын

pip install Pillow

@pranalibansode3922

3 жыл бұрын

@@CodemycomThank you so much for answering my doubt. But I have already installed pip even it's not working.

@Codemycom

3 жыл бұрын

@@pranalibansode3922 Some people just have trouble with it. You'll have to google it

@pranalibansode3922

3 жыл бұрын

@@CodemycomOk. Thank you so much. But your tutorials are excellent. Just thanks for sharing your knowledge heartly.

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

@Codemycom

3 жыл бұрын

databases are better in every conceivable way.

@holycow4889

3 жыл бұрын

@@Codemycom Oh okay. Thanks for answering :)

Why do you use "from tkinter import *" instead of just typing "import tkinter"?

@Codemycom

Жыл бұрын

Because that's how it needs to be.

@ahmedelsayed3133

Жыл бұрын

@@Codemycom Does that apply to other internal functions like "os"?

@Codemycom

Жыл бұрын

@@ahmedelsayed3133 no, everything has it's own rules.

sorry, what is meant by PIL import ImageTk, image. program doesn't work because of that

@Codemycom

3 жыл бұрын

You must install Pillow from the terminal

@teguh7201

3 жыл бұрын

@@Codemycom and I also have a problem with root.iconbitmap

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

@Codemycom

4 жыл бұрын

pip install pil pip install pillow

@kurtauerbach5883

4 жыл бұрын

same no module named pil

@kurtauerbach5883

4 жыл бұрын

@@Codemycom my windows environment cmd prompt yielded no love

@kurtauerbach5883

4 жыл бұрын

i just removed the pil and icon stuff more of a hassle than what its worth

@BeerTrooper

4 жыл бұрын

@@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

is this error-checked?

@Codemycom

Жыл бұрын

lol

what the purpose of root.iconbitmap('c:/gui/codemy.ico')? thanks later

@Codemycom

3 жыл бұрын

To add the icon to the top bar of the program

@teguh7201

3 жыл бұрын

@@Codemycom. But if I don't add that to the codings, will the codings make it to the end?

@Codemycom

3 жыл бұрын

@@teguh7201 You don't need to add an icon if you don't want to

@teguh7201

3 жыл бұрын

@@Codemycom Okay... Thank you. Your channel so helpful.

@Codemycom

3 жыл бұрын

@@teguh7201 Glad you like it!

I copied the same code.. There was an error

@Codemycom

3 жыл бұрын

then you don't have the same code...

CREATE TABLE IF NOT EXISTS addresses. then no need to comment out the code !

@Codemycom

Жыл бұрын

Yep

It says PIL module not found

@Codemycom

3 жыл бұрын

did you pip install pillow?

@leeganghalley6477

3 жыл бұрын

Yes

@Codemycom

3 жыл бұрын

Are you sure? are you using a virtual environment? Is it installed in there? Do you see it when you type: pip freeze

@leeganghalley6477

3 жыл бұрын

I installed python 3.8..my friend told me that pip would be there already.

@Codemycom

3 жыл бұрын

@@leeganghalley6477 pip is there, but I asked about PIL not pip

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/

So Walter White teaches Python?

@Codemycom

4 жыл бұрын

Apparently!

Walter

@Codemycom

Жыл бұрын

lol