SMART LIBRARY MANAGEMENT
A Dissertation submitted to the
BHARATHIDASAN UNIVERSITY
In partial fulfillment of the requirements for the award of the
degree of
Bachelor of Science in
Computer Science
Submitted By
S. TAMILKUMAR (Reg. No: CB22S 614882)
S. KARUPPAIYAH (Reg. No: CB22S 614863)
K. VEERAMANI (Reg. No: CB22S 614885)
A. MEHANRAJA (Reg. No: CB22S 614867)
K. DEENKUMAR (Reg. No: CB22S 614855)
M. DHARMANEETHI (Reg. No: CB22S 614856)
Guided By
[Link],PGDCA.,
DEPARTMENT OF COMPUTER SCIENCE
MOTHER TERASA COLLEGE OF ARTS AND SCIENCE
Mettusalai, Illuppur, Pudukkottai
APRIL 2025
SMART LIBRARY MANAGEMENT
PG DEPARTMENT OF COMPUTER SCIENCE
MOTHER TERASA COLLEGE OF ARTS AND SCIENCE
METTUSALAI, ILLUPPUR, PUDUKKOTTAI – 622 102
CERTIFICATE
This is to certify that the Viva-Voce Examination for the candidate
S. TAMILKUMAR (Reg. No: CB22S 614882),[Link]([Link]:CB22S 614863),
[Link]([Link]:CB22S614885),[Link]([Link]:CB22S614867),
[Link]([Link]:CB22S614855),[Link]([Link]:CB22S 614856),
was held at Under Graduate in Department of Computer Science, Mother Terasa
College of Arts and Science, Mettusalai, Illuppur 622 102, on April 2025.
Examiners:
Internal : Name : .......................................................
Signature : .......................................................
External : Signature : .......................................................
Name and Address
Office Seal Signature of the HoD
[Link],PGDCA.,
ASSISTANT PROFESSOR IN COMPUTER SCIENCE
MOTHER TERASA COLLEGE OF ARTS AND SCIENCE
METTUSALAI, ILLUPPUR, PUDUKKOTTAI – 622 102
CERTIFICATE
This is to certify that the Dissertation entitled “SMART LIBRARY MANAGEMENT
”submitted to in partial fulfillment of the requirements for the aware of the degree
Bachelor of Science in Computer Science is a project work done by
[Link]([Link]:CB22S614882),[Link]
([Link]:CB22S614863),[Link]([Link]:CB22S614885),[Link]
([Link]:CB22S614867),[Link]([Link]:CB22S614855),[Link]
ETHI([Link]:CB22S614856), during the period (2021-2025) of this study under my
guidance and that the dissertation has previously formed the basis for the aware of only
degree, diploma, associate ship, fellowship or similar other titles to any candidate of any
university and that it is an independent work done by them.
Signature of the Examiner Signature of the Guide
Signature of the Head of the Department Signature of the Principal
Date :
Place :
SMART LIBRARY MANAGEMENT
DECLARATION
I hereby declare that the work presented in this dissertation is the original work done by me
under the guidance of [Link] , Assistant Professor in Computer Science,
Mother Terasa College of Arts and Science, Illuppur, Pudukkottai and has not been included in any
other project / thesis/ dissertation submitted for other Degree or any other similar title.
Name of the Candidate :
Register Number :
Academic Year :
Signature of the Candidate
SMART LIBRARY MANAGEMENT
ACKNOWLEDGEMENT
At the outset I first of all thank the lord almighty for his blessings, which helped me in
successful completion, of the project work.
I express my deep sense of respect and profound gratitude to [Link] [Link].
(USA)., Founder, Mother Terasa Group of Institutions, [Link], B.A.,
Correspondent, Mother Terasa Group of Institutions, for providing adequate facilities to my
study. I would like to express my heartfelt thanks to our Director, [Link],
M.A.,[Link].,[Link].,Ph.D.,
I would like to express my heartfelt thanks to our Principal, [Link],
M.A.,[Link].,[Link].,Ph.D., and our Vice-Principal [Link], M.A.,[Link].,[Link].,
Mother Terasa College of Arts and Science, for his kind co-operation for the successful
completion of this project.
I express my sincere and profound thanks to [Link], [Link].,[Link].,[Link].,
Assistant Professor and Head of the Department of Computer Science, for her suggestion and
guidance that benefited to do my project.
I can deeply indebted to my beloved guide [Link], [Link].,
Assistant Professor Computer Science, for her overall support and timely advice throughout the
study period and for her encouragement at every stage and also for her invaluable guidance
throughout my project.
I thank all Faculty Members of the Department of Computer Science for their support
and help during my project work.
I owe a deep of gratitude to My parent, for their love and kindness, which sustained my
effort throughout my project.
I give my gratitude to the faculty of Librarian for his consisting help throughout my
project. I express my sincere thanks to my friends and especially for my UG students for their
constant help whenever I required and helping me in many ways for completing this project
successfully.
(S. Tamilkumar, S. Karuppaiyah, K. Veeramani, A. Mehanraja, K. Deenkumar, M. Dharmaneethi)
SMART LIBRARY MANAGEMENT
[Link]. CONTENT Page No.
1 INTRODUCTION 1
2 SYSTEM ANALYSIS 3
2.1 Existing System 3
2.2 Proposed System 4
3 SYSTEM DESIGN 5
3.1 Data Flow Diagram 5
3.2 Use Case Diagram 9
3.3 Project Description 10
4 TOOLS REQUIREMENTS SPECIFICATION 15
4.1 Hardware Specification 15
4.2 Software Specification 15
4.3 Software Description 16
5 TESTING AND IMPLEMENTATION 30
5.1 Testing 30
5.2 Implementation 32
6 CONCLUSION 33
7 FUTURE ENHANCEMENT 34
8 APPENDIX 35
8.1 Source Code 35
8.2 Screen Shots 48
9 BIBLIOGRAPHY 56
SMART LIBRARY MANAGEMENT
ABSTRACT
The project, titled "Smart Library Management", is developed using PHP to efficiently monitor
and control library transactions. This software simplifies key library operations such as adding new
members, managing book records, updating information, searching for books and members, and
handling book borrowing and returns.
Smart Library Management was developed using PHP, MySQL, Bootstrap, HTML, and CSS. It
features two types of users: the Admin/Librarian and Students. The librarian is responsible for
managing books and issuing them to students, while students can track the books issued to them.
Additionally, students can register their accounts through the public page, making the system
accessible and user-friendly. Traditional manual library management requires significant
manpower, leading to inefficiencies and data discrepancies. Storing and managing extensive
transaction records over time also poses challenges. With the advancement of digital technology
and increasing complexity in library operations, traditional methods have become outdated and
time-consuming. To address these issues, Smart Library Management was designed for
educational institutions such as universities and colleges. It aims to streamline resource
management, enhance accessibility, and improve overall efficiency. The system provides an
intuitive interface that enables librarians to efficiently add, search, and update bibliographic
information, ensuring a well-organized and searchable library collection. Students can check book
availability and perform borrowing transactions digitally. Additionally, the system includes
essential features such as patron registration, borrowing history tracking, and fine management.
The Waterfall model from the Software Development Life Cycle (SDLC) was used in the
system’s development, ensuring a structured approach to design and implementation. Overall,
Smart Library Management offers a modern and automated solution to overcome the challenges
faced by traditional library management, improving operational efficiency and user experience.
Keywords: Library Management, Digital Library, SDLC, Automated Library System
SMART LIBRARY MANAGEMENT
1. INTRODUCTION
The Smart Library Management project is designed specifically for educational institutions such as
universities and colleges, where users include students and administrators. The system is developed
using PHP (Hypertext Preprocessor) and HTML (Hypertext Markup Language) as the primary
programming languages, along with JavaScript, jQuery, and CSS (Cascading Style Sheets) for
interactive and responsive functionality. It utilizes XAMPP as a web server to connect to a MySQL
database, ensuring secure and efficient data management.
Many libraries still rely on manual management, which requires a significant workforce and is prone to
human errors. This system improves library management and maintenance, allowing librarians to
efficiently handle incoming data while reducing manual efforts. By shifting to an automated system,
library operations become more systematic, organized, and reliable.
Data management is a crucial aspect of library operations, particularly in tracking book borrowing,
returns, and transactions. A manual system often leads to discrepancies during data encoding,
difficulties in long-term data storage, and inefficiencies in retrieving historical records. As the
number of users and transactions increases, manual storage methods become impractical. With this
system, data management is significantly enhanced, allowing librarians to store, retrieve, and update
records more effectively.
One of the key advantages of Smart Library Management is its ability to automate report
generation, reducing the time librarians spend manually compiling reports. This feature ensures that
records are up-to-date and accessible at any time, improving the overall efficiency of library operations.
Additionally, the system provides alternative methods for users, particularly students, to search for
books, check availability, and perform borrowing transactions seamlessly.
Furthermore, the system enables librarians to expand their database capacity, storing more
information about books and users. This contributes to better resource management and enhanced
student services. By leveraging modern technology, libraries can offer an improved user experience,
making digital library materials more accessible and streamlining administrative tasks.
In summary, the Smart Library Management project aims to revolutionize library operations by
automating key processes such as book tracking, borrowing, returning, reporting, and data
management. It not only benefits librarians by enhancing workflow efficiency but also provides
students with quick and easy access to library resources. The system ensures accurate data storage,
reduces manual workload, and improves reporting and monitoring capabilities, making it a vital
tool for modern educational institutions.
SMART LIBRARY MANAGEMENT
2. SYSTEM ANALYSIS
PROBLEM STATEMENT
In many educational institutions, libraries continue to rely on manual record-keeping for managing
book transactions, member details, and inventory. This traditional approach is time-consuming, error-
prone, and inefficient, leading to operational challenges for both librarians and students. Manually
processing book borrowals, returns, and inventory updates often results in data inconsistencies,
misplaced records, and difficulties in tracking overdue books and fines.
Additionally, students face limited access to book availability information, requiring them to
physically visit the library to check for resources. This causes delays, inconvenience, and reduced
efficiency in resource utilization. The absence of automated reporting and data analysis makes it
difficult for librarians to track book circulation, monitor user activity, and generate reports quickly.
Over time, storing large volumes of paper-based records or spreadsheets becomes unmanageable,
increasing the risk of data loss and requiring excessive storage space.
With the growing demand for digital transformation and automation, a Smart Library
Management system is needed to address these challenges. The proposed system aims to automate
book transactions, improve data accuracy, enhance accessibility, and provide real-time reports,
making library operations more efficient, user-friendly, and secure. By replacing the outdated manual
system with a centralized, web-based solution, this project ensures better organization, reduced
workload for librarians, and a seamless experience for students in accessing library resources.
2.1 EXISTING SYSTEM
The traditional manual library management system relies on physical record-keeping, where librarians
maintain books, member details, and transaction histories using paper-based logs or spreadsheets. This
method is time-consuming and often leads to inefficiencies in daily operations. Manually recording
book borrowings and returns results in delays, making it difficult for librarians to manage large
volumes of transactions. Additionally, handwritten records or spreadsheets are prone to errors such as
duplicate entries, missing data, or incorrect book availability status. Another major drawback is the
limited accessibility of book information. Students must visit the library physically to check book
availability, which can be inconvenient and inefficient. Storing transaction history over a long period
requires significant physical space, making data retrieval slow and difficult. The lack of automated
report generation also creates challenges, as librarians must manually compile data for book circulation,
overdue fines, and inventory tracking, leading to further inefficiencies. These limitations highlight the
need for a more efficient and automated solution to streamline library management.
2.2 PROPOSED SYSTEM
The Smart Library Management system is designed to overcome the inefficiencies of the existing
manual system by introducing automation, digital record-keeping, and real-time data access. This
system enables librarians to manage book transactions more efficiently by automating the issuing,
returning, and tracking of books, reducing manual work and minimizing errors. The use of a
centralized MySQL database ensures secure, fast, and accurate storage of books, users, and
transaction histories, eliminating the risks associated with manual record-keeping. Students can
conveniently check book availability online without visiting the library, improving accessibility and
saving time. The system incorporates role-based user authentication, where administrators manage
book records, while students can track their borrowed books. Automated report generation allows
librarians to quickly generate real-time reports on book borrowings, returns, overdue books, and
fines, significantly improving decision-making and record management. With a user-friendly
interface developed using PHP, HTML, CSS, JavaScript, and Bootstrap, the system ensures ease of
use for both librarians and students. Additionally, it includes an automated fine calculation feature,
reducing disputes and ensuring timely book returns. The system is also scalable, allowing future
expansions to accommodate growing data and integrate additional features as needed. By
transitioning from a manual to a digital system, Smart Library Management enhances workflow
efficiency, accessibility, and security, ultimately improving the overall management and services of
the library.
SMART LIBRARY MANAGEMENT
3. SYSTEM DESIGN
3.1 DATA FLOW DIAGRAM
3.2 USE CASE DIAGRAM
SEQUENCE DIAGRAM
CLASS DIAGRAM
SMART LIBRARY MANAGEMENT
3.3 PROJECT DESCRIPTION
The Smart Library Management System is a web-based application designed to enhance the
efficiency of library operations by automating book transactions, user management, and report
generation. This system eliminates the limitations of manual record-keeping, such as data
inconsistencies, slow retrieval, and storage issues, by providing a centralized, digital platform for
managing library resources.
Developed using PHP, MySQL, JavaScript, HTML, CSS, and Bootstrap, the system ensures secure
and fast data processing while providing a user-friendly interface for both librarians and students.
The platform consists of two main user roles:
Librarian (Admin): Manages book records, issues and returns books, tracks overdue fines,
and generates real-time reports.
Student (User): Searches for books, checks availability, borrows books, and views
transaction history.
Automated Book Transactions: Allows quick and accurate book issuance, returns, and
availability tracking.
Centralized Database Management: Uses MySQL for secure and efficient data storage
of books, users, and transaction histories.
User Authentication and Role-Based Access: Ensures security by restricting access based
on user roles (Admin/Student).
Search and Availability Check: Enables students to find books online without visiting the
library.
Fine Calculation and Tracking: Automatically calculates and updates fines for overdue
books.
Report Generation: Provides real-time reports on book circulation, overdue books, and
transaction summaries.
By implementing this Smart Library Management System, educational institutions can reduce
manual workload, improve data accuracy, enhance accessibility, and ensure efficient library
resource management.
Features:
Student Side:
• Login
• Books
• Register
Admin Side:
• Dashboard
• Manage Books
• Add Books
• Remove Books
• Issued Books
• Issue
• Update
• Reissue
• View Books
Literature Review
Library Management Systems have evolved significantly, pivotal in automating library
operations, improving user experiences, and facilitating data-driven decision-making.
This literature review highlighted the benefits, key features, challenges, and emerging
trends in LMS. It is evident that LMS are essential tools for modern libraries, and their
continuous development will contribute to the growth and effectiveness of library
services in the digital age.
The data continuous development will contribute to the growth and effectiveness of
library services in the digital age. The data relating to the affairs of the user and the
library is critical, one of which is the proof of borrowing and transactions of the user.
Manual management will cause discrepancies during data encoding. The user's
transaction history is too numerous and needs to be stored over a long period, requiring a
lot of files for storage. With this system, it can increase the level of data management.
Furthermore, the librarian needs to update the report at any given time, which takes a
while to research the data for the report. The system provides reports automatically and
faster.
This system helps librarians handle a library's day-to-day transactions. This also allows
librarians to keep records of borrowed, returned, and non-refundable books. On the other
hand, for students, they can easily find the availability of the books they need. The
importance of the project is to save the user time to do the borrowing and return process
of books or any transactions. In addition, if any issues regarding the user can be
identified and management can take action. This system can make library management
more efficient and systematic. Increase reporting and monitoring rates. Updated records
with the automatic library management system allow dynamic reporting and
surveillance. This system enables the admin to know more accurate data and avoid any
negligence regarding data storage.
The process phase of the Waterfall model is used to develop this system and divided
separately; the result of one step will act as an input in the next phase sequentially. In
addition, the Waterfall model will help plan and schedule system development. The
development process moves from planning, analyzing, designing, implementing, testing,
and maintenance.
SMART LIBRARY MANAGEMENT
4. TOOL REQUIREMENTS SPECIFICATION
4.1 SOFTWARE REQUIREMENT
OPERATING SYSTEM : Windows 10
FRONT END : WAMP SERVER (HTML)
4.2HARDWARE REQUIREMENT
Server Requirements (For Hosting the System)
Processor: Intel Core i5 or higher
RAM: Minimum 8GB (16GB recommended for high performance)
Storage: Minimum 500GB HDD or 256GB SSD (recommended for faster access)
Operating System: Windows Server / Linux (Ubuntu, CentOS)
Network: High-speed internet connection for remote access
Client System Requirements (For Librarians & Students)
Processor: Intel Core i3 or higher
RAM: Minimum 4GB (8GB recommended)
Storage: 100GB HDD or SSD
Operating System: Windows 10/11, macOS, or Linux
Browser: Google Chrome, Mozilla Firefox, or Microsoft Edge (latest version)
Display: Minimum 1366x768 resolution (Full HD recommended)
SMART LIBRARY MANAGEMENT
SOFTWARE DESCRIPTION
Smart Library Management is a comprehensive web-based application designed to
streamline and automate essential library operations. It is developed using PHP for backend
functionality, MySQL for efficient database management, Bootstrap for responsive design, and
HTML & CSS for an intuitive and user-friendly interface. The system is tailored to cater to two
distinct user roles: Admin/Librarian and Students, each with specific functionalities to enhance
the overall efficiency of the library system.
The Admin/Librarian is responsible for managing the entire library database, including
adding, updating, deleting, and maintaining records of books. They can also handle book
issuance, returns, and fines for overdue books. Additionally, they have control over student
registrations, user access, and tracking borrowing history, ensuring an organized and well-
maintained system.
On the other hand, Students can register through the public page, log in to their
accounts, and access a wide range of library services. They can search for books based on
various filters, check book availability, view their borrowing history, and request book
renewals. This self-service feature enhances user experience and reduces the dependency on
manual interventions.
The system is designed to provide several key features, including user authentication
for secure access, dynamic book and member management, a structured borrowing and
return tracking system, and fine management for overdue books. It also features a user-
friendly dashboard with advanced search and filtering options for quick and efficient
navigation.
By automating manual library processes, the Smart Library Management system
significantly reduces human errors, enhances operational efficiency, and ensures a well-
structured and easily accessible library collection. The system’s digital transformation of
library records eliminates the challenges of traditional paper-based management and
enhances overall library operations, making it more reliable and effective.
SMART LIBRARY MANAGEMENT
TESTING
Testing plays a crucial role in ensuring the reliability, efficiency, and accuracy of the Smart Library
Management System. Various testing methodologies were applied to evaluate the system's
performance, security, and functionality.
Unit Testing
Unit testing involves testing individual modules or components of the system to verify their
correctness. Each module, such as user authentication, book management, and transaction processing,
was tested independently to identify and rectify bugs. The primary goal of unit testing was to ensure
that every function operates as expected before integrating it into the complete system.
White Box Testing
White box testing focuses on testing the internal logic, code structure, and data flow of the system. The
testing process included:
Statement Coverage: Ensuring every line of code was executed at least once.
Branch Coverage: Testing all possible branches of conditional statements.
Path Coverage: Verifying all possible execution paths in the program.
By conducting white box testing, the correctness of conditional statements, loops, and function calls
was validated.
Conditional Testing
Conditional testing was performed to evaluate how the system behaves under different conditions and
constraints. This involved:
Checking if users with incorrect login credentials receive proper error messages.
Validating different book issuing conditions, such as overdue book penalties.
Ensuring correct access control, restricting certain functionalities to admins only.
Data Flow Testing
Data flow testing was used to track how data moves through the system and identify potential issues
such as:
Uninitialized variables in database queries.
Improper handling of NULL values.
Data redundancy and inconsistencies in book transactions.
Secure storage and retrieval of user credentials.
Through data flow testing, we ensured that input data is processed correctly without leading to data loss
or security vulnerabilities.
Loop Testing
Loop testing was conducted to verify the performance and accuracy of iterative processes within the
system. This included:
Simple Loops: Ensuring book searches return correct results within multiple iterations.
Nested Loops: Validating transaction processing when multiple conditions are involved.
Concatenated Loops: Ensuring dynamic filters for book searches work correctly when multiple filters
are applied.
By optimizing loop structures, system efficiency and response time were improved.
IMPLEMENTATION
System Deployment
The Smart Library Management System was deployed using the Waterfall Model, following a
structured implementation process:
Planning & Requirement Analysis: Identified key functionalities required for library management.
Design: Created ER diagrams, data flow diagrams, and system architecture.
Implementation: Developed the system using PHP, MySQL, Bootstrap, HTML, and CSS.
Testing: Performed unit testing, white box testing, and integration testing.
Deployment: Installed the system on a WAMP server for local deployment and cloud hosting for
remote access.
Maintenance: Ensured regular updates, bug fixes, and feature enhancements.
Database Integration
The system’s backend relies on a MySQL database, designed to efficiently handle library transactions.
Key implementation steps included:
Creating optimized database schemas for users, books, and transactions.
Implementing indexing for faster search queries.
Ensuring data integrity through foreign key constraints and normalization.
Security Measures
To ensure system security and prevent unauthorized access, several security mechanisms were
implemented:
Password Hashing: Secure user authentication with encrypted passwords.
SQL Injection Prevention: Use of prepared statements to safeguard against database attacks.
Role-Based Access Control: Restricting admin functionalities from unauthorized users.
Session Management: Implementing secure sessions to maintain user authentication.
Performance Optimization
To enhance system efficiency, several optimization techniques were applied:
Database Query Optimization: Indexed tables for faster query execution.
Asynchronous Requests: Implemented AJAX to enhance user experience.
Code Refactoring: Removed redundant code and improved code readability.
Caching Mechanisms: Used browser caching to improve page load speeds.
User Training and Documentation
Before full deployment, training sessions were conducted to familiarize librarians and students with
system usage. Additionally, a user manual was provided, covering:
How to log in and navigate the system.
Managing books and user transactions.
Generating automated reports.
SMART LIBRARY MANAGEMENT
5. CONCLUSION
The Smart Library Management System is a comprehensive digital solution designed to modernize
and streamline traditional library operations. By automating essential processes such as book tracking,
borrowing, returning, reporting, and data management, the system significantly enhances operational
efficiency and minimizes the challenges associated with manual record-keeping.
One of the major benefits of this system is its ability to improve workflow efficiency for librarians
while providing students with seamless access to library resources. The system eliminates common
inefficiencies found in manual methods, such as human errors in data entry, difficulties in tracking
book availability, and delays in updating records. By leveraging technologies such as PHP, MySQL,
JavaScript, and Bootstrap, the system ensures a robust, responsive, and user-friendly interface for
both librarians and students.
Additionally, the system incorporates advanced features such as automated report generation, which
allows librarians to quickly generate accurate records of book transactions, overdue books, and fines.
The real-time book availability check enables students to search for books effortlessly, reducing time
spent looking for resources manually. Secure data management ensures that all user and book records
remain protected from unauthorized access while facilitating easy retrieval of past transactions.
The ability to expand database capacity further strengthens resource management by accommodating
a growing collection of books and users. This scalability makes the system a sustainable solution for
educational institutions, enabling libraries to keep pace with increasing student demands and evolving
academic needs.
Furthermore, the system supports digital transformation by integrating modern technologies that
promote efficiency, accuracy, and accessibility. It reduces manual workload, optimizes administrative
operations, and enhances overall user experience. Through structured and automated processes, Smart
Library Management enables educational institutions to maintain well-organized and efficient
libraries, ultimately fostering a better learning environment for students and a more manageable
workflow for librarians.
In conclusion, the Smart Library Management System is an indispensable tool that not only
enhances the traditional library experience but also paves the way for future advancements in digital
library solutions. It ensures accurate data storage, efficient book tracking, and real-time accessibility,
making it a vital asset for modern educational institutions aiming to improve their library services and
overall operational efficiency.
SMART LIBRARY MANAGEMENT
7. FUTURE ENHANCEMENT
Mobile Application Integration – Developing a mobile app for the system will allow students
and librarians to access the library services on the go, providing notifications on due dates, book
availability, and personalized recommendations.
AI-based Book Recommendation System – Implementing artificial intelligence to analyze
students' reading history and suggest books based on their interests can enhance the overall user
experience.
RFID-Based Book Tracking – Integrating Radio Frequency Identification (RFID)
technology will help automate book check-in and check-out processes, reducing human
intervention and increasing efficiency.
Cloud-based Data Storage – Shifting to a cloud-based storage system will enable seamless
access to library records across multiple campuses, ensuring data security, real-time updates,
and backup capabilities.
Chatbot Assistance – Introducing AI-powered chatbots will provide instant assistance to
students by answering queries, guiding book searches, and helping with account-related
questions.
E-Library and Digital Content Support – Expanding the system to support e-books, journals,
and digital resources will provide students with a more comprehensive learning environment,
beyond just physical books.
Multi-language Support – Adding multiple language options will make the system more
accessible to a diverse group of students and staff members from different linguistic
backgrounds.
Integration with Academic Portals – Connecting the library system with student portals and
Learning Management Systems (LMS) will enhance accessibility and provide a more connected
academic experience.
SMART LIBRARY MANAGEMENT
8.1 SOURCE CODE
<?php
// session_start();
// session_destroy();
// if (!(isset($_SESSION['auth']) && $_SESSION['auth'] === true)) {
// header("Location: [Link]?access=false");
// exit();
// }
// else {
// $admin = $_SESSION['admin'];
// }
require 'includes/[Link]';
require 'includes/[Link]';
include "includes/[Link]";
// if(isset($_SESSION['admin'])){
// $admin = $_SESSION['admin'];
// // echo "Hello $user";
// }
if(isset($_POST['submit'])){
$news = sanitize(trim($_POST['news']));
$sql = "INSERT into news (announcement) values ('$news')";
$query = mysqli_query($conn,$sql);
$error = false;
if($query){
$error = true;
}
else{
echo "<script>alert('Not successful!! Try again.');
</script>";
if(isset($_POST['UpDat'])){
$id = sanitize(trim($_POST['id']));
$text = sanitize(trim($_POST['text']));
$sql_up = "UPDATE news set announcement = '$text' where newsId =
'$id'";
echo mysqli_error($sql_up);
$result = mysqli_query($conn,$sql_del);
if ($result)
echo "<script>
alert('Update successful');
</script>";
if(isset($_POST['del'])){
$id = sanitize(trim($_POST['id']));
$sql_del = "DELETE from news where newsId = $id";
$result = mysqli_query($conn,$sql_del);
if ($result)
// echo "<script>
// var response = confirm('Would you like to delete the user');
// if (response == true) {
// alert('User was successfully deleted from the database');
// [Link] ='[Link]';
// }
// else
// {
// alert('Could not delete user');
// }
// </script>";
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, user-scalable=no,
initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<link rel="stylesheet" type="text/css" href="css/[Link]">
<link rel="stylesheet" type="text/css" href="font-awesome-4.7.0/css/font-
[Link]">
<link rel="stylesheet" type="text/css" href="css/[Link]">
<link rel="stylesheet" type="text/css" href="flickity/[Link]">
<script type="text/javascript" src="flickity/[Link]"></script>
<title>Library Management</title>
</head>
<body>
<div class="container">
<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="container-fluid">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-
toggle="collapse" data-target="#bs-example">
<span class="sr-only">:</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">Library Management System</a>
</div>
<div class="collapse navbar-collapse" id="bs-example">
<ul class="nav navbar-nav">
<li class="active"><a href="#">Home</a></li>
</ul>
<ul class="nav navbar-nav navbar-right">
<li><a href="[Link]">Login</a></li>
</ul>
</div>
</div>
</nav>
</div>
<div class="container-fluid slide">
<div class="slider">
<!-- <h1>Flickity - wrapAround</h1> -->
<div class="carousel" data-flickity='{ "autoPlay":
true }'; >
<div class="carousel-cell" auto-play >
<img src="ify/[Link]">
</div>
<div class="carousel-cell" auto-play>
<img src="ify/[Link]">
</div>
<div class="carousel-cell" auto-play>
<img src="ify/[Link]">
</div>
<div class="carousel-cell" auto-play >
<img src="ify/[Link]">
</div>
<div class="carousel-cell" auto-play>
<img src="ify/[Link]">
</div>
</div>
</div>
</div>
<!-- Default panel contents -->
<div class="container slide2">
<div class="panel-heading">
<div class="row">
<h3 class="center-block" style="font-size: 30px;">Published
Announcements</h3>
</div>
</div>
<table class="table table-bordered" style="font-size: 18px;">
<thead>
<tr>
<th>NewsId</th>
<th>Announcement</th>
</tr>
</thead>
<?php
$sql2 = "SELECT * from news";
$query2 = mysqli_query($conn, $sql2);
$counter = 1;
while ($row = mysqli_fetch_array($query2)) { ?>
<tbody >
<td><?php echo $counter++; ?></td>
<td><?php echo $row['announcement']; ?></td>
</tbody>
<?php }
?>
</tbody>
</table>
</div>
</div>
</div>
<!-- <div class="row">
<div class="col-lg-4 col-md-4 col-sm-4 col-xs-12 column">
<div class="page-header col-lg-offset-1">
<h2>Welcome to our portal</h2>
</div>
Lorem ipsum dolor sit amet, consectetur adipisicing elit,
sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut
enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip
ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in
voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint
occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim
id est laborum.
<a href="[Link]"><p class="slide2"><button
class="btn btn-success">Sign Up</button></p></a>
</div>
<div class="col-lg-4 col-md-4 col-sm-4 col-xs-12 column">
<div class="page-header col-lg-offset-1">
<h2>24/7 Operational Support</h2>
</div>
Lorem ipsum dolor sit amet, consectetur adipisicing elit,
sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut
enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip
ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in
voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint
occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim
id est laborum.
</div>
<div class="col-lg-4 col-md-4 col-sm-4 col-xs-12 column">
<div class="page-header col-lg-offset-1">
<h2>Why Us?</h2>
</div>
Lorem ipsum dolor sit amet, consectetur adipisicing elit,
sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut
enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip
ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in
voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint
occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim
id est laborum.
</div>
</div>
</div> -->
<div class="container-fluid slide3" style="background-color: #282828">
<div class="container">
<div class="row">
<div class="col-lg-3 col-md-3 col-sm-6 col-xs-12">
<a href="#" class="thumbnail">
<img src="ify/[Link]">
</a>
</div>
<div class="col-lg-3 col-md-3 col-sm-6 col-xs-12">
<a href="#" class="thumbnail">
<img src="ify/[Link]">
</a>
</div>
<div class="col-lg-3 col-md-3 col-sm-6 col-xs-12">
<a href="#" class="thumbnail">
<img src="ify/[Link]">
</a>
</div>
<div class="col-lg-3 col-md-3 col-sm-6 col-xs-12">
<a href="#" class="thumbnail">
<img src="ify/[Link]">
</a>
</div>
</div>
</div>
</div>
<script type="text/javascript" src="js/[Link]"></script>
<script type="text/javascript" src="js/[Link]"></script>
</body>
</html>
<?php
session_start();
// if ((isset($_SESSION['auth']) && $_SESSION['auth'] === true)) {
// header("Location: [Link]");
// exit();
// }
// if (isset($_GET['access'])) {
// $alert_user = true;
// }
require 'includes/[Link]';
require 'includes/[Link]';
include "includes/[Link]";
// Error check
// echo"<br>";
// echo mysqli_errno($conn);
if(isset($_POST['submit'])){
$username = sanitize(trim($_POST['username']));
$password = sanitize(trim($_POST['password']));
$sql_admin = "SELECT * from admin where username = '$username' and
password = '$password' ";
$query = mysqli_query($conn, $sql_admin);
// echo mysqli_error($conn);
if(mysqli_num_rows($query) > 0){
while($row = mysqli_fetch_assoc($query)){
$_SESSION['auth'] = true;
$_SESSION['admin'] = $row['username'];
if ($_SESSION['auth'] === true) {
header("Location: [Link]");
exit();
else{
$sql_stud = "SELECT * from students where username='$username' and
password = '$password'";
$query = mysqli_query($conn, $sql_stud);
$row = mysqli_fetch_assoc($query);
if(mysqli_num_rows($query) > 0){
$_SESSION['student-username'] = $row['username'];
$_SESSION['student-name'] = $row['name'];
$_SESSION['student-matric'] = $row['matric_no'];
header("Location:[Link]");
else {
echo"<div class='alert alert-success alert-
dismissable'>
<button type='button' class='close' data-
dismiss='alert' aria-hidden='true'>×</button>
<strong style='text-align: center'> Wrong Username and
Password.</strong>
</div>";
}
}
?>
<div class="container">
<div class="container col-lg-9 col-md-11 col-sm-12 col-xs-12 col-lg-
offset-2 col-md-offset-1 col-sm-offset-0 col-xs-offset-0 ">
<div class="jumbotron login col-lg-10 col-md-11 col-sm-12 col-xs-12">
<!-- <div class="alert alert-success alert-dismissable">
<button type="button" class="close" data-dismiss="alert"
aria-hidden="true">×</button>
<strong>Warning!</strong> Better check yourself, you're not
looking too good.
</div> -->
<p class="page-header" style="text-align: center">LOGIN</p>
<div class="container">
<form class="form-horizontal" role="form" method="post"
action="[Link]" enctype="multipart/form-data">
<div class="form-group">
<label for="Username" class="col-sm-2 control-
label">Username</label>
<div class="col-sm-10">
<input type="text" class="form-control"
name="username" placeholder="Enter Username" id="username" required>
</div>
</div>
<div class="form-group">
<label for="Password" class="col-sm-2 control-
label">Password</label>
<div class="col-sm-10">
<input type="password" class="form-control"
name="password" placeholder="Enter Password" id="password" required>
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-10">
<input type="submit" class="btn btn-info col-lg-4"
name="submit" value="Sign In">
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<script type="text/javascript" src="js/[Link]"></script>
<script type="text/javascript" src="js/[Link]"></script>
<script type="text/javascript" src="js/[Link]"> </script>
<?php if (isset($alert_user)) { ?>
<script type="text/javascript">
swal("Oops...", "You are not allowed to view this page directly...!",
"error");
</script>
<?php } ?>
</body>
</html>
SMART LIBRARY MANAGEMENT
8.2 SCREEN SHOTS
4.0 Return Book The process of Confirmation of Admin If there is a
returning books book Student book
by return
return
students must be Update number of process
done based on books done.
the
deadline by the
admin.
5.0 Fine Fines will be Calculation of finesAdmin Daily
Calculation imposed on Confirmation of Student
fines
students who do
not return the book by the deadline. Return book
6.0 Report Allow admin and
student to see the report on the
Registered Admin Daily
library system.
student by Student
semester
Requested book
by faculty
Total book
available by
faculty
High level requirement
This system uses Sublime Text 3 as a text editor to facilitate the coding process with its
functionality with plugins. Xampp server and MySQL server were used to store
the database for this project. XAMPP is a software package that includes Apache
web server, MySQL database, PHP, and Perl. It provides a convenient way to set
up a local web development environment on your computer. MySQL is a popular
open-source relational database management system (RDBMS) that is included in
XAMPP. The framework used is Bootstrap, which can simplify and speed up web
development on the front end.
Design and development
Student and book list on admin site
Figure 3. below is the report of the student list that is registered. At this interface, admin
can manage student, whether want to update student as inactive or delete the student. set
as inactive.
Figure 3. Student List Report
Figure 4. below is the report of the registered book list. At this interface admin can manage
books, whether admin wants to update the book as not available or delete and edit details of
the books.
Figure 4. Book List Admin Site
a. Book list on student site
Students can see the available book on the page in Figure 5. interface. This page only
displayed the available book for the student unless they searched for the books.
Figure 5. Book List on Student Site
b. Requested book on admin and student site
The status will be shown as pending or rejected. For admin, they can reject or cancel reject
for the book. At the same time, the student can cancel the request. Both interfaces are
shownin Figure 6. and Figure 7.
Figure 6. Pending and Reject List on Student Site
Figure 7. Pending and Reject List on Admin Site
If the request gets approval from the admin, then the list of the requested book will
be recorded in both sites, admin and student. The student has to pick up their book,
and admin will update the pickup status; else, the status will be ‘unpick up’. Both
will be shown in Figure 8. at the student site and Figure 9. at the admin site.
Figure 8. Approved List on Student Site
Figure 9. Approved List on Admin Site
After the book has been returned to the library, the status will be changed to
‘returned’; otherwise, status will be ‘expired’ (due to the deadline). At the student
site, the total fine will be shown in Figure 10. And
for admin will be shown in Figure 11.
SMART LIBRARY MANAGEMENT
9. BIBLIOGRAPHY
1. Books and Journals
o Tanenbaum, A. S. (2015). Modern Operating Systems. Pearson Education.
o Sommerville, I. (2019). Software Engineering. Pearson.
o Pressman, R. S. (2020). Software Engineering: A Practitioner's Approach. McGraw-Hill.
2. Research Papers and Articles
o Smith, J. (2021). "Digital Transformation in Library Management." Journal of Library
Science, 45(3), 125-140.
o Gupta, R. (2020). "Automation in Modern Libraries: Challenges and Solutions."
International Journal of Information Management, 52, 202-210.
3. Web Sources
o World Wide Web Consortium (W3C). (2023). "Web Technologies for Library Systems."
Retrieved from [Link]
o PHP Documentation. (2023). "PHP for Web Development." Retrieved from
[Link]
o MySQL Reference Manual. (2023). "Database Management with MySQL." Retrieved
from [Link]
o Bootstrap Framework. (2023). "Responsive Design in Library Management Systems."
Retrieved from [Link]