This Tutorial will teach you how to make the Login and Logout Form with Session in PHP MySQL. In order to create the project i have used editor as PHPStrom
First Step you have to Establish the Database Connection. i have created the file which name is db.php.
<?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "pmlogin"; $conn = mysqli_connect($servername,$username,$password,$dbname); ?>
After that you have to create the Login Form. and call the database connection page name like this way include “db.php”;
<?php
include "db.php";
session_start();
if($_SERVER["REQUEST_METHOD"]=='POST')
{
$username = mysqli_real_escape_string($conn,$_POST['username']);
$password = mysqli_real_escape_string($conn,$_POST['password']);
$sql = "select * from user where user = '$username' and pass = '$password'";
$result = mysqli_query($conn,$sql);
if(mysqli_num_rows($result)== 1)
{
while ($row = mysqli_fetch_assoc($result))
{
$user_id = $row['id'];
$user_name = $row['user'];
$_SESSION["id"]=$id;
$_SESSION["utype"]=$type;
$_SESSION['user'] = $user_name;
}
header('location:index.php');
}
else
{
echo "<script> alert('Username or Password do not Match') </script>";
}
}
?>
<html xmlns="http://www.w3.org/1999/xhtml"><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><?php echo ADM_TITLE; ?></title>
<style type="text/css">
<!--
body,td,th {
color: #000000;
}
body {
background-color: #F0F0F0;
}
.style1 {
font-family: Arial, Helvetica, sans-serif;
font-size: 14px;
padding: 12px;
text-decoration: none;
line-height: 25px;
border-radius: 4px;
}
.style2 {
font-family: Arial, Helvetica, sans-serif;
font-size: 16px;
padding: 12px;
text-decoration: none;
font-size: 18px;
line-height: 25px;
border-radius: 4px;
}
</style>
<script language="javascript">
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
</script>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
</head>
<body onload="MM_preloadImages('pagination/ajax-loader.gif');">
<div class="container">
<table width="100%" height="100%" border="0" cellspacing="0" width="100%" align="center">
<tr>
<td align="center" valign="middle"><?php //echo $sess_id; ?>
<table class="table-bordered" width="350" border="0" cellpadding="3" cellspacing="3" bgcolor="#FFFFFF" >
<form name="frm_login" id="frm_login" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<tr>
<td height="25" colspan="2" align="left" valign="middle" bgcolor="#FF9900" class="style2">
<div align="center">
<strong>Administrator Panel</strong>
</div>
</td>
</tr>
<tr>
<td width="118" align="left" valign="middle" class="style1">User Name</td>
<td width="225" align="left" valign="middle"><input type="text" class="form-control" size="10px" id="username" placeholder="Enter email" name="username"></td>
</tr>
<tr>
<td align="left" valign="middle"><input type="password" class="form-control" size="10px" id="password" placeholder="Enter password" name="password"></td>
</tr>
<tr>
<td align="left" valign="middle" class="style1">Role</td>
<td align="left" valign="middle" class="style1">
<select class="form-control" id="project_status" name="project_status"
placeholder="Project Status" required>
<option value="">Please Select</option>
<option value="1">On Going</option>
<option value="2">On Hold</option>
<option value="3">Completed</option>
<option value="4">Canceled</option>
</select>
</td>
</tr>
<tr>
<td align="right" colspan="2" valign="middle">
<input type="submit" name="button" class="btn btn-info" id="button" value="Login" />
<input type="submit" name="button" class="btn btn-warning" id="button" value="Reset" />
</td>
</tr>
</form>
</table>
</td>
</tr>
</table>
</div>
</body>
</html>
Login we made a user validation. if the user enter the correct username along with password it will redirect to the index.php page along with session.other wise it will show the Error message as Username or Password do not Match.
if you want logout the page click logout link.
<?php
session_start();
if(session_destroy())
{
header("Location: login.php");
exit();
}
?>
If you're just beginning to learn Java GUI programming creating an Water System Calculator is a fantastic project for…
GitHub is a powerful tool used by teams and developers around the globe. This guide is…
It's like having a super-smart buddy that is always there to help you write stories,…
The UK is known for its rich history, diverse culture, and most of all its…
Do you have a plan for your next holiday? Being aware of the Bank Holidays within the…
The world is rapidly changing of software development AI-assisted tools for coding have become the main focus. As…