How to create admin login page using PHP?
Last Updated :
30 May, 2022
In this article, we will see how we can create a login page for admin, connected with the database, or whose information to log in to the page is already stored in our database.
Follow the steps to create an admin login page using PHP:
Approach: Make sure you have XAMPP or WAMP installed on your windows machine. In case you’re using Linux OS then install the LAMP server. In this article, we will be using the XAMPP server.
1. Create Database: First, we will create a database named ‘geeksforgeeks‘ (you can give any name to your database). You can also use your existing database or create a new one.
create database “geeksforgeeks”
2. Create Table: Create a table named ‘adminlogin’ with 3 columns to store the data.
create table “adminlogin”
3. Create Table Structure: The table “adminlogin” contains three fields.
- id – primary key – auto increment
- username – varchar(100)
- password – varchar(100)
The datatype for username and password is varchar. The size can be altered as per the requirement. However, 100 is sufficient, and the datatype for “id” is int and it is a primary key.
A primary key also called a primary keyword is a key in a relational database that is unique for each record. It is a unique identifier, such as a driver’s license number, telephone number (including area code), or vehicle identification number (VIN).
Your table structure should look like this.
table structure
Or copy and paste the following code into the SQL panel of your PHPMyAdmin.
DROP TABLE IF EXISTS `adminlogin`;
CREATE TABLE IF NOT EXISTS `adminlogin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
To do this from SQL Panel refer to the following screenshot.
create a table from SQL panel
4. Insert admin login information: Here, we are inserting two records in our table. You can add as many as you want.
inserting records
Or copy and paste the following code to insert records into the SQL panel.
INSERT INTO `adminlogin` (`id`, `username`, `password`) VALUES (NULL, 'admin', 'admin'), (NULL, 'admin2', 'admin2');
After inserting the values, the table will look like this.
table records
5. Create a folder that includes the following files: The folder should be in “C:\xampp\htdocs\” (or where your XAMPP is installed). For the WAMP server, it should be in “C:\wamp64\www\” and on Linux “/opt/lampp/htdocs”.
HTML
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<link rel="stylesheet" href=
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<link rel="stylesheet" href="login.css">
<title>Login Page</title>
</head>
<body>
<form action="validate.php" method="post">
<div class="login-box">
<h1>Login</h1>
<div class="textbox">
<i class="fa fa-user" aria-hidden="true"></i>
<input type="text" placeholder="Username"
name="username" value="">
</div>
<div class="textbox">
<i class="fa fa-lock" aria-hidden="true"></i>
<input type="password" placeholder="Password"
name="password" value="">
</div>
<input class="button" type="submit"
name="login" value="Sign In">
</div>
</form>
</body>
</html>
|
PHP
<?php
$conn = "";
try {
$servername = "localhost:3306";
$dbname = "geeksforgeeks";
$username = "root";
$password = "";
$conn = new PDO(
"mysql:host=$servername; dbname=geeksforgeeks",
$username, $password
);
$conn->setAttribute(PDO::ATTR_ERRMODE,
PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
?>
|
CSS
body {
margin: 0;
padding: 0;
font-family: sans-serif;
background: url() no-repeat;
background-size: cover;
}
.login-box {
width: 280px;
position: absolute;
top: 50%;
left: 50%;
transform: translate(-50%, -50%);
color: #191970;
}
.login-box h1 {
float: left;
font-size: 40px;
border-bottom: 4px solid #191970;
margin-bottom: 50px;
padding: 13px;
}
.textbox {
width: 100%;
overflow: hidden;
font-size: 20px;
padding: 8px 0;
margin: 8px 0;
border-bottom: 1px solid #191970;
}
.fa {
width: px;
float: left;
text-align: center;
}
.textbox input {
border: none;
outline: none;
background: none;
font-size: 18px;
float: left;
margin: 0 10px;
}
.button {
width: 100%;
padding: 8px;
color: #ffffff;
background: none #191970;
border: none;
border-radius: 6px;
font-size: 18px;
cursor: pointer;
margin: 12px 0;
}
|
PHP
<?php
include_once('connection.php');
function test_input($data) {
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$username = test_input($_POST["username"]);
$password = test_input($_POST["password"]);
$stmt = $conn->prepare("SELECT * FROM adminlogin");
$stmt->execute();
$users = $stmt->fetchAll();
foreach($users as $user) {
if(($user['username'] == $username) &&
($user['password'] == $password)) {
header("location: adminpage.php");
}
else {
echo "<script language='javascript'>";
echo "alert('WRONG INFORMATION')";
echo "</script>";
die();
}
}
}
?>
|
- Filename: adminpage.php Add anything that you want to display to the admin page.
6. After completing all the above steps, now follow the steps:
- Run XAMPP server
- Start Apache and MySQL services from XAMPP Panel.
- Type http://localhost/loginPage/ in your browser.
You will get the following login page screen.
If you enter the correct credentials i.e. username and password, then you will be logged in to the “admin.php” page.
else, you get an error pop-up alert.
PHP is a server-side scripting language designed specifically for web development. You can learn PHP from the ground up by following this PHP Tutorial and PHP Examples.
Similar Reads
How to create admin login page using PHP?
In this article, we will see how we can create a login page for admin, connected with the database, or whose information to log in to the page is already stored in our database. Follow the steps to create an admin login page using PHP: Approach: Make sure you have XAMPP or WAMP installed on your win
4 min read
Signup form using PHP and MySQL Database
The task is to create and design a sign-up form in which if the user enters details, the HTML form data are inserted into our MySQL server database. Approach: First task is that we have to create our MySQL server Database and a Table according to our requirements. We connect our MySQL server Databas
4 min read
Online Group Chat application using PHP
Prerequisites: Technical knowledge: HTMLCSSJavascript (basics)PHP (Database connectivity)SQL queries Softwares to be installed: XAMPP server: This is a free software which contains web server Apache, Database management system for MySQL (or MariaDB). It can be downloaded for free from the official s
9 min read
How to Resize JPEG Image in PHP ?
Why do we need to resize images? In a website, often, we need to scale an image to fit a particular section. Sometimes, it becomes necessary to scale down any image of random size to fit a cover photo section or profile picture section. Also, we need to show a thumbnail of a bigger image. In those c
2 min read
How to make PDF file downloadable in HTML link using PHP ?
In web development, it is common to provide users with downloadable resources, such as PDF files. If you want to create a downloadable PDF link using HTML and PHP, this article will guide you through the process of making a PDF file downloadable when the user clicks on a link. ApproachCreate an HTML
3 min read
How to extract img src and alt from html using PHP?
Extraction of image attributes like 'src', 'alt', 'height', 'width' etc from a HTML page using PHP. This task can be done using the following steps. Loading HTML content in a variable(DOM variable). Selecting each image in that document. Selecting attribute and save it's content to a variable. Outpu
2 min read
Upload pdf file to MySQL database for multiple records using PHP
We will upload multiple records to the database and display all the records from the database on the same page. In this article, we will see how we can upload PDF files to a MySQL database using PHP. Approach: Make sure you have XAMPP or WAMP installed on your machine. In this tutorial, we will be u
7 min read
Mailer multiple address in PHP
In this article, we will be demonstrating how we can send the mail to the multiple addresses from the database using the PHP. PHPMailer library is used to send any email safely from the unknown e-mail to any mail id using PHP code through XAMPP web-server for this project. Installation process for a
2 min read
Covid 19 Tracker Web App using PHP
In this article, we will see how to create a web application for tracking the Covid19 using PHP. Our Covid19 Tracker app will give the latest information for the States and Union Territories of India about the following things. Number of Active Cases of Covid19.Number of Confirmed Cases of Covid19.N
3 min read
How to automatically start a download in PHP ?
This post deals with creating a start downloading file using PHP. The idea is to make a download button which will redirect you to another page with the PHP script that will automatically start the download. Creating a download button: <!DOCTYPE html> <html> <head> <meta name=
2 min read