▶️ 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
Someone is sitting in the shade today because someone planted a tree a long time ago. Appreciate your efforts. This series has helped me a lot. Thanks a lot.
jhon keeps bumping his head into different things every week oh also thanks for the awesome content.(really without you i wouldn't have made my project)
Love the videos. Very easy to follow and understand. Thank you so much for providing these!! Quick question tho. I’m new to a bunch of this stuff. Is this a standalone program that needs to be stalled on a computer or would your program be ran inside a browser window? Also does this program as it sits, have the functionality to be opened in many different instances by multiple users and allow them to create, update and delete records from the GUI or limited to single user? Thanks for taking the time to provide this content and for reading my questions
awesome videoseries. the explanations are nice and clear. helped me a lot to do some own works and project. love your videos and the way how you teach :)
Thanks for your video. I learnt a lot for your videos. I have one question on this video. Why don't you use toplevel() to create the edit window instead of creating it just like root?
@@Codemycom ya I thought ur next video would be a continuation of the same project... 😁 Because at d end of d video u had said that in the next video we will look at drop-down and stuff...
hi! in 11:51 i have an syntax error 'oid' : record_id Syntax Error = no such column: addresses i copied your code in github and same syntax error plz replay i need help to that
Exception in Tkinter callback Traceback (most recent call last): File "C:\Python\Python39\lib\tkinter\__init__.py", line 1885, in __call__ return self.func(*args) File "C:\Users\azmin\latihan pbd\databasepasien.py", line 40, in update c.execute("""UPDATE addresses SET sqlite3.OperationalError: no such column: tanggal_lahir sir please clarify I getting tied
Hey John thank you very much for your videos. Is there concern with sql injection when we put SET first_name = :first WHERE oid = :oid - Should we instead be using a place holder like =? Or is this not a concern with certain projects that may not be on the internet? Thanks again for your insight
Hey @Codemy.com I keep getting an error that says the following. 'oid': record_id sqlite3.OperationalError: near "text": syntax error Any help would be appreciated. Thanks!
5:15 , in mycase the primary key to be compared is a varchar type, how would i compare it c.execute("SELECT * FROM matchs where match_id="+ to_update_match_id ) varchar type content is written in to_update_match_id
Codemy.com I did watch a video you did on scroll bars just not sure how to go about it on this as the label box only shows up once button is clicked also trying to sort out the strange text overlay when refreshed. I wonder if setting the label to show always less the text would work? I will be doing a lot of learning on your website as I think I am trying to run before I can walk. Who says you can’t teach an old dog new tricks.
is there a way to search the database for a string or collection of strings? EDIT: found a way to search using LIKE but its only pulling one record even with fetchall() and fetchmany() and it also has to match the entry in that column exactly, so if i have a name and want to search for it partially EDIT 2: so this is where im at (made it easier to read) cursor.execute(" SELECT *, oid FROM customer WHERE f_name IN Customer LIKE :name", ('name': (f_name.get(),))) basically what im trying to do is make a button for looking up names in the database and displaying them to a label
When you do editing buttons you have to use classes, if you don't do that you will have problems with editing clients e.g. with the same name, because the variable x is still overwritten
Something like that class Button12: def __init__(self, id2, index, x): self.id2 = id2 self.index=index self.x=x def cbutton(self): num=0 edit_button = Button(ramka, text="Edit "+str(x[4]),command=lambda: edit_now(self.index, self.id2)) edit_button.grid(row=self.index, column=num) for y in x: searched_label = Label(ramka, text=y) searched_label.grid(row=self.index, column=num+1) num += 1
if not result: result = "Record not found..." else: print(result) id_reference=[] for index, x in enumerate(result): id2=str(x[4]) p1 = Button12(id2, index, x) p1.cbutton()
Open your version of this application and try to edit the first person on the list when there are at least 2 people on the list. An error will occur and the data of person 2 will be displayed for person 1
Hallo John, this SQLite Part of this trainig was very helpful for me. I've created a project-Database but when I click the save Button in the edit Window, the changes havn't be done. Do you have an idea whats wrong? I dind't get an error massage, so its hard to find the missmatch. Thanks, klaus
Hey man these tutorials are really proving a valuable asset in learning this material but I noticed that there isn’t a tutorial which has the other stuff that you were talking about at the end of the video, is there a video with those topics on codemy.com?
@@Codemycom I think that was the point of it: it can't. I figured the purposed would've been to trigger some kind of error saying "Hey this doesn't exist, please enter a valid UID" or something
hello . Is this the end of the program ? I kinda need to finish one of those for a school project and your tutorial is great for me . but I can tell its not finised .
Hello sir, please hear my comment. What could be this error im getting.. File "C:\gui\database.py", line 37, in update c.execute("""UPDATE addresses SET sqlite3.OperationalError: no such column: mobile I changed the zipcode to mobile and rechecked all the operation that caused it but i cant find it. Any help will do.
Hey guys. I also included a bug in my code. I am executing the code with Spyder. When hitting the save button i have the following error message: 'oid' record_id sqlite3.Warning: You can only execute one statement at a time. Do you have any suggestions how to fix it? So in fact, when i hitthe save button in the new window nothing happens - it neither updates the record, nor does it destroy the window. Appreciating any advice :-)
I replaced c.execute with c.executescript to pass more then one statement and now got the following error: typeerror function takes exactly 1 argument (2 given). Is it a typo or was there some sqlite3 update?
@@Codemycom Thanks mate! Got it now. It was only an indentation error. Suggesting all the python beginners to check for possible indentation errors iteratively. Sublime editor helps to figure out the indentation errors visually. Using spyder i fixed it with a built-in fix for indentation errors. Unfortunately, the error message in the console was misleading.
hey . sorry to bother you . but I need some help with something. an I said in a previews comment your tutorial is great for what I need . its perfect actually. but I need to add one more thing. I have to create a DB for employees of a firm . and I need to add a button who will reduce every employee's salary with 5% . I have no idea how to do that, but I do know its simple . I just cant figure it out. can you help me with that ?
@@Codemycom ok . I found how . But I get an error . TypeError : cant multiply sequence by non-int of type 'float'. I cant figure it out . And it doesnt work if I make that sequence an int .
@@pheebs8571 the salary is coming out of the database as an integer, to multiple by a decimal number (.05) you need to convert it to a float...wrap the salary in a float() function... like float(salary) - (float(salary)*.05)
@@Codemycom so i am trying to build a CRM and i people able to have a account and be able to log into it but im not sure how to link a entry bar with the database to look for a certain username or password
your videos are great but i keep getting this error even thought i wrote the code correctly : c.execute("""UPDATE addresses SET sqlite3.OperationalError: no such column: address i dont know what to do
@@Codemycom i understand but the problem is that i am following along with your video and I wrote the code the same as you but I really don't know what to do
I get and error that says File "C:/Users/colin/PycharmProjects/hello_world/venv/Data Bace App with Tkinter.py", line 203, in update c.execute("""UPDATE adresses SET sqlite3.InterfaceError: Error binding parameter :new - probably unsupported type. any help would be appreciated
@@Codemycom thats basicly it, 'oid' : record_id therr is no other error, if i delete it then it just goes up a line and gives the same error for 'zipcode' : zipcode_editor.get(),
@@borgyoh Yeah, the whole block of code has an error in it somewhere. Somewhere in the c.execute("""UPDATE addresses SET... block...likely in the WHERE clause section you used a wrong quotation mark or something. Or you left out a comma somewhere..or something. Plus where is the colon ('oid': record_id) your first comment had it like this 'oid' :record_id (next to record_id which is wrong).
@@Codemycom AAAAAAHHH!!! i found the problem, fixed it, yeah it was a typo... i went over it again and again...never noticed it. why cant we get away with bad grammar in coding? anyways, thanks for your tutorials and thanks for replying. i will try not to bother you until i make ultra sure what the error is. maybe i need to buy glassess
@@borgyoh no worries...it's always hard to catch typos...our brains just pass over them. Sometimes I have to leave the code for a day or two and then look at it again before the typo jumps out and I notice it lol
▶️ 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
Someone is sitting in the shade today because someone planted a tree a long time ago. Appreciate your efforts. This series has helped me a lot. Thanks a lot.
Glad you enjoy them!
Thanks, John. You are a great teacher!
thanks for watching!
he deserves so more he keeps on creating so good videos I hope you will touch stars one day coz you are awesome
Thanks, I appreciate it!
jhon keeps bumping his head into different things every week
oh also thanks for the awesome content.(really without you i wouldn't have made my project)
Ha, yep!
Love the videos. Very easy to follow and understand. Thank you so much for providing these!! Quick question tho. I’m new to a bunch of this stuff. Is this a standalone program that needs to be stalled on a computer or would your program be ran inside a browser window? Also does this program as it sits, have the functionality to be opened in many different instances by multiple users and allow them to create, update and delete records from the GUI or limited to single user? Thanks for taking the time to provide this content and for reading my questions
Uppppssss! Hope you are not badly hurt John!!
Thank you for your efforts and clear explanations! :)
Very welcome!
Great job sir
thanks
awesome videoseries. the explanations are nice and clear. helped me a lot to do some own works and project. love your videos and the way how you teach :)
Glad you like them!
Thank you sir it helps me a lot on my project...thank you so much
very usefull tutorial 👍
Glad you enjoyed it!
Thanks for your video. I learnt a lot for your videos. I have one question on this video. Why don't you use toplevel() to create the edit window instead of creating it just like root?
Day 95: Still waiting for the next video in this project series. :D
lol there are 150 videos in this playlist...did you not know where to look?
@@Codemycom after this video u started a new project itself.. a whether app.
@@mm333-e1t Yeah and then 100 other videos.
@@Codemycom ya I thought ur next video would be a continuation of the same project... 😁 Because at d end of d video u had said that in the next video we will look at drop-down and stuff...
I might be getting a head of the lessons but would be nice to offset the new window when it opens instead covering the current window?
Hi, thank you very much for your video.
Thank you too
hi!
in 11:51 i have an syntax error
'oid' : record_id
Syntax Error = no such column: addresses
i copied your code in github and same syntax error
plz replay i need help to that
I don't suggest copying code, errors like this occur
Very good .. when you are doing other Video on this you mention on the end
soon
Exception in Tkinter callback
Traceback (most recent call last):
File "C:\Python\Python39\lib\tkinter\__init__.py", line 1885, in __call__
return self.func(*args)
File "C:\Users\azmin\latihan pbd\databasepasien.py", line 40, in update
c.execute("""UPDATE addresses SET
sqlite3.OperationalError: no such column: tanggal_lahir
sir please clarify I getting tied
i get that same problem too
we have a same problem
Hey John thank you very much for your videos. Is there concern with sql injection when we put SET first_name = :first WHERE oid = :oid - Should we instead be using a place holder like =? Or is this not a concern with certain projects that may not be on the internet? Thanks again for your insight
Hey @Codemy.com I keep getting an error that says the following.
'oid': record_id
sqlite3.OperationalError: near "text": syntax error
Any help would be appreciated. Thanks!
its a syntax error, most likely you need a space after the : and before the record_id
5:15 , in mycase the primary key to be compared is a varchar type, how would i compare it
c.execute("SELECT * FROM matchs where match_id="+ to_update_match_id
)
varchar type content is written in to_update_match_id
A primary key can't be a varchar...a primary key is definitionally a number, an integer
Thanks, the course was a great help!
@@guitarec4105 Glad you found it useful!
Enjoyed this project would love to see a scroll bar on the list etc. Any chance of any further projects with sqlite3?
Might do more sqlite...think I did a scollbar already
Codemy.com I did watch a video you did on scroll bars just not sure how to go about it on this as the label box only shows up once button is clicked also trying to sort out the strange text overlay when refreshed. I wonder if setting the label to show always less the text would work? I will be doing a lot of learning on your website as I think I am trying to run before I can walk. Who says you can’t teach an old dog new tricks.
is there a way to search the database for a string or collection of strings?
EDIT: found a way to search using LIKE but its only pulling one record even with fetchall() and fetchmany() and it also has to match the entry in that column exactly, so if i have a name and want to search for it partially
EDIT 2: so this is where im at (made it easier to read)
cursor.execute("
SELECT *, oid
FROM customer
WHERE f_name
IN Customer
LIKE :name", ('name': (f_name.get(),)))
basically what im trying to do is make a button for looking up names in the database and displaying them to a label
You are quite clever. This program is awesome and I learned a lot. Thx. ◉‿◉
Thanks Slick Willie!
i like the videos u make .thank u
Thanks for watching!
@@Codemycom really i follow u from lebanon . And all my friends in my uni watch ur vids and get benifit alot from ur experience. ❤👍
@@Acuce7ibd468j Awesome!
Is there anywhere we can find the code of the whole program?
Thank you and great work you are helping us a lot!
GitHub.com/flatplanet
When you do editing buttons you have to use classes, if you don't do that you will have problems with editing clients e.g. with the same name, because the variable x is still overwritten
Something like that
class Button12:
def __init__(self, id2, index, x):
self.id2 = id2
self.index=index
self.x=x
def cbutton(self):
num=0
edit_button = Button(ramka, text="Edit "+str(x[4]),command=lambda: edit_now(self.index, self.id2))
edit_button.grid(row=self.index, column=num)
for y in x:
searched_label = Label(ramka, text=y)
searched_label.grid(row=self.index, column=num+1)
num += 1
if not result:
result = "Record not found..."
else:
print(result)
id_reference=[]
for index, x in enumerate(result):
id2=str(x[4])
p1 = Button12(id2, index, x)
p1.cbutton()
Not true. There are always infinite ways to do anything. If you like classes, use them. But you certainly don't have to.
Open your version of this application and try to edit the first person on the list when there are at least 2 people on the list. An error will occur and the data of person 2 will be displayed for person 1
I was able to fix it only by using a class, but maybe there are other ways
@@filipk2834 worked fine
Sir , what kind of jobs we can get after full learning of database with python
You can get jobs programming databases with python :-p
Hallo John, this SQLite Part of this trainig was very helpful for me. I've created a project-Database but when I click the save Button in the edit Window, the changes havn't be done. Do you have an idea whats wrong? I dind't get an error massage, so its hard to find the missmatch. Thanks, klaus
Look to the section of your code that saves to the database, you likely left out something
AMAZING
Glad you liked it :-)
Hey man these tutorials are really proving a valuable asset in learning this material but I noticed that there isn’t a tutorial which has the other stuff that you were talking about at the end of the video, is there a video with those topics on codemy.com?
what other stuff was that? (I recorded this video like a year ago, don't remember what you're referring to)
@@Codemycom drop down box with records, what to do if you try and edit a record that doesn't exist, maybe edit record indicies?
@@danielmayper6548 How could that happen? If the record doesn't exist, how could it be in the drop down box?
@@Codemycom I think that was the point of it: it can't. I figured the purposed would've been to trigger some kind of error saying "Hey this doesn't exist, please enter a valid UID" or something
@@danielmayper6548 Nah, if a record doesn't exist, it couldn't be populated in a drop down box that pulls records from the database.
I modified your code sir, Instead of opening the records in show records in the label, I opened them in notepad.
ok
will u plz tell me how many classes and how function are there in tkinter module?
Sorry, I have no idea what you're asking...
How many module are there in tkinter....
hello . Is this the end of the program ? I kinda need to finish one of those for a school project and your tutorial is great for me . but I can tell its not finised .
I'll probably add more to it, or continue on with more tkinter tutorials. Super busy with another project at the moment though...
Hello sir, please hear my comment.
What could be this error im getting..
File "C:\gui\database.py", line 37, in update
c.execute("""UPDATE addresses SET
sqlite3.OperationalError: no such column: mobile
I changed the zipcode to mobile and rechecked all the operation that caused it but i cant find it.
Any help will do.
it's telling you that you didn't actually change the column name to mobile like you think you did
@@Codemycom I try changing it all to zipcode and it finally works haha. BTW, thanks for this video, now i have a project.
@@erzio1254 awesome
Which is the next tutorial in this series (ie the SQL Addresses Database) - No 24 starts off on a different topic
#24 is the next one
I am getting the error while updating the record (sqlite3.OperationalError: near ".": syntax error). What might be the issue?
The error is telling you what the issue is.
is there any video to see how to make the game automatically update the score of a player if a game ends if the score is bigger?
what game is that?
I dont know what mistake have i done in my code but the changes made in the entry box is not updated.....Can u plzz help me???
My entry box is also not update and I gives error on 'oid ': record _id
@Yogi pedia it looks like you have a space in your code between the d and the ‘, maybe using ‘oid’: record_id will help over ‘oid ‘: record_id
SIR , at what age you started coding?
I was 8 years old when I started
@@Codemycom sir people say that C++,Java is better than python
But i really like python
@@AnujKumar-xn5tg Me too...Java is a nightmare
Hello how can I fix this error ?: sqlite3.OperationalError: no such column: f_name
add a column named f_name to your model
Hey guys. I also included a bug in my code. I am executing the code with Spyder. When hitting the save button i have the following error message: 'oid' record_id sqlite3.Warning: You can only execute one statement at a time. Do you have any suggestions how to fix it? So in fact, when i hitthe save button in the new window nothing happens - it neither updates the record, nor does it destroy the window. Appreciating any advice :-)
I replaced c.execute with c.executescript to pass more then one statement and now got the following error: typeerror function takes exactly 1 argument (2 given). Is it a typo or was there some sqlite3 update?
you have an error somewhere
@@Codemycom Thanks mate! Got it now. It was only an indentation error. Suggesting all the python beginners to check for possible indentation errors iteratively. Sublime editor helps to figure out the indentation errors visually. Using spyder i fixed it with a built-in fix for indentation errors. Unfortunately, the error message in the console was misleading.
hey . sorry to bother you . but I need some help with something. an I said in a previews comment your tutorial is great for what I need . its perfect actually. but I need to add one more thing. I have to create a DB for employees of a firm . and I need to add a button who will reduce every employee's salary with 5% . I have no idea how to do that, but I do know its simple . I just cant figure it out. can you help me with that ?
Just do it in the exact same way as the videos but subtract 5% from the salary output... salary - (salary * .05)
@@Codemycom ok . I found how . But I get an error .
TypeError : cant multiply sequence by non-int of type 'float'. I cant figure it out .
And it doesnt work if I make that sequence an int .
@@pheebs8571 the salary is coming out of the database as an integer, to multiple by a decimal number (.05) you need to convert it to a float...wrap the salary in a float() function... like float(salary) - (float(salary)*.05)
@@Codemycom yep. That worked . Thanks for your time . And good luck in what you do
@@pheebs8571 sure thing!
Is there a way to link this to a signin page
what do you mean a signin page?
@@Codemycom so i am trying to build a CRM and i people able to have a account and be able to log into it but im not sure how to link a entry bar with the database to look for a certain username or password
@@lockespc @pixelmasters I have tons of videos on using databases with tkinter.
your videos are great but i keep getting this error even thought i wrote the code correctly :
c.execute("""UPDATE addresses SET
sqlite3.OperationalError: no such column: address
i dont know what to do
It's telling you there is no column called address, you likely forgot to create a column or named it something slightly different.
@@Codemycom i understand but the problem is that i am following along with your video and I wrote the code the same as you but I really don't know what to do
@@hibasmi7997 No, you didn't write the code the same as me. You have a typo or forgot to create the column.
I get and error that says
File "C:/Users/colin/PycharmProjects/hello_world/venv/Data Bace App with Tkinter.py", line 203, in update
c.execute("""UPDATE adresses SET
sqlite3.InterfaceError: Error binding parameter :new - probably unsupported type.
any help would be appreciated
Pycharm sucks...I can't help you with that. Try using the tools I do.
i'm getting an error i did many other ways but still getting errors in update section will you please help me with it
What's the error? Did you google the exact error? (copy and paste it right into google)
some of the data doesn't update?
help?
check your code for typos
SIR I DONE THIS BUT ERROR "sqlite3.ProgrammingError: You can only execute one statement at a time." I CAN'T FIND IT
PLZ MAKE SOLUTION
Check your code to discover what you did differently from the video, that is the only solution.
ok@@Codemycom
Anyone have the code to add a search field.
But ,Sir how these stuff can form a website ??
Sorry i mistakenly commented here
I am talking about the CRM one
you can’t. tkinter is not a website tool
@@Codemycom Sir, your codemy.com site is made by using coding .PYTHON??
i keep getting a unrecognized token error ":"
'oid' :record_id
likely a typo in your code...can't tell without seeing it.
@@Codemycom thats basicly it,
'oid' : record_id
therr is no other error, if i delete it then it just goes up a line and gives the same error for
'zipcode' : zipcode_editor.get(),
@@borgyoh Yeah, the whole block of code has an error in it somewhere. Somewhere in the c.execute("""UPDATE addresses SET... block...likely in the WHERE clause section you used a wrong quotation mark or something. Or you left out a comma somewhere..or something. Plus where is the colon ('oid': record_id) your first comment had it like this 'oid' :record_id (next to record_id which is wrong).
@@Codemycom AAAAAAHHH!!! i found the problem, fixed it, yeah it was a typo... i went over it again and again...never noticed it. why cant we get away with bad grammar in coding? anyways, thanks for your tutorials and thanks for replying. i will try not to bother you until i make ultra sure what the error is. maybe i need to buy glassess
@@borgyoh no worries...it's always hard to catch typos...our brains just pass over them. Sometimes I have to leave the code for a day or two and then look at it again before the typo jumps out and I notice it lol
why did to write (WHERE oid = :oid)
huh?
In video 22 of tkinter.
I am unable to understand the following.
WHERE oid = :oid
Aye yo..someone do me a solid and put the whole code in comments for me to copy and paste
yes please someone come in clutch
@@ricky5870 Don't be lazy, write the code yourself or you won't learn it.
github.com/flatplanet/Intro-To-TKinter-RUclips-Course
Codemy.com will do boss, replying to me have me motivation 👍
@@ricky5870 ha good
Where is the source code?
github.com/flatplanet
ERROR =Operation Error: no such column: frist_name.. sir please clarify... I getting tied
Check your code for errors