Creating a Registration and Login System with PHP and MySQL

A registration and login system is a fundamental component of many web applications and provides user authentication and security. This allows users to create an account log in with their login credentials and manage their session securely.

By using PHP for server-side scripting and MYSQL for database, management we can we can efficiently handle user data, validate credentials, and maintain user sessions. Here we use HTML, CSS, Bootstrap, and JavaScript to create a responsive web application with a dynamic error-handling mechanism. PHP and MYSQL are used for server-side rendering and Database management.

Prerequisites

• PHP Programming
• HTML
• CSS
• Bootstrap 5
• JavaScript
• MYSQL
• XAMPP
• VS Code
• Session Management

Application Features

This Registration and Login System with PHP and MySQL has the below features. And we provide related source code with outputs.

• User Registration: While registering a user. We check whether the given email exists or not. If exists we display an error message like an already email exists otherwise save the user data in the Database.
• User Login: While login, We check If the given user email ID is registered or not. If the email id is available then successfully redirect to the dashboard with sessions otherwise we display an error toast message.
• Forgot Password or Reset Password: If you want to reset your password or forgot your password then this feature can update your new password with an existing password in the database. While Resetting the password we check whether the given email ID exists or not. If not exist then we display an error message like email does not exist.
• Email Check: While resetting the password. First, we check whether the given email id exists or not. If exists then we display a green color tick mark on the email field otherwise we display the wrong symbol on the email field.
• Prevent Direct Access IDDashboard: Here we prevent accessing the Dashboard page directly without login. To achieve we use the session concept in PHP programming.
• Session Management: After successful login, we maintain the session by using an email id.
• Error Handling and Display related Error Messages: For every feature accessing we provide error handling with related error messages using toast in Bootstrap
  

Steps to Create a Registration and Login System with PHP and MySQL

For Creating a Registration and Login System with PHP and MySQL here we use XAMPP server and MySQL database. So you should have installed these two your system then only this project run on your local machine when tested. Below we provide a step by step process to create a Registration and Login System with PHP and MySQL.

Note:

Project Name : loginRegisterationSystem

Database Name: users

Table Name : userdata

Step 1: Set Up the Environment

Here we use XAMPP as a Server. So First we need start the Apache and MySQL in XAMPP.

Step 2: Create Database

Now create a Database using XAMPP Server this click on admin button related MySQL then you redirected to PhpMyAdmin page then create a new Database. Once Database is created then create a table to store user information below we provide those information for your reference.

Step 2: Create Table

Run the below given code to the "SQL" tab.

Table creation:

CREATE TABLE userdata (
 id int NOT NULL AUTO_INCREMENT,
 username varchar(45) NOT NULL,
 email varchar(45) NOT NULL,
 password varchar(255) NOT NULL,
 PRIMARY KEY ( id ),
 UNIQUE KEY id_UNIQUE ( id )
)

Step 3: Create the Project

Once Project setting is completed. It's time to create a project to handle Registration and Login System with PHP and MySQL. So first navigate to xampp folder in your system then go to htdocs the create a project. Once project is created successfully now created required files below we provide folder structure image for your reference.

\xampp->htdocs->loginRegisterationSystem

Folder Structure:

Step 3: Create the Database Connection

Open your project folder in any IDE here we use VS Code then create a folder name database. In this folder create a php file with name db_connection.php then write PHP script for connecting the MySQL Database. Below we provide connection scripting source for your reference. For connecting MySQL database we need below parameters.

• host name
• username
• password
• database name

Note: Add your username and password that you have set already. If you are new then username will be username and the password will be blank "".

db_connection.php

Step 4: Create the Registration Page

Once Database connection is completed Then create a folder in the project with name pages. In that folder create register php file and include connection file in that and write source code for designing web page and store the user data which is given using that registration form. Below we provide that source code for your reference along with outputs. While registration a user. We check the given email is exist or not. If exist we display an error message like already email exist otherwise save the user data in Database. For registration purpose we gather below information.

• user name
• email address
• password

register.php

Step 5: Create Login page

Once user registration is completed Then create a login php file and include connection file in that and write source code for designing web page and check user data which is given using that login form. Below we provide that source code for your reference along with outputs. While login, We check If given user email id is registered or not. If email id available then successfully redirecting to dashboard with sessions otherwise we display a error toast message. For login purpose we gather below information.

• email address
• password

login.php

Step 6: Create the Dashboard

Once login page completed then create a dashboard page. And add connection file and session to avoid direct access without login. Below we provide that source code for your reference. If login successfully done redirecting to dashboard with sessions otherwise we display a error toast message. In dashboard page we implement logout functionality also we provide output image for your reference.

• session : user email

dashboard.php

Step 7: Create Logout Component

If you want to logout then click on logout button in dashboard page. Then automatically your session is destroyed and redirecting to login page. For your reference we provide source code below.

logout.php

Step 8: Create Forgot Password page

If your password is forgot then click on forgot option in login page then redirecting to forgot password page then enter your email id. after enter your email id we check this email is is exist or not. If exist we display a green color tick symbol otherwise we display red color wrong symbol on email field. below we provide source codes for email check and reset password for your reference.

resetpassword.php

Step 9: Create Check Email validation logic

Step 10: Use this link to get the output

http://localhost/loginRegisterationSystem/pages/register.php%3C/span>

Output: