How To Make a Login Page in Python with Example

In this article, we’re going to learn on How To Make a Login Page in Python. Python’s usage is presently taking the web development scene by the usage of storm, growing always every year.

Project Software Information

Project Name:	Login Page in Python
Abstract:	Login Page in Python is a simple form for a username and password that lets people who already have an account on the site log in.
Language/s Used:	Python Tkinter GUI Library
Python version (Recommended):	2.x or 3.x
Database:	MySQL
Type:	Python App
Developer:	IT SOURCECODE
Updates:	0

This Login Page project system is a simple GUI based application and this created by using Python and Mysql Database file. It used Tkinter module for the Graphical User Interface.

As a beginner, it is easy to Python and would no longer require as many dependencies that you want to download separately. Python gives TKinter toolkit to increase graphical user interface packages.

About Login Page in Python

In this,we will create a graphical user interface. You may expand any graphical user interface packages easily by just learning. So without wasting your time, let’s start our Python graphical user interface Login tutorial.

Remember in order for you to acquire the idea on how to make Login Page in Python with MySql Database with Source Code. Please follow all the given instructions below without skipping any step.

By the way if you are new to python programming and you don’t know what would be the the Python IDE to use, I have here a list of Best Python IDE for Windows, Linux, Mac OS that will suit for you. I also have here How to Download and Install Latest Version of Python on Windows.

These are the Steps on How To Make a Login Page in Python

Code Explanations

1. Importing Tkinter Function

What does import tkinter do in Python?

Tkinter is the standard GUI library for Python. Python when combined with Tkinter provides a fast and easy way to create GUI applications. Tkinter provides a powerful object-oriented interface to the Tk GUI toolkit

from tkinter import *

In the code above, which is for importing tkinter just write one line of code.

2. Importing the mysql connector

What is MySQL connector in Python?

MySQL Connector/Python enables Python programs to access MySQL databases, using an API that is compliant with the Python Database API Specification v2. 0 (PEP 249). It is written in pure Python and does not have any dependencies except for the Python Standard Library.

import mysql.connector

In the code above, which is for importing mysql connector just write one line of code.

3. Connecting to the Database

In the code below, which is for the connection to the mysql database.

connectiondb = mysql.connector.connect(host="localhost",user="root",passwd="",database="logindb")
cursordb = connectiondb.cursor()

4. Designing the main window

So first of all you have to design the main display. This display screen have two buttons Login and exit. So let’s see the way to put into effect this.(Python Language with Source Code for Login Page with MySql Database)

def main_display():
global root
root = Tk()
root.config(bg="white")
root.title("Log-IN Portal")
root.geometry("1400x750")
Label(root,text='Welcome to Log In', bd=20, font=('arial', 20, 'bold'), relief="groove", fg="white",
bg="blue",width=300).pack()
Label(root,text="").pack()
Button(root,text='Log In', height="1",width="20", bd=8, font=('arial', 12, 'bold'), relief="groove", fg="white",
bg="blue",command=login).pack()
Label(root,text="").pack()
Button(root,text='Exit', height="1",width="20", bd=8, font=('arial', 12, 'bold'), relief="groove", fg="white",
bg="blue",command=Exit).pack()
Label(root,text="").pack()

main_display()

• You can also minimize or maximize the design of main screen window as in line with your choice and make it extra attractive.
• When the above code is executed, let’s see the output of this code.(Python Language with Source Code for Login Page with MySql Database)

Output:

5. Designing new window for login

Now we ought to implement login process. So for this, first of all we should layout a login window. It is equal as sign in window however having little changes.

def login():
global root2
root2 = Toplevel(root)
root2.title("Account Login")
root2.geometry("1400x750")
root2.config(bg="white")

global username_verification
global password_verification
Label(root2, text='Log In', bd=5,font=('arial', 12, 'bold'), relief="groove", fg="white",
bg="blue",width=300).pack()
username_verification = StringVar()
password_verification = StringVar()
Label(root2, text="").pack()
Label(root2, text="Username :", fg="black", font=('arial', 12, 'bold')).pack()
Entry(root2, textvariable=username_verification).pack()
Label(root2, text="").pack()
Label(root2, text="Password :", fg="black", font=('arial', 12, 'bold')).pack()
Entry(root2, textvariable=password_verification, show="*").pack()
Label(root2, text="").pack()
Button(root2, text="Login", bg="blue", fg='white', relief="groove", font=('arial', 12, 'bold'),command=login_verification).pack()
Label(root2, text="")

• And now we will sooner or later take a look at our login process. So fill the username and password area in sign in form and press login button.
• When the above code is executed, it produces the following result below.

Output:

6. Login verification module

In this module we will verify the username and password for login.

def login_verification():
    user_verification = username_verification.get()
    pass_verification = password_verification.get()
    sql = "select * from usertable where username = %s and password = %s"
    mycur.execute(sql,[(user_verification),(pass_verification)])
    results = mycur.fetchall()
    if results:
        for i in results:
            logged()
            break
    else:
        failed()

7. Login design and success message popup

Now we are able to outline a characteristic that will show a popup for successful login. So let’s see the way to do it.
So if the user has entered the valid entries then the popup success message will appear.

ef logged():
global logged_message
logged_message = Toplevel(root2)
logged_message.title("Welcome")
logged_message.geometry("500x100")
Label(logged_message, text="Login Successfully!... Welcome {} ".format(username_verification.get()), fg="green", font="bold").pack()
Label(logged_message, text="").pack()
Button(logged_message, text="Logout", bg="blue", fg='white', relief="groove", font=('arial', 12, 'bold'), command=logged_destroy).pack()

• If the user enter the correct username and password then the popup message successful will appear
• If the above code is executed, it produces the following result below.

Output:

8. Design for login failed or invalid message popup

Now we are able to outline a characteristic that will show a popup for invalid message popup. So let’s see the way to do it.
So if the user has entered the invalid value then the invalid popup message will appear..

ef failed():
global failed_message
failed_message = Toplevel(root2)
failed_message.title("Invalid")
failed_message.geometry("500x100")
Label(failed_message, text="Invalid Username or Password", fg="red", font="bold").pack()
Label(failed_message, text="").pack()
Button(failed_message,text="Ok", bg="blue", fg='white', relief="groove", font=('arial', 12, 'bold'), command=failed_destroy).pack()

• If the user enter the incorrect username or password then the invalid popup message will appear
• If the above code is executed, it produces the following result below.

Output:

9. Complete source code of the Login Page in Python with MySql Database

from tkinter import *
import tkinter.messagebox
import mysql.connector


#connecting to the database
connectiondb = mysql.connector.connect(host="localhost",user="root",passwd="",database="logindb")
cursordb = connectiondb.cursor()


def login():
global root2
root2 = Toplevel(root)
root2.title("Account Login")
root2.geometry("450x300")
root2.config(bg="white")

global username_verification
global password_verification
Label(root2, text='Please Enter your Account Details', bd=5,font=('arial', 12, 'bold'), relief="groove", fg="white",
bg="blue",width=300).pack()
username_verification = StringVar()
password_verification = StringVar()
Label(root2, text="").pack()
Label(root2, text="Username :", fg="black", font=('arial', 12, 'bold')).pack()
Entry(root2, textvariable=username_verification).pack()
Label(root2, text="").pack()
Label(root2, text="Password :", fg="black", font=('arial', 12, 'bold')).pack()
Entry(root2, textvariable=password_verification, show="*").pack()
Label(root2, text="").pack()
Button(root2, text="Login", bg="blue", fg='white', relief="groove", font=('arial', 12, 'bold'),command=login_verification).pack()
Label(root2, text="")

def logged_destroy():
logged_message.destroy()
root2.destroy()

def failed_destroy():
failed_message.destroy()

def logged():
global logged_message
logged_message = Toplevel(root2)
logged_message.title("Welcome")
logged_message.geometry("500x100")
Label(logged_message, text="Login Successfully!... Welcome {} ".format(username_verification.get()), fg="green", font="bold").pack()
Label(logged_message, text="").pack()
Button(logged_message, text="Logout", bg="blue", fg='white', relief="groove", font=('arial', 12, 'bold'), command=logged_destroy).pack()


def failed():
global failed_message
failed_message = Toplevel(root2)
failed_message.title("Invalid Message")
failed_message.geometry("500x100")
Label(failed_message, text="Invalid Username or Password", fg="red", font="bold").pack()
Label(failed_message, text="").pack()
Button(failed_message,text="Ok", bg="blue", fg='white', relief="groove", font=('arial', 12, 'bold'), command=failed_destroy).pack()


def login_verification():
user_verification = username_verification.get()
pass_verification = password_verification.get()
sql = "select * from usertable where username = %s and password = %s"
cursordb.execute(sql,[(user_verification),(pass_verification)])
results = cursordb.fetchall()
if results:
for i in results:
logged()
break
else:
failed()

def Exit():
wayOut = tkinter.messagebox.askyesno("Login System", "Do you want to exit the system")
if wayOut > 0:
root.destroy()
return

def main_display():
global root
root = Tk()
root.config(bg="white")
root.title("Login System")
root.geometry("500x500")
Label(root,text='Welcome to Log In System', bd=20, font=('arial', 20, 'bold'), relief="groove", fg="white",
bg="blue",width=300).pack()
Label(root,text="").pack()
Button(root,text='Log In', height="1",width="20", bd=8, font=('arial', 12, 'bold'), relief="groove", fg="white",
bg="blue",command=login).pack()
Label(root,text="").pack()
Button(root,text='Exit', height="1",width="20", bd=8, font=('arial', 12, 'bold'), relief="groove", fg="white",
bg="blue",command=Exit).pack()
Label(root,text="").pack()

main_display()
root.mainloop()

How To Run The Login Page in Python with MySql Database with Source Code?

To run this project, you must have installed a Pycharm on your PC (for Windows). This Login Page in Python with MySql Database with Source Code purposes only!

After downloading the project you must follow the steps below:

Step 1: Unzip the file or Extract the file

Step 2: Double click the login

Step 3: Project is ready to run

Downloadable Source Code 

I have here the list of Best Python Project with Source code free to download for free, I hope this can help you a lot.

Conclusion:

In this Login Page in Python with MySql Database with Source Code, I use the mysql.Connector library to set up a connection.