Had fun with this one, put all the create, delete, query in functions, created a second windows with buttons so I did not have to go modify the code every time I made a mistake with the table 2 years since it's up, still helpful thank you
This is great. Back in the days before RUclips, learning how to write a simple GUI driven app with a database backend would have entailed a chunky textbook, several weeks and way too much theory to be worked through. You got all this into a 25 minute video. Well done!
▶️ 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 Take $22 off with coupon code: youtube
Hi, Your videos are amazing and Very useful in a good representation manner. Easily understand in every steps. If possible, please put your using codes video in description may help to others. Because while watching your video that speed they can't write the code, every time rewind, replay or pause the video then check the execution. Sorry if i'm wrong ..
Thanks again for the helpful video, I was curious about something though. I noticed around 14 minutes in that you were able to go through the entry boxes very quickly as though you had a key-binding for arrowing-down between entry boxes. Would you happen to have a key binding tutorial for entry boxes or an explanation on how to navigate between the entry boxes after running the program? I am currently having to manually click between entry boxes, and testing the various functions this way is time consuming.
Hello sir, i have a confusion. When you create the table and you put it only five columns in there (firstname, lastname, zipcode, pricepaid & user id), and you have created the 13 entry for the the five column and it works i dont know how is it possible. Can you explain
Hello john, thanks for the video. It really helps me to enhance my tkinter skills. I also designed a small registration form, there's not a single error in the program but after printing result I got "(' ', ' ')" this as a output. You got entries as a output , but I didn't get the data which I entered on the form. Can you please help me?
Emmm... for the label and grid, I have them in separate lines but I'm still getting AttributeError "nonetype' object has no attribute 'get'. I can't seem to find out what the problem is... so after entering text and click add customer to database, the text doesn't go away...
You grid the entry in one line therefore the attribute error occurs entry = Entry(root).grid() -> Error Therefore the attribute error occurs You have to separate these in two lines
John, when I run the statement inside the add_customer function, I am getting an error in the statement my_cursor.execute(sql_command, values). The error is as follows: Exception in Tkinter callback Traceback (most recent call last) self.sock.sendall(packet) OSError: [WinError 10038] An operation was attempted on something that is not a socket During handling of the above exception, another exception occurred: return self.func(*args) my_cursor.execute(sql_command,values) self._handle_result(self._connection.cmd_query(stmt)) result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) self._socket.send( raise errors.OperationalError( mysql.connector.errors.OperationalError: 2055: Lost connection to MySQL server at 'localhost:3306', system error: 10038 An operation was attempted on something that is not a socket [Finished in 3.5s]
@@Codemycom I was actually creating a database address_book in which I took the attributes first name,last name, address, city, state, and zip code. I have attached the statement: command="INSERT INTO addresses (first_name, last_name, address, city, state, zipcode) values (%s,%s,%s,%s,%s,%s)" values=(f_name_label_entry.get(),l_name_label_entry.get(),address_label_entry.get(),city_label_entry.get(),state_label_entry.get(),zipcode_label_entry.get()) cur.execute(command,values) Actually, there is no syntax error, but it is showing "an operation was performed which was not in the socket" like that. Please help...
Hi John. Thanks for the video but i gettin this error and couldn't find any solution. mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
thanks for the tutorials , i get the error 1060 duplicate column name 'email' while altering . i had to drop the table and create it again . can u tell my why this happened?
pls help i am getting this error i m using python 3.6 in idle I am getting File "C:\Users\Dell\Desktop\python project.py", line 155, in clearall id.delete(0,'end') AttributeError: 'builtin_function_or_method' object has no attribute 'delete' if not delete ()what should i do
@Codemy.com Exception in Tkinter callback Traceback (most recent call last): File "C:\Users\DELL\AppData\Local\Programs\Python\Python38\lib\tkinter init -py", line 1883, in call return self. func (*args) File "C:\Users\DELL\AppData\Local\Programs\Python\Python38\CRM.py", line 78 in add customer my cursor.execute (sql command, values) File "C:\Users\DELL\AppData\Local\Programs\Python\Python38\lib\site-packages\m ysql\connector cursor_cext.py", line 234, in execute self. cnx.handle unread result () File "C:\Users\DELL\AppData\Local\Programs\Python\Python38\lib\site-packages\m ysql\connector connection_cext.py", line 746, in handle unread result raise errors. InternalError ("Unread result found") mysql.connector.errors.InternalError: Unread result found Ln: 30 Col: 4
raise errors.InternalError("Unread result found") mysql.connector.errors.InternalError: Unread result found Getting this error before inserting values into customer table Keep getting this error,how to fix it ?
I am facing the same error prior to clicking the add database button have you found a solution because I have tried the buffered=TRUE one and still the error is unresolved
Could be just a typo somewhere. It told me the same thing. The problem was on the line I cleared the fields in the add_customer function. What I had on line: clear_fields()1 What should be there: clear_fields() (or whatever you named that function.) Anyway, its not a greatly descriptive error. The line it said the error was on was this line: my_cursor.execute(sql_command, values) I swear I checked and counted all the values in all the spots 10 times before I noticed that rogue '1' at the end of the clear boxes (fields) function call
![SahBabii - Viking [Official Music Video]](http://i.ytimg.com/vi/D37cL92JX0I/mqdefault.jpg)
Had fun with this one, put all the create, delete, query in functions, created a second windows with buttons so I did not have to go modify the code every time I made a mistake with the table
2 years since it's up, still helpful
thank you
Glad you enjoyed it!
This is great. Back in the days before RUclips, learning how to write a simple GUI driven app with a database backend would have entailed a chunky textbook, several weeks and way too much theory to be worked through. You got all this into a 25 minute video. Well done!
Glad it was helpful!
Amazing series!! Helped me a lot for my GUI project!
Happy to hear it
Like button smashed as always :) Thank you! And greetings from Poland ❤
Thanks!
▶️ 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
Take $22 off with coupon code: youtube
Enjoy the series, many thanks for this sir! :)
You're welcome!
8:03
i have tried a way to put labels on the grid faster.
form_list = [
'first name',
'email',
'address 1',
'address 2',
'city' ,
'state' ,
'country',
'phone' ,
'payment method',
'discount code'
]
for i in range(len(form_list)):
form_frame = Frame(root).grid(pady = 5, column= 1)
label = Label(form_frame, text=f"{form_list[i].title()}" )
label.grid(row=i+1, padx=(50,10), pady = (5,5), sticky = "W")
Hi,
Your videos are amazing and Very useful in a good representation manner. Easily understand in every steps.
If possible, please put your using codes video in description may help to others.
Because while watching your video that speed they can't write the code, every time rewind, replay or pause the video then check the execution. Sorry if i'm wrong ..
My code is all on my github page, but people shouldn't really need it. Pause. Rewind. It's video dude, and I'm not writing a ton of code here.
Thanks Heisenberg !
Ha!
Many thanks for giving code
Sure thing
hi🤩🤩🤩... thank you. it works correctly . if i use wampserver.
awesome
smashed the like button :)
thanks!
hi john just a bit confused why did you remove the user id
Thanks again for the helpful video, I was curious about something though.
I noticed around 14 minutes in that you were able to go through the entry boxes very quickly as though you had a key-binding for arrowing-down between entry boxes. Would you happen to have a key binding tutorial for entry boxes or an explanation on how to navigate between the entry boxes after running the program? I am currently having to manually click between entry boxes, and testing the various functions this way is time consuming.
@14:33
I just hit the tab key on the keyboard.
@@Codemycom ahh thanks!
@@andrewwilkinson3978 Sure thing
Hello sir, i have a confusion. When you create the table and you put it only five columns in there (firstname, lastname, zipcode, pricepaid & user id), and you have created the 13 entry for the the five column and it works i dont know how is it possible. Can you explain
Hello john, thanks for the video. It really helps me to enhance my tkinter skills. I also designed a small registration form, there's not a single error in the program but after printing result I got "(' ', ' ')" this as a output. You got entries as a output , but I didn't get the data which I entered on the form. Can you please help me?
Emmm... for the label and grid, I have them in separate lines but I'm still getting AttributeError "nonetype' object has no attribute 'get'.
I can't seem to find out what the problem is... so after entering text and click add customer to database, the text doesn't go away...
You grid the entry in one line therefore the attribute error occurs
entry = Entry(root).grid() -> Error
Therefore the attribute error occurs
You have to separate these in two lines
@@AbbasAli-9669 That's what I did. I had label and grid in separate lines but still get errors
woah I'm late 😁
Ha!
John, when I run the statement inside the add_customer function, I am getting an error in the statement my_cursor.execute(sql_command, values). The error is as follows:
Exception in Tkinter callback
Traceback (most recent call last)
self.sock.sendall(packet)
OSError: [WinError 10038] An operation was attempted on something that is not a socket
During handling of the above exception, another exception occurred:
return self.func(*args)
my_cursor.execute(sql_command,values)
self._handle_result(self._connection.cmd_query(stmt))
result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))
self._socket.send(
raise errors.OperationalError(
mysql.connector.errors.OperationalError: 2055: Lost connection to MySQL server at 'localhost:3306', system error: 10038 An operation was attempted on something that is not a socket
[Finished in 3.5s]
what did you do differently from the video?
@@Codemycom I was actually creating a database address_book in which I took the attributes first name,last name, address, city, state, and zip code. I have attached the statement:
command="INSERT INTO addresses (first_name, last_name, address, city, state, zipcode) values (%s,%s,%s,%s,%s,%s)"
values=(f_name_label_entry.get(),l_name_label_entry.get(),address_label_entry.get(),city_label_entry.get(),state_label_entry.get(),zipcode_label_entry.get())
cur.execute(command,values)
Actually, there is no syntax error, but it is showing "an operation was performed which was not in the socket" like that.
Please help...
Hi John. Thanks for the video but i gettin this error and couldn't find any solution. mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
you likely need to use one of the other connectors
how to split window into two frames just like opened book
just use two frames
nice
Thanks
thanks for the tutorials , i get the error 1060 duplicate column name 'email' while altering .
i had to drop the table and create it again . can u tell my why this happened?
No idea
Maybe you didn't comment out the text 3:30 that adds more to the original table
pls help i am getting this error i m using python 3.6 in idle I am getting
File "C:\Users\Dell\Desktop\python project.py", line 155, in clearall
id.delete(0,'end')
AttributeError: 'builtin_function_or_method' object has no attribute 'delete'
if not delete ()what should i do
it is delete() and stop using IDLE, use the git bash terminal and sublime text like I do in the video. Tkinter doesn't work well with IDLE.
sir why we alter it ,,why we dont create the whole fields in one go?
*shrugs*
Can you share your github repository? Please.
github.com/flatplanet/Intro-To-TKinter-RUclips-Course
@@Codemycom Thanks.
Sir I'm getting error while inserting data into the table. Can u explain why this error occurs
Not without knowing what error you're getting
@Codemy.com
Exception in Tkinter callback
Traceback (most recent call last):
File "C:\Users\DELL\AppData\Local\Programs\Python\Python38\lib\tkinter init -py", line 1883, in call
return self. func (*args)
File "C:\Users\DELL\AppData\Local\Programs\Python\Python38\CRM.py", line 78
in add customer
my cursor.execute (sql command, values)
File "C:\Users\DELL\AppData\Local\Programs\Python\Python38\lib\site-packages\m ysql\connector cursor_cext.py", line 234, in execute
self. cnx.handle unread result ()
File "C:\Users\DELL\AppData\Local\Programs\Python\Python38\lib\site-packages\m ysql\connector connection_cext.py", line 746, in handle unread result
raise errors. InternalError ("Unread result found") mysql.connector.errors.InternalError: Unread result found
Ln: 30 Col: 4
@@Codemycom sir this is the error I'm getting
@@Codemycom Thank you for your quick response sir
@@learnwithnawf246 It's saying you have an error in CRM.py on line 78
raise errors.InternalError("Unread result found")
mysql.connector.errors.InternalError: Unread result found
Getting this error before inserting values into customer table
Keep getting this error,how to fix it ?
Try Googling the error
@@Codemycom did it
Added Buffered =True in cursor ,still error occurs
Your videos are amazing BTW 👌
I am facing the same error prior to clicking the add database button
have you found a solution because I have tried the buffered=TRUE one and still the error is unresolved
Could be just a typo somewhere. It told me the same thing. The problem was on the line I cleared the fields in the add_customer function.
What I had on line:
clear_fields()1
What should be there:
clear_fields()
(or whatever you named that function.) Anyway, its not a greatly descriptive error. The line it said the error was on was this line:
my_cursor.execute(sql_command, values)
I swear I checked and counted all the values in all the spots 10 times before I noticed that rogue '1' at the end of the clear boxes (fields) function call