“Library Management System”
Submitted in partial fulfillment of the requirements for the award of degree
Bachelor of Computer Application
From
Hemchand Yadav Vishwavidyalaya,Durg(C.G)
Year: 2024-25
Guided By: Submitted By:
Mrs. Arpita Ajish Ashish Ku. Sahu[H2334100097]
(Assistant Professor) Kunal Lanjewar[H2334100179]
L.Chesta[H2334100171]
Kundan Sahu[H2334100168]
Submitted To:
GD Rungta college of Science and Technology, Bhilai
Hemchand Yadav Vishwavidyalaya,Durg(C.G)
Table of Content
S.no Title Page No.
1. Declaration
2. Acknowledgement
3. Introduction
4. Objective of project
5. Technology Stack
6. SRS(Software Requirement)
7. HRS(Hardware requirement)
8. ER- Diagram
9. DFD(Data Flow Diagram)
10. Database
11. Form Layout
12. Source Code
13. Future Scope
14. Conclusion
15. Reference
Declaration
This is to certify that the Project work entitled “LIBRARY
MANAGEMENT SYSTEM”, which is submitted by me in partial
fulfilment for the award of degree of Bachelor of Computer
Application, GD Rungta College Of Science and Technology,
Bhilai, comprises the work carried out by me.
I further declare that the work reported in this project has
been submitted and will not be submitted, either in part or in full
for the award of any other degree or diploma in this Institute or
any other Institute or University
Place: Bhilai Submitted By:
Date: Ashish Ku. Sahu[H2334100097]
Kunal Lanjewar[H2334100179]
L.Chesta[H2334100171]
Kundan Sahu[H2334100168]
Acknowledgement
With immense pleasure, I would like to present this report on
the project assignment of “Library management system”. I offer
my sincere thanks to Principal Dr. Neema S Balan, G.D RUNGTA
COLLEGE OF SCIENCE AND TECHNOLOGY, Bhilai for giving us an
opportunity to work our college. I would like to thank all the
faculties for helping us directly or indirectly in the completion of
the project.
Next I would like to thanks Head of the Department of Computer
Science Dr. Jyoti Upadhyay mam for giving us proper
environment to work and develop our project in our laboratory.
I would also like to thank the Computer staff members and
project guide Name of Faculty who helped me to collect the
required data for our project.
Introduction
Library management system is a project which aims in
developing a computerized system to maintain all the daily
work of library. This project has many features which are
generally not available in normal library management
systems like facility of user login .It also has a facility of
admin login through which the admin can monitor the
whole system .It also has facility of an online notice board
where admin can put up information about workshops or
seminars being held in our colleges or nearby colleges and
librarian after proper verification from the concerned
institution organizing the seminar can add it to the notice
board. It has also a facility where user after logging in their
accounts can see list of books issued and its issue date and
return date and also the students can request the librarian
to add new books by filling the book request form. The
librarian after logging into his account that is admin
account can generate various reports such as student
report, issue report, teacher report and book report Overall
this project of ours is being developed to help the students
as well as staff of library to maintain the library in the best
way possible and also reduce the human efforts.
Objective Of Project
The main objective of the Project on Library Management System
is to manage the details of Student, Books, Issues, Librarian,
Member. It manages all the information about Student, Address
of Member as well as Student. The project is totally built at
administrative end and thus only the administrator is guaranteed
the access. The purpose of the project is to build web-based
application program to reduce the manual work for managing the
Student, Books, Address, Issues. It tracks all the details about the
Issues, Librarian, Member, etc.
1. The objectives of a library management system is to operate a
library with efficiency and at reduced costs. The system being
entirely automated streamlines all the tasks involved in
operations of the library.
2. The activities of book purchasing, cataloguing, indexing,
circulation recording and stock checking are done by the
software. Such software eliminates the need for repetitive
manual work and minimizes the chances of errors.
3. The library management system software helps in reducing
operational costs. Managing a library manually is labour intensive
and an immense amount of paperwork is involved. An automated
system reduces the need for manpower and stationery. This leads
to lower operational costs.
4. The system saves time for both the user and the librarian. With
just a click the user can search for the books available in the
library. The librarian can answer queries with ease regarding the
availability of books.
5. Adding, removing or editing the database is a simple process.
Adding new members or cancelling existing memberships can
be done with ease.
6. Stock checking and verification of books in the library can be
done within a few hours. The automated system saves a
considerable amount of time as opposed to the manual system.
7. The library management system software makes the library a
smart one by organizing the books systematically by author, title
and subject. This enables users to search for books quickly and
effortlessly.
8. Students need access to authentic information. An advanced
organized library is an integral part of any educational
institution.
9. In this digital age a web-based library management system
would be ideal for students who can access the library’s
database on their smartphones.
10. The main objective of the Project of Library Management
System is to manage the details of users as well as books.
11. It also manages all the information about Student, Address
of Member as well as Student.
Technology Stack
Frontend Technologies:
1. HTML
2. CSS
3. Bootstrap
4. JavaScript
5. PHP
Backend Technologies:
1. PHP
2. SQL
Software Requirement
1.Frontend Requirements
• HTML5: For structuring the website content.
• CSS3: For styling and designing the user interface.
•JavaScript: For adding interactivity and dynamic
functionalities.
2. Backend Requirements
• PHP 7.x or above: For server-side scripting, data
processing, and handling user requests.
• Apache Server: Web server for running PHP scripts (e.g.,
XAMPP for local testing).
3. Database Requirements
• MySQL 8.x: For storing and managing user data, pet
details, adoption requests, and contact queries.
4. Development Tools
• Code Editor: Visual Studio Code, Sublime Text, or
Notepad++ for writing and managing code.
• Local Development Server: XAMPP for local testing of PHP
and MySQL.
• Web Browsers: Google Chrome, Mozilla Firefox, or
Microsoft Edge for testing and debugging frontend
functionalities.
Hardware Requirement
1.Development Machine Requirements
• Processor: Intel i3 or higher (or AMD equivalent).
• RAM: Minimum 4 GB (8 GB recommended for smooth
development).
• Storage: 100 GB of available disk space for tools, database,
and project files.
• Display: Minimum resolution of 1366x768 pixels.
• Network: Stable internet connection for accessing
resources and testing.
2.Server Requirements (Deployment)
• Processor: Intel Xeon or equivalent multi-core processor.
• RAM: Minimum 8 GB (for handling multiple user
requests).
• Storage: 500 GB (SSD recommended for faster
performance).
• Database Server: MySQL with adequate storage for data
handling.
• Web Server: Apache Server for hosting PHP applications.
Future Scope
Our web-based application “Library Management System” which
provides complete information about Users like Student, Admin .
We will add more content on them in future. In our web-based
application right now, only Books and Users with their
information available but in future we will add Online Lectures,
Links, etc .We will also provide more images in GUI related to our
web-based application in future. We will try to find out more
about this topic and add in future. We will try to make this
application more attractive so that visitor cannot get bored while
using it. We will provide login id to each and every user so that
he can access our website from anywhere through log in id and
password. In future we add some major facilities like Reservation
of Book .One of the major future scope is making our system
online. Connecting libraries to a common data centre will provide
globalization to the libraries, and then the user will be able to
search books all over the city and nearby areas. Reviews, rating,
comparing of books and libraries can also be incorporated. This
would help the user to browse through popular books and make
his selection based on the books rating. Also data obtained from
this can be used to discover topics, genre and books that the
readers are interested in reading.
E-R Diagram
Data Flow Diagram
Form Layout
User-Registration Form :
User-Login Form :
User-Dashboard Form :
Admin-Login Form :
Admin-Dashboard Form :
Source Code
Login Page: (index.php)
<?php
session_start();
?>
<!DOCTYPE html>
<html>
<head>
<title>LMS</title>
<meta charset="utf-8" name="viewport" content="width=device-width,intial-
scale=1">
<link rel="stylesheet" type="text/css" href="bootstrap-4.4.1/css/bootstrap.min.css">
<script type="text/javascript" src="bootstrap-4.4.1/js/juqery_latest.js"></script>
<script type="text/javascript" src="bootstrap-4.4.1/js/bootstrap.min.js"></script>
</head>
<style type="text/css">
#main_content{
padding: 50px;
background-color: whitesmoke;
}
#side_bar{
background-color: whitesmoke;
padding: 50px;
width: 300px;
height: 450px;
}
</style>
<body>
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
<div class="container-fluid">
New User Registration:(register.php)
<?php
$connection = mysqli_connect("localhost","root","");
$db = mysqli_select_db($connection,"lms");
$query = "insert into users
values('','$_POST[name]','$_POST[email]','$_POST[password]',$_POST[mobile],'$_POST[add
ress]')";
$query_run = mysqli_query($connection,$query);
?>
<script type="text/javascript">
alert("Registration successfull...You may Login now !!");
window.location.href = "index.php";
</script>
User Login:(index.php)
<body>
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="index.php">Library Management
System (LMS)</a>
</div>
<ul class="nav navbar-nav navbar-right">
<li class="nav-item">
<a class="nav-link" href="admin/index.php">Admin Login</a>
</li>
<li class="nav-item">
<a class="nav-link" href="signup.php"></span>Register</a>
</li>
<li class="nav-item">
<a class="nav-link" href="index.php">Login</a>
</li>
</ul>
</div>
</nav><br>
<span><marquee>This is library mangement system. Library opens at 8:00 AM and
close at 8:00 PM</marquee></span><br><br>
<div class="row">
<div class="col-md-4" id="side_bar">
<h5>Library Timing</h5>
User Dashboard:(view_profile.php)
<?php
session_start();
#fetch data from database
$connection = mysqli_connect("localhost","root","");
$db = mysqli_select_db($connection,"lms");
$name = "";
$email = "";
$mobile = "";
$query = "select * from users where email = '$_SESSION[email]'";
$query_run = mysqli_query($connection,$query);
while ($row = mysqli_fetch_assoc($query_run)){
$name = $row['name'];
$email = $row['email'];
$mobile = $row['mobile'];
$address = $row['address'];
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Dashboard</title>
<meta charset="utf-8" name="viewport" content="width=device-width,intial-
scale=1">
<link rel="stylesheet" type="text/css" href="bootstrap-4.4.1/css/bootstrap.min.css">
<script type="text/javascript" src="bootstrap-4.4.1/js/juqery_latest.js"></script>
<script type="text/javascript" src="bootstrap-4.4.1/js/bootstrap.min.js"></script>
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
Admin Login(index.html)
<?php
session_start();
?>
<!DOCTYPE html>
<html>
<head>
<title>LMS | Login</title>
<meta charset="utf-8" name="viewport" content="width=device-width,intial-
scale=1">
<link rel="stylesheet" type="text/css" href="../bootstrap-
4.4.1/css/bootstrap.min.css">
<script type="text/javascript" src="./bootstrap-4.4.1/js/juqery_latest.js"></script>
<script type="text/javascript" src="./bootstrap-4.4.1/js/bootstrap.min.js"></script>
</head>
<style type="text/css">
#main_content{
padding: 50px;
background-color: whitesmoke;
}
#side_bar{
background-color: whitesmoke;
padding: 50px;
width: 300px;
height: 450px;
}
</style>
<body>
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
<div class="container-fluid">
<div class="navbar-header">
Admin Dashboard(admin_dashboard.php)
<?php
require("functions.php");
session_start();
?>
<!DOCTYPE html>
<html>
<head>
<title>Dashboard</title>
<meta charset="utf-8" name="viewport" content="width=device-width,intial-
scale=1">
<link rel="stylesheet" type="text/css" href="../bootstrap-
4.4.1/css/bootstrap.min.css">
<script type="text/javascript" src="../bootstrap-4.4.1/js/juqery_latest.js"></script>
<script type="text/javascript" src="../bootstrap-4.4.1/js/bootstrap.min.js"></script>
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="admin_dashboard.php">Library
Management System (LMS)</a>
</div>
<font style="color: white"><span><strong>Welcome: <?php echo
$_SESSION['name'];?></strong></span></font>
<font style="color: white"><span><strong>Email: <?php echo
$_SESSION['email'];?></strong></font>
<ul class="nav navbar-nav navbar-right">
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" data-toggle="dropdown">My Profile </a>
Add Books(add_books.php)
<?php
require("functions.php");
session_start();
#fetch data from database
$connection = mysqli_connect("localhost","root","");
$db = mysqli_select_db($connection,"lms");
$name = "";
$email = "";
$mobile = "";
$query = "select * from admins where email = '$_SESSION[email]'";
$query_run = mysqli_query($connection,$query);
while ($row = mysqli_fetch_assoc($query_run)){
$name = $row['name'];
$email = $row['email'];
$mobile = $row['mobile'];
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Add New Book</title>
<meta charset="utf-8" name="viewport" content="width=device-width,intial-
scale=1">
<link rel="stylesheet" type="text/css" href="../bootstrap-
4.4.1/css/bootstrap.min.css">
<script type="text/javascript" src="../bootstrap-4.4.1/js/juqery_latest.js"></script>
<script type="text/javascript" src="../bootstrap-4.4.1/js/bootstrap.min.js"></script>
<script type="text/javascript">
function alertMsg(){
Issue Book(issue_book.php)
<?php
session_start();
?>
<!DOCTYPE html>
<html>
<head>
<title>Issue Book</title>
<meta charset="utf-8" name="viewport" content="width=device-width,intial-
scale=1">
<link rel="stylesheet" type="text/css" href="../bootstrap-
4.4.1/css/bootstrap.min.css">
<script type="text/javascript" src="../bootstrap-4.4.1/js/juqery_latest.js"></script>
<script type="text/javascript" src="../bootstrap-4.4.1/js/bootstrap.min.js"></script>
<script type="text/javascript">
function alertMsg(){
alert(Book added successfully...);
window.location.href = "admin_dashboard.php";
}
</script>
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="admin_dashboard.php">Library
Management System (LMS)</a>
</div>
<font style="color: white"><span><strong>Welcome: <?php echo
Admin Profile(view_profile.php)
<?php
require("functions.php");
session_start();
#fetch data from database
$connection = mysqli_connect("localhost","root","");
$db = mysqli_select_db($connection,"lms");
$name = "";
$email = "";
$mobile = "";
$query = "select * from admins where email = '$_SESSION[email]'";
$query_run = mysqli_query($connection,$query);
while ($row = mysqli_fetch_assoc($query_run)){
$name = $row['name'];
$email = $row['email'];
$mobile = $row['mobile'];
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Dashboard</title>
<meta charset="utf-8" name="viewport" content="width=device-width,intial-
scale=1">
<link rel="stylesheet" type="text/css" href="../bootstrap-
4.4.1/css/bootstrap.min.css">
<script type="text/javascript" src="../bootstrap-4.4.1/js/juqery_latest.js"></script>
<script type="text/javascript" src="../bootstrap-4.4.1/js/bootstrap.min.js"></script>
</head>
<body>
Issued Book(issued_book.php)
<?php
session_start();
#fetch data from database
$connection = mysqli_connect("localhost","root","");
$db = mysqli_select_db($connection,"lms");
$book_name = "";
$author = "";
$book_no = "";
$student_name = "";
$query = "select
issued_books.book_name,issued_books.book_author,issued_books.book_no,users.name
from issued_books left join users on issued_books.student_id = users.id where
issued_books.status = 1";
?>
<!DOCTYPE html>
<html>
<head>
<title>Issued Books</title>
<meta charset="utf-8" name="viewport" content="width=device-width,intial-
scale=1">
<link rel="stylesheet" type="text/css" href="../bootstrap-
4.4.1/css/bootstrap.min.css">
<script type="text/javascript" src="../bootstrap-4.4.1/js/juqery_latest.js"></script>
<script type="text/javascript" src="../bootstrap-4.4.1/js/bootstrap.min.js"></script>
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
<div class="container-fluid">
Conclusion
Library Management System has been created keeping in mind
the needs of Small and Medium scale libraries. Its an efficient
software that includes all the basic functionalities like making
data entries for new books, newspapers and magazines,
registering a new user, editing and deleting records that are
required for smooth functioning of a library. Additionally the user
login and book history are also stored and can be accessed by the
administrator. It also facilitates the librarian to create new user
groups and edit their access levels and functions (like that of the
assistants). Apart from this the general users are also given the
rights to not only keep track of the books that they have issued
and fines due but they too can search for the
books/magazines/newspapers that interest them.
Reference
• https://youtu.be/qeA19rgCC4o?si=XTRyt2xPYCkxIszV
• https://www.researchgate.net/publication/381021632
• https://www.researchgate.net/publication/373137554
• https://www.google.com/url?sa=t&source=web&rct=j
&opi=89978449&url=https://gscen.shikshamandal.org
/wp-content/uploads/2022/sp/BCCA-
2022/22.pdf&ved=2ahUKEwjM2-mL8o-
KAxUMsVYBHRSJIIsQFnoECDAQAQ&usg=AOvVaw2HEi
jNnnUKsQGcHigBnyOK
