thanks too much brother , note to those people who may get my errors : if i delete the table and try the code i got error says that table not exist , for that i changed the position of the code of creation the table to exception part and added '' IF NOT EXISTS " ,to not get an other error that says : 'table is already exists'
Brother I got some errors, whenever I entered the details in signup page it displays some errors like raise_for_error,raise_for_exception ,_read_packet
mycursor.execute(query,(userentry.get())) in this what is happening? str(ashakarthikeyan), it must be of type list, tuple or dict Im getting this error
Hi , I make a page consisting a button and give the command to open a new page without destroying the previous page it works but when I add image in second page and try to open it by first page without destroying first , then it doesn't show me that image that I add to second page But when I run the second page Individually it works properly and also shows that image which i add to it can you please help me to solve this problem
if anyone is getting issue with connecting mysql database with python . You can try connecting the database with another method using 'mysql connector' method. You can refer youtube video of 'Tech with tim youtube channel' ..... video name is 'Python Mysql tutorial'.
The last part , Where you check for an existing Username... 34:50 This specific line: mycursor.execute(query, (usernameEntry.get())) It's crazy that you don't get a ProgrammingError. That line lacks a Comma for me: mycursor.execute(query, (usernameEntry.get(),))
Hi Coding Lifestyle, may I ask a favor please? Can you please recreate this program or at least the part where you connect your python to MySQL, but this time please, use PostgreSQL database please?
31:00 after clicking the signup button, 🚫 no dialog box appears; 🚫 Entry field not get cleared; 🏳️ Database and table created, but with 0 table data. And, since I was executing the .py file through command prompt, it displays an exception like below 👇🏻 TypeError: 'str' object is not callable Please 🙏 help with this code Sir
@@noons186 it can be because of password encryption for which you have to import modules like hashlib, cryptography, credentials(in python) you should also grant permission to user from database cmd for that you search on google because i have forgotten the command😅😅 according to me this will solve the issue and also take care that you are importing right module for database you are using ( like mysql for mysql db etc) create proper cursor and check the statements thoroughly once again. i hope this will solve your issue.
if emailEntry.get()=='' or usernameEntry.get()=='' or passwordEntry.get()=='' or confirmEntry.get()=='': messagebox.showerror('Error','All Fields Are Required') elif passwordEntry.get() != confirmEntry.get(): messagebox.showerror('Error', 'Password Mismatch') elif check.get()==0: messagebox.showerror('Error', 'Please accept Terms & Condition') else: try: con=pymysql.connect(host='localhost',user='root',password='1234') mycursor=con.cursor() except: messagebox.showerror('Error', 'Database Connectivity Issue, Please Try Again') return try: query = 'create database userdata' mycursor.execute(query) query = 'use userdata' mycursor.execute(query) query = 'create tabel data(id int auto_increment primary key not null,email varchar(50),username varchar(100),password varchar(50))' mycursor.execute(query) ## All work has been done smoothly but after the return [create data base ] is not working properly.. Showing Error =Database Connectivity Issue, Please Try Again')
When I have run command pip install pymysql I am getting an error New connection error How can I fix it sir please reply fast I need this system for my website 🙏🙏🙏🙏🙏🙏🙏
sir i m facing error in python idle mysql.connector.errors.ProgrammingError: Could not process parameters: str(prakash), it must be of type list, tuple or dict
@@codinglifestyle4u sir error is resolved i was using " mycursor.execute(query,(usernameEntry.get())) " this but now i used [ ] instead of ( ) " mycursor.execute(query,[usernameEntry.get()]) " but Thank you sir..
At last 5 min you said about an error message that if username already existed in our database then it should show error that it has already existed. How can i set the error message like email already existed along with username existed condition error msg condition. Elif is not working for that.
I had this issue - had to drop the drop the database 'userdata' in MySQL workbench then when I ran the code and it recreated the database it could then create the table fine.
import re def is_valid_email(email): # Regular expression for email validation pattern = r'^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$' # Check if the email matches the pattern if re.match(pattern, email): return True else: return False # Test the function email_to_check = "example@example.com" if is_valid_email(email_to_check): print("Valid email!") else: print("Invalid email!")
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 '%s' at line 1
Help. I get these errors when trying to sign up: Exception in Tkinter callback Traceback (most recent call last): File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.1264.0_x64__qbz5n2kfra8p0\Lib\tkinter\__init__.py", line 1948, in __call__ return self.func(*args) ^^^^^^^^^^^^^^^^ File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\signup.py", line 42, in connect_database mycusrsor.execute(query,(email_Entry.get(),username_Entry.get(),password_Entry.get())) File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\cursors.py", line 153, in execute result = self._query(query) ^^^^^^^^^^^^^^^^^^ File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\cursors.py", line 322, in _query conn.query(q) File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\connections.py", line 558, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\connections.py", line 822, in _read_query_result result.read() File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\connections.py", line 1200, in read first_packet = self.connection._read_packet() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\connections.py", line 772, in _read_packet packet.raise_for_error() File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.ProgrammingError: (1146, "Table 'userdata.data' doesn't exist")
line 39, in connect_database mycursor.execute(query,(emailEntry.get(),usernameEntry.get(),passwordEntry.get())) line no.39->mycursor.execute(query,(emailEntry.get(),usernameEntry.get(),passwordEntry.get()))
thanks too much brother , note to those people who may get my errors : if i delete the table and try the code i got error says that table not exist , for that i changed the position of the code of creation the table to exception part and added '' IF NOT EXISTS " ,to not get an other error that says : 'table is already exists'
I have finally completed this project. Thanks very much
Ur welcome
Hey help me out with the connection to MySQL ...
Ping me on instagram coding_lifestyle_4u
@@codinglifestyle4u do u have telegram I don't use Instagram
Brother I got some errors, whenever I entered the details in signup page it displays some errors like raise_for_error,raise_for_exception ,_read_packet
Very Informative
Thanks 😊
mycursor.execute(query,(userentry.get())) in this what is happening? str(ashakarthikeyan), it must be of type list, tuple or dict Im getting this error
What did u do bro? I also got same error
Did it get solve?
@@shyamrajkhowa7067 yep
Hi , I make a page consisting a button and give the command to open a new page without destroying the previous page it works but when I add image in second page and try to open it by first page without destroying first , then it doesn't show me that image that I add to second page
But when I run the second page Individually it works properly and also shows that image which i add to it
can you please help me to solve this problem
Can u send me the pic on instagram coding_lifestyle_4u
if anyone is getting issue with connecting mysql database with python . You can try connecting the database with another method using 'mysql connector' method. You can refer youtube video of 'Tech with tim youtube channel' ..... video name is 'Python Mysql tutorial'.
Thanks 👍
hai codinglifestyle. How do i connect the database via xampp, not mysql 8.0 command line client. I hope you respond to my response
Please watch the tutorial on how to connect database via xampp
The last part , Where you check for an existing Username... 34:50
This specific line:
mycursor.execute(query, (usernameEntry.get()))
It's crazy that you don't get a ProgrammingError.
That line lacks a Comma for me:
mycursor.execute(query, (usernameEntry.get(),))
But that is fine there is no issue 😀
thank you very much!
Plzz help me with databasee connectivity
Ping me on instagram coding_lifestyle_4u
Bro thankyou for that!
Pls can make a video on how to create the database from snatch..pls
Hi Coding Lifestyle, may I ask a favor please? Can you please recreate this program or at least the part where you connect your python to MySQL, but this time please, use PostgreSQL database please?
Sure
@@codinglifestyle4u please include the part where you use fetchone. Thank you
Can we not switch over to windows multiple times by using destroy method?
Yes please try to find the solution For this
for that you'll have to overlap the windows this method is much convinient
I am getting a database connectivity issue and do not know how to fix it
What is the error?
@@codinglifestyle4u i have fixed it dont worry.
@@mannysokhi4203 can u help me to resolve this...
Send me the error pic on instagram coding_lifestyle_4u
@@codinglifestyle4u yes i have sent it can you go through it...
31:00 after clicking the signup button,
🚫 no dialog box appears;
🚫 Entry field not get cleared;
🏳️ Database and table created, but with 0 table data.
And, since I was executing the .py file through command prompt, it displays an exception like below 👇🏻
TypeError: 'str' object is not callable
Please 🙏 help with this code Sir
At last, I have found out the error. I forgot to put coma after query.. i.e. line number 39 on 31:36.
Ok
Hi. Why u do not use MySQL work bench instead of Command line?
U can use that too
what should i do if it shows database connectivity issue
Can U send me the issue pic on instagram coding_lifestyle_4u
how did u fix it
@@noons186 it can be because of password encryption for which you have to import modules like hashlib, cryptography, credentials(in python)
you should also grant permission to user from database cmd for that you search on google because i have forgotten the command😅😅 according to me this will solve the issue and also take care that you are importing right module for database you are using ( like mysql for mysql db etc) create proper cursor and check the statements thoroughly once again. i hope this will solve your issue.
hey do you know how to fix the Database connectivity issue as this is an error I am encountering
Text me on Instagram coding_lifestyle_4u
How to solve the "connectivity issue" in sing up page?
Nd the data base is not shown in mysql command line client how to resolve it?
Open mysql workbench once before running the code
Recreate the database and table at once and then run the code
Can you show me if there is any error on instagram coding_lifestyle_4u
if emailEntry.get()=='' or usernameEntry.get()=='' or passwordEntry.get()=='' or confirmEntry.get()=='':
messagebox.showerror('Error','All Fields Are Required')
elif passwordEntry.get() != confirmEntry.get():
messagebox.showerror('Error', 'Password Mismatch')
elif check.get()==0:
messagebox.showerror('Error', 'Please accept Terms & Condition')
else:
try:
con=pymysql.connect(host='localhost',user='root',password='1234')
mycursor=con.cursor()
except:
messagebox.showerror('Error', 'Database Connectivity Issue, Please Try Again')
return
try:
query = 'create database userdata'
mycursor.execute(query)
query = 'use userdata'
mycursor.execute(query)
query = 'create tabel data(id int auto_increment primary key not null,email varchar(50),username varchar(100),password varchar(50))'
mycursor.execute(query)
## All work has been done smoothly but after the return [create data base ] is not working properly..
Showing Error =Database Connectivity Issue, Please Try Again')
@@codinglifestyle4u how to create the database and table at once exactly?
When I have run command pip install pymysql I am getting an error New connection error How can I fix it sir please reply fast I need this system for my website 🙏🙏🙏🙏🙏🙏🙏
Good morning sir
Can we create separate table each email id?
Yes you can
sir i m facing error in python idle
mysql.connector.errors.ProgrammingError: Could not process parameters: str(prakash), it must be of type list, tuple or dict
Rewatch that part again and see if you are doing it correctly
@@codinglifestyle4u sir error is resolved i was using " mycursor.execute(query,(usernameEntry.get())) " this
but now i used [ ] instead of ( ) " mycursor.execute(query,[usernameEntry.get()]) "
but Thank you sir..
@@prakashsachan2595bro if your code is crt ,can you please share here? SIGNUP!
Mysql showing only 4 database
At last 5 min you said about an error message that if username already existed in our database then it should show error that it has already existed. How can i set the error message like email already existed along with username existed condition error msg condition. Elif is not working for that.
Ping me on instagram coding_lifetystyle_4u
can it still works if i share the applications to the other users ?
Getting error of pymysql . Programming Error:(1146,"Table 'pd.pd' doesn't exist")
Please help me out from this issue asap
Thanks.
Make sure you are using the correct table name and the table exists in the database
I had this issue too. Make the table separately in another python program and it should work
I had this issue - had to drop the drop the database 'userdata' in MySQL workbench then when I ran the code and it recreated the database it could then create the table fine.
Sir is it show the error when we do code in idle ?
Bcz it’s throwing a error in the function def connect_database():
As object has no attribute get
No it wont show error in idle, you must be making a mistake please rewatch that part
@@codinglifestyle4u ni bro everything is writing get function only is not working
Bro we are doing a project banking system pls help me to save transaction history in database please bro
Please learn how to store the data there from google or youtube
Getting database connectivity issue, please try again... how to resolve it please help
I hope it is fixed
Have you solved this issue?
Same error how can i solve it
Open mysql workspace once and then again try to run the code
@@codinglifestyle4u what do you mean i opened my workbench but still? do i have to make something on the workbench
heyyy is there a video where u use inbuilt sql lite
Yes have a look th-cam.com/video/CuUX8WsdIjM/w-d-xo.htmlsi=zTQduLa0fvDoJ4VW
Bro I have a error
pymysql.err.ProgrammingError: (1146, "Table 'sr.asr' doesn't exist")
Please check the code you are making mistake
Exactly the same error I had, how did you rectify it please?
Pls have created all GUI and install database but I know how to create the database
Please watch the tutorial and follow the steps
How to clear the error in mysql
Show tables;
Empty set (0.00 sec)
Recreate the new database and table at once and then rerun the code
Yes I got it
It's working
What was the error?
@@codinglifestyle4u after sign up
Error 1054 unknown column password in field list
Bro bro from where you get the eye button image of perfect
From Flaticon website
@@codinglifestyle4u thanks brother ❤
How to add validation rules for email here
import re
def is_valid_email(email):
# Regular expression for email validation
pattern = r'^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$'
# Check if the email matches the pattern
if re.match(pattern, email):
return True
else:
return False
# Test the function
email_to_check = "example@example.com"
if is_valid_email(email_to_check):
print("Valid email!")
else:
print("Invalid email!")
@@codinglifestyle4u sir where I have to write this code
this can work for other users or just my pc ?
For other users as well
Or can we insert text file to sql
Yes check on google how to do it
Why is name of database not appear
Plz rewatch that part you must have made some mistake
Table not creating.
You must be making some mistake
Are u getting any error?
If not change the database name and rerun the code
Can you provide source code/??
It will be better to watch the tutorials and build this project, source code is paid
I want start the project
Ok go ahead and start
hahahah hardcoding the password!!
Where?
Bro source code please
Please watch the tutorials and build it
Ok bro
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 '%s' at line 1
The error is clear that you have done mistake in sql syntax please rewatch that part once again.
Help. I get these errors when trying to sign up: Exception in Tkinter callback
Traceback (most recent call last):
File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.1264.0_x64__qbz5n2kfra8p0\Lib\tkinter\__init__.py", line 1948, in __call__
return self.func(*args)
^^^^^^^^^^^^^^^^
File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\signup.py", line 42, in connect_database
mycusrsor.execute(query,(email_Entry.get(),username_Entry.get(),password_Entry.get()))
File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\cursors.py", line 153, in execute
result = self._query(query)
^^^^^^^^^^^^^^^^^^
File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\cursors.py", line 322, in _query
conn.query(q)
File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\connections.py", line 558, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\connections.py", line 822, in _read_query_result
result.read()
File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\connections.py", line 1200, in read
first_packet = self.connection._read_packet()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\connections.py", line 772, in _read_packet
packet.raise_for_error()
File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1146, "Table 'userdata.data' doesn't exist")
now it only says connectivity issue please try again it wont fix
i fixed it
Ok great
how did you fix db connectivity error issue
@@GuestGorebox how to fix it , could you please help me bro ?
line 39, in connect_database
mycursor.execute(query,(emailEntry.get(),usernameEntry.get(),passwordEntry.get()))
line no.39->mycursor.execute(query,(emailEntry.get(),usernameEntry.get(),passwordEntry.get()))
Did it solve ?