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.
Index
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>
