LIBRARY MANAGEMENT SYSTEM

A MINI PROJECT REPORT

Submitted by
SANSKAR SHARMAJRA2011033010079)
RISHU RAJJRA20110330100821
Under the Guidance of
Dr. S. VIMAL
Assistant Professor, Department of Computational Intelligence

In partial satisfaction of the requirements for the degree of

BACHELORS OF TECHNOLOGY
in
COMPUTER SCIENCE ENGINEERING

with specialization in Software Engineering

SRM
INSTITUTE OF SCIESCE&TECHNOLOGY
Dened to be University u/s 3 ofUGC Act, 19s

SCHOOL OFCOMPUTING
COLLEGE OF ENGINEERINGAND TECHNOLOGY
SRM INSTITUTE OF SCIENCE AND TECHNOLOGY
KATTANKULATHUR- 603203

May 2023

1
 LIBRARY MANAGEMENT SYSTEM
AMIN PROJECT REPORT

Submitted by
SANSKARSHARMAIRA2011033010079|
RISHURAJ |RA2011033010082]

Under the Guidance of

Dr. S.VIMAL
Intelligence
Assistant Professor, Department of Computational

the degree of
In partial satisfaction ofthe requirementsfor
BACHELORS OF TECHNOLOGY
in
COMPUTER SCIENCE ENGINEERING

Engineering
with specialization in Software

SRM INSTITUTE OF SCIENCE&THCHNOLOGY

Detned te6z Untversity us JofUGC ACt,
1956

SCHOOL OF COMPUTING

AND TECHNOLOGY
COLLEGE OF ENGINEERING
SCIENCE AND
TECHNOLOGY
SRM INSTITUTE OF
KATTANKULATHUR - 603203

May 2023
 OSRM INSTIILTE OF SCIENCE& TECINOLOY
Demed to b Ustersity /i0GC Act, 1996

SRM INSTITUTION OF SCIENCE AND

TECHNOLOGYKATTANKULATHUR-603203
BONAFIDE CERTIFICATE

Certified that this Course Project Report titled "Library Management

System" is the
bonafide work done by SANSKAR SHARMA
RA2011033010079)
and RISHU
RAJ RA2011033010082| who carried out under my supervision.
Certified further, that
to the best of my knowledge the work reported herein does not
form part of any other
work.

HEAD OF THE DEPARTMENT

Faculty In-Charge Dr. R Annie Uthra
Dr. S. VIMAL
Assistant Professor
Professor and Head,
Department of Computational Intelligence,
Department of Computational Intelligence SRM Institute of Science and Technology
SRM Institute of Science and Technology
Kattankulathur Campus, Chennai
Kattankulathur Campus, Chennai

2
 FACULTY OF ENGINEERING AND TECHNOLOGY

SRM INSTITUTE OF SCIENCE AND TECHNOLOGY

Kattankulathur, Chengalpattu District

May 2023

(Under Section 3 of UGC Act, 1956)

A Project Report
On
Library Management System

Submitted by:
Sanskar Sharma (RA2011033010079)
Rishu Raj (RA2011033010082)

Under the guidance of

Dr. S.VIMAL

In partial fulfilment for the Course

of

18CSC303J - Database Management Systems in Department of Computational

Intelligence

1
 SRM INSTITUTION OF SCIENCE AND
TECHNOLOGYKATTANKULATHUR-603203

BONAFIDE CERTIFICATE

Certified that this Course Project Report titled “Library Management System” is the
bonafide work done by SANSKAR SHARMA [RA2011033010079] and RISHU
RAJ [RA2011033010082] who carried out under my supervision. Certified further, that
to the best of my knowledge the work reported herein does not form part of any other
work.

SIGNATURE HEAD OF THE DEPARTMENT

Faculty In-Charge Dr. R Annie Uthra
Dr. S. VIMAL Professor and Head ,
Assistant Professor Department of Computational Intelligence,
Department of Computational Intelligence SRM Institute of Science and Technology
SRM Institute of Science and Technology Kattankulathur Campus, Chennai
Kattankulathur Campus, Chennai

ABSTRACT

2
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. Manual process of keeping student records,
book records, account details, managing employee is very difficult. There are
various problems also faced by the student in library such as finding any
particular book, information whether book is available or not, searching of books
using ISBN number etc. To eliminate this manual system, library management
system has been developed. Library Management System will handle all the
current issues faced by the students and by its admin personnel. It has a facility
of admin login through which the admin can monitor the whole system. It has a
facility where student after logging in their accounts can see list of books issued
and its issue date and return date. Overall, this project of ours is being
developed to help the staff of library to maintain the library in the best way
possible and also reduce the human efforts.

3
 TABLE OF CONTENTS

S.NO Topic Page No

1. Abstract 3

2. Introduction 5

3. Objective 6

4. Architecture Diagram 7-8

9-10
5. Dataset

11-23
6. Coding & output

7. Conclusion & 24
References

4
 INTRODUCTION

Module 1 - Member Module

In this module, we are displaying information from the database regarding all
the members that are registered. In this module the librarian can add or delete
the members registered in the library and only the members who are registered
can view the information.
The first part is Adding of members. The initial page displays all the registers
members present in our database. In this file the librarian can add a member
by filling up all the details such as its address, name, phone number etc.
The second part is updation of the member. If the member wants to update
his/her phone number this could be done with the help of the update option
available, after filling up all the new details the database will be updated using
the appropriate query.
The third part is Deletion of the member. We have provided an option for the
librarian to permanently delete a member from the database. When the librarian
click on delete option button present in-front of the member than that particular
member will be deleted from the database and the list will be updated.

Module 2 - Books Module

In this module we are displaying information from the database regarding all the
books that are available in the library. This option is divided into various
categories like books which are lost, damaged that are subject to replacement
etc.
The first file that is books.php displays the books that are not archive. Second
tab that is of new_books.php displays information of new books available in
library. Then, it includes option of old_books.php containing information
regarding the old books. Similarly, there is option for lost books and then for
damage books. It includes another option for books that are subject to
replacement.
This module provides admin a systematic view of all the books divided into
various categories, making the task easier for the admin.
In every file of books module, there is an option provided Add Books, which
enables the admin to add books in various categories defined above.

Module 3 - Search Module

The search module lets users search for specific book on the site. You can
search both for author and for particular book. When you are on the search
tab of website, you will be able to search for authors and book available on
the library management system.

5
Module 4 – Login and Logout Module
The default user for our project is admin. Our project provides the facility for
the admin to login and then review all the books and members in the library

OBJECTIVE

Manual process of keeping student records, book records, account details,

managing employee is very difficult. There are various problems also faced by
the student in library such as finding any particular book, information whether
book is available or not, for what time this book will be available, searching of
books using ISBN number etc. To eliminate this manual system, library
management system has been developed. Library Management System will
handle all the current issues faced by the students and by its admin personnel.

To store all the information in the database from where user will place their
query and get the results on the basis of their query. Only valid users will be
able to access this Library Management System. Through this Library
Management System, it will be easy to manage accounts and various details of
particular student and employees working under library along with the records
of book.

The current Library Management System does not eliminate the process of
searching books within the library campus. Students have to find books
manually. They have to wait until they are not provided with their library card
and token. For receiving book, they have to show their library card and wait in
line for their turns. The admin personnel also have to look manually on which
day which person will take the charge within library to manage the overall work.

6
Architecture Diagram:

7
8
Dataset:

9
10
 Code:
Member Model

login_server_page

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Login Form</title>
<link
href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css"
rel="stylesheet" id="bootstrap-css">
<script
src="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/js/bootstrap.min.js"></script>
<script
src="//cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<link rel="stylesheet" href="style.css">
</head>
<style>

body{
background-image: url('images/library.jpg')

.login-form-3 .btnSubmit {
font-weight: 600;
color: #0062cc;
background-color: #fff;
}

.login-form-3 h3 {
text-align: center;
color: #fff;
}

.login-form-1 h3 {
text-align: center;
color: #fff;
}
.login-form-3 {
padding: 5%;
box-shadow: 0 5px 8px 0 rgba(0, 0, 0, 0.2), 0 9px 26px 0 rgba(0, 0, 0, 0.19);
}

11
 </style>
<body >

<?php
$emailmsg="";
$pasdmsg="";
$msg="";

$ademailmsg="";
$adpasdmsg="";

if(!empty($_REQUEST['ademailmsg'])){
$ademailmsg=$_REQUEST['ademailmsg'];
}

if(!empty($_REQUEST['adpasdmsg'])){
$adpasdmsg=$_REQUEST['adpasdmsg'];
}

if(!empty($_REQUEST['emailmsg'])){
$emailmsg=$_REQUEST['emailmsg'];
}

if(!empty($_REQUEST['pasdmsg'])){
$pasdmsg=$_REQUEST['pasdmsg'];
}

if(!empty($_REQUEST['msg'])){
$msg=$_REQUEST['msg'];
}

?>

<div class="container login-container">

<div class="row"><h4><?php echo $msg?></h4></div>
<div class="row">

<div class="col-md-6 login-form-3">

<h3>Admin Login</h3>
<form action="loginadmin_server_page.php" method="get">
<div class="form-group">
<input type="text" class="form-control"
name="login_email" placeholder="Your Email *" value="" />
</div>
<Label style="color:red">*<?php echo $ademailmsg?></label>
<div class="form-group">
<input type="password" class="form-control"
name="login_pasword" placeholder="Your Password *" value="" />

12
 </div>
<Label style="color:red">*<?php echo $adpasdmsg?></label>
<div class="form-group">
<input type="submit" class="btnSubmit" value="Login" />
</div>
<!-- <div class="form-group">

<a href="#" class="ForgetPwd" value="Login">Forget

Password?</a>
</div> -->
</form>
</div>
<div class="col-md-6 login-form-1">
<h3>Student Login</h3>
<form action="login_server_page.php" method="get">
<div class="form-group">
<input type="text" class="form-control"
name="login_email" placeholder="Your Email *" value="" />
</div>
<Label style="color:red">*<?php echo $emailmsg?></label>
<div class="form-group">
<input type="password" class="form-control"
name="login_pasword" placeholder="Your Password *" value="" />
</div>
<Label style="color:red">*<?php echo $pasdmsg?></label>
<div class="form-group">
<input type="submit" class="btnSubmit" value="Login" />
</div>
</form>
</div>
</div>
</div>
<script src="" async defer></script>
</body>
</html>

13
library_managment.sql:-

-- phpMyAdmin SQL Dump

-- version 5.0.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 01, 2021 at 05:28 PM
-- Server version: 10.4.14-MariaDB
-- PHP Version: 7.4.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `library_managment`
--

-- --------------------------------------------------------

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (

`id` int(11) NOT NULL,
`email` varchar(25) NOT NULL,
`pass` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `email`, `pass`) VALUES

(1, 'idno22381@gmail.com', '123');

-- --------------------------------------------------------

--
-- Table structure for table `book`
--

14
CREATE TABLE `book` (
`id` int(11) NOT NULL,
`bookpic` varchar(25) NOT NULL,
`bookname` varchar(25) NOT NULL,
`bookdetail` varchar(110) NOT NULL,
`bookaudor` varchar(25) NOT NULL,
`bookpub` varchar(25) NOT NULL,
`branch` varchar(110) NOT NULL,
`bookprice` varchar(25) NOT NULL,
`bookquantity` varchar(25) NOT NULL,
`bookava` int(11) NOT NULL,
`bookrent` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `book`
--

INSERT INTO `book` (`id`, `bookpic`, `bookname`, `bookdetail`, `bookaudor`,

`bookpub`, `branch`, `bookprice`, `bookquantity`, `bookava`, `bookrent`) VALUES
(4, 'arrow.jpg', 'Scott Gallagher', '1st edition', 'no idea', 'Suscipit', 'it',
'756', '20', 16, 4),
(5, 'logo.png', 'Ferris Mclaughlin', 'Qui ex dolor fugiat ', 'Est voluptates offi',
'Dolorem earum accusa', 'electrical', '264', '157', 157, 0),
(6, 'arrow.png', 'harry', 'Ea quas nulla ration', 'Ut dolorem culpa ex', 'Eum
proident quidem', 'it', '76', '3', 2, 1);

-- --------------------------------------------------------

--
-- Table structure for table `issuebook`
--

CREATE TABLE `issuebook` (

`id` int(11) NOT NULL,
`userid` int(11) NOT NULL,
`issuename` varchar(25) NOT NULL,
`issuebook` varchar(25) NOT NULL,
`issuetype` varchar(25) NOT NULL,
`issuedays` int(11) NOT NULL,
`issuedate` varchar(25) NOT NULL,
`issuereturn` varchar(25) NOT NULL,
`fine` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `issuebook`
--

15
INSERT INTO `issuebook` (`id`, `userid`, `issuename`, `issuebook`, `issuetype`,
`issuedays`, `issuedate`, `issuereturn`, `fine`) VALUES
(2, 1, 'salman', 'Rich daddy poor dady', 'student', 3, '30/03/2021', '02/04/2021',
1800),
(3, 2, 'Randall Burch', 'Scott Gallagher', 'teacher', 4, '30/03/2021',
'03/04/2021', 0),
(6, 1, 'salman', 'Scott Gallagher', 'student', 7, '30/03/2021', '06/04/2021',
1800),
(9, 5, 'salmannew', 'Scott Gallagher', 'teacher', 21, '30/03/2021', '20/04/2021',
0),
(10, 1, 'salman', 'Scott Gallagher', 'student', 7, '01/04/2021', '08/04/2021', 0),
(11, 1, 'salman', 'harry', 'student', 7, '01/04/2021', '08/04/2021', 0);

-- --------------------------------------------------------

--
-- Table structure for table `requestbook`
--

CREATE TABLE `requestbook` (

`id` int(11) NOT NULL,
`userid` int(11) NOT NULL,
`bookid` int(11) NOT NULL,
`username` varchar(25) NOT NULL,
`usertype` varchar(25) NOT NULL,
`bookname` varchar(25) NOT NULL,
`issuedays` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `userdata`
--

CREATE TABLE `userdata` (

`id` int(11) NOT NULL,
`name` varchar(25) NOT NULL,
`email` varchar(25) NOT NULL,
`pass` varchar(25) NOT NULL,
`type` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `userdata`
--

INSERT INTO `userdata` (`id`, `name`, `email`, `pass`, `type`) VALUES

(1, 'salman', 'idno22382@gmail.com', '123', 'student'),
(2, 'Randall Burch', 'voqo@mailinator.com', 'Ratione nulla dolore', 'teacher'),

16
(3, 'Gabriel Daugherty', 'bipacer@mailinator.com', 'Voluptas explicabo ',
'teacher'),
(5, 'salmannew', '1234@gmail.com', '123', 'teacher');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
ADD PRIMARY KEY (`id`);

--
-- Indexes for table `book`
--
ALTER TABLE `book`
ADD PRIMARY KEY (`id`);

--
-- Indexes for table `issuebook`
--
ALTER TABLE `issuebook`
ADD PRIMARY KEY (`id`),
ADD KEY `pk_fk` (`userid`);

--
-- Indexes for table `requestbook`
--
ALTER TABLE `requestbook`
ADD PRIMARY KEY (`id`),
ADD KEY `pk_fk_book` (`bookid`),
ADD KEY `pk_fk_users` (`userid`);

--
-- Indexes for table `userdata`
--
ALTER TABLE `userdata`
ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

17
--
-- AUTO_INCREMENT for table `book`
--
ALTER TABLE `book`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

ALTER TABLE `issuebook`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `requestbook`
--
ALTER TABLE `requestbook`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `userdata`
--
ALTER TABLE `userdata`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

ALTER TABLE `issuebook`

ADD CONSTRAINT `pk_fk` FOREIGN KEY (`userid`) REFERENCES `userdata` (`id`);

ALTER TABLE `requestbook`

ADD CONSTRAINT `pk_fk_users` FOREIGN KEY (`userid`) REFERENCES `userdata` (`id`);
COMMIT;

18
Student_login page:

Admin_login page:

19
20
21
22
23
CONCLUSION:-

Library Management Systems (LMS) have revolutionized the way libraries operate and
manage their resources. These systems have simplified the entire process of cataloging,
indexing, and circulating books, while also providing users with easy access to library
resources.
The benefits of LMS are numerous, including improved efficiency, enhanced user
experience, and increased accuracy in record-keeping. Additionally, LMS allows librarians to
track borrowing patterns and trends, helping them make data-driven decisions for future
collection development.
However, implementing an LMS can be a complex process that requires significant resources
and planning. Libraries must carefully consider their needs and budget before selecting an
LMS that meets their specific requirements. In addition, LMS must be regularly updated and
maintained to ensure continued functionality and optimal performance.
Overall, Library Management Systems have greatly improved the way libraries operate and
provide services to their users. While challenges may arise during implementation, the
benefits of LMS outweigh any initial difficulties and ultimately lead to more effective and
efficient library operations.

References:-

• https://www.g2.com/categories/library-management-systems

• https://www.iitms.co.in/library-management-system/

• https://www.elibrarysoftware.com/

24