index.php
//index.php
<?php
session_start();
include('conn.php');
?>
<!DOCTYPE html>
<html>
<head>
<title>Login Using Cookie with Logout</title>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
</head>
<body id="LoginForm">
<div class="container">
<h1 class="form-heading">PHP Mysql Login using Cookie and Session</h1>
<div class="login-form">
<div class="main-div">
<div class="panel">
<h2>Admin Login</h2>
<p>Please enter your username and password</p>
</div>
<form id="Login" method="POST" action="login.php">
<div class="form-group">
<input type="text" value="<?php if (isset($_COOKIE["user"])){echo $_COOKIE["user"];}?>" name="username" class="form-control" id="inputEmail" placeholder="Email Address">
</div>
<div class="form-group">
<input type="password" value="<?php if (isset($_COOKIE["pass"])){echo $_COOKIE["pass"];}?>" name="password" class="form-control" id="inputPassword" placeholder="Password">
</div>
<div class="form-group" style="text-align:left;">
<label><input type="checkbox" name="remember" <?php if (isset($_COOKIE["user"]) && isset($_COOKIE["pass"])){ echo "checked";}?>> Remember me </label>
</div>
<div class="forgot">
<a href="#">Forgot password?</a>
</div>
<input type="submit" class="btn btn-primary" value="Login" name="login">
<span> <?php
if (isset($_SESSION['message'])){
echo $_SESSION['message'];
}
unset($_SESSION['message']);
?></span>
</form>
</div>
<p class="botto-text"> by Cairocoders</p>
</div>
</div>
<style>
body#LoginForm{ background-image:url("img/bgblur.jpg"); background-repeat:no-repeat; background-position:center; background-size:cover; padding:10px;}
.form-heading { color:#fff; font-size:23px;text-align:center;}
.panel h2{ color:#444444; font-size:18px; margin:0 0 8px 0;}
.panel p { color:#777777; font-size:14px; margin-bottom:30px; line-height:24px;}
.login-form .form-control {
background: #f7f7f7 none repeat scroll 0 0;
border: 1px solid #d4d4d4;
border-radius: 4px;
font-size: 14px;
height: 50px;
line-height: 50px;
}
.main-div {
background: #ffffff none repeat scroll 0 0;
border-radius: 2px;
margin: 10px auto 30px;
max-width: 38%;
padding: 50px 70px 70px 71px;
}
.login-form .form-group {
margin-bottom:10px;
}
.login-form{ text-align:center;}
.forgot a {
color: #777777;
font-size: 14px;
text-decoration: underline;
}
.login-form .btn.btn-primary {
background: #f0ad4e none repeat scroll 0 0;
border-color: #f0ad4e;
color: #ffffff;
font-size: 14px;
width: 100%;
height: 50px;
line-height: 50px;
padding: 0;
}
.forgot {
text-align: left; margin-bottom:30px;
}
.botto-text {
color: #ffffff;
font-size: 14px;
margin: auto;
}
.login-form .btn.btn-primary.reset {
background: #ff9900 none repeat scroll 0 0;
}
.back { text-align: left; margin-top:10px;}
.back a {color: #444444; font-size: 13px;text-decoration: none;}
</style>
</body>
</html>
login.php
//login.php
<?php
if(isset($_POST['login'])){
session_start();
include('conn.php');
$username=$_POST['username'];
$password=$_POST['password'];
$query=mysqli_query($conn,"select * from user where user_name='$username' && user_password='$password'");
if (mysqli_num_rows($query) == 0){
$_SESSION['message']="Login Failed. User not Found!";
header('location:index.php');
}
else{
$row=mysqli_fetch_array($query);
if (isset($_POST['remember'])){
//set up cookie
setcookie("user", $row['user_name'], time() + (86400 * 30));
setcookie("pass", $row['user_password'], time() + (86400 * 30));
}
$_SESSION['id']=$row['user_id'];
header('location:success.php');
}
}
else{
header('location:index.php');
$_SESSION['message']="Please Login!";
}
?>
conn.php
//conn.php
<?php
$conn = mysqli_connect("localhost","root","","testingdb");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
?>
success.php
//success.php
<?php
session_start();
if (!isset($_SESSION['id']) ||(trim ($_SESSION['id']) == '')) {
header('index.php');
exit();
}
include('conn.php');
$query=mysqli_query($conn,"select * from user where user_id='".$_SESSION['id']."'");
$row=mysqli_fetch_assoc($query);
?>
<!DOCTYPE html>
<html>
<head>
<title>Login Success</title>
</head>
<body>
<h2>Login Success</h2>
<?php echo $row['user_email']; ?>
<br>
<a href="logout.php">Logout</a>
</body>
</html>
logout.php
//logout.php
<?php
session_start();
session_destroy();
if (isset($_COOKIE["user"]) AND isset($_COOKIE["pass"])){
setcookie("user", '', time() - (3600));
setcookie("pass", '', time() - (3600));
}
header('location:index.php');
?>
user table
CREATE TABLE `user` ( `user_id` bigint(20) NOT NULL, `user_name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_email` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; INSERT INTO `user` (`user_id`, `user_name`, `user_email`, `user_password`) VALUES (1, 'cairocoders', 'cairocoders@gmail.com', 'pass'), (2, 'tutorial101.blogspot.com', 'cairocoders08@gmail.com', 'pass'); ALTER TABLE `user` ADD PRIMARY KEY (`user_id`); ALTER TABLE `user` MODIFY `user_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
