Hi Guys Welcome TO Seekcoding Blogspot......
Today I am going to Show
1.how to create login and registration form in python.....
2.how to connect login and registration form using the mysql database....
'''
Before starting the tutorial you please make sure that you have installed the mysql
server on you operating system......
if you have mysql server on your operating system then follow these steps
1.open your mysql prompt
2.enter the password if you have put it....
3.then create the database with the name "pythongui"
4.use the pythongui database
5.create the table with the table name "register" with the attributes (username,
emailid,password,confirm password......
I am writing the queries here
step 1: create database pythongui;
step 2: use pythongui;
step 3:
create table register(username char(30),emailid char(200),password char(30),
confirmpassword char(30));
first finish these three steps........
Now our database is ready to store the data........
Note: if you have any difficulty in creating the database please watch this video----
https://www.youtube.com/watch?v=NAwcl9R0M9w
'''
#now let us get started.........
#first import the modules required.....
from tkinter import *
from PIL import ImageTk
from tkinter import messagebox
import pymysql
class Login:
def __init__(self,root):
self.root=root
self.root.title("Login and registration system for Apps")
self.root.geometry("1366x700+0+0")
self.root.resizable(False,False)
self.loginform()
def loginform(self):
Frame_login=Frame(self.root,bg="white")
Frame_login.place(x=0,y=0,height=700,width=1366)
self.img=ImageTk.PhotoImage(file="background-2.jpg")
img=Label(Frame_login,image=self.img).place(x=0,y=0,width=1366,height=700)
frame_input=Frame(self.root,bg='white')
frame_input.place(x=320,y=130,height=450,width=350)
label1=Label(frame_input,text="Login Here",font=('impact',32,'bold'),
fg="black",bg='white')
label1.place(x=75,y=20)
label2=Label(frame_input,text="Username",font=("Goudy old style",20,"bold"),
fg='orangered',bg='white')
label2.place(x=30,y=95)
self.email_txt=Entry(frame_input,font=("times new roman",15,"bold"),
bg='lightgray')
self.email_txt.place(x=30,y=145,width=270,height=35)
label3=Label(frame_input,text="Password",font=("Goudy old style",20,"bold"),
fg='orangered',bg='white')
label3.place(x=30,y=195)
self.password=Entry(frame_input,font=("times new roman",15,"bold"),
bg='lightgray')
self.password.place(x=30,y=245,width=270,height=35)
btn1=Button(frame_input,text="forgot password?",cursor='hand2',
font=('calibri',10),bg='white',fg='black',bd=0)
btn1.place(x=125,y=305)
btn2=Button(frame_input,text="Login",command=self.login,cursor="hand2",
font=("times new roman",15),fg="white",bg="orangered",
bd=0,width=15,height=1)
btn2.place(x=90,y=340)
btn3=Button(frame_input,command=self.Register,text="Not Registered?register"
,cursor="hand2",font=("calibri",10),bg='white',fg="black",bd=0)
btn3.place(x=110,y=390)
def login(self):
if self.email_txt.get()=="" or self.password.get()=="":
messagebox.showerror("Error","All fields are required",parent=self.root)
else:
try:
con=pymysql.connect(host='localhost',user='root',password='shivakesh2',
database='pythongui')
cur=con.cursor()
cur.execute('select * from register where emailid=%s and password=%s'
,(self.email_txt.get(),self.password.get()))
row=cur.fetchone()
if row==None:
messagebox.showerror('Error','Invalid Username And Password'
,parent=self.root)
self.loginclear()
self.email_txt.focus()
else:
self.appscreen()
con.close()
except Exception as es:
messagebox.showerror('Error',f'Error Due to : {str(es)}'
,parent=self.root)
def Register(self):
Frame_login1=Frame(self.root,bg="white")
Frame_login1.place(x=0,y=0,height=700,width=1366)
self.img=ImageTk.PhotoImage(file="background-2.jpg")
img=Label(Frame_login1,image=self.img).place(x=0,y=0,width=1366,height=700)
frame_input2=Frame(self.root,bg='white')
frame_input2.place(x=320,y=130,height=450,width=630)
label1=Label(frame_input2,text="Register Here",font=('impact',32,'bold'),
fg="black",bg='white')
label1.place(x=45,y=20)
label2=Label(frame_input2,text="Username",font=("Goudy old style",20,"bold"),
fg='orangered',bg='white')
label2.place(x=30,y=95)
self.entry=Entry(frame_input2,font=("times new roman",15,"bold"),
bg='lightgray')
self.entry.place(x=30,y=145,width=270,height=35)
label3=Label(frame_input2,text="Password",font=("Goudy old style",20,"bold"),
fg='orangered',bg='white')
label3.place(x=30,y=195)
self.entry2=Entry(frame_input2,font=("times new roman",15,"bold"),
bg='lightgray')
self.entry2.place(x=30,y=245,width=270,height=35)
label4=Label(frame_input2,text="Email-id",font=("Goudy old style",20,"bold"),
fg='orangered',bg='white')
label4.place(x=330,y=95)
self.entry3=Entry(frame_input2,font=("times new roman",15,"bold"),
bg='lightgray')
self.entry3.place(x=330,y=145,width=270,height=35)
label5=Label(frame_input2,text="Confirm Password",
font=("Goudy old style",20,"bold"),fg='orangered',bg='white')
label5.place(x=330,y=195)
self.entry4=Entry(frame_input2,font=("times new roman",15,"bold"),
bg='lightgray')
self.entry4.place(x=330,y=245,width=270,height=35)
btn2=Button(frame_input2,command=self.register,text="Register"
,cursor="hand2",font=("times new roman",15),fg="white",
bg="orangered",bd=0,width=15,height=1)
btn2.place(x=90,y=340)
btn3=Button(frame_input2,command=self.loginform,
text="Already Registered?Login",cursor="hand2",
font=("calibri",10),bg='white',fg="black",bd=0)
btn3.place(x=110,y=390)
def register(self):
if self.entry.get()==""or self.entry2.get()==""or self.entry3.get()==""or self.entry4.get()=="":
messagebox.showerror("Error","All Fields Are Required",parent=self.root)
elif self.entry2.get()!=self.entry4.get():
messagebox.showerror("Error","Password and Confirm Password Should Be Same"
,parent=self.root)
else:
try:
con=pymysql.connect(host="localhost",user="root",password="shivakesh2",
database="pythongui")
cur=con.cursor()
cur.execute("select * from register where emailid=%s"
,self.entry3.get())
row=cur.fetchone()
if row!=None:
messagebox.showerror("Error"
,"User already Exist,Please try with another Email"
,parent=self.root)
self.regclear()
self.entry.focus()
else:
cur.execute("insert into register values(%s,%s,%s,%s)"
,(self.entry.get(),self.entry3.get(),
self.entry2.get(),
self.entry4.get()))
con.commit()
con.close()
messagebox.showinfo("Success","Register Succesfull"
,parent=self.root)
self.regclear()
except Exception as es:
messagebox.showerror("Error",f"Error due to:{str(es)}"
,parent=self.root)
def appscreen(self):
Frame_login=Frame(self.root,bg="white")
Frame_login.place(x=0,y=0,height=700,width=1366)
label1=Label(Frame_login,text="Hi! Welcome To Seek coding"
,font=('times new roman',32,'bold'),
fg="black",bg='white')
label1.place(x=375,y=100)
label2=Label(Frame_login,text="Youtube Channel.If you are New to Channel"
,font=('times new roman',32,'bold'),
fg="black",bg='white')
label2.place(x=235,y=160)
label3=Label(Frame_login,text="Please Subscribe,Like And Share"
,font=('times new roman',32,'bold'),
fg="black",bg='white')
label3.place(x=340,y=220)
btn2=Button(Frame_login,text="Logout",command=self.loginform,cursor="hand2",
font=("times new roman",15),fg="white",bg="orangered",
bd=0,width=15,height=1)
btn2.place(x=1000,y=10)
def regclear(self):
self.entry.delete(0,END)
self.entry2.delete(0,END)
self.entry3.delete(0,END)
self.entry4.delete(0,END)
def loginclear(self):
self.email_txt.delete(0,END)
self.password.delete(0,END)
root=Tk()
ob=Login(root)
root.mainloop()