▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My RU-vid 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 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 :)
I am a high school Spanish teacher that is learning Python. You have the best videos on RU-vid 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 RU-vidrs implement that. Thank you for everything.
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
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... :)
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 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 🙂
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.
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
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NoTM8JciWaQ.html
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
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!
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.
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
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?
@@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)
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.
Is it possible to have a function that creates a database using Python and TKinter GUI? Let's say you have an Entry Field and Button. Then you pass the information from the entry field to the function tied to the Button (i.e. "submit"). The submit function then creates a database with the name of whatever string was passed from the entry field to the submit function. Is this possible?
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?
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?
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 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 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
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)
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??
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.
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 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
"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 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.
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 .
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?
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
@@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
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/