0% found this document useful (0 votes)
21 views22 pages

User Management System Proposal & Report

The document outlines a Micro Project Proposal and Report for a User Management System developed using PHP. It includes aims, course outcomes, methodology, action plan, resources required, and detailed implementation steps, including source code. The project aims to automate user registration and management, providing functionalities for user authentication and profile management.

Uploaded by

vaijantachavle
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
21 views22 pages

User Management System Proposal & Report

The document outlines a Micro Project Proposal and Report for a User Management System developed using PHP. It includes aims, course outcomes, methodology, action plan, resources required, and detailed implementation steps, including source code. The project aims to automate user registration and management, providing functionalities for user authentication and profile management.

Uploaded by

vaijantachavle
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Index

Sr. No. Contents Page No.

Annexure I– Micro Project Proposal 1-2

[Link]/Benefits of the Micro-Project 1

2. Course Outcome Addressed 1

[Link] Methodology 1
1

4. Action Plan 2

5. Resources Required 2

6. Name of Team Member with Roll No. 2

Annexure II – Micro Project Report 3-40

[Link] 3

[Link]/Benefits of the Micro-Project 3

[Link] Outcome Achieved 3

4. Literature Review 4

[Link] Methodology Followed 4

2 5.1 Algorithm 4

5.2 Flow chart 5

5.3 Source Code 6-37

[Link] Resources Used 37

[Link] of Micro-Projects 37-39

8. Skill developed / Learning out of this Micro-Project 40


Annexure I

Micro Project Proposal

User Management System Using PHP

1. Aims/Benefits of the Micro-Project: The


main aims of the system are:
• To provide online user registration To
manage user database.
• To edit user’s details. To delete user

2. Course Outcome Addressed:


• Developer program using a control statement
• Perform operations based on array and graphics
• Develop program by applying various object
oriented concepts
• Use form control with validate to collect users
input
• Perform database operation in php

3. Proposed Methodology:
User management system provides functionality to manage personal profiles and users.
Personal profiles contain information such as profile identification number, email, first and last name,
etc. Personal profiles are used for personal information such as names, addressee. In order to access
personal profile for reading and modification PIN number is used for authentication. User information
contains user identification number, username, password and session for authentication.

This product provides a simple user management page that lets you view, search users, create new
user accounts, and edit existing ones. Also provides tools to disable or delete users, manage
permissions, and issue password resets .

1
[Link] Plan:

S Details of Activity Planned Planne Name of


r. Start date d Finish Responsible
N date Team Members
o.
Search the topic 09/01/2025 23/01/2025
1
3:30pm – 4:30pm 3:30pm – 4:30pm
Choosing the topic and 23/01/2025 30/01/2025
2
search 3:30pm – 4:30pm 3:30pm – 4:30pm
Plan the overall structure 30/01/2025 06/02/2025
3
and design 3:30pm – 4:30pm 3:30pm – 4:30pm
Implementing the code 06/02/2025 13/02/2025
4
3:30pm – 4:30pm 3:30pm – 4:30pm
Gadve Shradhda
Integrating with database 13/02/2025 20/02/2025 Shahaji
5
3:30pm – 4:30pm 3:30pm – 4:30pm

Testing the project 20/02/2025 06/03/2025


6
3:30pm – 4:30pm 3:30pm – 4:30pm
Debugging 06/03/2025 20/03/2025
7
3:30pm – 4:30pm 3:30pm – 4:30pm

Finalizing project with its 20/03/2025 20/03/2025


8
report 3:30pm – 4:30pm 3:30pm – 4:30pm

2
4. Resources Required:

Sr.
No. Name of resource / material Specification Quantity Remarks

1 Computer WINDOWS 7,2GB RAM, 1


160GB HDD
2 Operating System WINDOWS 7 1

3 Compiler Sublime Text 1

4 Browser Chrome 1

Names of Team Member with Roll No.:

Sr.
No. Enrollment No. Name of Team Member Roll No.

1 2210950128 Gadve Shradhda Shahaji 23

Mr. Sugre D.D

Name and Signature of the Teacher

3
Annexure – II

Micro-Project Report

User Management System Using PHP

1. Rationale:
User management system provides functionality to manage personal profiles and users.
Personal profiles contain information such as profile identification number, email, first and last name,
etc. Personal profiles are used for personal information such as names, addressee. In order to access
personal profile for reading and modification PIN number is used for authentication. User information
contains user identification number, username, password and session for authentication .

2. Aims/Benefits of the Micro-Project:


The main aims of the system are:

• To provide online user registration


To manage user database.
• To edit user’s details.
• To delete user

3. Course Outcomes Achieved:

1. Perform Database operation in PHP.


2. Perform operation based on array and graphics.

4. Literature Review:
The purpose of User Management System is to automate the existing manual system by the help of
computerized equipment’s and full-fledged computer software, fulfilling their requirements, so that
their valuable data/information can be stored for a longer period with easy accessing and manipulation
of the same. The required software and hardware are easily available and easy to work with.
User Management System, as described above, can lead to error free, secure, reliable and fast
management system. It can assist the user to concentrate on their other activities rather to concentrate
on the record keeping. Thus it will help organization in better utilization of resources. The organization
can maintain computerized records without redundant entries. That means that one need not be
distracted by information that is not relevant, while being able to reach the information.

4
5. Actual Methodology Followed:

5.1 Algorithm:
1. Start.
2. Login Dashboard.
3. If input user detail is correct then access granted and open dashboard page.
Else, go to login page.
4. You can manage system setting.
5. Sign out dashboard, If No go to 4th step otherwise our click Yes then you sign out.
6. End.

5.2 Flow-Chart:

5
5.3 Modules:

The Modules of the System are as follows:

ADMIN

• Login: Admin has to Login to manage the whole website.


• Manage User- Admin manages all the users in the database.
• Delete User-Admin can delete user from database.
USER

• Login: User has to Login to listen and download the songs.


• Edit Profile: User can view and edit their profile after registering and logging in on the website.
• Registration: This module is accessible by the user to register on the website to access all the
feature.

5.4 Source Code:

1. [Link]

<!DOCTYPE html>

<html lang="en">

<head>

<meta charset="utf-8">

<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-


fit=no">

<meta name="description" content="">

<meta name="author" content="">

<title>User Management System in PHP Using Stored Procedure</title>

<!-- Bootstrap core CSS -->

<link href="vendor/bootstrap/css/[Link]" rel="stylesheet">

<!-- Custom styles for this template -->

<link href="css/[Link]" rel="stylesheet">

6
</head><body id="page-top">
<!-- Navigation -->

<nav class="navbar navbar-expand-lg navbar-dark bg-dark fixed-top"


id="mainNav">

<div class="container">

<a class="navbar-brand js-scroll-trigger" href="#page-top">UMS-SP</a>

<button class="navbar-toggler" type="button" data-toggle="collapse" data-


target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false"
aria-label="Toggle navigation">

<span class="navbar-toggler-icon"></span>

</button>

<div class="collapse navbar-collapse" id="navbarResponsive">

<ul class="navbar-nav ml-auto">

<li class="nav-item">

<a class="nav-link js-scroll-trigger" href="#about">About</a>

</li>

<li class="nav-item">

<a class="nav-link js-scroll-trigger" href="[Link]">User Signup</a>

</li>

<li class="nav-item">

<a class="nav-link js-scroll-trigger" href="[Link]">User Login</a>

</li>

<li class="nav-item">

<a class="nav-link js-scroll-trigger" href="admin/">Admin</a> </li>

</ul> </div> </div> </nav>

7
<header class="bg-primary text-white">

<div class="container text-center">

<h1>User Management System in PHP Using Stored Procedure</h1>

<p class="lead">UMS-SP Project Project has two modules</p>

</div> </header>

<section id="about”<div class="container">

<div class="row">

<div class="col-lg-8 mx-auto">

<h2>About this page</h2>

<p class="lead">This is a great place to talk about your webpage. This


template is purposefully unstyled so you can use it as a boilerplate or starting point for
you own landing page designs! This template features:</p>

<ul><li>Clickable nav links that smooth scroll to page sections</li>

<li>Responsive behavior when clicking nav links perfect for a one page website</li>

<li>Bootstrap's scrollspy feature which highlights which section of the page


you're on in the navbar</li>

<li>Minimal custom CSS so you are free to explore your own unique
design options</li>

</ul> </div> </div> </div> </section>

<!-- Footer -->

<footer class="py-5 bg-dark">

<div class="container">

<p class="m-0 text-center text-white">Copyright &copy; PHPGurukul 2021</p</div>

<!-- /.container -->

</footer>

8
<!-- Bootstrap core JavaScript -->

<script src="vendor/jquery/[Link]"></script>

<script src="vendor/bootstrap/js/[Link]"></script>

<!-- Plugin JavaScript -->

<script src="vendor/jquery-easing/[Link]"></script>

<!-- Custom JavaScript for this theme -->

<script src="js/[Link]"></script>

</body></html>

2. login

<?php

session_start();

include('includes/[Link]');

if(isset($_POST['login']))

{
$email=$_POST['emailid'];

$password=md5($_POST['loginpassword']);

$query=mysqli_query($con,"call sp_userlogin('$email','$password')");

$num=mysqli_fetch_array($query); if($num>0)

$_SESSION['uid']=$num['id'];

$_SESSION['fname']=$num['FirstName'];

header("location:[Link]");

}els{

echo "<script>alert('Invalid login details');</script>";

9
} } ?>

<!DOCTYPE html>

<html lang="en">

<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-
fit=no">

<meta name="description" content="">

<meta name="author" content="">


<title>User Management System in PHP Using Stored Procedure</title>

<!-- Custom fonts for this template-->

<link href="vendor/fontawesome-free/css/[Link]" rel="stylesheet"


type="text/css">

<link
href="[Link]
0,600i,700,700i,800,800i,900,900i"

rel="stylesheet">
<!-- Custom styles for this template-->

<link href="css/[Link]" rel="stylesheet">

</head>
<body class="bg-gradient-primary"<div class="container">
<!-- Outer Row -->
<div class="row justify-content-center">
<div class="col-xl-10 col-lg-12 col-md-9">
<div class="card o-hidden border-0 shadow-lg my-5">

<div class="card-body p-0">

<!-- Nested Row within Card Body -->

<div class="row">

10
<div class="col-lg-6 d-none d-lg-block
bg-login-image"></div>

Back!</h1>
form-control-user"
<div class="col-lg-6">

<div class="p-5">

<div class="text-center">

<h1 class="h4 text-gray-900 mb-4">Welcome</div>


<form class="user" method="password”<div
class="form-group"

<input type="email" class="form-control

id="exampleInputEmail"
aria-describedby="emailHelp"

placeholder="Enter Email Address..." name="emailid" required="true"> </div>

<div class="form-group">

<input type="password" class="form-control form-control-user"


id="exampleInputPassword"
placeholder="Password" name="loginpassword" required="true"></div>

<button type="submit" name="login" class="btn btn-primary btn-user btn-block">

Login</button> </form> <hr><div class="text-


center"> <a class="small"

11
href="[Link]">Forgot Password?</a>

</div>

<div class="text-center">

<a class="small" href="[Link]">Create an


Account!</a>
</div> </div> </div> </div> </div> </div> </div></div>

<!-- Bootstrap core JavaScript-->

<script src="vendor/jquery/[Link]"></script>

<script src="vendor/bootstrap/js/[Link]"></script>

<!-- Core plugin JavaScript-->

<script src="vendor/jquery-easing/[Link]"></script>

<!-- Custom scripts for all pages-->

<script src="js/[Link]"></script>

</body>

</html>

3. Signup:
<?php
//db Connection file
include('includes/[Link]');
//code for signup
if(isset($_POST['signup']))
{
$fname=$_POST['fname'];
$lname=$_POST['lname'];
$email=$_POST['emailid'];
$password=md5($_POST['inputpass']);
$isactive=1;
//checking email if already exists
$ret=mysqli_query($con, "call sp_checkemailavailabilty('$email')");

12
$result=mysqli_num_rows($ret);
if($result>0){
echo "<script>alert('This email id already associated with another
account');</script>";
}else{
$ret->close();
$con->next_result();
$query=mysqli_query($con,"call
sp_signup('$fname','$lname','$email','$password','$isactive')"
); if ($query) {

echo "<script>alert('You have successfully registered');</script>";


echo "<script>[Link]='[Link]'</script>";
}
else
{

echo "<script>alert('Something Went Wrong. Please try again');</script>";


}
}

}
?>
<!DOCTYPE html> <html
lang="en">

<head>

<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1,
shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">

<title>User Management System in PHP Using Stored Procedure</title>

13
<!-- Custom fonts for this template-->
<link href="vendor/fontawesome-free/css/[Link]" rel="stylesheet"
type="text/css">
<link

href="[Link]
0i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">

<!-- Custom styles for this template-->


<link href="css/[Link]" rel="stylesheet">
<script type="text/javascript">
function checkpass()
{
if([Link]!=[Link])
{
alert('New Password and Repeat Password field does not match');
[Link]();
return false;
}
return true;
}

</script> </head>
<body class="bg-gradient-primary">
<div class="container">

<div class="card o-hidden border-0 shadow-lg my-5">


<div class="card-body p-0">
<!-- Nested Row within Card Body -->
<div class="row">
<div class="col-lg-5 d-none d-lg-block
bg-register-image"></div>
<div class="col-lg-7">
<div class="p-5">
<div class="text-center">
<h5 style="color:blue">User Management

14
System in PHP Using Stored Procedure</h5>
<h1 class="h4 text-gray-900 mb-4">Create an
Account!</h1>
</div>
<form class="user" name="signup" method="post"
onsubmit="return checkpass();">
<div class="form-group row">
<div class="col-sm-6 mb-3 mb-sm-0">
<input type="text" class="form-control
form-control-user" id="fname" placeholder="First Name" name="fname"
required="true">
</div>
<div class="col-sm-6">
<input type="text" class="form-control
form-control-user" id="lname" name="lname" placeholder="Last Name"
required="true">
</div>
</div>
<div class="form-group">
<input type="email" class="form-control
form-control-user" id="emailid" placeholder="Email Address" name="emailid"
required="true">
</div>
<div class="form-group row">
<div class="col-sm-6 mb-3 mb-sm-0">
<input type="password"
class="form-control form-control-user" id="inputpass" name="inputpass"
placeholder="Password" required="true">
</div>
<div class="col-sm-6">
<input type="password"
class="form-control form-control-user" id="repeatpass" placeholder="Repeat
Password" name="repeatpass" required="true">
</div>
</div>
<button type="submit" name="signup"

15
class="btn btn-primary btn-user btn-block">
Register Account </button>

</form>
<hr>
<div class="text-center">
<a class="small"
href="[Link]">Forgot Password?</a>
</div>
<div class="text-center">
<a class="small" href="[Link]">Already have

an account? Login!</a> </div>


</div>
</div>
</div>
</div>
</div> </div>
<!-- Bootstrap core JavaScript-->
<script src="vendor/jquery/[Link]"></script>
<script src="vendor/bootstrap/js/[Link]"></script>
<!-- Core plugin JavaScript-->
<script src="vendor/jquery-easing/[Link]"></script>

<!-- Custom scripts for all pages-->

<script src="js/[Link]"></script>
</body>
</html>

16
6. Actual Resources Used:

Sr. Name of resource / Specification Quantity Remarks


No. material

1 Computer WINDOWS 7,2GB RAM, 1


160GB HDD
2 Operating System WINDOWS 7 1

3 Compiler Sublime text 1

4 Browser Chrome 1

[Link] of Micro-Projects:

17
18
19
[Link] developed / Learning out of this

• We learn that how to make the project in PHP programming.


• How to do the testing of program in Sublime text.
• How to collect the information and how to make the presentation that we learn from this proje
• We develop our logic implementation for programing and coding.

[Link]:

User Management System developed using PHP is that it provides a secure and efficient
way to handle user data and authentication. By incorporating features such as user
registration, login/logout functionality, password recovery, and role-based access
control, it ensures proper management of user accounts. PHP’s ability to interact with
databases (like MySQL) allows for dynamic user data storage and retrieval. The system
is scalable, and with proper security practices such as hashing passwords, implementing
validation, and using session management, it can be adapted to various applications
while maintaining user privacy and data integrity.

20
[Link] of this Micro-Project:

1. User management describes the ability for administrators to manage user access to
various IT resources like systems, devices, applications, storage systems, networks,
SaaS services, and more.
2. User management enables admins to control user access and on-board and off-board
users to and from IT resources.
3. Enhancing Security Profiles.
4. Allows Easy Access No Matter Where You Are

*********

21

Common questions

Powered by AI

The proposed methodology involves using object-oriented concepts, form controls, and database operations in PHP. It ensures security by incorporating user authentication through username, password, and sessions. Additionally, the system uses a PIN for accessing and modifying personal profile information . Security is enhanced through controlled access, user data encryption, and secure session management .

The document illustrates that the integration of user management functionalities with database operations in PHP is achieved through the use of stored procedures for user registration, login, and profile management. PHP interacts with databases like MySQL to seamlessly handle user data through dynamic storage and retrieval. This allows the system to maintain consistency and data integrity while providing a robust framework for user activities, including user authentication and permissions management .

The key functions of the User Management System include providing online user registration, managing the user database, allowing editing of user details, and enabling the deletion of users . These functions also encompass user authentication through a PIN number, and the system provides tools for creating user accounts, managing permissions, and resetting passwords .

The document describes the 'Algorithm' as a series of steps used in the User Management System, starting from the login process to managing system settings and user sign out. It provides a structured approach to handle user inputs and outputs, ensuring correct authentication and access control . This procedural outline ensures that the system can perform reliably and efficiently when managing user activities .

The project team developed skills in PHP programming, program testing using Sublime Text, and information collection and presentation. They also enhanced their logical implementation abilities for programming and coding. These skills contributed to a comprehensive understanding of creating and managing a functional user management system, allowing them to apply these competencies in real-world scenarios .

In the User Management System, password management is crucial for maintaining security. It includes functionalities like password recovery and ensuring passwords are stored securely using hashing techniques. The integration of password reset tools also helps maintain account security by allowing users to reset forgotten passwords while ensuring that the process is secure and does not expose vulnerabilities .

Implementing a User Management System with stored procedures in PHP addresses challenges such as security vulnerabilities and data inconsistency. Stored procedures help centralize database logic, reducing the risk of SQL injection and ensuring that data operations remain consistent across the application. They also aid in performance optimization by reducing network latency and improving data access speeds, which are critical for real-time user management applications .

The User Management System ensures data integrity and privacy through practices such as hashing passwords, implementing validation, and using session management. It also involves role-based access control for user accounts, ensuring only authorized users can access sensitive data and functionalities. The system uses PHP's capability to interact with databases like MySQL for secure data storage and retrieval, maintaining the confidentiality and integrity of user information .

Automating a user management system reduces errors and increases reliability, efficiency, and security in managing user data. It helps organizations focus on activities other than record keeping, thus leading to better utilization of organizational resources. By minimizing redundant data entries, it ensures that the relevant information can be accessed easily and accurately .

The resource requirements for the micro-project include a computer with Windows 7, 2GB RAM, and 160GB HDD, an operating system (Windows 7), a compiler (Sublime Text), and a browser (Chrome). These resources are necessary for coding, debugging, and testing the User Management System developed in PHP .

You might also like