PHP Login Script with Encryption.

In this post I want to explain how to insert encrypted password while registration and accessing the same with login time. I'm just storing encrypted user password in database. Demo username ='test' and password = 'test'

Database
MySQL admin table columns id, username, passcode.

CREATE TABLE admin
(
id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(50) UNIQUE,
passcode VARCHAR(50)
);

Encrypted Password
Here database table admin password:test encrypted and storing like this

registration.php
Contains PHP and HTML code. Just inserting form values into database table admin

<?php

include("db.php");
if($_SERVER["REQUEST_METHOD"] == "POST")
{

// username and password sent from Form

$username=mysqli_real_escape_string($db,$_POST['username']);
$password=mysqli_real_escape_string($db,$_POST['password']);
$password=md5($password); // Encrypted Password
$sql="Insert into admin(username,passcode) values('$username','$password');";
$result=mysqli_query($db,$sql);
echo "Registration Successfully";
}

?>

<form action="registration.php" method="post">

<label>UserName :</label>

<input type="text" name="username"/><br />

<label>Password :</label>

<input type="password" name="password"/><br/>

<input type="submit" value=" Registration "/><br />

</form>

login.php
Login Script accessing the encrypted password.

<?php

include("db.php");
session_start();
if($_SERVER["REQUEST_METHOD"] == "POST")
{

// username and password sent from Form

$username=mysqli_real_escape_string($db,$_POST['username']);
$password=mysqli_real_escape_string($db,$_POST['password']);
$password=md5($password); // Encrypted Password
$sql="SELECT id FROM admin WHERE username='$username' and passcode='$password'";
$result=mysqli_query($db,$sql);
$count=mysqli_num_rows($db,$result);

// If result matched $username and $password, table row must be 1 row
if($count==1)
{
header("location: welcome.php");
}
else
{
$error="Your Login Name or Password is invalid";
}
}

?>

<form action="login.php" method="post">

<label>UserName :</label>

<input type="text" name="username"/><br />

<label>Password :</label>

<input type="password" name="password"/><br/>

<input type="submit" value=" Login "/><br />

</form>

db.php
Database configuration file.

<?php
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'username');
define('DB_PASSWORD', 'password');
define('DB_DATABASE', 'database');
$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
?>