Admin and User login system PHP and MySQL database

How to Create Admin and User login system PHP and MySQL database

  • First Create these Files or Folders.

  • Create this file Create Database & Table:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
How to run project:
1) Create a database called multi_login
2) create a table users with the following fields:
 - id - int(11)
 -username - varchar(100)
 -email - varchar(100)
 -user_type - varchar(20)
 -password - varchar(100)
3) Start apache and mysql and launch site on browser
4) In order to create an admin, use a client like phpmyadmin and manually create a user with user_type admin. Use this user to login and be able to create other users.
Thanks
Get more at codewithawa.com


  • Create this file Style.css:
Source code:

 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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
* {
 margin: 0px;
 padding: 0px;
}
body {
 font-size: 120%;
 background: #F8F8FF;
}

.header {
 width: 40%;
 margin: 50px auto 0px;
 color: white;
 background: #5F9EA0;
 text-align: center;
 border: 1px solid #B0C4DE;
 border-bottom: none;
 border-radius: 10px 10px 0px 0px;
 padding: 20px;
}
form, .content {
 width: 40%;
 margin: 0px auto;
 padding: 20px;
 border: 1px solid #B0C4DE;
 background: white;
 border-radius: 0px 0px 10px 10px;
}
.input-group {
 margin: 10px 0px 10px 0px;
}

.input-group label {
 display: block;
 text-align: left;
 margin: 3px;
}
.input-group input {
 height: 30px;
 width: 93%;
 padding: 5px 10px;
 font-size: 16px;
 border-radius: 5px;
 border: 1px solid gray;
}
#user_type {
 height: 40px;
 width: 98%;
 padding: 5px 10px;
 background: white;
 font-size: 16px;
 border-radius: 5px;
 border: 1px solid gray;
}
.btn {
 padding: 10px;
 font-size: 15px;
 color: white;
 background: #5F9EA0;
 border: none;
 border-radius: 5px;
}
.error {
 width: 92%; 
 margin: 0px auto; 
 padding: 10px; 
 border: 1px solid #a94442; 
 color: #a94442; 
 background: #f2dede; 
 border-radius: 5px; 
 text-align: left;
}
.success {
 color: #3c763d; 
 background: #dff0d8; 
 border: 1px solid #3c763d;
 margin-bottom: 20px;
}

.profile_info img {
 display: inline-block; 
 width: 50px; 
 height: 50px; 
 margin: 5px;
 float: left;
}

.profile_info div {
 display: inline-block; 
 margin: 5px;
}

.profile_info:after {
 content: "";
 display: block;
 clear: both;
}
  • Create this file Function.php:
Source code:

  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
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
<?php 
 session_start();

 // connect to database
 $db = mysqli_connect('localhost', 'root', '', 'multi_login');

 // variable declaration
 $username = "";
 $email    = "";
 $errors   = array(); 

 // call the register() function if register_btn is clicked
 if (isset($_POST['register_btn'])) {
  register();
 }

 // call the login() function if register_btn is clicked
 if (isset($_POST['login_btn'])) {
  login();
 }

 if (isset($_GET['logout'])) {
  session_destroy();
  unset($_SESSION['user']);
  header("location: ../login.php");
 }

 // REGISTER USER
 function register(){
  global $db, $errors;

  // receive all input values from the form
  $username    =  e($_POST['username']);
  $email       =  e($_POST['email']);
  $password_1  =  e($_POST['password_1']);
  $password_2  =  e($_POST['password_2']);

  // form validation: ensure that the form is correctly filled
  if (empty($username)) { 
   array_push($errors, "Username is required"); 
  }
  if (empty($email)) { 
   array_push($errors, "Email is required"); 
  }
  if (empty($password_1)) { 
   array_push($errors, "Password is required"); 
  }
  if ($password_1 != $password_2) {
   array_push($errors, "The two passwords do not match");
  }

  // register user if there are no errors in the form
  if (count($errors) == 0) {
   $password = md5($password_1);//encrypt the password before saving in the database

   if (isset($_POST['user_type'])) {
    $user_type = e($_POST['user_type']);
    $query = "INSERT INTO users (username, email, user_type, password) 
        VALUES('$username', '$email', '$user_type', '$password')";
    mysqli_query($db, $query);
    $_SESSION['success']  = "New user successfully created!!";
    header('location: home.php');
   }else{
    $query = "INSERT INTO users (username, email, user_type, password) 
        VALUES('$username', '$email', 'user', '$password')";
    mysqli_query($db, $query);

    // get id of the created user
    $logged_in_user_id = mysqli_insert_id($db);

    $_SESSION['user'] = getUserById($logged_in_user_id); // put logged in user in session
    $_SESSION['success']  = "You are now logged in";
    header('location: index.php');    
   }

  }

 }

 // return user array from their id
 function getUserById($id){
  global $db;
  $query = "SELECT * FROM users WHERE id=" . $id;
  $result = mysqli_query($db, $query);

  $user = mysqli_fetch_assoc($result);
  return $user;
 }

 // LOGIN USER
 function login(){
  global $db, $username, $errors;

  // grap form values
  $username = e($_POST['username']);
  $password = e($_POST['password']);

  // make sure form is filled properly
  if (empty($username)) {
   array_push($errors, "Username is required");
  }
  if (empty($password)) {
   array_push($errors, "Password is required");
  }

  // attempt login if no errors on form
  if (count($errors) == 0) {
   $password = md5($password);

   $query = "SELECT * FROM users WHERE username='$username' AND password='$password' LIMIT 1";
   $results = mysqli_query($db, $query);

   if (mysqli_num_rows($results) == 1) { // user found
    // check if user is admin or user
    $logged_in_user = mysqli_fetch_assoc($results);
    if ($logged_in_user['user_type'] == 'admin') {

     $_SESSION['user'] = $logged_in_user;
     $_SESSION['success']  = "You are now logged in";
     header('location: admin/home.php');    
    }else{
     $_SESSION['user'] = $logged_in_user;
     $_SESSION['success']  = "You are now logged in";

     header('location: index.php');
    }
   }else {
    array_push($errors, "Wrong username/password combination");
   }
  }
 }

 function isLoggedIn()
 {
  if (isset($_SESSION['user'])) {
   return true;
  }else{
   return false;
  }
 }

 function isAdmin()
 {
  if (isset($_SESSION['user']) && $_SESSION['user']['user_type'] == 'admin' ) {
   return true;
  }else{
   return false;
  }
 }

 // escape string
 function e($val){
  global $db;
  return mysqli_real_escape_string($db, trim($val));
 }

 function display_error() {
  global $errors;

  if (count($errors) > 0){
   echo '<div class="error">';
    foreach ($errors as $error){
     echo $error .'<br>';
    }
   echo '</div>';
  }
 }

?>



  • Create this file Index.php: 

Source code:

 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
<?php 
 include('functions.php');

 if (!isLoggedIn()) {
  $_SESSION['msg'] = "You must log in first";
  header('location: login.php');
 }
?>
<!DOCTYPE html>
<html>
<head>
 <title>Home</title>
 <link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
 <div class="header">
  <h2>Home Page</h2>
 </div>
 <div class="content">
  <!-- notification message -->
  <?php if (isset($_SESSION['success'])) : ?>
   <div class="error success" >
    <h3>
     <?php 
      echo $_SESSION['success']; 
      unset($_SESSION['success']);
     ?>
    </h3>
   </div>
  <?php endif ?>
  <!-- logged in user information -->
  <div class="profile_info">
   <img src="images/user_profile.png"  >

   <div>
    <?php  if (isset($_SESSION['user'])) : ?>
     <strong><?php echo $_SESSION['user']['username']; ?></strong>

     <small>
      <i  style="color: #888;">(<?php echo ucfirst($_SESSION['user']['user_type']); ?>)</i> 
      <br>
      <a href="index.php?logout='1'" style="color: red;">logout</a>
     </small>

    <?php endif ?>
   </div>
  </div>
 </div>
</body>
</html>


  • Create this file LogIn.php: 

 Source code:


 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
<?php include('functions.php') ?>
<!DOCTYPE html>
<html>
<head>
 <title>Registration system PHP and MySQL</title>
 <link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>

 <div class="header">
  <h2>Login</h2>
 </div>
 
 <form method="post" action="login.php">

  <?php echo display_error(); ?>

  <div class="input-group">
   <label>Username</label>
   <input type="text" name="username" >
  </div>
  <div class="input-group">
   <label>Password</label>
   <input type="password" name="password">
  </div>
  <div class="input-group">
   <button type="submit" class="btn" name="login_btn">Login</button>
  </div>
  <p>
   Not yet a member? <a href="register.php">Sign up</a>
  </p>
 </form>


</body>
</html>
  • Create this file Register.php: 

 Source code: 
 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
<?php include('functions.php') ?>
<!DOCTYPE html>
<html>
<head>
 <title>Registration system PHP and MySQL</title>
 <link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
 <div class="header">
  <h2>Register</h2>
 </div>
 
 <form method="post" action="register.php">

  <?php echo display_error(); ?>

  <div class="input-group">
   <label>Username</label>
   <input type="text" name="username" value="<?php echo $username; ?>">
  </div>
  <div class="input-group">
   <label>Email</label>
   <input type="email" name="email" value="<?php echo $email; ?>">
  </div>
  <div class="input-group">
   <label>Password</label>
   <input type="password" name="password_1">
  </div>
  <div class="input-group">
   <label>Confirm password</label>
   <input type="password" name="password_2">
  </div>
  <div class="input-group">
   <button type="submit" class="btn" name="register_btn">Register</button>
  </div>
  <p>
   Already a member? <a href="login.php">Sign in</a>
  </p>
 </form>
</body>
</html>

Comments

  1. NazeerahJuly 18, 2021 at 12:43 PM

    thank you, please where is the source code for home.php

    ReplyDelete
  2. AnonymousJuly 27, 2021 at 1:51 AM

    where is the admins folder files?

    ReplyDelete

Post a Comment

Popular posts from this blog