Login Page Linked With Signup Page: User Registration with MySQL | Python Tkinter GUI Project
HTML-код
- Опубликовано: 21 июл 2024
- Hey everyone, in this video you will learn how to store the user data from the sign-up page in the MySQL database.
In this project login and sign-up pages are linked with each other.
Here MySQL database is used to store the user data which the user will enter during sign up and with the help of that data user will be able to log in and change the password.
Watch how to download & Install MySQL database:
• Download & Install MyS...
Source Code:
faizan-er.myinstamojo.com/pro...
Project Images: drive.google.com/drive/folder...
Time Stamp:
(00:00:00) Intro
(00:04:35) download mysql
(00:04:52) install pymysql
(00:06:36) connect database
(00:17:19) creating database
(00:25:52) inserting data in database
(00:38:20) Ending
Terms related to this video:
login page using tkinter python
login page using tkinter in python
login page using tkinter github
signup page using tkinter
simple login page using tkinter
how to make login page in tkinter
login app using python
login form using python
how to create signin form using tkinter
how to create a registration form using python
login page python
python login page
python mysql
mysql project using python
Tags:
#loginpage #pythonmysql #pythonguiproject #pythontkinter #tkinterproject
★★★ Subscribe ★★★
/ @codinglifestyle4u
★★★ Follow ★★★
/ coding_lifestyle_4u
Thanks for watching.
Please Like, Subscribe & Share.
Stay tuned for upcoming projects 🙂
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
can it still works if i share the applications to the other users ?
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 🙏🙏🙏🙏🙏🙏🙏
Pls can make a video on how to create the database from snatch..pls
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
Very Informative
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
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
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
Hi. Why u do not use MySQL work bench instead of Command line?
U can use that too
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
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
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!
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?
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.
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
Pls have created all GUI and install database but I know how to create the database
Please watch the tutorial and follow the steps
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
Good morning sir
Can we create separate table each email id?
Yes you can
this can work for other users or just my pc ?
For other users as well
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
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?
Or can we insert text file to sql
Yes check on google how to do it
Bro bro from where you get the eye button image of perfect
From Flaticon website
@@codinglifestyle4u thanks brother ❤
heyyy is there a video where u use inbuilt sql lite
Yes have a look ruclips.net/video/CuUX8WsdIjM/видео.htmlsi=zTQduLa0fvDoJ4VW
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.
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
Why is name of database not appear
Plz rewatch that part you must have made some mistake
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...
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 👍
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
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
I want start the project
Ok go ahead and start
Can you provide source code/??
It will be better to watch the tutorials and build this project, source code is paid
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
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.
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
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 ?