Login and Signup form using PHP and
MySQL with validation
❮ PreviousNext ❯
Login, Signup and Logout now common for any web application. Because
without login we can not track the data who uses our application.
1. PHP Login logout example with sessi...
Play
Unmute
Remaining Time -4:47
1x
Playback Rate
Fullscreen
Advertisement: 0:07
2.
1. Now Playing
PHP Login logout example with session
2.
How to Delete Data From MySQL Using PHP
4:24
3.
PHP Login logout example with session
5:04
4.
How to insert data in PHP XAMPP Server
6:54
5.
How to upload file In PHP
5:47
6.
Retrieve Data From MySQL Using PHP
6:08
7.
How to Insert Data using PHP Ajax
6:12
8.
How to insert data in PHP XAMPP Server
6:54
9.
Login and signup example using php
2:01
10.
How to upload file In PHP
5:47
11.
Play Video
PHP Login logout example with session
In this example we will discuss how to create a login and signup form using PHP
and MySQL database.
For any kind of web application login, signup is the most important thing for
security reasons. If we do not have login features in our web application then
any one can access our data and services.
Here in this login and signup form example we using 5 files these are:
SQL file: For create table
database.php:For connecting database
register.php: For getting the values from the user
register_a.php: A PHP file that process the signup request
login.php :for getting the values from the user
loginProcess.php : For login process to check valid user or not
home.php : for welcome page after login
logout.php :For logout from the application
Step 1:Create the above table
Step 2: create all other files mentioned above.
Step 3: Create an upload folder for storing the image file.
Then open your browser and put url localhost/login/
Sql file
CREATE TABLE `register` (
`ID` int(10) NOT NULL,
`First_Name` varchar(100) NOT NULL,
`Last_Name` varchar(100) NOT NULL,
`Email` varchar(100) NOT NULL,
`Password` int(100) NOT NULL,
`File` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
database.php
<?php
$url='localhost';
$username='root';
$password='';
$conn=mysqli_connect($url,$username,$password,"fregister");
if(!$conn){
die('Could not Connect My Sql:' .mysql_error());
}
?>
register.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-
scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://fonts.googleapis.com/css?
family=Roboto:400,700">
<title>Welcome to Finance Portal</title>
<link rel="stylesheet"
href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/boot
strap.min.css">
<link rel="stylesheet"
href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font
-awesome.min.css">
<link rel="stylesheet" href="assests/css/style.css">
<script src="https://code.jquery.com/jquery-
3.5.1.min.js"></script>
<script
src="https://cdn.jsdelivr.net/npm/
[email protected]/dist/umd/poppe
r.min.js"></script>
<script
src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootst
rap.min.js"></script>
</head>
<body>
<div class="signup-form">
<form action="register_a.php" method="post"
enctype="multipart/form-data">
<h2>Register</h2>
<p class="hint-text">Create your account</p>
<div class="form-group">
<div class="row">
<div class="col"><input type="text"
class="form-control" name="first_name" placeholder="First Name"
required="required"></div>
<div class="col"><input type="text"
class="form-control" name="last_name" placeholder="Last Name"
required="required"></div>
</div>
</div>
<div class="form-group">
<input type="email" class="form-control"
name="email" placeholder="Email" required="required">
</div>
<div class="form-group">
<input type="password" class="form-control"
name="pass" placeholder="Password" required="required">
</div>
<div class="form-group">
<input type="password" class="form-control"
name="cpass" placeholder="Confirm Password" required="required">
</div>
<div class="form-group">
<input type="file" name="file" required>
<!-- <input type="submit" name="upload"
value="Upload" class="btn"> -->
</div>
<div class="form-group">
<label class="form-check-label"><input
type="checkbox" required="required"> I accept the <a
href="#">Terms of Use</a> & <a href="#">Privacy
Policy</a></label>
</div>
<div class="form-group">
<button type="submit" name="save" class="btn btn-
success btn-lg btn-block">Register Now</button>
</div>
<div class="text-center">Already have an account? <a
href="login.php">Sign in</a></div>
</form>
</div>
</body>
</html>
register_a.php
<?php
extract($_POST);
include("database.php");
$sql=mysqli_query($conn,"SELECT * FROM register where
Email='$email'");
if(mysqli_num_rows($sql)>0)
{
echo "Email Id Already Exists";
exit;
}
else(isset($_POST['save']))
{
$file = rand(1000,100000)."-".$_FILES['file']['name'];
$file_loc = $_FILES['file']['tmp_name'];
$folder="upload/";
$new_file_name = strtolower($file);
$final_file=str_replace(' ','-',$new_file_name);
if(move_uploaded_file($file_loc,$folder.$final_file))
{
$query="INSERT INTO register(First_Name, Last_Name,
Email, Password, File ) VALUES ('$first_name', '$last_name',
'$email', 'md5($pass)', '$final_file')";
$sql=mysqli_query($conn,$query)or die("Could Not Perform
the Query");
header ("Location: login.php?status=success");
}
else
{
echo "Error.Please try again";
}
}
?>
login.php
<?php
session_start();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-
scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://fonts.googleapis.com/css?
family=Roboto:400,700">
<title>Welcome to Finance Portal</title>
<link rel="stylesheet"
href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/boot
strap.min.css">
<link rel="stylesheet"
href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font
-awesome.min.css">
<link rel="stylesheet" href="assests/css/style.css">
<script src="https://code.jquery.com/jquery-
3.5.1.min.js"></script>
<script
src="https://cdn.jsdelivr.net/npm/
[email protected]/dist/umd/poppe
r.min.js"></script>
<script
src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootst
rap.min.js"></script>
</head>
<body>
<div class="signup-form">
<form action="loginProcess.php" method="post"
enctype="multipart/form-data">
<h2>Login</h2>
<p class="hint-text">Enter Login Details</p>
<div class="form-group">
<input type="email" class="form-control"
name="email" placeholder="Email" required="required">
</div>
<div class="form-group">
<input type="password" class="form-control"
name="pass" placeholder="Password" required="required">
</div>
<div class="form-group">
<button type="submit" name="save" class="btn btn-
success btn-lg btn-block">Login</button>
</div>
<div class="text-center">Don't have an account? <a
href="register.php">Register Here</a></div>
</form>
</div>
</body>
</html>
loginProcess.php
<?php
session_start();
if(isset($_POST['save']))
{
extract($_POST);
include 'database.php';
$sql=mysqli_query($conn,"SELECT * FROM register where
Email='$email' and Password='md5($pass)'");
$row = mysqli_fetch_array($sql);
if(is_array($row))
{
$_SESSION["ID"] = $row['ID'];
$_SESSION["Email"]=$row['Email'];
$_SESSION["First_Name"]=$row['First_Name'];
$_SESSION["Last_Name"]=$row['Last_Name'];
header("Location: home.php");
}
else
{
echo "Invalid Email ID/Password";
}
}
?>
home.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-
scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://fonts.googleapis.com/css?
family=Roboto:400,700">
<title>Welcome to Finance Portal</title>
<link rel="stylesheet"
href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/boot
strap.min.css">
<link rel="stylesheet"
href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font
-awesome.min.css">
<link rel="stylesheet" href="assests/css/style.css">
<script src="https://code.jquery.com/jquery-
3.5.1.min.js"></script>
<script
src="https://cdn.jsdelivr.net/npm/
[email protected]/dist/umd/poppe
r.min.js"></script>
<script
src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootst
rap.min.js"></script>
</head>
<body>
<div class="signup-form">
<form action="home.php" method="post"
enctype="multipart/form-data">
<h2>Welcome</h2>
<br>
<?php
session_start();
include 'database.php';
$ID= $_SESSION["ID"];
$sql=mysqli_query($conn,"SELECT * FROM
register where ID='$ID' ");
$row = mysqli_fetch_array($sql);
?>
<img src="upload/<?php echo $row['File'] ?>" height="150"
width="150" style="border-radius:50%;display:block;margin-
left:auto;margin-right:auto;" />
<p class="hint-text"><br><b>Welcome </b><?php echo
$_SESSION["First_Name"] ?> <?php echo $_SESSION["Last_Name"] ?
></p>
<div class="text-center">Want to Leave the Page? <br><a
href="logout.php">Logout</a></div>
</form>
</div>
</body>
</html>
logout.php
<?php
session_start();
unset($_SESSION["id"]);
unset($_SESSION["name"]);
header("Location:login.php");
?>
<?php
$servername='localhost';
$username='root';
$password='';
$dbname = "crud";
$conn=mysqli_connect($servername,$username,$password,"$dbname");
if(!$conn){
die('Could not Connect My Sql:' .mysql_error());
}
?>
index.php
<?php
session_start();
include_once 'database.php';
if(isset($_POST['submit']))
{
$user_id = $_POST['user_id'];
$result = mysqli_query($conn,"SELECT * FROM user_details
where user_id='" . $_POST['user_id'] . "'");
$row = mysqli_fetch_assoc($result);
$fetch_user_id=$row['user_id'];
$email_id=$row['email_id'];
$password=$row['password'];
if($user_id==$fetch_user_id) {
$to = $email_id;
$subject = "Password";
$txt = "Your password is : $password.";
$headers = "From:
[email protected]" . "\r\n" .
"CC: [email protected]";
mail($to,$subject,$txt,$headers);
}
else{
echo 'invalid userid';
}
}
?>
<!DOCTYPE HTML>
<html>
<head>
<style type="text/css">
input{
border:1px solid olive;
border-radius:5px;
}
h1{
color:darkgreen;
font-size:22px;
text-align:center;
}
</style>
</head>
<body>
<h1>Forgot Password<h1>
<form action='' method='post'>
<table cellspacing='5' align='center'>
<tr><td>user id:</td><td><input type='text'
name='user_id'/></td></tr>
<tr><td></td><td><input type='submit' name='submit'
value='Submit'/></td></tr>
</table>
</form>
</body>
</html>
