New LMS

ABSTRACT
A library management system for ZPPSU with barcode scanner is a project which
aims to develop an automated system to maintain all the daily work of library. This project
has many features which some of the features are not available in other library. The proposed
system has a login logout for the admins account, the system is capable of adding new books,
members and edit the student and books information. And it has also the borrow tab where
we can borrow book by scanning the barcode and it can automatically record in the list of
borrower. It also has a returned tab where we can view the list of all members that returned
the book. Admin account can generate various report such as student report, issue report and
book report. It improves the monthly or yearly inventory of the library and it can avoid lost
and damaged book in the library. After the proponents completely developed the project, the
proponents make the testing phase in the library of ZPPSU as we observe of all the survey
test, mostly all their answers are number 5 which is strongly agree then it is also good to hear
because the comment of the client is, (very good keep up the good work) all of them the
comment is very good. The project is friendly user you can use even no internet connection
because the system is offline, we make this ofline because the problem of the library of their
existing system is online when it comes a low of internet connection the system is always
loading so the proponents make a solution of their problem. By the help of the system the
admin will easily manage the library and also the book and the member information.
CHAPTER I
INTRODUCTION`
Nowadays, through the development of present day technology, there are loads of
speedy and dependable options for research. However, a library nonetheless can pay a critical
position on the scholars and researcher’s life. A Library remains taken into consideration
because the maximum correct vicinity for records. Undeniably, human beings, particularly
people who aren't having net connections, or even electricity, depend completely on books.
Furthermore, libraries additionally deliver records now no longer observed on the World
Wide Web. The library nonetheless stays because of the most inexpensive and the maximum
reachable vicinity for research. Gathering of records thru books in a library nonetheless
performs a completely critical position with regards to collecting of records and research.
The proponents have observed the following problems that exist in the library of
Zamboanga Peninsula Polytechnic State University, when borrowing and returning books, the
in charge manually takes down information like name and date year which uses a pen and
paper and often takes time to finish. So the existing system of the ZPPSU is an online so that
is the main problem of the library because when it comes a low internet connection the
existing system is always loading, the proponents find a way to make a solution, the solution
is the proponents make an offline system which is the Zamboanga Peninsula Polytechnic
State University with Barcode Scanner. They do have system for their library but they need
to pay or renew it every year it so expensive.
The proponents aim to develop a Library Management System for Zamboanga
Peninsula Polytechnic State University with Barcode Scanner to eliminate the problem of the
LIBRARY MANAGEMENT SYSTEM FOR ZAMBOANGA PENINSULA POLYTECHNIC STATE UNIVERSITY WITH BARCODE SCANNER 1
library of ZPPSU and to easily monitor the borrower like who borrowed this book and who
have returned and have not return yet. This system would really help the Library of
Zamboanga Peninsula Polytechnic State University to easily monitor and allocated the
penalty of every borrower who did not return the book to its assigned date of returning. In
this system the proponents aim to provide accurate and reliable reports of the Books and of
the Borrowers.
Project Context
Zamboanga Peninsula Polytechnic State University (ZPPSU) is currently using
manual process in their library, like the borrower get a slip from staff of the library and copy
the details of the book (Author, Tittle and book location. After that the staff will present the
slip of paper to the librarian in charge. If the book is available it presents a validated LCCIC
for proper charging, and also the borrower will fill out the book card and present the book
card with the book borrowed to the librarian. Then the librarian will write down the due date
into the slip of paper. LCCIC and book card are clip/filled together until the book is returned.
It consumes more time and hustle using manual services of the current system that the
library staff use and also the admin. It takes more time when they use a slip of paper for
borrowing a book sometimes the slip will misplace
In this research, the proponents aim to design and develop a Library system with
Barcode Scanner for Zamboanga Peninsula Polytechnic State University, a Library that could
easily monitor who borrowed the book, to provide accurate and reliable report of the library.
The Library Management System for Zamboanga Peninsula Polytechnic State University can
easily access who borrowed the book and do the inventory faster than present manual
process.
Thus, this capstone project focused on how to design and develop a Library System for
Zamboanga Peninsula Polytechnic State University to easily monitor the who borrowed the book,
who returned the book and who did not.
Purpose and Description
The main purpose of this capstone project is to develop a Library Management
System for Zamboanga Peninsula Polytechnic State University. This system would help the
Library of the Zamboanga Peninsula Polytechnic State University to easily track and monitor
the information of the borrowers and of the books.
The Features of the system are the following:
 Log - in and Log - out Services. This refers to one of the features of the developed
system that required users to enter their Username and Password to be able to use the
system in Library of Zamboanga Peninsula Polytechnic State University and allows
the admin to access the overall functionalities of the system.
 List of Borrowers. This feature of the system is a guide for library to know what are
the book they have been borrowed and to know if the they are already registered in to
the system.
 Add Book. This is the where will the user add a new book.
 Add Borrower. This is where the user will add a new borrower member.
 Borrow. This is the features where will the user input the details if there’s someone
want to borrow.
 List of Books. This feature will show what are the available books and their quantity
 Transactions. This feature will show reports of the library.
This propose project will be a great for the school library, it can lessen your time work, easily
to track the data of the library and friendly user.
OBJECTIVES
This study aims to develop a Library Management system for Zamboanga Peninsula
Polytechnic State University with Barcode.
SPECIFIC OBJECTIVES
 To develop a system that has an admin account for monitoring the library.
 To manage the transactions of record in the library.
 To build a system that has a barcode capability.
 Generate a function
Scope and Limitation
Scope
The system capable of adding new books, searching books, adding students,
removing borrowers, viewing student’s information, edit borrower’s information, edit
books details, scan an assigned barcode of each book, edit the quantity of penalty fees
and due date of borrowing. Capable to print the reports of the transaction.
Limitation
 The system is not capable of accepting student concerns.
 The system does not require internet connection.
 The student is not capable to manage the system.
 The system is not capable of online payment transaction.
 The staff was not capable of deleting the book.
CHAPTER II
REVIEW OF RELATED LITERATURE AND STUDIES
This chapter includes related literature and studies with regards to Library Management
System. Below are following Foreign and Local Related Literature and Studies.
2.1 Foreign Local Related Literature
According to E.Valenti(2016) from the article entitled “The State of Library
Management Systems” are systems that help big in terms of some transactions on the library.
On this article the automated library systems said that it can do multitasking. It can do
recording books on library but it can also make different transactions. It will make the library
service convenient like making card cataloging. Therefore, multitasking inside the library
very nice. The system will be the one who records all the transaction inside the library so it
decreases the task of the librarian so it can avoid the cases of the lost records due to human
errors.
Foreign Local Related Study
According to A.Agarwal (2013) on the research entitled Online Library Management
System. The main problem of the different libraries worldwide are they are still using manual
method. So the researcher proposed to make an automated system that will have better log in
form and to record quickly the borrowed and still existing books. So the librarian or the staffs
can monitor every time the books that carried outside by the students, therefore online library
management system can be use outdoor or even without the school library. You can access or
borrow books using the internet. It will be very convenient and less time consuming.
2.2 Foreign and local Related System
Library Management System Project Report
The Library Management System (LMS) is a program that helps librarians manage a library.
Based on the needs of users, the system could provide a minimal set of functionality, such as
adding and updating members and books. This system can also handle check-in
specifications, borrower’s transactions and more. A library management system can
automatically cater all of library information and transactions. It aims to organize all of the
activities involved in library management software. This can also provide information about
the books in the library, their authors, library members, book borrowers, and library
personnel.
Figure 2.2.1 Library Management System
Library Management System Mini Project Report On LIBRARY MANAGEMENT
SYSTEM
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 record various transactions like issue of books, return
of books, addition of new books, addition of new students etc. 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.
Figure 2.2.2 Soe Library Management System Home Page
Library Management System
With the advancement of technology, it is imperative to exalt all the systems into a user-
friendly manner. The Library Management system (LMS) acts as a tool to transform
traditional libraries into digital libraries. In traditional libraries, the students/user have to
search for books which are hassle process and there is no proper maintenance of database
about issues/fines. The overall progress of work is slow and it is impossible to generate a fast
report. The librarians have to work allotted for arranging, sorting books in the book sells. At
the same time, they have to check and monitor the lend/borrow book details with its fine. It is
a tedious process to work simultaneously in different sectors. LMS will assist the librarians to
work easily. The LMS supports the librarians to encounter all the issues concurrently.
Figure 2.2.3 Library Management System Adding new book.
LIBRARY MANAGEMENT SYSTEM WITH TOPIC MODELLING AND ITS
ADAPTABILITY TO OPEN AND DISTANCE LEARNING LIBRARIES
The 1980s and 1990s saw an increase in the deployment of Integrated Library
Systems (ILS). As libraries started automating their operations or continued to do so. Because
of these systems, libraries staff work, in many cases, more efficiently than in the past.
Although these systems are constrictive, they have changed throughout time because of this.
efficiency-enhancing procedures. The ability to "search" is one of the areas with expanded
capabilities. which expands on the use of topic modeling as a novel element in
contemporary library systems that are integrated in institutions of distance and open learning.
Users can now take part. And look for fresh approaches to solve text classification and data
exploration issues. Routine management of a library.
2.4 Table of Comparison
System Features Library Library

Library Library Library
Management Management
Management Management Management
System Mini System for
System System System with
Project Zamboanga
Project Topic
Report Peninsula
Report Modeling and
Polytechnic
Its
State
Adaptability
University
try to Open
and distance
Learning
Libraries
Add Borrower, Add Yes Yes Yes Yes Yes
member, delete, edit
borrower
Book/Add book/edit Yes Yes Yes Yes Yes
book/delete
book/Lost
Book/Damage
book/print
booklist/print books
barcode
Admin/Add staff/edit Yes Yes Yes Yes Yes
staff
Borrow/Options Yes Yes Yes Yes Yes
(Book quantity,
Penalty, Days of
Borrowing)
INVENTORY Yes Yes Yes Yes Yes
(Borrowed book,
Returned book)
TRANSACTIONS Yes Yes Yes Yes Yes
REPORTS
(List of Borrower, List
of Return)
Print Report No No No No Yes
Barcode Scanner No No No No Yes
2.3 Synthesis
A library management system with Barcode Scanner is a system which is used to
track books. The above mentioned concept on computerization of library system with
Barcode is relevant to the present project because these served as foundation of library
management system for the school that will easily and faster also secured.
CHAPTER III
3.1 Discussion Software Development Life Cycle and each Phases
Agile methodology model will the proponent going to use for developing this project.
Agile is an iterative approach to project management and software development that helps
faster work of the admin and with fewer headaches. Instead of manual System or online
system, because when it comes a losing of internet connection the system will be useless, it
doesn’t function when you lost an internet connection while the offline you can still manage.
The first phase is Planning phase, in this phase the proponent conducts an interview to
his client and research to gather for an idea in order to develop this propose project, by the
using this first phase of this Agile model the data is very important key to develop this kind
of project and it can help the proponent to making them propose project done fast. The
second is Design phase, proponent simply designed the interface of the propose project and it
is not colorful. The interface of the Zamboanga Peninsula Polytechnic State University
Library Management System with Barcode Scanner is a user friendly and it is easy to use.
This could be proving when the user could know what is button function is when the user
looks at the button. Because the button text is very and easy understand, example when want
to delete a data the proponent use ‘Delete’ as button text not a very deep text word.
Development phase the propose library system solution developing a manual library system
in wampp. And to develop a reliable system for the Zamboanga Peninsula Polytechnic State
University to provide objective / automatic tools enabling optimization of the resources and
to create a system that contribute for the harmonization of the current library system. Testing
phase, once this propose project will approve that’s the time we will conduct this phase while
developing system of this project proposal. This project will release if the proponent manages
to achieve the recommendations of the client. After developing the project, the client will test
the project system for them to give a feedback to the proponents.
3.2 Details of technology to be used
The following are the Hardware and Software to be used:
Hardware
 Any desktop or laptop with an operating system that can runs an internet browser.
 Barcode Scanner
Software
 Operating System Windows 10 / 8 / 7
 Sublime Text
 Wammp
People ware
 Project Manager
 System Analysis
 Programmer
 System assurance
3.3 How the project will work
A Library Management System for Zamboanga Peninsula Polytechnic State
University a project that manages and stores books information. The system proposes to
help students and librarians in maintaining a continual track of all books available in the
library. It only allows the administrator to conduct research for the desired book easily. The
library of Zamboanga Peninsula Polytechnic State University must keep a continual check on
all books provided and returned, as well as keep track of fines. If the librarian or library
manager does this operation manually, there is a possibility the librarian or library
management will make a mistake by checking the books information. These errors are
prevented by allowing the system to maintain track of information such as the date of issue,
and the last due date of the books. so there is no need to keep manual track of the
information, reducing the possibilities of returning and borrowing books incorrectly. Every
books would generate a barcode for the staff of library easily process the borrowing portion
all they have to the is to scan the barcode of the book and it would automatically input the
information of the book without typing the keyboard.
CHAPTER IV
METHODOLOGY
In this chapter, presents the methodology that is used for collecting data and how data
is analyzed. We use the population and sampling of the study to choose selected individuals
to perform and performed an interview, we collected the data by asking some questions of the
chosen individuals to come up of a solution to their problem and analyzed the data by
gathering useful information such as what is the main problem of their school library and
how it is processed.
Figure 4.1 Agile Methodology
The proponents used this kind of methodology which is the Agile model because it is
more convenient or accessible and only basic documentation to understand just enough to get
started on the work is encouraged. Changes to documentation are much easier.
4.1 Requirement Analysis
Library Management System is an automated system which helps librarian to control
the daily library activities in digital format. It lessens the paper work like losing file, file
damaged and time consuming. It can assist person to control the transaction or record greater
efficiently and time-saving. The functional and nonfunctional requirements are included in
LMS to offer whole description and outline of system requirement before the developing
process is carried out.
4.2 Requirements Documentation
The first day of the system propose the proponent get the permission of the client to
talk about the library management system if it is approving of what the proponents did in
propose system. The proponents provide a system that can manage to their library well and to
all the information of books and students. The propose system make their library lesser paper
work and time managing. And then, the system will manage to Zamboanga peninsula
polytechnic state university library management system with barcode scanner.
FUNCTIONAL REQUIREMENTS
Administrator:
1.1 Books tab, where the admin can view the list of book and add new books
1.2 Borrow tab, where the admin can scan the books when its borrow
1.3 View the list of books
1.4 View the list of barcode
1.5 Printing the names of borrowers
1.6 Printing the borrowers’ penalty record
1.7 Generate barcode
1.8 Print list of barcode
1.9 Print list of books
1.10 Print the transaction report
1.11 Add member
1.12 Edit books
1.13 Edit the days of borrow
1.14 Edit the penalty
1.15 Delete member
1.16 Edit member information
1.17 Viewing the list of new books
1.18 Viewing the list of lost books
1.19 Viewing the list of damaged books
1.20 Delete book
NONFUNCTIONAL REQUIREMENTS
 Operational
1.1 The Zamboanga peninsula polytechnic state university library
management system with barcode scanner operates on PC’s, laptop and also
we use barcode scanner for scanning the books.
1.2 The admin is not required an internet connection
 Security
2.1 only the admin can view the information of borrower
2.2 only the admin can edit the borrower information.
 Efficiency
3.1 The Staff or the librarian of the library would easily access the library, thus
searching and book transaction would be very fast.
 Usability Requirement
4.1 The system is designed for a user friendly environment so that the admin
and staff of library could perform the various tasks easily and in an effective
way.
4.3.1 Design of software, System, Product, and/or Processes
The proponents of the system aim for the design to be better understood by providing an
instance of what the system should be like. Use Case Analysis, Data Flow Diagram, Entity-
Relationship Diagram, and Architecture Design are all components of software or system design.
4.3.2 Use case Analysis
Use case diagram the admin has a dashboard where he/she will manage the whole system
such as add new books, edit books, edit borrower information edit the penalty days, add new staff.
While the staff he/she cannot edit the books, add books, penalty days or adding a staff.
Context Diagram Level 0
Figure 4.3.3 Context Diagram
In Figure 4.3.2 shows the context diagram flow that the Admin (user) should add a member so that if
the admin searches the name or id number of the borrower the admin would know if the borrower was
registered into the system or not and also of the books to know it’s status or available.
DATA FLOW DIAGRAM LEVEL 1
Figure 4.3.4 Data Flow Diagram
In figure 4.3.3 shows the process and the data flow of the system, every information of the
books and of the borrowers that the admin or the staff input into the system it automatically
saves into the designated database table of the system.
Entity-relationship Diagram
Figure 4.3.8 Entity Relationship Diagram
In this figure shows the relationship each of entity and all the attributes that has of each
entity.
Architectural Design
Librarian
Figure 4.3.9 Architectural Design
In Figure shows the cycle process of the propose project.
4.4 Development and Testing Plan
4.4.1Development
In development the proponent used the HTML, CSS, JavaScript and PHP 5 for the front end and for the back end was wampp, the
proponent ensure that the function of this system is hundred percent functioning and could easily track if there’s an error into the system.
To ensure that the user could input the information of the member and of the book without any difficulty issue.
4.4.2 Testing Plan
The System will be tested once the propose project had been developed. It would be tested by five members staff of the library.
The team leader will assign of each staff to test the system.
Project Work Plan
Septembe October Novembe Decembe January

Task Duration Start Finish
r r r
Task Name
ID (Days) Date Date
4
1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3
Requirements Gathering 10 09/01/22 09/14/22
I Chapter 1: Introduction 5 09/14/22 09/20/22
1.1 Project Context 4 09/20/22 09/23/22
1.2 Purpose & Description 4 09/20/22 09/23/22
1.3 Objectives 3 09/26/22 09/28/22
1.4 Scope and Limitation 5 09/26/22 09/3022
1.5 Definition of Terms 2 09/26/22 09/27/22
Chapter 2: Review Related Literature

II 10 10/03/22 10/14/22
and Systems
Foreign and Local Related

2.1 4 10/03/22 10/06/22
Literature/Studies
2.2 Foreign And Local Related Systems 4 10/07/22 10/12/22
2.3 Table of Comparison 1 10/13/22 10/13/22
2.4 Synthesis 1 10/14/22 10/14/22
III Chapter 3: Technical Background 10 10/17/22 10/28/22
3.1 The Technicality of The Project 4 10/17/22 10/20/22
3.2 Details of Technologies to Be Used 4 10/21/22 10/26/22
3.3 How the Project Will Work 3 10/26/22 10/28/22
IV Chapter 4: Methodology 43 11/01/22 12/29/22
4.1 Requirements Analysis 5 11/01/22 11/07/22
4.2 Requirements Documentation 5 11/08/22 11/14/22
Design of Software, Systems, Product,

4.3 11 11/15/22 11/29/22
and/or Process
Use Case Analysis
Data Flow Diagram
Entity-Relationship Diagram
Architectural Design
4.4 Development and Testing Plan 11 11/30/22 12/14/22
Project Work Plan
Project Teamwork
4.5 Description Prototype 4 12/15/22 12/21/22
4.6 Implementation Plan 4 12/21/22 12 /26/22
4.7 Implementation Result 3 12/27/22 12/29/22
Chapter 5: Conclusion and

V 1 12/01/22 01/16/23
Recommendation
Project Team Work Assignment and Responsibilities
Phases Team Tasks
Plan Christian Sanoh The one who gather an information
for in able to implement this project
All Member
Design Christian Sanoh Is the one who conduct an
interview to the client asking what
might be the design that client
desire
All Member Assisting the team leader to the
design the project proposal
Development Programmer
All Member Assisting the developer of the
project and providing the
information that they have gathered
Testing Christian Sanoh Once the project proposal will be
developed as a system it is my
responsible to check if the
documentation sink to the system.
All Member List down what and where would
going to revise or to arrange of the
designated problems
Deployment All Member All member would help each other
once the propose project will
deploy
All Member Other members will teach the client
how the system work.
Release All Member Once the propose project release it
would deploy immediately by the
proponents
All member Listing what are the possible
feedback of the client
Unit test
The system had completed to a unit test, and it work and run successfully.
System test
The tabulated table show the total rating of capabilities and features of the system of the 5
respondent that undergo of testing phase of our project.
System’s Capabilities and Features Mean Descriptive Ratings
A. Functional Suitability
1. Functional Completeness. The system covers all the specified tasks 4.60 Strongly agree
and user objectives.
2. Functional Correctness. The system provides the correct results with 4.80 Strongly agree
the needed degree of precision.
3. Functional Appropriateness. The system facilitates the 5.00 Very strongly agree
accomplishment of specified tasks and objectives.
B. Performance Efficiency
4. Time Behavior. The system’s response and processing times and 5.00 Very strongly agree
throughput rates when performing its functions meet requirements.
5. Resource Utilization. The system’s amounts and types of resources 4.60 Strongly agree
used when performing its functions, meet requirements.
6. Capacity. The system’s maximum limits of parameters meet 4.80 Strongly agree
requirements.
C. Compatibility
7. Co-existence. The system can perform its required functions 4.40 Strongly agree
efficiently while sharing a common environment and resources with
other products, without detrimental impact on any other product.
8. Interoperability. The system can exchange information and use the 4.60 Strongly agree
information that has been exchanged.
D. Usability
9. Appropriateness Recognizability. The system allows users to 4.80 Strongly agree
recognize if it is appropriate for their needs.
10. Learnability. The system can be used by specified users to achieve 4.80 Strongly agree
specified goals of learning to use the application with effectiveness,
efficiency, freedom from risk and satisfaction in a specified context of
use.
11. Operability. The system has attributes that make it easy to operate and 5.00 Very strongly agree
control.
12. User Error Protection. The system protects users against making 5.00 Very strongly agree
errors.
13. User Interaction Aesthetics. The system’s user interface enables 5.00 Very strongly agree
pleasing and satisfying interaction for the user.
14. Accessibility. The system can be used by people with the widest range 4.80 Strongly agree
of characteristics and capabilities to achieve a specified goal in a
specified context of use.
E. Reliability
15. Maturity. The system meets the needs for reliability under normal 4.60 Strongly agree
operation
16. Availability. The system is operational and accessible when required 5.00 Very strongly agree
for use.
17. Fault Tolerance. The system operates as intended despite the 5.00 Very strongly agree
presence of hardware or software faults.
18. Recoverability. The system can recover the data directly affected and 5.00 Very strongly agree
re-establish the desired state.
F. Security
19. Confidentiality. The system ensures that data are accessible only to
those authorized to have access.
20. Integrity. The system prevents unauthorized access to, or modification 5.00 Very strongly agree
of, computer programs or data.
21. Non-repudiation. The system can be proven to have taken place, so 5.00 Very strongly agree
that the events or actions cannot be repudiated later.
G. Portability
22. Adaptability. The system can effectively and efficiently be adapted 4.80 Strongly agree
for different or evolving hardware, software or other operational or
usage environments
23. Install ability. The system can be successfully installed and/or 5.00 Very strongly agree
uninstalled in a specified environment
4.5 Description of the prototype
While designing something from scratch, it is inevitable that problems will arise. For
this reason, the designer needs to change the product and iterate the process of designing. In
such cases, the most sensible approach is to start by making a prototype first. It is optimized
for ease and speed of development and also possible to change and modify it. It enables the
designer to present a demonstrable product before planning to move to production. It also
eliminates the iron out issues of scaling up and polish during the process of manufacture.
In this interface where you can view the dashboard.
In this module shows the list of member’s information who registered in to the system.
In this module, shows the list of books where you can scan for borrow.
In this module shows where you can select the name of borrower.
In this module shows where you can select the ID number of borrower, and edit the number of days
of the books when its borrowed
In
this
module shows the date of returned an the at
4.6 Implementation Plan
In the system propose all the member should have their own task to do the system
implementation. To become a library with a Barcode Scanner system. Development of the
strategic plan has been collaborative effort intended to ensure that all members of this
research group are doing their best. All the members should understand their roles and
responsibilities for ensuring the system will be success. In this phase, a group member pay
attention to details and monitor processes to implement quick changes as required.
CHAPTER V
Conclusion
The designed Zamboanga Peninsula System is analyzed successfully, the system has been
tested and proved to be friendly user and to be very helpful for a library’s admin, it lessens
paper works and it is easy to use because of no internet connection uses, compare to the
existing system of the ZPPSU its difficult to use because of loss of internet connection, the
system is always loading. Library Management System for Zamboanga Peninsula
Polytechnic State University with Barcode Scanner is an offline library system that has a
simple but catchy design. The developers designed and developed+ the system to help the
admin manage the library easier and to have a successful processing of the library, that can
help them speed up their library works and at the same time can save their time and effort.
And also avoid of the loses of books and the book damaged. And it is a good decision for the
developers to come up with Zamboanga Peninsula Polytechnic State University Library
System with Barcode Scanner.
RECOMMENDATION
The Library Management system for Zamboanga Peninsula Polytechnic State University
could enhance for the future researcher of the Zamboanga Peninsula Polytechnic State
University. It could add another UI for the computer lab of the library for the user to monitor
or to track the time usage of the computer of each student.
Bibliography
Alikira, R. (2012, November 22). Electronic Library Management System (ELMS). GRIN.
Retrieved July 8, 2022, from https://www.grin.com/document/205391?
fbclid=IwAR11fYxgl26mcnXj0kWtuTDaKiFvGoCeoGGjuF4umBj5WubmSLFuaXR
OKGc
Schamber, L. (1990, October 31). Automation for the School Library Media Center. Eric
Digest. ERIC. Retrieved July 8, 2022, from https://eric.ed.gov/?id=ED327217
Schamber, L. (1990, October 31). Automation for the School Library Media Center. Eric
Digest. ERIC. Retrieved July 8, 2022, from https://eric.ed.gov/?id=ED327217
Babafemi, R. A. (2019). The use and effect of smartphones in students’ learning activities ...
LIBRARY MANAGEMENT SYSTEM WITH TOPIC MODELLING AND ITS
ADAPTABILITY TO OPEN AND DISTANCE LEARNING LIBRARIES. Retrieved
January 13, 2023, from https://digitalcommons.unl.edu/cgi/viewcontent.cgi?
article=6260&context=libphilprac
APPENDICES A
Evidence of Conducting an Interview
On this picture show the evidenced of the proponent that they conduct an interview for them
to acquire the requirements to develop this project.
Appendices B
Process data
Appendices C
Relevant Source code
add_user.php
<?php include ('header.php'); ?>
<div class="page-title">
<div class="title_left">
<h3>
<small>Home / Admin Profile /</small> Add Admin
</h3>
</div>
</div>
<div class="clearfix"></div>
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<div class="x_title">
<h2><i class="fa fa-plus"></i> Add Admin</h2>
<ul class="nav navbar-right panel_toolbox">
<li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a></li>

<li><a class="close-link"><i class="fa fa-close"></i></a></li>
</ul>
</div>
<div class="x_content">

<form method="post" enctype="multipart/form-data" class="form-horizontal form-
label-left">
<div class="form-group">
<label class="control-label col-md-4" for="first-name">First Name <span
class="required" style="color:red;">*</span>
</label>
<div class="col-md-3">
<input type="text" name="firstname" id="first-name2" required="required"
class="form-control col-md-7 col-xs-12">
</div>
</div>
<label class="control-label col-md-4" for="first-name">Middle Name
</label>
<input type="text" name="middlename" placeholder="MI / Middle Name....."
id="first-name2" class="form-control col-md-7 col-xs-12">
</div>
</div>
<label class="control-label col-md-4" for="last-name">Last Name <span
</label>
<input type="text" name="lastname" id="last-name2" required="required"
</div>
</div>
<label class="control-label col-md-4" for="last-name">User Name <span
</label>
<input type="text" name="username" id="last-name2" required="required"
</div>
</div>
<label class="control-label col-md-4" for="last-name">Password <span
</label>
<input type="password" name="password" id="last-name2"
required="required" class="form-control col-md-7 col-xs-12">
</div>
</div>
<label class="control-label col-md-4" for="last-name">Confirm Password <span
</label>
<input type="password" name="confirm_password" id="last-name2"
required="required" class="form-control col-md-7 col-xs-12">
</div>
</div>

<label class="control-label col-md-4" for="last-name">Admin Image
</label>
<input type="file" style="height:44px;" name="image" id="last-name2"
</div>
</div>
<div class="ln_solid"></div>
<div class="col-md-9 col-sm-9 col-xs-12 col-md-offset-3">
<a href="admin.php"><button type="button" class="btn btn-primary"><i
class="fa fa-times-circle-o"></i> Cancel</button></a>
<button type="submit" name="submit" class="btn btn-success"><i class="fa
fa-plus-square"></i> Submit</button>
</div>
</div>
</form>
<?php
include ('include/dbcon.php');
if (!isset($_FILES['image']['tmp_name'])) {
echo "";
}else{
$file=$_FILES['image']['tmp_name'];
$image = $_FILES["image"] ["name"];
$image_name= addslashes($_FILES['image']
['name']);
$size = $_FILES["image"] ["size"];
$error = $_FILES["image"] ["error"];
if($size > 10000000)
//conditions for the file
die("Format is not
allowed or file size is too big!");
else
move_uploaded_file($_FILES["image"]["tmp_name"],"upload/" . $_FILES["image"]["name"]);
$profile=$_FILES["image"]
["name"];
$firstname =
$_POST['firstname'];
$middlename =
$_POST['middlename'];
$lastname =
$_POST['lastname'];
$username =
$_POST['username'];
$password =
$_POST['password'];
$confirm_password =
$_POST['confirm_password'];
// $admin_type =
$_POST['admin_type'];
$result=mysqli_query($con,"select * from admin WHERE
username='$username' ") or die (mysqli_error());
$row=mysqli_num_rows($result);
if ($row > 0)
echo "<script>alert('Username already taken!');
window.location='add_admin.php'</script>";
elseif($password != $confirm_password)
{
echo "<script>alert('Password do not match!');
window.location='add_admin.php'</script>";
}else
mysqli_query($con,"insert into admin (firstname,
middlename, lastname, username, password, confirm_password, admin_image, admin_type,
admin_added)
values ('$firstname', '$middlename', '$lastname',
'$username', '$password', '$confirm_password', '$profile', 'Admin', NOW())")or die(mysqli_error());
echo "<script>alert('Account successfully added!');
window.location='admin.php'</script>";
?>

</div>
</div>
</div>
</div>
<?php include ('footer.php'); ?>
Admin.php
<h3>
<small>Home /</small> Admin Profile
</h3>
</div>
</div>
<div class="row">
<h2><i class="fa fa-info"></i> Admin Information</h2>
<?php
$user_query = mysqli_query($con,"select * from admin where admin_id = '$id_session'")or
die(mysqli_error());
$user_row =mysqli_fetch_array($user_query);
$admin_type = $user_row['admin_type'];
?>
<?php if ($admin_type == 'Admin') {
?>
<li>
<a href="add_admin.php"
style="background:none;">
<button class="btn btn-primary"><i
class="fa fa-plus"></i> Add Admin</button>
</a>
</li>
<?php } ?>

</ul>
</div>
<div class="table-responsive">
<table cellpadding="0" cellspacing="0"
border="0" class="table table-striped table-bordered" id="example">
<thead>
<tr>
<th>Image</th>
<th>Full Name</th>

<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$result= mysqli_query($con,"select * from
admin order by admin_id ASC") or die (mysqli_error());
while ($row= mysqli_fetch_array ($result) ){
$id=$row['admin_id'];
?>
<tr>
<td>
<?php
if($row['admin_image'] != ""): ?>
<img src="upload/<?php
echo $row['admin_image']; ?>" width="100px" height="100px" style="border:4px groove #CCCCCC;
border-radius:5px;">
<?php else: ?>
<img src="images/user.png"
width="100px" height="100px" style="border:4px groove #CCCCCC; border-radius:5px;">
<?php endif; ?>
</td>
<td><?php echo $row['firstname']."
".$row['middlename']." ".$row['lastname']; ?></td>

<td>
<a class="btn btn-primary"
for="ViewAdmin" href="view_admin.php<?php echo '?admin_id='.$id; ?>">
<i class="fa fa-
search"></i>
</a>
<a class="btn btn-warning"
for="ViewAdmin" href="edit_admin.php<?php echo '?admin_id='.$id; ?>">
<i class="fa fa-
edit"></i>
</a>


<div class="modal fade"
id="delete<?php echo $id;?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-
hidden="true">
<div class="modal-dialog">
<div class="modal-
content">
<div class="modal-
header">
<h4
class="modal-title" id="myModalLabel"><i class="glyphicon glyphicon-user"></i> Admin</h4>
</div>
<div class="modal-
body">
<div
class="alert alert-danger">
Are you sure you want to delete?
</div>
<div
class="modal-footer">
<button class="btn btn-inverse" data-dismiss="modal" aria-hidden="true"><i
class="glyphicon glyphicon-remove icon-white"></i> No</button>
<a
href="delete_admin.php<?php echo '?admin_id='.$id; ?>" style="margin-bottom:5px;" class="btn
btn-primary"><i class="glyphicon glyphicon-ok icon-white"></i> Yes</a>
</div>
</div>
</div>
</div>
</div>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<style>
.btn-primary {
color: #fff;
background-color: #421919;
border-color: #421919;
</style>
book.php
<h3>
Books
</h3>
<style>
.page-title {
color: black;
h3{
font-weight: bold;
</style>
</div>
</div>
<div class="row">
<a href="print_barcode1.php"
target="_blank" style="background:none;">
<button class="sqaure-button pull-right"><i
class="fa fa-barcode"></i> Print Books Barcode</button>
<a href="book_print.php" target="_blank">
<Button class="sqaure-button"
backgroundColor="maroon"><i class="fa fa-print"></i> Print Booklist</Button>
</a>
<a href="book_print.php" target="_blank"

</a>
<br />
<br />
<h2><i class="fa fa-book"></i> Book List</h2>
<li>
<a href="add_book.php"
<button class="btn btn-primary"><i
class="fa fa-plus"></i> Add Book</button>
</a>
</li>

</ul>
<ul class="nav nav-pills">
<li role="presentation"
class="active"><a href="book.php">All</a></li>
<li role="presentation" ><a
href="new_books.php">New Books</a></li>

<button style="padding:8px;"
class="btn btn-primary" role="presentation"><a href="lost_books.php" style="color: white;">Lost
Books</a></button>
<style>
a{
color: black;
</style>
<li role="presentation"><a
href="damage_books.php">Damaged Books</a></li>

</ul>
</div>
<thead>
<tr>
<th
style="width:100px;">Book Image</th>
<th>Barcode</th>
<th>BookName</th>
<th>ISBN</th>
<th>Author</th>
<th>Copies</th>
<th>Category</th>
<th>Status</th>
<th>Remarks</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
book order by book_id ASC ") or die (mysqli_error());
$id=$row['book_id'];
$category_id=$row['category_id'];
$cat_query = mysqli_query($con,"select *
from category where category_id = '$category_id'")or die(mysqli_error());
$cat_row = mysqli_fetch_array($cat_query);
?>
<tr>
<td>
<?php if($row['book_image'] !=
""): ?>
<img src="upload/<?php echo
$row['book_image']; ?>" class="img-thumbnail" width="75px" height="50px">
<?php else: ?>
<img class="img-thumbnail"
width="75px" height="50px">
<?php endif; ?>
</td> <td><a target="_blank"
href="view_book_barcode.php?code=<?php echo $row['book_barcode']; ?>"><?php echo
$row['book_barcode']; ?></a></td>

<td style="word-wrap: break-word;
width: 10em;"><?php echo $row['book_title']; ?></td>
width: 10em;"><?php echo $row['isbn']; ?></td>
width: 10em;"><?php echo $row['author']."<br />".$row['author_2']."<br />".
$row['author_3']."<br />".$row['author_4']."<br />".$row['author_5']; ?></td>
<td><?php echo
$row['book_copies']; ?></td>
<td><?php echo
$cat_row['classname']; ?></td>
<td><?php echo $row['status']; ?
></td>
<td><?php echo $row['remarks']; ?
></td>
<td>

for="ViewAdmin" href="edit_book.php<?php echo '?book_id='.$id; ?>">
<i class="fa fa-edit"></i>
</a>
php echo $id;?>">
<i class="glyphicon
</a>

hidden="true">
<div class="modal-
content">
<div class="modal-
header">
<h4
class="modal-title" id="myModalLabel"><i class="glyphicon glyphicon-user"></i> User</h4>
</div>
<div class="modal-
body">
<div
</div>
<div
<a
href="delete_book.php<?php echo '?book_id='.$id; ?>" style="margin-bottom:5px;" class="btn btn-
primary"><i class="glyphicon glyphicon-ok icon-white"></i> Yes</a>
</div>
</div>
</div>
</div>
</div>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<Style>
.btn-primary {
color: #fff;
background-color: blue;
border-color: #1A82C3;
.nav-pills>li.active>a, .nav-pills>li.active>a:hover, .nav-pills>li.active>a:focus {
color: #fff;
background-color: blue;
}
.sqaure-button {
height: 100%;
font-weight: bold;
width: 50%;
color: white;
font-size: 20px;
.sqaure-button:after{
content: "";
display: block;
.btn-primary {
color: #fff;
.nav>li>a {
position: relative;
display: block;
padding: 13px 15px 7px;
color: #fff;
</Style>
borrow.php
<h3>
<small>Home /</small> Borrow
</h3>
</div>
</div>
<div class="row">

</ul>
</div>
<div class="container-fluid">
<div class="row">
<div class="col-md-4"></div>
<form method="post" action="">
<select name="school_number" class="select2_single form-control"
required="required" tabindex="-1" >
<option
value="0">Select School ID Number</option>
<?php
$result=
mysqli_query($con,"select * from user where status = 'Active' ") or die (mysqli_error());
while ($row=
mysqli_fetch_array ($result) ){
$id=$row['user_id'];
?>
<option value="<?php echo $row['school_number']; ?>"><?php echo
$row['school_number']; ?> - <?php echo $row['firstname']; ?></option>
<?php } ?>
</select>
<br />
<br />
<button name="submit" type="submit" class="btn
btn-primary" style="margin-left:110px;"><i class="glyphicon glyphicon-log-in"></i> Submit</button>
</form>
<?php
include ('include/dbcon.php');
if (isset($_POST['submit'])) {
$school_number = $_POST['school_number'];
$sql = mysqli_query($con,"SELECT * FROM user WHERE school_number = '$school_number'
");
$count = mysqli_num_rows($sql);
$row = mysqli_fetch_array($sql);
if($count <= 0){
echo "<div class='alert alert-success'>".'No match found for the School ID
Number'."</div>";
}else{
$school_number = $_POST['school_number'];
echo ('<script> location.href="borrow_book.php?school_number='.
$school_number.'";</script');
?>
</div>
<div class="col-md-4"></div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="row">
<?php include ('allowed_days.php'); ?>
</div>
<button onclick="window.location.href='settings.php';">
options
</button>
</form>
<style>
a.btn-success, a.btn-primary, a.btn-warning, a.btn-danger {
color: black !important;
</style>
borrow_book.php
<?php
$school_number = $_GET['school_number'];
$user_query = mysqli_query($con,"SELECT * FROM user WHERE school_number =
'$school_number' ");
$user_row = mysqli_fetch_array($user_query);
?>
<h3>
<small>Home /</small> Borrowed Transaction
</h3>
</div>
</div>
<div class="row">
<?php
$sql = mysqli_query($con,"SELECT * FROM user
WHERE school_number = '$school_number' ");
$row = mysqli_fetch_array($sql);
?>
<h2>
Borrower Name : <span style="color:maroon;"><?php echo
$row['firstname']." ".$row['middlename']." ".$row['lastname']; ?></span>
</h2>

</ul>
</div>
<thead>
<tr>
<th>Barcode</th>
<th>BookName</th>
<th>Author</th>
<th>Date Borrowed</th>
<th>Due Date</th>
<th>Penalty</th>
<th>Action</th>
<?php
$borrow_query =
mysqli_query($con,"SELECT * FROM borrow_book
LEFT JOIN book ON
borrow_book.book_id = book.book_id
WHERE user_id = '".
$user_row['user_id']."' && borrowed_status = 'borrowed' ORDER BY borrow_book_id DESC") or
die(mysqli_error());
$borrow_count =
mysqli_num_rows($borrow_query);
while($borrow_row =
mysqli_fetch_array($borrow_query)){
$due_date=
$borrow_row['due_date'];
$timezone = "Asia/Manila";
if(function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);
$cur_date = date("Y-m-d H:i:s");
$date_returned = date("Y-m-d
H:i:s");
//$due_date =
strtotime($cur_date);
//$due_date = strtotime("+3 day",
$due_date);
//$due_date = date('F j, Y g:i a',
$due_date);
///$checkout = date('m/d/Y',
strtotime("+1 day", strtotime($due_date)));
$penalty_amount_query=
mysqli_query($con,"select * from penalty order by penalty_id DESC ") or die (mysqli_error());
$penalty_amount =
mysqli_fetch_assoc($penalty_amount_query);
if ($date_returned >
$due_date) {
$penalty =
round((float)(strtotime($date_returned) - strtotime($due_date)) / (60 * 60 *24) *
($penalty_amount['penalty_amount']));
} elseif ($date_returned <
$due_date) {
$penalty = 'No
Penalty';
} else {
$penalty = 'No
Penalty';
?>
</tr>
</thead>
<tbody>
<tr>
<td><?php echo
$borrow_row['book_barcode']; ?></td>
<td style="text-transform:
capitalize"><?php echo $borrow_row['book_title']; ?></td>
capitalize"><?php echo $borrow_row['author']; ?></td>

<td><?php echo date("M d, Y h:m:s
a",strtotime($borrow_row['date_borrowed'])); ?></td>
<?php
if ($borrow_row['status'] !=
'Hardbound') {
echo
"<td>".date('M d, Y h:m:s a',strtotime($borrow_row['due_date']))."</td>";
} else {
echo
"<td>".'Hardbound Book, Inside Only'."</td>";
?>

<?php
if ($borrow_row['status'] !=
'Hardbound') {
echo "<td>".
$penalty."</td>";
} else {
echo
"<td>".'Hardbound Book, Inside Only'."</td>";
?>

<td>
<input type="hidden"
name="date_returned" class="new_text" id="sd" value="<?php echo $date_returned ?>" size="16"
maxlength="10" />
name="user_id" value="<?php echo $borrow_row['user_id']; ?>">
name="borrow_book_id" value="<?php echo $borrow_row['borrow_book_id']; ?>">
name="book_id" value="<?php echo $borrow_row['book_id']; ?>">
name="date_borrowed" value="<?php echo $borrow_row['date_borrowed']; ?>">
name="due_date" value="<?php echo $borrow_row['due_date']; ?>">
<button name="return" class="btn
btn-danger"><i class="glyphicon glyphicon-remove"></i> Return</button>
</form>
</td>
</tr>
<?php
if ($borrow_count <= 0){
echo '
<table style="float:right;">
<tr>
<td
style="padding:10px;" class="alert alert-danger">No books borrowed</td>
</tr>
</table>
';
}
?>
<?php
if (isset($_POST['return'])) {
$user_id=
$_POST['user_id'];
$borrow_book_id=
$_POST['borrow_book_id'];
$book_id=
$_POST['book_id'];
$date_borrowed=
$_POST['date_borrowed'];
$due_date=
$_POST['due_date'];
$date_returned =
$_POST['date_returned'];
$update_copies =
mysqli_query($con,"SELECT * from book where book_id = '$book_id' ") or die (mysqli_error());
$copies_row=
mysqli_fetch_assoc($update_copies);
$book_copies =
$copies_row['book_copies'];
$new_book_copies =
$book_copies + 1;
if ($new_book_copies ==
'0') {
$remark = 'Not
Available';
} else {
$remark =
'Available';
mysqli_query($con,"UPDATE book SET book_copies = '$new_book_copies' where book_id =
'$book_id'") or die (mysqli_error());
mysqli_query($con,"UPDATE book SET remarks = '$remark' where book_id = '$book_id' ") or
die (mysqli_error());
$cur_date = date("Y-m-d
H:i:s");
$date_returned_now =
date("Y-m-d H:i:s");
//$due_date =
strtotime($cur_date);
//$due_date =
strtotime("+3 day", $due_date);
//$due_date = date('F j, Y g:i
a', $due_date);
///$checkout =
date('m/d/Y', strtotime("+1 day", strtotime($due_date)));
$penalty_amount_query=
mysqli_query($con,"select * from penalty order by penalty_id DESC ") or die (mysqli_error());
$penalty_amount =
mysqli_fetch_assoc($penalty_amount_query);
if ($date_returned >
$due_date) {
$penalty =
round((float)(strtotime($date_returned) - strtotime($due_date)) / (60 * 60 *24) *
($penalty_amount['penalty_amount']));
} elseif ($date_returned <
$due_date) {
$penalty = 'No
Penalty';
} else {
$penalty = 'No
Penalty';
mysqli_query($con,"UPDATE borrow_book SET borrowed_status = 'returned', date_returned
= '$date_returned_now', book_penalty = '$penalty' WHERE borrow_book_id= '$borrow_book_id'
and user_id = '$user_id' and book_id = '$book_id' ") or die (mysqli_error());
mysqli_query($con,"INSERT
INTO return_book (user_id, book_id, date_borrowed, due_date, date_returned, book_penalty)
values ('$user_id',
'$book_id', '$date_borrowed', '$due_date', '$date_returned', '$penalty')") or die (mysqli_error());
$report_history1=mysqli_query($con,"select * from admin where admin_id = $id_session ")
or die (mysqli_error());
$report_history_row1=mysqli_fetch_array($report_history1);
$admin_row1=$report_history_row1['firstname']." ".$report_history_row1['middlename']."
".$report_history_row1['lastname'];
INTO report
(book_id, user_id,
admin_name, detail_action, date_transaction)
VALUES
('$book_id','$user_id','$admin_row1','Returned Book',NOW())") or die(mysqli_error());
?>
<script>
window.location="borrow_book.php?school_number=<?php echo $school_number ?>";
</script>
<?php
?>
</tbody>
</table>
</div>
<div class="row" style="margin-top:30px;">
<form method="post">
<div class="col-xs-4">
<input type="text" style="margin-
bottom:10px; margin-left:-9px;" class="form-control" name="barcode" placeholder="Enter barcode
here....." autofocus required />
</div>
</form>
<table class="table table-bordered">
<th style="width:100px;">Book Image</th>
<th>Barcode</th>
<th>Title</th>
<th>Author</th>
<th>ISBN</th>
<th>Status</th>
<th>Action</th>
<?php
if (isset($_POST['barcode'])){
$barcode =
$_POST['barcode'];
$book_query =
mysqli_query($con,"SELECT * FROM book WHERE book_barcode = '$barcode' ") or die
(mysqli_error());
$book_count =
mysqli_num_rows($book_query);
$book_row =
mysqli_fetch_array($book_query);
if
($book_row['book_barcode'] != $barcode){
echo '
<table>
<tr>
<td class="alert alert-info">No match for the barcode entered!</td>
</tr>
</table>
';
} elseif ($barcode == '') {
echo '
<table>
<tr>
<td class="alert alert-info">Enter the correct details!</td>
</tr>
</table>
';
}else{
?>
<tr>
<input type="hidden" name="user_id"
value="<?php echo $user_row['user_id'] ?>">
<input type="hidden" name="book_id"
value="<?php echo $book_row['book_id'] ?>">
<td>
<?php if($book_row['book_image'] != ""): ?
>
<img src="upload/<?php echo
$book_row['book_image']; ?>" width="100px" height="100px" style="border:4px groove #CCCCCC;
border-radius:5px;">
<?php else: ?>
<img src="images/book_image.jpg"
<?php endif; ?>
</td>
<td><?php echo
$book_row['book_barcode'] ?></td>
<td style="text-transform: capitalize"><?php
echo $book_row['book_title'] ?></td>
<td style="text-transform: capitalize"><?php
echo $book_row['author'] ?></td>
<td><?php echo $book_row['isbn'] ?></td>
<td><?php echo $book_row['status']
?></td>
<td><button name="borrow" class="btn
btn-info"><i class="fa fa-check"></i> Borrow</button></td>
</tr>
<?php } }?>
<?php
$allowable_days_query=
mysqli_query($con,"select * from allowed_days order by allowed_days_id DESC ") or die
(mysqli_error());
$allowable_days_row =
mysqli_fetch_assoc($allowable_days_query);
$cur_date = date("Y-m-d H:i:s");
$date_borrowed = date("Y-m-d H:i:s");
$due_date = strtotime($cur_date);
$due_date = strtotime("+".
$allowable_days_row['no_of_days']." day", $due_date);
$due_date = date('Y-m-d H:i:s', $due_date);
///$checkout = date('m/d/Y', strtotime("+1
day", strtotime($due_date)));
?>
<input type="hidden" name="due_date"
class="new_text" id="sd" value="<?php echo $due_date ?>" size="16" maxlength="10" />
name="date_borrowed" class="new_text" id="sd" value="<?php echo $date_borrowed ?>"
size="16" maxlength="10" />
<?php
if (isset($_POST['borrow'])){
$user_id
=$_POST['user_id'];
$book_id
=$_POST['book_id'];
$date_borrowed
=$_POST['date_borrowed'];
$due_date
=$_POST['due_date'];
$trapBookCount=
mysqli_query($con,"SELECT count(*) as books_allowed from borrow_book where user_id =
'$user_id' and borrowed_status = 'borrowed'") or die (mysqli_error());
$countBorrowed =
mysqli_fetch_assoc($trapBookCount);
$bookCountQuery=
mysqli_query($con,"SELECT count(*) as book_count from borrow_book where user_id = '$user_id'
and borrowed_status = 'borrowed' and book_id = $book_id") or die (mysqli_error());
$bookCount =
mysqli_fetch_assoc($bookCountQuery);
$allowed_book_query=
mysqli_query($con,"select * from allowed_book order by allowed_book_id DESC ") or die
(mysqli_error());
$allowed =
mysqli_fetch_assoc($allowed_book_query);
if
($countBorrowed['books_allowed'] == $allowed['qntty_books']){
echo "<script>alert('
".$allowed['qntty_books']." ".'Books Allowed per User!'." '); window.location='borrow_book.php?
school_number=".$school_number."'</script>";
}elseif
($bookCount['book_count'] == 1){
echo
"<script>alert('Book Already Borrowed!'); window.location='borrow_book.php?school_number=".
$school_number."'</script>";
}else{
$update_copies =
mysqli_query($con,"SELECT * from book where book_id = '$book_id' ") or die (mysqli_error());
$copies_row=
mysqli_fetch_assoc($update_copies);
$book_copies =
$copies_row['book_copies'];
$new_book_copies =
$book_copies - 1;
if ($new_book_copies < 0){
echo
"<script>alert('Book out of Copy!'); window.location='borrow_book.php?school_number=".
$school_number."'</script>";
}elseif
($copies_row['status'] == 'Damaged'){
echo
"<script>alert('Book Cannot Borrow At This Moment!'); window.location='borrow_book.php?
}elseif
($copies_row['status'] == 'Lost'){
echo
"<script>alert('Book Cannot Borrow At This Moment!'); window.location='borrow_book.php?
}else{
if ($new_book_copies ==
'0') {
$remark = 'Not
Available';
} else {
$remark =
'Available';
mysqli_query($con,"UPDATE book SET book_copies = '$new_book_copies' where book_id =
'$book_id' ") or die (mysqli_error());
mysqli_query($con,"UPDATE book SET remarks = '$remark' where book_id = '$book_id' ") or
die (mysqli_error());
INTO borrow_book(user_id,book_id,date_borrowed,due_date,borrowed_status)
VALUES('$user_id','$book_id','$date_borrowed','$due_date','borrowed')") or die
(mysqli_error());
$report_history=mysqli_query($con,"select * from admin where admin_id = $id_session ")
or die (mysqli_error());
$report_history_row=mysqli_fetch_array($report_history);
$admin_row=$report_history_row['firstname']." ".$report_history_row['middlename']." ".
$report_history_row['lastname'];
INTO report
(book_id, user_id,
admin_name, detail_action, date_transaction)
VALUES
('$book_id','$user_id','$admin_row','Borrowed Book',NOW())") or die(mysqli_error());
?>
<script>
window.location="borrow_book.php?school_number=<?php echo $school_number ?>";
</script>
<?php
?>
</form>
</table>
</div>
</div>
</div>
</div>
</div>
borrowed.php
<h3>
<small>Home /</small> Borrowed Books
</h3>
</div>
</div>
<div class="row">

<h2><i class="fa fa-book"></i> Borrowed Books Monitoring</h2>
<li>
<a href="print_borrowed_books.php"
<button class="btn btn-danger"><i class="fa
fa-print"></i> Print</button>
</a>
</li>

</ul>

<form method="GET" action="" class="form-inline">
<div class="control-group">
<div class="controls">
<input type="date" style="color:black;" value="<?php echo date('Y-m-d'); ?
>" name="datefrom" class="form-control has-feedback-left" placeholder="Date From" aria-
describedby="inputSuccess2Status4" required />
<span class="fa fa-calendar-o form-control-feedback left" aria-
hidden="true"></span>
<span id="inputSuccess2Status4" class="sr-only">(success)</span>
</div>
</div>
</div>
<div class="control-group">
<div class="controls">
<input type="date" style="color:black;" value="<?php echo date('Y-m-d'); ?
>" name="dateto" class="form-control has-feedback-left" placeholder="Date To" aria-
describedby="inputSuccess2Status4" required />
<span class="fa fa-calendar-o form-control-feedback left" aria-
hidden="true"></span>
<span id="inputSuccess2Status4" class="sr-only">(success)</span>
</div>
</div>
</div>
<button type="submit"
name="search" class="btn btn-primary btn-outline"><i class="fa fa-calendar-o"></i>
Search</button>
</form>
</div>

<?php
$where ="";
if(isset($_GET['search'])){
$where = " and
(date(borrow_book.date_borrowed) between '".date("Y-m-d",strtotime($_GET['datefrom']))."' and
'".date("Y-m-d",strtotime($_GET['dateto']))."' ) ";
$return_query= mysqli_query($con,"SELECT
* from borrow_book
LEFT JOIN book ON borrow_book.book_id =
book.book_id
LEFT JOIN user ON borrow_book.user_id =
user.user_id
where borrow_book.borrowed_status =
'borrowed' $where order by borrow_book.borrow_book_id DESC") or die (mysqli_error());
$return_count =
mysqli_num_rows($return_query);
// $count_penalty =
mysqli_query($con,"SELECT sum(book_penalty) FROM return_book ")or die(mysqli_error());
// $count_penalty_row =
mysqli_fetch_array($count_penalty);
?>

<thead>
<tr>
<th>Barcode</th>
<th>Borrower Name</th>
<th>Title</th>

<th>Date Borrowed</th>
<th>Due Date</th>


</tr>
</thead>
<tbody>
<?php
while ($return_row= mysqli_fetch_array
($return_query) ){
$id=$return_row['borrow_book_id'];
?>
<tr>
<td><?php echo
$return_row['book_barcode']; ?></td>
capitalize"><?php echo $return_row['firstname']." ".$return_row['lastname']; ?></td>
capitalize"><?php echo $return_row['book_title']; ?></td>

<td><?php echo date("M d, Y h:m:s
a",strtotime($return_row['date_borrowed'])); ?></td>
<?php
if ($return_row['book_penalty'] !=
'No Penalty'){
echo "<td class=''
style='width:100px;'>".date("M d, Y h:m:s a",strtotime($return_row['due_date']))."</td>";
}else {
echo "<td>".date("M d, Y
h:m:s a",strtotime($return_row['due_date']))."</td>";
?>
<?php
// if ($return_row['book_penalty'] !
= 'No Penalty'){
// echo "<td class=''
style='width:100px;'>".date("M d, Y h:m:s a",strtotime($return_row['date_returned']))."</td>";
// }else {
// echo "<td>".date("M d, Y
h:m:s a",strtotime($return_row['date_returned']))."</td>";
// }
?>
<?php
// if ($return_row['book_penalty'] !
= 'No Penalty'){
// echo "<td class='alert
alert-warning' style='width:100px;'>Php ".$return_row['book_penalty'].".00</td>";
// }else {
// echo "<td>".
$return_row['book_penalty']."</td>";
// }
?>
</tr>
<?php
if ($return_count <= 0){
echo '
<table style="float:right;">
<tr>
<td
style="padding:10px;" class="alert alert-danger">No Books returned at this moment</td>
</tr>
</table>
';
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<style>
.btn-danger {
background: #421919;
.alert-danger, .alert-error {
color: #E9EDEF;
background-color:#421919;
</style>
home.php

</style>


<div class="row tile_count" style="margin-right:-245px;">
<div class="dash1">
<div class="left"></div>
<div class="right">
<?php
$result = mysqli_query($con,"SELECT *
FROM admin");
$num_rows = mysqli_num_rows($result);
?>
<style>
.dash1 {
width: 350px;
height: 150px;
background: white;
margin: 20px 10px;
float: left;
border-radius: 80px;
</style>
<a href="admin.php">
<span class="count_top"><i class=""></i></span>
</a>
<style>
.count_top {
color: black;
</style>
<div class="icon-design">
<img src="images/admin123.jpg" alt="">
</div>
<style>
.icon-design img{
width: 100px;
height: 100px;
display: block;
margin-left: auto;
margin-right: auto;
}
</style>
<div class="countgreen"><?php echo $num_rows; ?></div>
<style>
.countgreen {
text-align: center;
color: black;
font-size: 20px;
</style>
<a href="admin.php">
<span class="count_bottom"> Total of
Admin</span>
</a>
<style>
.count_bottom {
text-align:center;
color: black;
display: block;
</style>
</div>
</div>
<div class="dash2">
<div class="right">
<style>
.dash2 {
width: 350px;
height: 150px;
background: white;
margin: 20px 10px;
float: left;
border-radius:50px;
</style>
<?php
FROM user");
?>
<img src="images/admin1234.png" alt="Image" width="10"
height="10" class="display">
</div>
</style>
<a href="user.php">
<span class="count_top"><i class=""></i> <i class=""></i> </span>
<a href="user.php">
<span class="count_bottom">Total of
Members</span>
</a>
</div>
</div>
<style>
.count_bottom {
color: black;
.countgreen {
color: black;
</style>
<div class="dash3">
<div class="right">
<style>
.dash3 {
width: 350px;
height: 150px;
background: white;
margin: 20px 10px;
float: left;
</style>
<?php
FROM book");
?>
<img src="images/admin12345.jpg " alt="Image" width="10"
</div>
<a href="book.php">
<span class="count_top"><i class=""></i> </span>
</a>
<a href="book.php">
<span class="count_bottom ">Total of
Books</span>
</a>
</div>
</div>
<div class="dash4">
<div class="right">
<style>
.countgreen {
color: black;
}
</style>
<style>
.dash4 {
width: 350px;
height: 150px;
background: white;
margin: 20px 10px;
float: left;
</style>
<?php
FROM borrow_book");
?>
<img src="images/admin123456.png " alt="Image" width="10"
</div>
<a href="borrowed.php">
<span class="count_top"><i class=""></i> </span>
<a href="borrowed.php">
<span class="count_bottom ">Total of Book
Borrowed</span>
</div>
</a>
</div>
<div class="dash5">
<div class="right">
<style>
.countgreen {
color: black;
</style>
<style>
.dash5 {
width: 350px;
height: 150px;
background: white;
margin: 20px 10px;
float: left;
}
.right_col {
min-height: 770px;
</style>
<?php
FROM return_book");
?>
<img src="images/admin1234567.png" alt="Image" width="10"
</div>
<a href="returned_book.php">
<span class="count_top"><i class=""></i></span>
</a>
<a href="returned_book.php">
<span class="count_bottom ">Total of Book
Returned</span>
</div>
</div>
</a>
</div>
<style>
.countgreen {
color: black;
</style>

<?php include('slide.php'); ?>
login.php
<?php
include('include/dbcon.php');
if (isset($_POST['login'])){
$username=$_POST['username'];
$password=$_POST['password'];
$login_query=mysqli_query($con,"select * from admin where username='$username' and
password='$password'");
$count=mysqli_num_rows($login_query);
$row=mysqli_fetch_array($login_query);
if ($count > 0){
session_start();
$_SESSION['id']=$row['admin_id'];
echo "<script>alert('Successfully Login!'); window.location='home.php'</script>";
}else{
echo "<script>alert('Invalid Username and Password! Try again.');
window.location='index.php'</script>";
?>
<?php }
?>
user.php
<h3>
<small>Home /</small> Members
<style>
H3 {
color: BLACK;
font-weight: bold;
</style>
</h3>
</div>
</div>
<div class="row">

<h2><i class="fa fa-users"></i> Members Information</h2>
<li>
<a href="add_user.php"
<button class="btn btn-primary btn-
outline"><i class="fa fa-plus"></i> Add Member</button>
</a>
</li>
<li>



</ul>
</div>
<thead>
<tr>

<th>School ID</th>
<th>Member Full
Name</th>
<th>Contact Number</th>
<th>Type</th>
<th>Level</th>
<th>Course</th>
<th>Section</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
user order by user_id DESC") or die (mysqli_error());
$id=$row['user_id'];
?>
<tr>

<td> <?php echo
$row['school_number']; ?></a></td>
<td><?php echo $row['firstname']."
".$row['middlename']." ".$row['lastname']; ?></td>
<td><?php echo $row['contact']; ?
></td>
<td><?php echo $row['type'];
?></td>
<td><?php echo $row['level'];
?></td>
<td><?php echo $row['Course']; ?
></td>
<td><?php echo $row['section']; ?
></td>
<td><?php echo $row['status']; ?
></td>
<td>
<a class="btn btn-primary"
for="ViewAdmin" href="view_user.php<?php echo '?user_id='.$id; ?>">
<i class="fa fa-
search"></i>
</a>
for="ViewAdmin" href="edit_user.php<?php echo '?user_id='.$id; ?>">
<i class="fa fa-edit"></i>
</a>
php echo $id;?>">
<i class="glyphicon
</a>

hidden="true">
<div class="modal-
content">
<div class="modal-
header">
<h4
class="modal-title" id="myModalLabel"><i class="glyphicon glyphicon-user"></i> User</h4>
</div>
<div class="modal-
body">
<div
</div>
<div
<a
href="delete_user.php<?php echo '?user_id='.$id; ?>" style="margin-bottom:5px;" class="btn btn-
primary"><i class="glyphicon glyphicon-ok icon-white"></i> Yes</a>
</div>
</div>
</div>
</div>
</div>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<style>
.btn-primary {
color: #fff;
background-color:blue;
border-color: #1A82C3;
</style>
APPENDIXCES D
Evaluation Tool or Test Documents
APPENDICES E
Sample Input/output/Reports
Appendices F
Screen Layouts
Appendix G
Test Result
A. Functional Suitability
1. Functional Completeness. The system covers all the specified tasks 4.60 Strongly agree
and user objectives.
2. Functional Correctness. The system provides the correct results with 4.80 Strongly agree
the needed degree of precision.
3. Functional Appropriateness. The system facilitates the 5.00 Very strongly agree
accomplishment of specified tasks and objectives.
B. Performance Efficiency
4. Time Behavior. The system’s response and processing times and 5.00 Very strongly agree
throughput rates when performing its functions meet requirements.
5. Resource Utilization. The system’s amounts and types of resources 4.60 Strongly agree
used when performing its functions, meet requirements.
6. Capacity. The system’s maximum limits of parameters meet 4.80 Strongly agree
requirements.
C. Compatibility
7. Co-existence. The system can perform its required functions 4.40 Strongly agree
efficiently while sharing a common environment and resources with
other products, without detrimental impact on any other product.
8. Interoperability. The system can exchange information and use the 4.60 Strongly agree
information that has been exchanged.
D. Usability
9. Appropriateness Recognizability. The system allows users to 4.80 Strongly agree
recognize if it is appropriate for their needs.
10. Learnability. The system can be used by specified users to achieve 4.80 Strongly agree
specified goals of learning to use the application with effectiveness,
efficiency, freedom from risk and satisfaction in a specified context of
use.
11. Operability. The system has attributes that make it easy to operate and 5.00 Very strongly agree
control.
12. User Error Protection. The system protects users against making 5.00 Very strongly agree
errors.
13. User Interaction Aesthetics. The system’s user interface enables 5.00 Very strongly agree
pleasing and satisfying interaction for the user.
14. Accessibility. The system can be used by people with the widest range 4.80 Strongly agree
of characteristics and capabilities to achieve a specified goal in a
specified context of use.
E. Reliability
15. Maturity. The system meets the needs for reliability under normal 4.60 Strongly agree
operation
16. Availability. The system is operational and accessible when required 5.00 Very strongly agree
for use.
17. Fault Tolerance. The system operates as intended despite the 5.00 Very strongly agree
presence of hardware or software faults.
18. Recoverability. The system can recover the data directly affected and 5.00 Very strongly agree
re-establish the desired state.
F. Security
19. Confidentiality. The system ensures that data are accessible only to
those authorized to have access.
20. Integrity. The system prevents unauthorized access to, or modification 5.00 Very strongly agree
of, computer programs or data.
21. Non-repudiation. The system can be proven to have taken place, so 5.00 Very strongly agree
that the events or actions cannot be repudiated later.
G. Portability
22. Adaptability. The system can effectively and efficiently be adapted 4.80 Strongly agree
for different or evolving hardware, software or other operational or
usage environments
23. Installability. The system can be successfully installed and/or 5.00 Very strongly agree
uninstalled in a specified environment
Appendix H
Sample Generated Outputs
APPENDICES I
User Manuals
Administrator Module
Login Module
In this module it illustrates that the admin should provide a combination of username
and password to access the system. If the admin entered invalid username and password the
admin cannot access the system.
Home Tab
In this module it shows the administrator dashboard.
In this module shows where you can view the total of the staff.
In this module show the total of the borrower.
In this module shows the total of the books.
In this module shows the total of the borrowed books.
In this module shows the total of the book returned.
Members Tab
In this module shows the list of member’s information who registered in to the
system. And it has five function. Add Members, Search Bar, View, Delete and Edit. The
function of Add member is for adding a new member which we can view here and the second
function is for search Bar. the function for search bar is to easily locate the name of the
members and third function is for View. The function for view is to view the member’s
information. And the fourth function is the Edit, the function for edit is to edit the member’s
information and the last function is Delete, the function for delete is to delete the member’s
information.
New Members Form
In this module, this form includes all the basic information of members. in this form show us
where the librarian can add new members in the system.
Books Tab
In this module, shows all the list of books and it has nine function the first is the
damaged book shows all the book damaged, the second is the lost books shows if what books
lost, the third is Add book and the function is to add book in the system, the fourth is the
search bar and the function for search bar is to easily locate the information of the books. The
fifth is the Edit and the for is to edit the books information, and the Seventh is the print book
list the function is to know all the list of books and also it can print. The eighth function is the
print books barcode and the function is to know the books barcode and also it can print. And
the last is the delete the function for delete is to delete the books information.
Adding Books Form
In this module, shows us all the books damaged information.
Book Lost Information
In this module, show us all the lost book information.
Add Books Form
In this Module, this form includes all the basic information of Add book. This form show
where the librarian can add Books in the system.
Book Print Reports
In this module, shows the printed reports of all the books registered in the system.
List of Books Barcode
In this module, this form shows all the books barcode.
Admin Tab
In this module, admin tab shows the admin information.
Admin Registration Form
In this module, this form is to create an account for the admin.
Borrow Tab
In this module, the borrow tab show us the field of selecting the name who are borrow
a book and selecting a name who are returning the book by simply search the name or ID
number of the borrower.
In this module, shows the form of selecting a school ID number to borrow a book.
Option Tab
In this module, this form shows us the limitation of borrowing a book and editing the
amount of penalty.
Borrowed Books Tab
In this module, the borrowed books tab shows us all the members who borrowed
book.
Print Books Borrowed
In this module, shows the printed reports of all the members who borrowed books in
the library.
Returned Books Tab
In this module. The returned books tab shows us all the members who returned the
books.
Returned Tab
In this module, shows the printed reports of all members who returned the books.
Transaction Reports Tab
In this module, show all the transaction who borrowed and returned books and the
assigned admin.
Curriculum Vitae

New LMS

Uploaded by

Document Informationclick to expand document information

Copyright:

Available Formats

New LMS

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

New LMS

Uploaded by

Copyright:

Available Formats

ABSTRACT

to pay or renew it every year it so expensive.

The proponents aim to develop a Library Management System for Zamboanga

Zamboanga Peninsula Polytechnic State University (ZPPSU) is currently using

borrowing a book sometimes the slip will misplace

who returned the book and who did not.

Purpose and Description

The main purpose of this capstone project is to develop a Library Management

the information of the borrowers and of the books.

The Features of the system are the following:

system in Library of Zamboanga Peninsula Polytechnic State University and allows

the admin to access the overall functionalities of the system.

 Transactions. This feature will show reports of the library.

to track the data of the library and friendly user.

Polytechnic State University with Barcode.

 To manage the transactions of record in the library.

 To build a system that has a barcode capability.

Scope and Limitation

removing borrowers, viewing student’s information, edit borrower’s information, edit

 The system is not capable of accepting student concerns.

 The system does not require internet connection.

 The system is not capable of online payment transaction.

 The staff was not capable of deleting the book.

REVIEW OF RELATED LITERATURE AND STUDIES

2.1 Foreign Local Related Literature

According to E.Valenti(2016) from the article entitled “The State of Library

Foreign Local Related Study

According to A.Agarwal (2013) on the research entitled Online Library Management

2.2 Foreign and local Related System

Library Management System Project Report

specifications, borrower’s transactions and more. A library management system can

Figure 2.2.1 Library Management System

Library Management System Mini Project Report On LIBRARY MANAGEMENT

happens when a non-computerized system is used.

Figure 2.2.2 Soe Library Management System Home Page

Library Management System

Figure 2.2.3 Library Management System Adding new book.

LIBRARY MANAGEMENT SYSTEM WITH TOPIC MODELLING AND ITS

ADAPTABILITY TO OPEN AND DISTANCE LEARNING LIBRARIES

capabilities. which expands on the use of topic modeling as a novel element in

exploration issues. Routine management of a library.

2.4 Table of Comparison

System Features Library Library

Add Borrower, Add Yes Yes Yes Yes Yes

member, delete, edit

Book/Add book/edit Yes Yes Yes Yes Yes

Admin/Add staff/edit Yes Yes Yes Yes Yes

Borrow/Options Yes Yes Yes Yes Yes

TRANSACTIONS Yes Yes Yes Yes Yes

(List of Borrower, List

Print Report No No No No Yes

Barcode Scanner No No No No Yes

A library management system with Barcode Scanner is a system which is used to

3.1 Discussion Software Development Life Cycle and each Phases

the project system for them to give a feedback to the proponents.

3.2 Details of technology to be used

The following are the Hardware and Software to be used:

 Operating System Windows 10 / 8 / 7

3.3 How the project will work