User Management System PHP

User Management System PHP MySQL – In this tutorial we see how to develop a user registration login management system with admin panel access using PHP MySQL. This project objective is to maintain a lot of users data with one website portal. Like different types of users are login & check their data.

Admin able to change user password, remove & add users, tracking and more functionality permission available for admin who maintain all users. Most companies & business people are using these types of applications.  

User Management System

Okay let’s start our project to develop an online user management system with PHP. PHP is the easiest scripting language. Used for developing web based applications & sites. In the beginning we struggle to learn but after a few days, we easily understand the concept.  

User Management System PHP

Above image mentions the dashboard admin system. Here I have used Bootstrap plugin to make attractive designs. Through the bootstrap we are able to design high level designs.

DataBase Connection

Before writing the code we create & connect to the MySQL database. Because after only we store and retrieve data from tables. MySQL is the best option for PHP, otherwise you can choose a non relational database like mongoDB.

<?php 
// DB credentials.
define('DB_HOST','localhost');
define('DB_USER','root');
define('DB_PASS','vetri');
define('DB_NAME','usermanagement');
// Establish database connection.
try
{
$dbh = new PDO("mysql:host=".DB_HOST.";dbname=".DB_NAME,DB_USER, DB_PASS,array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"));
}
catch (PDOException $e)
{
exit("Error: " . $e->getMessage());
}
?>

After integrating with back-end to front-end. We initialize further values to assign a user interface. Every project has a login module, register module, add delete module etc.  

Homepage Development

Most users are attracted to the UI, When we implement a good user interface, all of users impress our site & repeatedly enquire about the website. In the source code I give SQL files, so after creating database import your .sql file.

<?php
session_start();
include('includes/config.php');
if(isset($_POST['login']))
{
$status='1';
$email=$_POST['username'];
$password=md5($_POST['password']);
$sql ="SELECT email,password FROM users WHERE email=:email and password=:password and status=(:status)";
$query= $dbh -> prepare($sql);
$query-> bindParam(':email', $email, PDO::PARAM_STR);
$query-> bindParam(':password', $password, PDO::PARAM_STR);
$query-> bindParam(':status', $status, PDO::PARAM_STR);
$query-> execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
if($query->rowCount() > 0)
{
$_SESSION['alogin']=$_POST['username'];
echo "<script type='text/javascript'> document.location = 'profile.php'; </script>";
} else{
  
  echo "<script>alert('Invalid Details Or Account Not Confirmed');</script>";

}

}

?>
<!doctype html>
<html lang="en" class="no-js">

<head>
	<meta charset="UTF-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1, maximum-scale=1">
	<meta name="description" content="">
	<meta name="author" content="">

	
	<link rel="stylesheet" href="css/font-awesome.min.css">
	<link rel="stylesheet" href="css/bootstrap.min.css">
	<link rel="stylesheet" href="css/dataTables.bootstrap.min.css">
	<link rel="stylesheet" href="css/bootstrap-social.css">
	<link rel="stylesheet" href="css/bootstrap-select.css">
	<link rel="stylesheet" href="css/fileinput.min.css">
	<link rel="stylesheet" href="css/awesome-bootstrap-checkbox.css">
	<link rel="stylesheet" href="css/style.css">

</head>

<body>
	<div class="login-page bk-img">
		<div class="form-content">
			<div class="container">
				<div class="row">
					<div class="col-md-6 col-md-offset-3">
						<h1 class="text-center text-bold mt-4x">Login</h1>
						<div class="well row pt-2x pb-3x bk-light">
							<div class="col-md-8 col-md-offset-2">
								<form method="post">

									<label for="" class="text-uppercase text-sm">Your Email</label>
									<input type="text" placeholder="Username" name="username" class="form-control mb" required>

									<label for="" class="text-uppercase text-sm">Password</label>
									<input type="password" placeholder="Password" name="password" class="form-control mb" required>
									<button class="btn btn-primary btn-block" name="login" type="submit">LOGIN</button>
								</form>
								<br>
								<p>Don't Have an Account? <a href="register.php" >Signup</a></p>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>
	
	<!-- Loading Scripts -->
	<script src="js/jquery.min.js"></script>
	<script src="js/bootstrap-select.min.js"></script>
	<script src="js/bootstrap.min.js"></script>
	<script src="js/jquery.dataTables.min.js"></script>
	<script src="js/dataTables.bootstrap.min.js"></script>
	<script src="js/Chart.min.js"></script>
	<script src="js/fileinput.js"></script>
	<script src="js/chartData.js"></script>
	<script src="js/main.js"></script>

</body>

</html>

Download Source Code

So finally I hope you understand the concept of a user management system. This is very useful for startup companies. Have faced any issues, comment below I will solve your doubts as soon as possible.

Download

Looking for our other popular articles like android app development, make money online etc.

  1. Android Tutorial For Beginners step by step.
  2. Earn Money Online Rs.800 per Day without any investment from home.
Tags: ,

Leave a Reply