Simple Registration and Login form with PHP and MySQL

Here we are discussing how to create simple login form in PHP and MySQL. You have to follow below basic steps for that.

Before starting, you should know how to use PHPMyAdmin and some basic knowledge of PHP.

Step 1: Create a Database

Create a database in PHPMyAdmin. Create Table using id, username, email, password fields. In my case, I created a table name ‘registration’.

Step 2: Create a Registration Page

Create a simple page with the name registration.php and paste the following code in it.

<?php
    session_start();

    // connect to the database
    $db = mysqli_connect("localhost","username","password","database_name");

    if(!$db){
        die("connection error...".mysqli_connect_error());
    }else{
        echo "You are successfully connected.";
    }
    
    if(isset($_POST['username']) && isset($_POST['password'])){
        $username=$_POST['username'];
        $email=$_POST['email'];
        $password=$_POST['password'];
        
    $temp = mysqli_query($db,"INSERT INTO registration (username,email,password) 
    VALUES ('$username','$email','$password')");
    
    if(!$temp){
        echo "error";
    }else{
        echo "Your registration is done.";
    }
    }
?>

<html>
<head>
<title>Registration</title>
</head>
<body>
<div class="container">
      <form class="form-signin" method="POST" name="registration">
        <h2 class="form-signin-heading">Please Register</h2>
        <div class="input-group">
	        <span class="input-group-addon" id="basic-addon1">Username</span>
	        <input type="text" name="username" id="username" class="form-control" placeholder="Username" required>
	    </div>
        <label for="inputEmail" class="sr-only">Email ID</label>
        <input type="email" name="email" id="email" class="form-control" placeholder="Email address" required autofocus>
        <br>
        <label for="inputPassword" class="sr-only">Password</label>
        <input type="password" name="password" id="password" class="form-control" placeholder="Password" required>
        <br>
        <input name="submit" type="submit" value="Register" />
        <a class="btn btn-lg btn-primary btn-block" href="login.php">Login</a>
      </form>
</div>
</body>
</html>

Step 3: Create Login Page

Create a simple page with name login.php and paste the following code in it

<?php
session_start();

    // connect to the database
    $db = mysqli_connect("localhost","username","password","database_name");

    if(!$db){
        die("connection error...".mysqli_connect_error());
    }else{
        echo "You are successfully connected.";
    }
session_start();
// after form submitted insert values in to tables.
if (isset($_POST['username'])){
        // removes backslashes
	$username = stripslashes($_REQUEST['username']);
        //escapes special characters in a string
	$username = mysqli_real_escape_string($db,$username);
	$password = stripslashes($_REQUEST['password']);
	$password = mysqli_real_escape_string($db,$password);
	//Checking for user already exist in the table or not
        $query = "SELECT * FROM `registration` WHERE username='$username'
and password='$password'";
	$result = mysqli_query($db,$query) or die(mysql_error());
	$rows = mysqli_num_rows($result);
        if($rows==1){
	    $_SESSION['username'] = $username;
            // Redirect user to index.php
	    header("Location: index.php");
         }else{
	echo "<div class='form'>
<h3>Username OR Password is incorrect.</h3>
<br/><a href='login.php'>Login</a></div>";
	}
    }
?>

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Login</title>
</head>
<body>

<div class="form">
<h1>Log In</h1>
<form action="" method="post" name="login">
<input type="text" name="username" placeholder="User Name" required>
<br>
<input type="password" name="password" placeholder="Password" required>
<br>
<input name="submit" type="submit" value="Login">
</form>
<p>Not registered yet? <a href='registration.php'>Register Here</a></p>
</div>
</body>
</html>

Step 4: Create an Index Page

Create a simple page with name index.php and paste the following code in it

<!DOCTYPE html>
<html>
<title>Index</title>
<body>
<h1>You are logged in...</h1>
</body>
</html>

Leave a Reply

Your email address will not be published. Required fields are marked *

Read previous post:
MySQLi Functions Introduction in PHP
MySQLi Functions Introduction in PHP

MySQLi functions allow you to access the MySQL database server. Here we take a quick look at some basic functions...

Close