You're a wonderful teacher and I have learnt a lot from you, a big thank you. I was able to follow through while implementing all the steps using MS SQL Server Express.
Hello. I have noticed a problem when data is tracing back from db to interface. leading zeros have been removed at the interface by our code even though db still shows data with leading zero which is stored as VARCHAR. as an example: password "01234" stored in db is showed as "1234" at password entry field. thank you.
I included the education as well, but since it's positioned on the right-hand side, so its not visible. However, you can add it to your database table.
It’s there on the right side, but you might not see it! 😄 If you missed it and already created the table without the education column, just add this code after the CREATE TABLE line: cursor.execute('ALTER TABLE employee_data ADD COLUMN education VARCHAR(100) AFTER employment_type')
Hi Coach. Thank you for all. I noticed that when we select a row to be updated, only one item can be updated. It's not possible to update many items at the same time. This is due to the fact that the row is selected. Can you see this issue?
brother, if i am clicking on the command to see the database is not showing me the employee_data. What is going wrong. How i can use mysql or how i can download it
hi please i cant insert into table i dont know why : File "c:\Users\wiwy\Desktop\mon 2eme projet\employer.py", line 46, in valide_employer cursor.execute('INSERT INTO employers VALUES(%s)',(empid)) ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\cursors.py", line 153, in execute result = self._query(query) File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\cursors.py", line 322, in _query conn.query(q) ~~~~~~~~~~^^^ File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 563, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) ~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 825, in _read_query_result result.read() ~~~~~~~~~~~^^ File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 1199, in read first_packet = self.connection._read_packet() File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 775, in _read_packet packet.raise_for_error() ~~~~~~~~~~~~~~~~~~~~~~^^ File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error err.raise_mysql_exception(self._data) ~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^ File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\err.py", line 150, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1136, "Column count doesn't match value count at row 1") PS C:\Users\wiwy\Desktop\mon 2eme projet>
really, educative. learning alot from this.🤟
It is very help full tutorial thank you very much from Ethiopia
You're a wonderful teacher and I have learnt a lot from you, a big thank you. I was able to follow through while implementing all the steps using MS SQL Server Express.
Thank you very much 😊
Great. This time, it is dosed. Many handlings. Every Day, we learn a little more. Thanks so much
Welcome 😊
just finished he second part , time to start this one , thanks for sharing
Welcome.. hope you are learning
@@codinglifestyle4u yessir i am pausing , trying on my own , and then correcting with the video
Great all the best.
Good Teacher
I really like the way you teach
Thanks
Thanks you so much Sir!! your sos sososso very helpfull!!!!
Welcome
I have learn alot from this video Thanks
Great congratulations 👏
2:00:22 succefully done ❤
Congratulations 👏
Hello. I have noticed a problem when data is tracing back from db to interface. leading zeros have been removed at the interface by our code even though db still shows data with leading zero which is stored as VARCHAR. as an example: password "01234" stored in db is showed as "1234" at password entry field. thank you.
Mr Faizan you did not explain why you did not add 'EDUCATION ' to the database but it appears in the mysql database
I included the education as well, but since it's positioned on the right-hand side, so its not visible. However, you can add it to your database table.
@@codinglifestyle4u yes it works 👍
It’s there on the right side, but you might not see it! 😄
If you missed it and already created the table without the education column, just add this code after the CREATE TABLE line:
cursor.execute('ALTER TABLE employee_data
ADD COLUMN education VARCHAR(100) AFTER employment_type')
Hi Coach. Thank you for all. I noticed that when we select a row to be updated, only one item can be updated. It's not possible to update many items at the same time. This is due to the fact that the row is selected. Can you see this issue?
This is possible in case the row is not selected. How to resolve the problem
hi sir can you please tell about mysql installation and setup ive used mssql and workbench only
Check MySQL installation and uninstallation videos in my channel
brother, if i am clicking on the command to see the database is not showing me the employee_data. What is going wrong.
How i can use mysql or how i can download it
Send me the error pic on instagram coding_lifestyle_4u
Thank you brother i learn from you more than my fucking colege😂😂
😀😀
hi please i cant insert into table i dont know why :
File "c:\Users\wiwy\Desktop\mon 2eme projet\employer.py", line 46, in valide_employer
cursor.execute('INSERT INTO employers VALUES(%s)',(empid))
~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\cursors.py", line 153, in execute
result = self._query(query)
File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\cursors.py", line 322, in _query
conn.query(q)
~~~~~~~~~~^^^
File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 563, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 825, in _read_query_result
result.read()
~~~~~~~~~~~^^
File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 1199, in read
first_packet = self.connection._read_packet()
File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 775, in _read_packet
packet.raise_for_error()
~~~~~~~~~~~~~~~~~~~~~~^^
File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\err.py", line 150, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1136, "Column count doesn't match value count at row 1")
PS C:\Users\wiwy\Desktop\mon 2eme projet>
Recheck the code
Brother, can i use sqlite 3
Yes you can
Sir cannot import name employee_form from employees
You have to write like this -
import employee_form from employees
Now, how to do own tkinter in python
I didn't get you please elaborate?
@@codinglifestyle4u I might Said it wrong, I mean't own graphical interface 👍
You will be able to create your own gui after learning one or two projects
@@codinglifestyle4u thank you! 🙂
i think i found a bug ,anyways , if you click on the employee button WHILE you are in that page already , the back button wont work anymore
i might add , a discord community or something similar for viewers , we can help eachothers and such , i bet it will be very active
Yes I am aware of that issue I will fix it in upcoming tutorials
@@codinglifestyle4u update , i just finished this part , to the next one
Great 👍
cursor.execute('CREATE DATABASE IF NOT EXISTS inventory_system')
^^^^^^
NameError: name 'cursor' is not defined
Please recheck the code you must be making mistake
@@codinglifestyle4u ok sir. thank you. i will recheck