Page |1

Chhatrapati Shahu Ji Maharaj

University,Kanpur
Project Report
on
[LIBRARY MANAGEMENT SYSTEM]

Submitted in Partial Fulfillment of the Requirements for the

Degree of
Bachelors of Computer Application
By:
[VIPIN YADAV]
[0202398]

Under the Supervision of

MR. DHIRENDRA KUMAR

PSIT College of Higher Education

Kanpur-Agra-Delhi National Highway – 2, Bhauti, Kanpur (2021-2022)

 Page |2

DECLARATION

I hereby declare that the project entitled “ LIBRARY MANAGEMENT SYSTEM ” submitted for the
Bachelor of Computer Application degree is my original work and the project has not formed the
basis for the award of any other degree of the university or other institute of higher learning, except
where due acknowledgment has been made in the text.

Signature of the student

vipinyadav

VIPIN YADAV

BCA 3-C

PSIT College Of Higher Education

 Page |3

CERTIFICATE

This is to certify that project entitled “ LIBRARY MANAGEMENT SYSTEM ” submitted for
partial fulfillment of the degree of BCA under the Department of Bachelor of Computer Application
to through PSIT College of Higher Education, Kanpur, done by Mr. VIPIN YADAV , Roll No.
0202398 is an authentic work carried out by me under the guidance of MR DHIRENDRA KUMAR.
The matter embodied in this project work has not been submitted earlier for award of any degree or
diploma to the best of my knowledge and belief.

Internal Examiner/Guide -MR. DHIRENDRA KUMAR

External ExaminEr -

Head of Department- MR. SANTOSH KUMAR SHARMA

 Page |4

ACKNOWLEDGEMENT

Presentation inspiration and motivation have always played a key role in the success of any venture.

I express my sincere thanks to Dr. Shivani Kapoor, Director, PSIT College of Higher Education,
Kanpur.

I pay my deep sense of gratitude to Mr. SANTOSH KUMAR SHARMA (HOD) of BCA
Department, PSIT College of Higher Education to encourage me to the highest peak and to provide
me the opportunity to prepare the project. I am immensely obliged to my friends for their elevating
inspiration, encouraging guidance and kind supervision in the completion of my project.

I feel to acknowledge my indebtedness and deep sense of gratitude to my guide Mr. DHIRENDRA
KUMAR whose valuable guidance and kind supervision given to me throughout the course which
shaped the present work as its show.

Last, but not the least, my parents are also an important inspiration for me. So with due regards, I
express my gratitude to them.

ABSTRACT:

Online Library Management System is a system which maintains the information about the books
present in the library, their authors, the members of library to whom books are issued, library staff
 Page |5

and all. This is very difficult to organize manually. Maintenance of all this information manually is a
very complex task. Owing to the advancement of technology, organization of an Online Library
becomes much simple. The Online Library Management has been designed to computerize and
automate the operations performed over the information about the members, book issues and returns
and all other operations. This computerization of library helps in many instances of its maintenances.
It reduces the workload of management as most of the manual work done is reduced.

Table of Contents:
S.No Title
 Page |6

1.1 Introduction
1.2 Existing System
1.3 Problems in Existing System
1.4 Proposed System
1.5 Objective of the Project
2.1 Modules & Description of the Modules
2.2 Hardware & Software Requirements
2.3 Front end & Back end Description
3.1 Feasibility Study
3.2 Software Development Life Cycle
3.3 Data Flow Diagram
4.1 ER Diagram(Database Schema Design)
4.2 Code of the project
4.3 Screen/Snapshots of the project
4.4 Coding Implementation References

CHAPTER 1

INTRODUCTION
 Page |7

This chapter gives an overview about the aim , objectives ,background and operation environment of
the system. The project titled Library Management System is LibraryManagement software for
monitoring and controlling the transactions in a library .The project “Library Management System” is
developed in php, which mainly focuses on basic operations in a library like adding new books, and
updating new information, searching books and members and return books.This project of
“LIBRARY MANAGEMENT” of gives us the complete information about the library. We can enter
the record of new books and retrieve the details of books available in the library. We can issue the
books to the students and maintain their records and can also check how many books are issued and
stock available in the library. In this project we can maintain the late fine of students who returns the
issued books after the due date.Throughout the project the focus has been on presenting information
and comments in an easy and intelligible manner. The project is very useful for those who want to
know about Library Management System.

The library management system is all about organizing, managing the library, and library-oriented
tasks. It also involves maintaining the database of entering new books and the record of books that
have been retrieved or issued, with their respective dates.

The main aim of this project is to provide an easy to handle and automated library management
system. This project also provides features and an interface for maintaining librarian’s records,
student’s history of issues, and fines. The owner can easily update, delete and insert data in the
database with this project

EXISTING SYSTEM
 Page |8

. Early days Libraries are managed manually. It required lot of time to record or to retrieve the details.
The employees who have to record the details must perform their job very carefully. Even a small
mistake would create a lot of problems. Security of information is very less. Report generations of all
the information is very tough task.

.Maintenance of Library catalogue and arrangement of the books to the catalogue is very complex
task. In addition to its maintenance of member details, issue dates and return dates etc. manually is a
complex task.

.All the operations must be performed in perfect manner for the maintenance of the library with out
any degradation which may finally result in the failure of the entire system.

. In the available Online Library Management System, librarian maintains the details of each book on
the registers so to find out the number of books available in the library they need to go to check the
entire entry which makes the process slow. While they need to spend an extra hour to maintain the
records of books. For a student who wants to know about a book in the library need to search the
entire book section. The student needs to check the status of the book means the last date of book,
how many books has issued.

PROBLEMS IN EXISTING SYSTEM

 Page |9

The problem occurred before having computerized system includes:

 File lost When computerized system is not implemented file is always lost because of human
environment.Some times due to some human error there may be a loss of records.

 File damaged When a computerized system is not there file is always lost due to some accdent like
spilling of water by some member on file accidentally. Besides some natural disaster like floods or
fires may also damage the files.

 Difficult to search record When there is no computerized system there is always a difficulty in
searching of records if the records are large in number .

 Space consuming After the number of records become large the space for physical storage of file
and records also increases if no computerized system is implemented.

 Cost consuming As there is no computerized system the to add each record paper will be needed
which will increase the cost for the management of library.

PROPOSED SYSTEM
 P a g e | 10

To solve the inconveniences as mentioned in the existing system, an Online Library is proposed. The
proposed system contains the following features:

. The students will register them through Online

. Individually each member will have his account through which he can access the information he
needs.

. Book details like authors, number of copies totally maintained by library, present available number
of books, reference books, non-reference books etc. all this information can be made handy.

. Regarding the members designation, number of books was issued.

.Issue dates and returns of each member is maintained separately and fine charged if there is any
delay in returning the book.

.Administrator can add, update the books.

. Time consuming is low, gives accurate results, reliability can be improved with the help of security.
 P a g e | 11

OBJECTIVE OF THE PROJECT

The project aims and objectives that will be achieved after completion of this project are discussed in
this subchapter. The aims and objectives are as follows:

 Online book reading.

 A search column to search availability of books.

 Facility to download required book.

 Video tutorial for students.

 An Admin login page where admin can add books, videos or page sources

 Open link for Learning Websites

E-Library Management System is an application which refers to library systems which are generally
small or medium in size. It is used by librarian to manage the library using a computerized system
where he/she can add new books, videos and Page sources. Books and student maintenance modules
are also included in this system which would keep track of the students using the library and also a
detailed description about the books a library contains. With this computerized system there will be
no loss of book record or member record which generally happens when a non computerized system
is used. All these modules are able to help librarian to manage the library with more convenience and
in a more efficient way as compared to library systems which are not computerized.
 P a g e | 12

Also the main objective of ths project is to ensure that no student in this entire world ever face the
problem of shortage of content to study or read for the betterment of their career and bright future.

.CHAPTER II

MODULES AND DESCRIPTION OF MODULES

Users in this system:

 Admin
 Librarian

User functions:

 Admin: Add, view, and delete the librarian.

 Librarian: Add, view, issue books, return books, payment

 Book Information Recording: All the information of each books should be recorded into the system
to provide the borrowers or the students the book references that they want to borrow.

 Administrator Login: The admin login will require the school librarian their email and password to
have the main access to the system and secure every information ang transaction done in the system.
 P a g e | 13

 Users/Borrowers' Login: This will also require the users or students email and password provided
when they were registered into the system. Their email and password will serve as their access to the
system in terms of borrowing books or inquiring for books.

 Book Monitoring and Updates: The system should save the borrowers info and the count of books
that are borrowed. These records should also be updatable when the books are returned.

 View and Check Information: The admin can view and check the books that are borrowed and who
were the students that borrowed them. Students can also view their borrowing transactions just like
the book information, date of book borrowing and returning.

 Borrowing Information: The borrowing information should consist the important details of the
borrowers and the books borrowed by each borrowers. This information should also record the day of
borrowing as well as the returning of the book.

 Borrowing Records: This will record all the transaction made and are stored for a period of time to
serve as reference for important matters. These modules must be present in creating the Library
Management system Project to satisfy the needs in managing Library transactions. Through this, the
borrowing and returning of books would be much easier for both students and librarians.

SYSTEM REQUIREMENTS
 P a g e | 14

NON FUNCTIONAL REQUIREMENTS

 Product Requirements

EFFICIENCY REQUIREMENT

When a library management system will be implemented librarian and user will easily acess library as
searching and book transaction will be very faster

. RELIABILITY REQUIREMENT

The system should accurately performs member registration ,member validation , report generation,
book transaction and search

USABILITY REQUIREMENT

The system is designed for a user friendly environment so that student and staff of library can
perform the various tasks easily and in an effective way.

ORGANIZATIONAL REQUIREMENT IMPLEMENTATION

REQUIREMNTS
 P a g e | 15

In implementing whole system it uses html in front end with php as server side scripting language
which will be used for database connectivity and the backend ie the database part is developed using
mysql

. DELIVERY REQUIREMENTS

The whole system is expected to be delivered in six months of time with a weekly evaluation by the
project guide.

FUNCTIONAL REQUIREMENTS
1. NORMAL USER

1.1 USER LOGIN

Description of feature This feature used by the user to login into system. They are required to
enter user id and password before they are allowed to enter the system .The user id and password
will be verified and if invalid id is there user is allowed to not enter the system. Functional
requirements -user id is provided when they register -The system must only allow user with valid
id and password to enter the system -The system performs authorization process which decides
what user level can acess to. -The user must be able to logout after they finished using system.

1.2 REGISTER NEW

USER Description of feature This feature can be performed by all users to register new user to
create account. Functional requirements -System must be able to verify information -System
must be able to delete information if information is wrong

1.3 REGISTER NEW BOOK

Description of feature This feature allows to add new books to the library Functional
requirements -System must be able to verify information -System must be able to enter number
of copies into table. - System must be able to not allow two books having same book id.

1.4 SEARCH BOOK 11 DESCRIPTION OF FEATURE

 P a g e | 16

This feature is found in book maintenance part . we can search book based on book id , book
name , publication or by author name. Functional requirements - System must be able to search
the database based on select search type - System must be able to filter book based on keyword
enterd - System must be able to show the filtered book in table view Functional requirements -
System should be able to add detailed information about events . -System should be able to
display information on notice board available in the homepage of site

SOFTWARE AND HARDWARE REQUIREMENTS

This section describes the software and hardware requirements of the system

SOFTWARE REQUIREMENTS

 Operating system- Windows 7 is used as the operating system as it is stable and supports more
features and is more user friendly

 Database MYSQL-MYSQL is used as database as it easy to maintain and retrieve records by simple
queries which are in English language which are easy to understand and easy to write.

 Development tools and Programming language- HTML is used to write the whole code and
develop webpages with css, java script for styling work and php for sever side scripting.

HARDWARE REQUIREMENTS 

Intel core i5 2nd generation is used as a processor because it is fast than other processors an provide
reliable and stable and we can run our pc for longtime. By using this processor we can keep on
developing our project without any worries.  Ram 1 gb is used as it will provide fast reading and
writing capabilities and will in turn support in processing.
 P a g e | 17

TECNOLOGY USED IN THE PROJECT

The whole Project is divided in two parts the front end and the back end

Front end The front end is designed using of html , Php ,css, Java script

HTML- HTMLorHyper Text Markup Languageis the main markuplanguage for creating web
pages and other information that can be displayed in a web browser.HTML is written in the form of
HTML elements consisting of tags enclosed in angle brackets (like ), within the web page content.
HTML tags most commonly come in pairs like <p>,<html>,<head>,<body> etc.

Although some tags represent empty elements and so are unpaired. The first tag in a pair is the start
tag, and the second tag is the end tag (they are also called opening tags and closing tags). In between
these tags web designers can add text, further tags, comments and other types of text-based content.
The purpose of a web browser is to read HTML documents and compose them into visible or audible
web pages. The browser does not display the HTML tags, but uses the tags to interpret the content of
the page.HTML elements form the building blocks of all websites. HTML allows images and objects
to be embedded and can be used to create interactive forms. It provides a means to create structured
documents by denoting structural semantics for text such as headings, paragraphs, lists, links, quotes
and other items. It can embed scripts written in languages such as JavaScript which affect the
behavior of HTML web pages.

CSS- Cascading Style Sheets(CSS) is a style sheet language used fordescribing the look and
formatting of a document written in a markup language. While most often used to style web pages
and interfaces written in HTML and XHTML, the language can be applied to any kind of XML
document, including plain XML, SVG and XUL. CSS is a cornerstone specification of the web and
almost all web pages use CSS style sheets to describe their presentation.CSS is designed primarily to
enable the separation of document content from document presentation, including elements such as
the layout, colors, and fonts. This separation can improve content accessibility, provide more
flexibility and control in the specification. of presentation characteristics, enable multiple pages to
share formatting, and reduce complexity and repetition in the structural content (such as by allowing
for table less web design).CSS can also allow the same markup page to be presented in different
styles for different rendering methods, such as on-screen, in print, by voice (when 14 read out by a
speech-based browser or screen reader) and on Braille-based, tactile devices. It can also be used to
allow the web page to display differently depending on the screen size or device on which it is being
viewed. While the author of a document typically links that document to a CSS file, readers can use a
different style sheet, perhaps one on their own computer, to override the one the author has specified.
 P a g e | 18

However if the author or the reader did not link the document to a specific style sheet the default style
of the browser will be applied.CSS specifies a priority scheme to determine which style rules apply if
more than one rule matches against a particular element. In this so-called cascade, priorities or
weights are calculated and assigned to rules, so that the results are predictable.

JAVA SCRIPT- JavaScript(JS) is a dynamic computer programminglanguage. It is most

commonly used as part of web browsers, whose implementations allow clientside scripts to interact
with the user, control the browser, communicate asynchronously, and alter the document content that
is displayed. It is also being used in server-side programming, game development and the creation of
desktop and mobile applications. JavaScript is a prototype-based scripting language with dynamic
typing and has first-class functions. Its syntax was influenced by C. JavaScript copies many names
and naming conventions from Java, but the two languages are otherwise unrelated and have very
different semantics. The key design principles within JavaScript are taken from the Self and Scheme
programming languages. It is a multiparadigm language, supporting object-oriented, imperative, and
functional programming styles. The application of JavaScript to use outside of web pages—for
example, in PDF documents, site-specific browsers, and desktop widgets—is also significant. Newer
and faster JavaScript VMs and platforms built upon them (notably Node.js) have also increased the
popularity of JavaScript for server-side web applications. On the client side, JavaScript was
traditionally implemented as an interpreted language but just-in-time compilation is now performed
by recent (post-2012) browsers.

PHP- PHPis a server-side scripting language designed for webdevelopment but also used as a
general-purpose programming language. PHP is now installed on more than 244 million websites and
2.1 million web servers. Originally created by 15 Rasmus Lerdorf in 1995, the reference
implementation of PHP is now produced by The PHP Group. While PHP originally stood for
Personal Home Page, it now stands for PHP: HypertextPreprocessor, a recursive backronym.PHP
code is interpreted by a webserver with a PHP processor module, which generates the resulting web
page: PHP commands can be embedded directly into an HTML source document rather than calling
an external file to process data. It has also evolved to include a command-line interface capability and
can be used in standalone graphical applications. PHP is free software released under the PHP
License. PHP can be deployed on most web servers and also as a standalone shell on almost every
operating system and platform, free of charge.

MYSQL- MySQL("My S-Q-L", officially, but also called "My Sequel") is (as ofJuly 2013) the
world's second most widely used open-source relational database management system (RDBMS). It is
named after co-founder Michael Widenius daughter, My. The SQL phrase stands for Structured
 P a g e | 19

Query Language. The MySQL development project has made its source code available under the
terms of the GNU General Public License, as well as under a variety of proprietary agreements.
MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB,
now owned by Oracle Corporation .MySQL is a popular choice of database for use in web
applications, and is a central component of the widely used LAMP open source web application
software stack (and other 'AMP' stacks). LAMP is an acronym for "Linux, Apache, MySQL,
Perl/PHP/Python." Free-software-open source projects that require a full-featured database
management system often use MySQL. For commercial use, several paid editions are available, and
offer additional functionality. Applications which use MySQL databases include: TYPO3, MODx,
Joomla, WordPress, phpBB, MyBB, Drupal and other software. MySQL is also used in many high-
profile, large-scale websites, including Wikipedia, Google (though not for searches), Facebook,
Twitter, Flickr, and YouTube

CHAPTER III

FEASIBILITY STUDY

The planning, development and realization of a computer software constitute a software development
project. The progress of a software development project generally requires significant investment in

human and automation resources. In order to ensure the success of the project development, the most

economical cost of these investments, and will be in operation and maintenance, at every stage of

development, need to prepare two given file. These files, together with computer programs and

data, constitute computer software. File is an indispensable part of computer software, its function is:

a. As the work results and end signs of developers in a certain stage;

b. to provide software development process and the progress of the management staff, some of the

software development process , " invisible " things converted into " visible in the " text information.

In order for managers to check the progress of the implementation of the development plan at all
 P a g e | 20

stages, so that they can judge whether the original target has been reached, and the type and amount

of resources that will continue to be consumed;

C. Record the technical information during the development process to facilitate the coordination of

future software development, use and modification;

d. Provide information about the operation, maintenance and training of the software, so that

managers, developers, operators and users can understand each other's work;

e. Report the functions and performance of the software to potential users so that they can determine

whether the software can serve their needs.

In other words, this guide believes that the preparation of documents must meet the needs of the

entire life cycle of computer software.

There are two types of documents contained in computer software: one type is various charts filled in

during the development process, which can be called worksheets; the other type is technical data or

technical management data that should be compiled, which can be called documents. This guide

specifies the format of software documentation and provides an explanation of these regulations. The

purpose of this guide is to make the compiled software document really play the role that the software

document should play.

2 scope

This guide is a guidance document. This means that South suggestions in the development of a

computer software, in general, should produce fourteen kinds of files. The fourteen types of files are:

Feasibility study report;

Project development plan;

Software requirements specification;

Data requirements specification;

Outline design specification;

 P a g e | 21

Detailed design specification;

Database design specification;

User manual;

Operation Manual;

Module development file;

Test Plan;

Test analysis report;

Monthly development progress report;

Project development summary report.

This guide will give guidelines for the compilation of the 14 types of documents recommended

during the development process. At the same time, this guide is also a guideline for the compilation

quality of these 14 types of documents. However, this guide does not deal with how to fill out work

forms during software development.

Generally speaking, a software is always a component part of a computer system (including

hardware, firmware, and software). In view of the diversity of computer systems , this guide generally
does not involve the documentation of the entire system development. This guide is only a guide for

the documentation of the software development process.

3 users of the document 

For those who use files, the types of files they care about vary with the work they undertake.

Management staff: feasibility study report, project development plan, module development file,

monthly development progress report, project development summary report;

 P a g e | 22

Developer: Feasibility study report, project development plan, software requirement specification,

data requirement specification, outline design specification, detailed design specification, database

design specification, test plan, test analysis report;

Maintenance personnel: design specification, test analysis report, module development file;

User: user manual, operation manual.

Although this guide puts forward the requirements for document preparation in software

development, it does not mean that these documents must be handed over to users. The types of

documents that users of a piece of software should get are stipulated by the contract between the

supplier and the user

4. Feasibility study report

The purpose of the preparation of the feasibility study are: to achieve a viable explanation in the

technical, economic and social conditions of the software development projects of sex; programs

reviewed in order to achieve reasonable goals and develop possible options; explain and demonstrate

selected Program.

The content requirements of the feasibility study report are as follows:

4 . 4 Introduction

4.4.4 Purpose of writing

  The library borrowing system is based on the management of users and the borrowing and return of

books by library managers . It also provides convenient management methods for users to borrow,

return, renew, and inquire about the books in the library by operating computers. Wait. The purpose

of writing this report is to study the overall requirements and implementation plans of the library

lending system from the aspects of the current application of technology, the user's operating mode,

and the economy, and analyze the feasibility of the development system, so as to decide whether to

develop the system Provide basis and suggestions.

 P a g e | 23

4.4.2 Background

  Software name: Library Management System.

4.4.3 Definition

  The library guan system is based on the borrowing, return, and management of books and

periodicals to provide efficient and convenient management methods. A system designed for

scientific processing, ordering, management and maintenance of book resources, providing document

information guarantee for teaching and scientific research and improving the efficiency of book

management. 4.4.4 Reference Materials

  Phan ed., "Introduction to Software Engineering" (first 5 edition), Tsinghua University Press;

4 .2 prerequisite for the feasibility study of 4 .2.4 requirements

Ø Reader management: the administrator should create a borrowing account for each reader, and

issue different types of readers (teachers, students)

Type of debit card (debit card can provide card number, reader's name, unique identification barcode)

Borrowing management: Readers with a borrowing card can use the system to handle books

borrowing, returning, and renewing books through the administrator. Ø Reader query: You can query

book information and personal borrowing status through the Internet or the query terminal in the
library, as well as renewing books (system review meets the renewal conditions).

Library management: Librarians regularly or irregularly carry out book information management

such as storage, modification, deletion and cancellation of book information (not loaned), including

book category, author, year and publisher management. It is required to keep up with the changes of

the books.

Various operations such as borrowing and inquiries can be completed conveniently, quickly and

effectively, and the legality of the input data is high and the query speed is fast.
 P a g e | 24

Ensure the correctness and timely update of information, and reduce the cost of information access.

Advanced technology and high reliability.

Security management: The system has sufficient self-protection systems, and has effective measures

against power failures, crashes, and system crashes to protect data from loss, and information security

is adequately guaranteed.

It can adapt to changes and modifications of application requirements and has flexible scalability.

Has high security. The system provides different functional modules for different users, and different

levels of restrictions on the operation authority of different visitors. Only administrators with certain

permissions can be allowed to borrow and return books, only department managers or maintenance

users with advanced permissions can manage users, and general reader users can only view book

information and borrowing status. In addition, the system also has a certain protection mechanism to

prevent the system from being maliciously attacked and information being maliciously modified and

stolen. There is a perfect backup mechanism, and it should be able to recover quickly if the system is

damaged. 4.2.2 Goal

Improve borrowing management methods and reduce manpower and management costs.

Improve work efficiency and reduce labor intensity.

Enhance resource sharing.

Improve the speed and accuracy of information processing, and establish an efficient information

transmission and service platform. 4.2.3 Conditions, assumptions and limitations

Operating environment: compatible with mainstream operating systems , office software, etc.

Hardware environment: computer, printer, scanner, etc.

Source of funding: PSIT College.

Development software: SQL Server, etc.

 P a g e | 25

Available information and resources: Wuhan Qingchuan College campus network, library and

Internet.

Recommended minimum software life: five years.

Proposed late time for the development of software to be put into use: April 30, 2048

4.2.4 Methods of conducting feasibility studies

  By investigating and analyzing the functions and implementation methods required by the library

lending system, the overall structure is determined, and compared with the existing library lending

system for analysis and research, there are more feasibility research methods.

4.2.5 Evaluation scale

  This library system can provide book managers with accurate and timely information, and provide

favorable support for managers' decision-making. It can promote the reform of the library

management system of colleges and universities, improve work efficiency, and reduce staff and

manpower management fees. These are the indirect benefits brought by the use of the system, but also

promote the process of school informatization and improve the student management system.

4 4.3 Analysis of the existing system 4 .3.4 data flow and processing flow

4.3.2 Workload

The librarian edits bibliographic information, reader information, book borrowing information, and

handles the number of borrowing information for borrowers.

4.3.3 Expenses

System development and establishment cost: 64,000 yuan

Hardware equipment fee: 400,000 yuan

Outsourcing development tools, software environment cost: 5000 yuan, making a library card

cost: 20,000 yuan
 P a g e | 26

Other one-time expenses: 3000 yuan

Recurrent expenditure: RMB 40000

In summary, the total one-time expenditure is 492,000 yuan, and the current expenditure is 40,000

yuan/year

4.3.4 Personnel

Developers: 4 people, responsible for system development, familiar with development software and

operating system. Have the ability to develop large-scale software, working time 2 months;

Staff: 20 people, responsible for establishing basic information such as books and readers, working

time 4 months;

Librarian: 45 people. After the system is established, the librarian is responsible for operating the

system to manage books. It requires a certain degree of computer operation ability and long-term

work. 4.3.5 Equipment

Server: x3950 x6 saphaha

Memory: 64G

Hard disk: 4T or more

Workstation: PowerEdge R430XD

Memory: 32G

Hard disk: 4T or more

4.3.6 Limitations

Due to the substantial improvement in hardware performance, the old system is no longer suitable for

the current ultra-high-speed microcomputers, processing information is slow, response time is long,

search algorithms are not optimized enough, operations are complicated, and security is insufficient.

To sum up, it has caused a lot of waste of manpower and material resources, and with the further
 P a g e | 27

division of labor and refinement of book management, the previous system has already appeared big

loopholes, so it is necessary to build a faster, more convenient, and more complete book. Library

lending system. 4 .4 proposed system 4 .4.4 of the proposed system will be described

The system consists of four modules: borrower management system, reader management system,

borrowing management system, and novelty search system.

4.4.2 Data flow and processing flow

4.4.3 Improvements

The borrower management system records the borrowing information based on the borrower

database, the book management system records the book information based on the book information

database, and the query system retrieves the borrower/book through the book/borrower database. The

borrowing management system operates on database information through other systems. 4.4.4 Impact

4.4.4.4 Impact on equipment

This system is based on the operating system and the Internet , so it needs to be equipped with

computers and communication lines that meet the various software and hardware conditions of the

above trains. After the system fails, the server needs to use the backup database to restore data

information, and sufficient data backup is required Space.4.4.4.2 Impact on software

Need to determine whether to develop the required genuine software environment , if not, you need to

purchase the impact of 4.4.4.3 on the user organization

The development process requires users to wake up and closely cooperate and accurately clarify their

needs. This system can make it more convenient for users to handle borrowing and returning books

and other things, saving manpower and material resources, and the systematic management software

is more convenient for users to operate. 4.4.4.4 Impact on system operation

The operating environment needs to support the operating system . It is required to establish the

original software environment required for the development of this system. 4.4.4.5 Impact on

development
 P a g e | 28

Establish a book information database , collect all aspects of book information, and improve the

planning and predictability of book management. 4.4.4.6 Impact on location and facilities

Implement unified operation and resource sharing in a library .

4.4.4.4 Impact on expenditures

Since the library is built by schools/government agencies, it is a for-profit organization. Expenses are

mainly reflected in expenditures: including capital construction costs, software development costs,

management and maintenance costs, staff salaries and training costs.  4.4.5 Limitations

Based on the limited network , Internet and windows operating system. 4.4.6 Feasibility in terms of

technical conditions

Relevant existing technology is very mature , leverage existing technology can achieve system

development goals . Used is java and sql language , it is the more popular language , another result of

the development period of relatively well-off , it is also feasible in terms of time , It is expected to be

completed within the planned period.

Reprinted at: https://www.cnblogs.com/we-are-a-team/p/10176426.html

SOFTWARE DEVELOPMENT LIFE CYCLE

P a g e | 29
P a g e | 30
 P a g e | 31

DATA FLOW DIAGRAMS

P a g e | 32
P a g e | 33
P a g e | 34
P a g e | 35
 P a g e | 36

.CHAPTER IV

DATABASE SCHEMA DIAGRAMS

P a g e | 37
 P a g e | 38

PROJECT CODE
<?php

session_start();

$dbservername = "localhost";

$dbusername = "root";

$dbpassword = "";

// Create connection

$conn = mysqli_connect($dbservername, $dbusername, $dbpassword);

// Check connection

if (!$conn) {

echo "Connected unsuccessfully";

die("Connection failed: " . mysqli_connect_error());

?>

<?php

require('dbconn.php');

?>
 P a g e | 39

<!DOCTYPE html>

<html>

<!-- Head -->

<head>

<title>Library Management System </title>

<!-- Meta-Tags -->

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

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

<meta name="keywords" content="Library Member Login Form Widget Responsive,

Login Form Web Template, Flat Pricing Tables, Flat Drop-Downs, Sign-Up Web Templates, Flat
Web Templates, Login Sign-up Responsive Web Template, Smartphone Compatible Web Template,
Free Web Designs for Nokia, Samsung, LG, Sony Ericsson, Motorola Web Design" />

<script type="application/x-javascript"> addEventListener("load", function()

{ setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>

<!-- //Meta-Tags -->

<!-- Style --> <link rel="stylesheet" href="css/style.css" type="text/css" media="all">

<!-- Fonts -->

<link href="//fonts.googleapis.com/css?family=Roboto:100,300,400,500,700,900"
rel="stylesheet">

<!-- //Fonts -->

</head>

<!-- //Head -->

 P a g e | 40

<!-- Body -->

<body>

<h1>LIBRARY MANAGEMENT SYSTEM</h1>

<div class="container">

<div class="login">

<h2>Sign In</h2>

<form action="index.php" method="post">

<input type="text" Name="RollNo" placeholder="RollNo"

required="">

<input type="password" Name="Password" placeholder="Password"

required="">

<div class="send-button">

<!--<form>-->

<input type="submit" name="signin"; value="Sign In">

</form>

</div>

<div class="clear"></div>

</div>

<div class="register">
 P a g e | 41

<h2>Sign Up</h2>

<form action="index.php" method="post">

<input type="text" Name="Name" placeholder="Name" required>

<input type="text" Name="Email" placeholder="Email" required>

<input type="password" Name="Password" placeholder="Password"

required>

<input type="text" Name="PhoneNumber" placeholder="Phone

Number" required>

<input type="text" Name="RollNo" placeholder="Roll Number"

required="">

<select name="Category" id="Category">

<option value="GEN">General</option>

<option value="OBC">OBC</option>

<option value="SC">SC</option>

<option value="ST">ST</option>

</select>

<br>

<br>

<div class="send-button">

<input type="submit" name="signup" value="Sign Up">

</form>

</div>

<p>By creating an account, you agree to our Terms</a></p>

<div class="clear"></div>
 P a g e | 42

</div>

<div class="clear"></div>

</div>

<!-- <div class="footer w3layouts agileits">

<p> &copy; 2018 Library Member Login. All Rights Reserved </a></p>

</div> -->

<?php

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

{$u=$_POST['RollNo'];

$p=$_POST['Password'];

$c=$_POST['Category'];

$sql="select * from LMS.user where RollNo='$u'";

$result = $conn->query($sql);

$row = $result->fetch_assoc();

$x=$row['Password'];

$y=$row['Type'];

if(strcasecmp($x,$p)==0 && !empty($u) && !empty($p))

{//echo "Login Successful";

$_SESSION['RollNo']=$u;
 P a g e | 43

if($y=='Admin')

header('location:admin/index.php');

else

header('location:student/index.php');

else

{ echo "<script type='text/javascript'>alert('Failed to Login! Incorrect RollNo or

Password')</script>";

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

$name=$_POST['Name'];

$email=$_POST['Email'];

$password=$_POST['Password'];

$mobno=$_POST['PhoneNumber'];

$rollno=$_POST['RollNo'];

$category=$_POST['Category'];

$type='Student';
 P a g e | 44

$sql="insert into LMS.user (Name,Type,Category,RollNo,EmailId,MobNo,Password) values

('$name','$type','$category','$rollno','$email','$mobno','$password')";

if ($conn->query($sql) === TRUE) {

echo "<script type='text/javascript'>alert('Registration Successful')</script>";

} else {

//echo "Error: " . $sql . "<br>" . $conn->error;

echo "<script type='text/javascript'>alert('User Exists')</script>";

?>

</body>

<!-- //Body -->

</html>

<?php

session_start();

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

$title=$_POST['title'];

$Description=$_POST['Description'];

$rollno=$_SESSION['RollNo'];
 P a g e | 45

$sql1="insert into LMS.recommendations (Book_Name,Description,RollNo) values

('$title','$Description','$rollno')";

echo $rollno;

/*

if($conn->query($sql1) === TRUE){

echo "<script type='text/javascript'>alert('Success')</script>";

else

{//echo $conn->error;

echo "<script type='text/javascript'>alert('Error')</script>";

}*/

?>

<!-- <!DOCTYPE html>

<html>

<head>

<title>Terms and Conditions</title>

</head>
 P a g e | 46

<body>

<h2>Please go through <a class="underline"

href="https://www.youtube.com/channel/UC05AFHY9u7auzbgpXAQ0zNA">AVE</a> website for
terms and conditions.</h2>

</body>

</html> -->

<?php

require('dbconn.php');

$id=$_GET['id'];

$roll=$_SESSION['RollNo'];

$sql="insert into LMS.return (RollNo,BookId) values ('$roll','$id')";

if($conn->query($sql) === TRUE)

echo "<script type='text/javascript'>alert('Request Sent to Admin.')</script>";

header( "Refresh:0.01; url=current.php", true, 303);

else

echo "<script type='text/javascript'>alert('Request Already Sent.')</script>";

header( "Refresh:0.01; url=current.php", true, 303);

}
 P a g e | 47

?>

<?php

require('dbconn.php');

$id=$_GET['id'];

$roll=$_SESSION['RollNo'];

$sql="insert into LMS.renew (RollNo,BookId) values ('$roll','$id')";

if($conn->query($sql) === TRUE)

echo "<script type='text/javascript'>alert('Request Sent to Admin.')</script>";

header( "Refresh:0.01; url=current.php", true, 303);

else

echo "<script type='text/javascript'>alert('Request Already Sent.')</script>";

header( "Refresh:0.01; url=current.php", true, 303);

}
 P a g e | 48

?>

<?php

require('dbconn.php');

?>

<?php

if ($_SESSION['RollNo']) {

?>

<!DOCTYPE html>

<html lang="en">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<meta name="viewport" content="width=device-width, initial-scale=1.0">

<title>Library Management System</title>

<link type="text/css" href="bootstrap/css/bootstrap.min.css" rel="stylesheet">

<link type="text/css" href="bootstrap/css/bootstrap-responsive.min.css" rel="stylesheet">

<link type="text/css" href="css/theme.css" rel="stylesheet">

<link type="text/css" href="images/icons/css/font-awesome.css" rel="stylesheet">

<link type="text/css" href='http://fonts.googleapis.com/css?

family=Open+Sans:400italic,600italic,400,600'

rel='stylesheet'>
 P a g e | 49

</head>

<body>

<div class="navbar navbar-fixed-top">

<div class="navbar-inner">

<div class="container">

<a class="btn btn-navbar" data-toggle="collapse" data-target=".navbar-inverse-

collapse">

<i class="icon-reorder shaded"></i></a><a class="brand" href="index.php">Library

Management System </a>

<div class="nav-collapse collapse navbar-inverse-collapse">

<ul class="nav pull-right">

<li class="nav-user dropdown"><a href="#" class="dropdown-toggle" data-

toggle="dropdown">

<img src="images/user.png" class="nav-avatar" />

<b class="caret"></b></a>

<ul class="dropdown-menu">

<li><a href="index.php">Your Profile</a></li>

<!--li><a href="#">Edit Profile</a></li>

<li><a href="#">Account Settings</a></li-->

<li class="divider"></li>

<li><a href="logout.php">Logout</a></li>

</ul>

</li>

</ul>

</div>

<!-- /.nav-collapse -->

</div>
 P a g e | 50

</div>

<!-- /navbar-inner -->

</div>

<!-- /navbar -->

<div class="wrapper">

<div class="container">

<div class="row">

<div class="span3">

<div class="sidebar">

<ul class="widget widget-menu unstyled">

<li class="active"><a href="index.php"><i class="menu-icon

icon-home"></i>Home

</a></li>

<li><a href="message.php"><i class="menu-icon

icon-inbox"></i>Messages</a>

</li>

<li><a href="book.php"><i class="menu-icon icon-book"></i>All Books

</a></li>

<li><a href="history.php"><i class="menu-icon icon-tasks"></i>Previously

Borrowed Books </a></li>

<li><a href="recommendations.php"><i class="menu-icon

icon-list"></i>Recommend Books </a></li>

<li><a href="current.php"><i class="menu-icon icon-list"></i>Currently Issued

Books </a></li>

</ul>

<ul class="widget widget-menu unstyled">

<li><a href="logout.php"><i class="menu-icon icon-signout"></i>Logout

</a></li>

</ul>
 P a g e | 51

</div>

<!--/.sidebar-->

</div>

<!--/.span3-->

<div class="span9">

<div class="content">

<div class="module">

<div class="module-head">

<h3>Reccomend a Book</h3>

</div>

<div class="module-body">

<br >

<form class="form-horizontal row-fluid" action="recommendations.php"

method="post">

<div class="control-group">

<label class="control-label" for="Title"><b>Book Title</b></label>

<div class="controls">

<input type="text" id="title" name="title" placeholder="Title"

class="span8" required>

</div>

</div>
 P a g e | 52

<div class="control-group">

<label class="control-label"
for="Description"><b>Description</b></label>

<div class="controls">

<input type="text" id="Description" name="Description"

placeholder="Description" class="span8" required>

</div>

</div>

<div class="control-group">

<div class="controls">

<button type="submit" name="submit"class="btn">Submit

Recommendation</button>

</div>

</div>

</form>

</div>

</div>

</div><!--/.content-->

</div>

<!--/.span9-->

</div>

</div>
 P a g e | 53

<!--/.container-->

</div>

<div class="footer">

<div class="container">

<b class="copyright">&copy; MMC Library Management System </b>All rights reserved.

</div>

</div>

<!--/.wrapper-->

<script src="scripts/jquery-1.9.1.min.js" type="text/javascript"></script>

<script src="scripts/jquery-ui-1.10.1.custom.min.js" type="text/javascript"></script>

<script src="bootstrap/js/bootstrap.min.js" type="text/javascript"></script>

<script src="scripts/flot/jquery.flot.js" type="text/javascript"></script>

<script src="scripts/flot/jquery.flot.resize.js" type="text/javascript"></script>

<script src="scripts/datatables/jquery.dataTables.js" type="text/javascript"></script>

<script src="scripts/common.js" type="text/javascript"></script>

<?php

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

$title=$_POST['title'];

$Description=$_POST['Description'];

$rollno=$_SESSION['RollNo'];

$sql1="insert into LMS.recommendations (Book_Name,Description,RollNo) values

('$title','$Description','$rollno')";
 P a g e | 54

if($conn->query($sql1) === TRUE){

echo "<script type='text/javascript'>alert('Success')</script>";

else

{//echo $conn->error;

echo "<script type='text/javascript'>alert('Error')</script>";

?>

</body>

</html>

<?php }

else {

echo "<script type='text/javascript'>alert('Access Denied!!!')</script>";

} ?>

<?php
 P a g e | 55

ob_start();

require('dbconn.php');

?>

<!DOCTYPE html>

<html lang="en">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<meta name="viewport" content="width=device-width, initial-scale=1.0">

<title>Library Management System</title>

<link type="text/css" href="bootstrap/css/bootstrap.min.css" rel="stylesheet">

<link type="text/css" href="bootstrap/css/bootstrap-responsive.min.css" rel="stylesheet">

<link type="text/css" href="css/theme.css" rel="stylesheet">

<link type="text/css" href="images/icons/css/font-awesome.css" rel="stylesheet">

<link type="text/css" href='http://fonts.googleapis.com/css?

family=Open+Sans:400italic,600italic,400,600'

rel='stylesheet'>

</head>

<body>

<div class="navbar navbar-fixed-top">

<div class="navbar-inner">

<div class="container">

<a class="btn btn-navbar" data-toggle="collapse" data-target=".navbar-inverse-

collapse">
 P a g e | 56

<i class="icon-reorder shaded"></i></a><a class="brand" href="index.php">Library

Management System </a>

<div class="nav-collapse collapse navbar-inverse-collapse">

<ul class="nav pull-right">

<li class="nav-user dropdown"><a href="#" class="dropdown-toggle" data-

toggle="dropdown">

<img src="images/user.png" class="nav-avatar" />

<b class="caret"></b></a>

<ul class="dropdown-menu">

<li><a href="index.php">Your Profile</a></li>

<!--li><a href="#">Edit Profile</a></li>

<li><a href="#">Account Settings</a></li-->

<li class="divider"></li>

<li><a href="logout.php">Logout</a></li>

</ul>

</li>

</ul>

</div>

<!-- /.nav-collapse -->

</div>

</div>

<!-- /navbar-inner -->

</div>

<!-- /navbar -->

<div class="wrapper">

<div class="container">

<div class="row">
 P a g e | 57

<div class="span3">

<div class="sidebar">

<ul class="widget widget-menu unstyled">

<li class="active"><a href="index.php"><i class="menu-icon

icon-home"></i>Home

</a></li>

<li><a href="message.php"><i class="menu-icon

icon-inbox"></i>Messages</a>

</li>

<li><a href="book.php"><i class="menu-icon icon-book"></i>All Books

</a></li>

<li><a href="history.php"><i class="menu-icon icon-tasks"></i>Previously

Borrowed Books </a></li>

<li><a href="recommendations.php"><i class="menu-icon

icon-list"></i>Recommend Books </a></li>

<li><a href="current.php"><i class="menu-icon icon-list"></i>Currently Issued

Books </a></li>

</ul>

<ul class="widget widget-menu unstyled">

<li><a href="logout.php"><i class="menu-icon icon-signout"></i>Logout

</a></li>

</ul>

</div>

<!--/.sidebar-->

</div>

<!--/.span3-->

<div class="span9">

<div class="module">

<div class="module-head">
 P a g e | 58

<h3>Update Details</h3>

</div>

<div class="module-body">

<?php

$rollno = $_SESSION['RollNo'];

$sql="select * from LMS.user where RollNo='$rollno'";

$result=$conn->query($sql);

$row=$result->fetch_assoc();

$name=$row['Name'];

$category=$row['Category'];

$email=$row['EmailId'];

$mobno=$row['MobNo'];

$pswd=$row['Password'];

?>

<form class="form-horizontal row-fluid" action="edit_student_details.php?id=<?

php echo $rollno ?>" method="post">

<div class="control-group">

<label class="control-label" for="Name"><b>Name:</b></label>

<div class="controls">

<input type="text" id="Name" name="Name" value= "<?php echo

$name?>" class="span8" required>

</div>
 P a g e | 59

</div>

<div class="control-group">

<label class="control-label" for="Category"><b>Category:</b></label>

<div class="controls">

<select name = "Category" tabindex="1" value="SC" data-

placeholder="Select Category" class="span6">

<option value="<?php echo $category?>"><?php echo $category ?>

</option>

<option value="GEN">GEN</option>

<option value="OBC">OBC</option>

<option value="SC">SC</option>

<option value="ST">ST</option>

</select>

</div>

</div>

<div class="control-group">

<label class="control-label" for="EmailId"><b>Email Id:</b></label>

<div class="controls">

<input type="text" id="EmailId" name="EmailId" value= "<?php echo

$email?>" class="span8" required>

</div>

</div>

<div class="control-group">
 P a g e | 60

<label class="control-label" for="MobNo"><b>Mobile

Number:</b></label>

<div class="controls">

<input type="text" id="MobNo" name="MobNo" value= "<?php echo

$mobno?>" class="span8" required>

</div>

</div>

<div class="control-group">

<label class="control-label" for="Password"><b>New

Password:</b></label>

<div class="controls">

<input type="password" id="Password" name="Password" value= "<?

php echo $pswd?>" class="span8" required>

</div>

</div>

<div class="control-group">

<div class="controls">

<button type="submit" name="submit"class="btn-

primary"><center>Update Details</center></button>

</div>

</div>

</form>

</div>

</div>
 P a g e | 61

</div>

<!--/.span9-->

</div>

</div>

<!--/.container-->

</div>

<div class="footer">

<div class="container">

<b class="copyright">&copy; MMC Library Management System </b>All rights reserved.

</div>

</div>

<!--/.wrapper-->

<script src="scripts/jquery-1.9.1.min.js" type="text/javascript"></script>

<script src="scripts/jquery-ui-1.10.1.custom.min.js" type="text/javascript"></script>

<script src="bootstrap/js/bootstrap.min.js" type="text/javascript"></script>

<script src="scripts/flot/jquery.flot.js" type="text/javascript"></script>

<script src="scripts/flot/jquery.flot.resize.js" type="text/javascript"></script>

<script src="scripts/datatables/jquery.dataTables.js" type="text/javascript"></script>

<script src="scripts/common.js" type="text/javascript"></script>

<?php

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

$rollno = $_GET['id'];
 P a g e | 62

$name=$_POST['Name'];

$category=$_POST['Category'];

$email=$_POST['EmailId'];

$mobno=$_POST['MobNo'];

$pswd=$_POST['Password'];

$sql1="update LMS.user set Name='$name', Category='$category', EmailId='$email',

MobNo='$mobno', Password='$pswd' where RollNo='$rollno'";

if($conn->query($sql1) === TRUE){

echo "<script type='text/javascript'>alert('Success')</script>";

header( "Refresh:0.01; url=index.php", true, 303);

else

{//echo $conn->error;

echo "<script type='text/javascript'>alert('Error')</script>";

?>

</body>

</html>
 P a g e | 63

<?php

require('dbconn.php');

?>

<?php

if ($_SESSION['RollNo']) {

?>

<!DOCTYPE html>

<html lang="en">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<meta name="viewport" content="width=device-width, initial-scale=1.0">

<title>Library Management System</title>

<link type="text/css" href="bootstrap/css/bootstrap.min.css" rel="stylesheet">

<link type="text/css" href="bootstrap/css/bootstrap-responsive.min.css" rel="stylesheet">

<link type="text/css" href="css/theme.css" rel="stylesheet">

<link type="text/css" href="images/icons/css/font-awesome.css" rel="stylesheet">

<link type="text/css" href='http://fonts.googleapis.com/css?

family=Open+Sans:400italic,600italic,400,600'

rel='stylesheet'>

</head>

<body>

<div class="navbar navbar-fixed-top">

<div class="navbar-inner">
 P a g e | 64

<div class="container">

<a class="btn btn-navbar" data-toggle="collapse" data-target=".navbar-inverse-

collapse">

<i class="icon-reorder shaded"></i></a><a class="brand" href="index.php">Library

Management System </a>

<div class="nav-collapse collapse navbar-inverse-collapse">

<ul class="nav pull-right">

<li class="nav-user dropdown"><a href="#" class="dropdown-toggle" data-

toggle="dropdown">

<img src="images/user.png" class="nav-avatar" />

<b class="caret"></b></a>

<ul class="dropdown-menu">

<li><a href="index.php">Your Profile</a></li>

<!--li><a href="#">Edit Profile</a></li>

<li><a href="#">Account Settings</a></li-->

<li class="divider"></li>

<li><a href="logout.php">Logout</a></li>

</ul>

</li>

</ul>

</div>

<!-- /.nav-collapse -->

</div>

</div>

<!-- /navbar-inner -->

</div>

<!-- /navbar -->

 P a g e | 65

<div class="wrapper">

<div class="container">

<div class="row">

<div class="span3">

<div class="sidebar">

<ul class="widget widget-menu unstyled">

<li class="active"><a href="index.php"><i class="menu-icon

icon-home"></i>Home

</a></li>

<li><a href="message.php"><i class="menu-icon

icon-inbox"></i>Messages</a>

</li>

<li><a href="book.php"><i class="menu-icon icon-book"></i>All Books

</a></li>

<li><a href="history.php"><i class="menu-icon icon-tasks"></i>Previously

Borrowed Books </a></li>

<li><a href="recommendations.php"><i class="menu-icon

icon-list"></i>Recommend Books </a></li>

<li><a href="current.php"><i class="menu-icon icon-list"></i>Currently Issued

Books </a></li>

</ul>

<ul class="widget widget-menu unstyled">

<li><a href="logout.php"><i class="menu-icon icon-signout"></i>Logout

</a></li>

</ul>

</div>

<!--/.sidebar-->

</div>

<div class="span9">
 P a g e | 66

<table class="table" id = "tables">

<thead>

<tr>

<th>Message</th>

<th>Date</th>

<th>Time</th>

</tr>

</thead>

<tbody>

<?php

$rollno=$_SESSION['RollNo'];

$sql="select * from LMS.message where RollNo='$rollno' order by Date

DESC,Time DESC";

$result=$conn->query($sql);

while($row=$result->fetch_assoc())

$msg=$row['Msg'];

$date=$row['Date'];

$time=$row['Time'];

?>

<tr>

<td><?php echo $msg ?></td>

<td><?php echo $date ?></td>

<td><?php echo $time ?></td>

 P a g e | 67

</tr>

<?php } ?>

</tbody>

</table>

</div>

<!--/.span3-->

<!--/.span9-->

</div>

</div>

<!--/.container-->

</div>

<div class="footer">

<div class="container">

<b class="copyright">&copy; MMC Library Management System </b>All rights reserved.

</div>

</div>

<!--/.wrapper-->

<script src="scripts/jquery-1.9.1.min.js" type="text/javascript"></script>

<script src="scripts/jquery-ui-1.10.1.custom.min.js" type="text/javascript"></script>

<script src="bootstrap/js/bootstrap.min.js" type="text/javascript"></script>

<script src="scripts/flot/jquery.flot.js" type="text/javascript"></script>

<script src="scripts/flot/jquery.flot.resize.js" type="text/javascript"></script>

<script src="scripts/datatables/jquery.dataTables.js" type="text/javascript"></script>

<script src="scripts/common.js" type="text/javascript"></script>

 P a g e | 68

</body>

</html>

<?php }

else {

echo "<script type='text/javascript'>alert('Access Denied!!!')</script>";

} ?>

<?php

session_start();

session_destroy();

header("location:../index.php");

exit;

?>

<?php

require('dbconn.php');

?>

<!DOCTYPE html>

<html lang="en">

<head>
 P a g e | 69

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<meta name="viewport" content="width=device-width, initial-scale=1.0">

<title>Library Management System</title>

<link type="text/css" href="bootstrap/css/bootstrap.min.css" rel="stylesheet">

<link type="text/css" href="bootstrap/css/bootstrap-responsive.min.css" rel="stylesheet">

<link type="text/css" href="css/theme.css" rel="stylesheet">

<link type="text/css" href="images/icons/css/font-awesome.css" rel="stylesheet">

<link type="text/css" href='http://fonts.googleapis.com/css?

family=Open+Sans:400italic,600italic,400,600'

rel='stylesheet'>

</head>

<body>

<div class="navbar navbar-fixed-top">

<div class="navbar-inner">

<div class="container">

<a class="btn btn-navbar" data-toggle="collapse" data-target=".navbar-inverse-

collapse">

<i class="icon-reorder shaded"></i></a><a class="brand" href="index.php">Library

Management System </a>

<div class="nav-collapse collapse navbar-inverse-collapse">

<ul class="nav pull-right">

<li class="nav-user dropdown"><a href="#" class="dropdown-toggle" data-

toggle="dropdown">

<img src="images/user.png" class="nav-avatar" />

<b class="caret"></b></a>

<ul class="dropdown-menu">

<li><a href="index.php">Your Profile</a></li>

<!--li><a href="#">Edit Profile</a></li>

 P a g e | 70

<li><a href="#">Account Settings</a></li-->

<li class="divider"></li>

<li><a href="logout.php">Logout</a></li>

</ul>

</li>

</ul>

</div>

<!-- /.nav-collapse -->

</div>

</div>

<!-- /navbar-inner -->

</div>

<!-- /navbar -->

<div class="wrapper">

<div class="container">

<div class="row">

<div class="span3">

<div class="sidebar">

<ul class="widget widget-menu unstyled">

<li class="active"><a href="index.php"><i class="menu-icon

icon-home"></i>Home

</a></li>

<li><a href="message.php"><i class="menu-icon

icon-inbox"></i>Messages</a>

</li>

<li><a href="book.php"><i class="menu-icon icon-book"></i>All Books

</a></li>
 P a g e | 71

<li><a href="history.php"><i class="menu-icon icon-tasks"></i>Previously

Borrowed Books </a></li>

<li><a href="recommendations.php"><i class="menu-icon

icon-list"></i>Recommend Books </a></li>

<li><a href="current.php"><i class="menu-icon icon-list"></i>Currently Issued

Books </a></li>

</ul>

<ul class="widget widget-menu unstyled">

<li><a href="logout.php"><i class="menu-icon icon-signout"></i>Logout

</a></li>

</ul>

</div>

<!--/.sidebar-->

</div>

<!--/.span3-->

<div class="span9">

<center>

<div class="card" style="width: 50%;">

<img class="card-img-top" src="images/profile2.png" alt="Card image

cap">

<div class="card-body">

<?php

$rollno = $_SESSION['RollNo'];

$sql="select * from LMS.user where RollNo='$rollno'";

$result=$conn->query($sql);

$row=$result->fetch_assoc();
 P a g e | 72

$name=$row['Name'];

$category=$row['Category'];

$email=$row['EmailId'];

$mobno=$row['MobNo'];

?>

<i>

<h1 class="card-title"><center><?php echo $name

?></center></h1>

<br>

<p><b>Email ID: </b><?php echo $email ?></p>

<br>

<p><b>Roll No: </B><?php echo $rollno ?></p>

<br>

<p><b>Category: </b><?php echo $category ?></p>

<br>

<p><b>Mobile number: </b><?php echo $mobno ?></p>

</b>

</i>

</div>

</div>

<br>

<a href="edit_student_details.php" class="btn btn-primary">Edit Details</a>

</center>

</div>
 P a g e | 73

<!--/.span9-->

</div>

</div>

<!--/.container-->

</div>

<div class="footer">

<div class="container">

<b class="copyright">&copy; 2018 Library Management System </b>All rights reserved.

</div>

</div>

<!--/.wrapper-->

<script src="scripts/jquery-1.9.1.min.js" type="text/javascript"></script>

<script src="scripts/jquery-ui-1.10.1.custom.min.js" type="text/javascript"></script>

<script src="bootstrap/js/bootstrap.min.js" type="text/javascript"></script>

<script src="scripts/flot/jquery.flot.js" type="text/javascript"></script>

<script src="scripts/flot/jquery.flot.resize.js" type="text/javascript"></script>

<script src="scripts/datatables/jquery.dataTables.js" type="text/javascript"></script>

<script src="scripts/common.js" type="text/javascript"></script>

</body>

</html>
 P a g e | 74

CONCLUSION

This website provides a computerized version of library management system which will benefit the
students as well as the staff of the library. It makes entire process online where student can search
books, staff can generate reports and do book transactions. It also has a facility for student login
where student can login and can see status of books issued as well request for book or give some
suggestions.
 P a g e | 75

It has a facility of teacher’s login where teachers can add lectures notes and also give necessary
suggestion to library and also add info about workshops or events happening in our college or nearby
college in the online notice board.

There is a future scope of this facility that many more features such as online lectures video tutorials
can be added by teachers as well as online assignments submission facility , a feature Of group chat
where students can discuss various issues of engineering can be added to this project thus making it
more interactive more user friendly and project which fulfills each users need in the best WAYS
possible.

REFERENCES

http://www.w3schools.com/html/html_intro.asp

http://www.udemy.com/css/css_background.asp

http://www.w3schools.com/js/js_datatypes.asp

http://www.researchgate.com/js/js_datatypes.asp

YASHWANT KANETKAR PHP AND HTML BOOK.

P a g e | 76
P a g e | 77