php admin and user login with session - Web Development and Web Design Codes

Latest

Friday, May 26, 2017

php admin and user login with session

PHP MySQL Admin Panel and User Panel Login With SESSION


admin and user login in php mysql
admin and user login in php mysql

Hi Guys Today we will Learn how To create a Admin and User Panel Login System with SESSION in Single page.
You do not need to create Separate admin and user page.
When a user Hit login Button After Fill the Username and Password They Will Automatically Redirect Their Area Accroding To Their Role.
Ex: Admin will Redirect admin page and user will Redirect user page. I provide this codes Only for Beginners .it will help User To Understand Role Based Login System with SESSION.
learn more about PHP SESSION

Database and Files Creation:

Database Structure:
Database Name: codenair
Table Name: user
Use the below SQL Commands to Create Table Named 'user'
?
1
2
3
4
5
6
7
CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `role` varchar(100) NOT NULL,
   PRIMARY KEY(id)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

Dumping data for table `user`
?
1
2
3
INSERT INTO `user` (`id`, `username`, `password`, `role`) VALUES
(NULL, 'XYZ', '1234', 'user'),
(NULL, 'ABCD', '1122', 'admin');

Files Structure:
Create 7 files in same folder named:
1. connect.php
2. login.php
3. session.php
4. admin.php
5. user.php
6. logout.php
7. style.css
Now Copy the Below codes for For Certain File
admin and user login in php mysql
admin and user login in php mysql

 connect.php:
?
1
2
3
4
5
6
7
8
<?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);
}
?>

login.php:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
<?php
session_start();
if(!empty($_SESSION['user'])){
 include('session.php');
 if($role_session=='admin'){
    header('location:admin.php');
     }
  if($role_session=='user'){
    header('location:user.php');
     }
}
?>
<link rel="stylesheet" href="style.css" type="text/css"/>
<h3>PHP MySQL SESSION Based User and Admin Pannel Login System</h3>
<form method="POST" action="">
   <table>
      <tr>
      <td><span>UserName:</span></td>
   <td><input type="text" name="username"/></td>
   </tr>
   <tr>
      <td><span>Password:</span></td>
   <td><input type="password" name="password"/></td>
   </tr>
   <tr>
      <td></td>
   <td><input type="submit" name="submit" value="LogIn"/></td>
   </tr>
   </table>
</form>
 
<?php
include("connect.php");
if(isset($_POST['submit'])){
 $name=$_POST['username'];
 $pass=$_POST['password'];
  //RUN Sql query to Get result
 $result=mysqli_query($conn,"SELECT*FROM user WHERE username='$name' AND password='$pass'");
    $count=$result->num_rows;
 //for valid user login count must be 1
 if($count==1){
    $row=$result->fetch_assoc();
    $role=$row['role'];
 //Setting SESSION
  $_SESSION['user']=array(
   'username'=>$row['username'],
   'password'=>$row['password'],
   'role'=>$row['role']
   );
   switch($role){
    case'user':
    header('location:user.php');
       break;
       case'admin':
       header('location:admin.php');
       break;   
 }
}else{
 echo "No User Found";
}
}
 ?>

session.php
Now we will access logged user session using session.php page.
?
1
2
3
4
5
6
7
8
9
10
11
<?php
include('connect.php');
session_start();
//Get username from SESSION
$user_check=$_SESSION['user']['username'];
//Fetch Data by User
$result=mysqli_query($conn,"SELECT*FROM user WHERE username='$user_check'");
$row=$result->fetch_assoc();
$login_session=$row['username'];
$role_session=$row['role'];
?>

admin.php
?
1
2
3
4
5
6
7
8
<?php
include('session.php');
if($role_session=='user'){
 header('location:user.php');
}
?>
<p>Your Name: <?php echo $login_session;?>|| Your Role: <?php echo $role_session;?></p>
<a href="logout.php">Logout Now</a>

user.php
?
1
2
3
4
5
6
7
8
9
<?php
include('session.php');
//Redirecting Admin to admin page
  if($role_session=='admin'){
 header('location:admin.php');
}
?>
<p>Your Name: <?php echo $login_session;?>|| Your Role: <?php echo $role_session;?></p>
<a href="logout.php">Logout Now</a>

logout.php
?
1
2
3
4
5
6
<?php
session_start();
session_destroy();
  
 header('location:login.php');
?>

style.css
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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;
}

ok You have Successfully Created PHP MySQL SESSION Based User and Admin Panel Login System.If you Have face any Problems Don't Forget to Comments.Thank you.
Read more

Subscribe via email

Ads Here
BANNER 728X90
Newer Article how to make simple crud in php and mysql Older Article php mysql upload audio
By v�o l�c
Labels:

2 comments:

  1. AnonymousFebruary 21, 2018 at 5:25 AM

    At step one (creating the table), I am getting this error:

    "Incorrect table definition; there can be only one auto column and it must be defined as a key"

    ReplyDelete
    Replies
    1. Puja RoyFebruary 23, 2018 at 4:05 AM

      Sorry For That...codes updated ..try again.. Thank you..

      Delete

Thank You for Your Comment

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)