PHP MySQL Login System Using SESSION Source Codes

PHP MySQL Login With SESSION

Hi Guys I hope you are doing Well. Today We will learn How to Create a SESSION Based Login System Using PHP.
It's very Easy and Simple.I Hope you will Enjoy This Article.

Database and Files Structure:

Database Structure:

PHP MySQL Login With SESSION

Database Name: codenair
Table Name: user
use Below SQL Codes for Create Table called test.

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

Now we Will Insert some rows in test table using Below codes.

INSERT INTO `user` (`id`, `username`, `password`, `fullname`) VALUES
(1, 'RAJ', '12345', 'ANJAN KUMAR DHALI'),
(2, 'ABCD', '12345', 'I Am Superstar');

Now We have Successfully Completed our Works on Database.
Files Structure:

PHP MySQL Login With SESSION

We will Needs 7 files to create our complete session based login system.
1. connect.php
2. index.php
3. profile.php
4. logout.php
5. style.css
Now Copy The below codes for your Different files.

1. connect.php

connect.php file to create connection with database and sever

<?php
// Creating connection test is our database name
$conn = new mysqli('localhost', 'root', '','codenair');
// Checking connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
?>

2. index.php

we use index page to display login form and process the user logged information.if the user session is activated user will automatically redirect profile page instead of login page.

<?php
session_start();
//checking for current user session
if(isset($_SESSION['user'])){
 //Redirect Active Session user to Profile page
header("location: profile.php");
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Login Form in PHP with Session</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id="main">
<h1>PHP MySQL Login Session Example</h1>
<form action="" method="post">
<table>
    <tr>
    <td><span>UserName :</span></td>
    <td><input id="name" name="username" type="text" required></td>
 </tr>
 <tr>
    <td><span>Password :</span></td>
    <td><input id="password" name="password" type="password" required></td>
 </tr>
 <tr>
    <td></td>
    <td><input type="submit" name="login" value="Login"></td>
 </tr>
 
</table>
</form>
</div>
</body>
</html>
 
<?php
//processing the login information
include("connect.php");
if (isset($_POST['login'])) {
if (empty($_POST['username']) || empty($_POST['password'])) {
      echo "Username or Password is Empty";
}else{
// Define $username and $password
$username = mysqli_real_escape_string($conn,$_POST['username']);
$password = mysqli_real_escape_string($conn,$_POST['password']);
// SQL query to fetch information of registerd users and finds user match.
$result =mysqli_query($conn,"select * from user where password='$password' AND username='$username'");
$row =$result->num_rows;
//if user match $row must be 1
if ($row == 1) {
   $_SESSION['user']=$username; // Registering SESSION for logged user
header("location: profile.php"); // Redirecting To Other Page
}else{
   echo "Username or Password is invalid";
}
}
}
?>

3. profile.php

Displaying Logged user Information

<?php
session_start();
//Checking for Current user session
if(empty($_SESSION['user'])){
 header('location:index.php');
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Welcome to <?php echo $_SESSION['user']; ?> Profiles</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id="profile">
<b id="welcome">Welcome : <i><?php echo $_SESSION['user']; ?></i></b>
<b id="logout"><a href="logout.php">Log Out</a></b>
  
<?php
include('connect.php');
//Getting Active SESSION User Data From Database
$result=mysqli_query($conn,"SELECT*FROM user WHERE username='".$_SESSION['user']."'");
$row=$result->fetch_assoc();?>
<h3>Your Username is: <?php echo $row['username'];?></h3>
<h3>Your Password is: <?php echo $row['password'];?></h3>
<h3>Your Full name is: <?php echo $row->fullname;?></h3>
  
<?php ?>
</div>
</body>
</html>

4. logout.php

Destroying current User Session.

<?php
session_start();
session_destroy();
header('location:index.php');
?>

7.Codes for style.css

Style our index and profile page.

input[type=text],[type=password]{
    width: 250px;
    padding: 8px;
    margin: 4px 0;
    box-sizing: border-box;
    border: 1px solid #808080;
    -webkit-transition: 0.5s;
    transition: 0.5s;
   font-size:20px;
}
span{
      font-size:22px;
     color:green;
        font-weight:bold;
}
input[type=text]:focus {
    border: 1px solid green;
}
   
input[type=submit]{
 background:black;
 color:white;
 padding:6px 8px;
 font-weight:bold;
 cursor:pointer;
 border-radius:5px;
}
#profile{
 background:#ccc;
 width:500px;
 height:200px;
 margin:auto;
 border:1px solid green;
}
#logout{
 border:1px solid green;
 font-size:20px;
}
#main{
 width:600px;
 box-shadow:3px 4px 14px 11px #ccc;
 margin:auto;
}
h3{
  color:green;
}

I hope you have Successfully Created PHP MySQL SESSION Based Login System.if You face any problems please comments and Keep Visiting for Next Tutorial.Thank You.