LIBRARY MANAGEMENT SYTEM

MINI PROJECT REPORT

Submitted by

SIBIAH R(953623205050)

SOBIKA JOLEEN G J(95323205051)

In partial fulfillment for the award of the degree of

BACHELOR OF TECHNOLOGY

RAMCO INSTITUTE OF TECHNOLOGY

DEPARTMENT OF INFORMATION

TECHNOLOGY RAJAPALAYAM-626

108

ANNA UNIVERSITY: CHENNAI 600 025

 BONAFIED CERTIFICATE

Certified that this Report titled “LIBRARY MANAGEMENT SYSTEM” is the bonafide
work of Sibiah R(953623205050),Sobika Joleen G J(953623205051) who carried out the
work under my supervision. Certified further that to the best of my knowledge the work
reported herein does not form part of any other thesis or dissertation on the basis of which a
degree or award was conferred on an earlier occasion on this or any other candidate.

SIGNATURE SIGNATURE
Mrs. A. Alagulakshmi Dr. V. Anusuya
SUPERVISOR HEAD OF THE DEPARTMENT
Assistant Professor, Associate Professor,
Department of Information Technology, Department of Information
Technology, Ramco Institute of Technology Ramco Institute of Technology
Rajapalayam-626 112. Rajapalayam-626 117.
 DECLARATION

We hereby declare that the project work entitled “Library Management System ” has
been submitted by me, Sibiah R(953623205050),Sobika Joleen G J(953623205051) in
the partial fulfilment of the requirement for the award of the degree of Bachelor of
Technology – Information Technology. We further declare that the contents, statements
and other relevant matters are true to the best of our knowledge.

Place : Rajapalayam. Sibiah R

Date : 24/ 05/2025. Sobika Joleen G J

 DEPARTMENT OF INFORMATION TECHNOLOGY
RAMCO INSTITUTE OF TECHNOLOGY
RAJAPALAYM-626 117.

ACKNOWLEDGEMENT

First and foremost, I express my utmost gratitude to our Chairman, Shri. P.R.
Venketrama Raja, B.E., MBA., for his remarkable support and encouragement toward
the improvement of the college.

I extend my sincere thanks to our respected Principal In-charge, Dr. L. Ganesan,

M.E., Ph.D., for the support rendered toward my project work.

I am deeply grateful to our Vice Principal, Dr. S. Rajakarunakaran, M.E., Ph.D.,

for his valuable support in the successful completion of my project.

I am also indebted to Dr. V. Anusuya, M.E., Ph.D., Associate Professor and Head,
Department of Information Technology, for providing the necessary lab facilities to
complete my work.

I convey my heartfelt thanks to my project supervisor, Mrs. A. Alagulakshmi,

B.Tech., M.E., Assistant Professor, Department of Information Technology, for her
continuous guidance and support throughout the project work.

I am very much thankful to all the staff members of the Department of Information
Technology for the various ways in which they supported me during the completion of my
project.

Last but not least, I extend my sincere thanks to my friends and family members for
their unwavering support and encouragement throughout my project journey.

Signature
 ABSTRACT

The Library Management System is a simple and efficient solution designed to

manage everyday library operations smoothly. It helps librarians and users keep track of
books, manage member registrations, and handle lending and returns with ease.
Traditional manual processes can be time-consuming and error-prone, but this system
streamlines key tasks to save time and improve accuracy. Core features include cataloging
of books, issuing and returning of items, due date tracking, and automatic fine calculation.
Users can search for books, check availability, and view their borrowing history through a
clean and easy-to-use interface. Librarians can manage inventory, track overdue books,
and generate basic reports for daily operations.The system is accessible through a web-
based platform, making it easy to use and maintain without the need for complex
infrastructure. It is ideal for libraries looking for a reliable and cost-effective way to
digitize their services and improve user experience.
 TABLE OF CONTENTS

Chapter No. Contents Page No

1
1 Introduction
1
1.1 Problem Definition
2
2 System Requirements
2
2.1 Hardware & Software Requirements
3
2.2 Software Requirements Specification(SRS)
5
3 Implementation
3.1 5
Database structure
3.2 7
ER Diagram
7
3.3 Query
10
3.4 Code
20
4 Experimental Results
20
4.1 Output Screens
28
5 Conclusion
6 29
References
 1. INTRODUCTION

In today’s digital world, managing library operations efficiently is more important than
ever. Libraries deal with a wide range of tasks including book cataloging, issuing and
returning of books, member management, and keeping track of inventory. Traditional
manual methods can be time-consuming, prone to errors, and difficult to scale as the
number of books and users grows.

This project, titled "Library Management System", is designed to simplify and

automate the day-to-day operations of a library. The goal is to create a user-friendly,
reliable, and cost-effective software solution that helps librarians manage resources more
efficiently and provides users with easy access to library services.The system supports
common library functions such as registering members, issuing and returning books,
searching for available titles, and calculating late fines. It also helps administrators
monitor book inventory, view usage reports, and maintain records—all through a
centralized web-based interface.

1.1 PROJECT DESCRIPTION

This project is focused on developing a simple and efficient Library Management

System that automates the essential tasks involved in managing a library. The system
enables administrators to handle member registration and management, maintain and update
the book catalog, and oversee the issuing and returning of books while keeping track of due
dates and availability. It also includes automatic fine calculation for overdue returns and
provides a user-friendly search function to locate books by title, author, or category. In
addition, the system can generate reports that offer insights into borrowed books, overdue
items, and overall inventory status.Designed with a modular architecture, the system is easy
to maintain and allows for future enhancements. It includes a secure login feature for both
administrators and users and can be deployed either on a local server or in the cloud,
depending on the library’s preferences. By replacing manual methods with a digital
platform, this Library Management System improves operational efficiency, reduces the

1
likelihood of errors, and enhances the overall experience for both staff and users.

2
 2. SYSTEM REQUIREMENTS

The Library Management System is designed to operate on a local server environment

using XAMPP, which includes Apache, MySQL, and PHP. Users can access the system
through modern web browsers such as Google Chrome or Mozilla Firefox. It requires basic
hardware specifications, including a dual-core processor, 4 GB of RAM, and at least 250
GB of hard disk space. The system is compatible with both Windows and Linux operating
systems. PHP version 7.0 or above is recommended for running the backend logic, while
MySQL is used for handling the database operations. The frontend is developed using
HTML, CSS, and JavaScript to ensure a user-friendly interface. Secure login functionality
is provided for both admin and student users to prevent unauthorized access. Additionally,
the system supports data backup and restoration through phpMyAdmin. The application is
also designed to be responsive, ensuring proper display and usability across desktops and
tablets.

2.1 HARDWARE & SOFTWARE REQUIREMENTS

Hardware Requirements

Component Specification

Processor Intel Core i3 or higher

RAM 4 GB minimum

Hard Disk 250 GB or more

Display 1024 × 768 resolution or higher

Input Devices Keyboard, Mouse

3
Software Requirements

Software Description

Operating System Windows 10 / 11 or Linux

Web Server Apache (via XAMPP)

Database MySQL (via XAMPP)

Scripting Language PHP

Frontend HTML, CSS, JavaScript

Browser Google Chrome / Mozilla Firefox

Development Tools VS Code / Sublime Text / Notepad++

2.2 SOFTWARE REQUIREMENTS SPECIFICATION(SRS)

2.2.1 INTRODUCTION

The Library Management System allows administrators to manage library resources

and user data efficiently through a web interface. It supports book cataloging, issuing,
returning, user registration, and report generation.

2.2.2 FUNCTIONAL REQUIREMENTS

 Admin login for secure access

 Add/update/delete book records
 Register and manage student records
 Categorize books under Technology, Science, Management
 Issue and return books

4
 Track issued book history
 Display author and admin details
 Generate basic reports (issued books, overdue list)

2.2.3 NON-FUNCTIONAL REQUIREMENTS

 The system should be user-friendly and accessible through a browser

 Response time should not exceed 2 seconds
 Data should be stored securely
 Easy backup and recovery through XAMPP

2.2.4 DATABASE TABLES

1. Book_Details – Stores available books

2. Student_Registration – Stores registered student details
3. Category – Stores category types (Technology, Science, Management)
4. Issued_Books – Tracks issued books and return status
5. Admin_Details – Admin credentials and info
6. Author_Details – Stores author names and info

5
 3. IMPLEMENTATION

 XAMPP: For hosting Apache and MySQL locally

 PHP: For backend scripting
 MySQL: Database to store and retrieve data
 HTML/CSS/JavaScript: For frontend design

3.1) DATABASE TABLE STRUCTURES

 Admin
 id (Primary Key)
 FullName
 AdminEmail
 UserName
 Password
 updationDate
 Authors (tblAuthors)
 id (Primary Key)
 AuthorName
 creationDate
 UpdationDate
 Books (tblBooks)
 id (Primary Key)
 BookName
 CatId (Foreign Key)
 AuthorId (Foreign Key)
 ISBNNumber
 BookPrice
 RegDate
 UpdationDate
 Categories (tblCategory)
6
 id (Primary Key)
 CategoryName
 Status
 CreationDate
 UpdationDate

 Students (tblStudents)
 id (Primary Key)
 StudentId
 FullName
 EmailId
 MobileNumber
 Password
 Status
 RegDate
 IssuedBooks (tblIssuedBookDetails)
 id (Primary Key)
 BookId (Foreign Key)
 StudentID (Foreign Key)
 IssuesDate
 ReturnDate
 ReturnStatus
 Fine

7
3.2) ER DIAGRAM :

3.3) QUERY

1. SET
Definition:
Sets system or session-level variables or modes.
Syntax:
SET variable_name = value;

2. START TRANSACTION / COMMIT

Definition:
Used to start and end a transaction (group of SQL operations that must be executed
together).
Syntax:

8
START TRANSACTION;
-- SQL commands here
COMMIT;
3. CREATE TABLE
Definition:
Creates a new table in the database with specified columns and data types.
Syntax:
CREATE TABLE table_name
( column1 datatype [constraints],
column2 datatype [constraints],
...
);
4. INSERT INTO
Definition:
Adds new records into a table.
Syntax:
INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);
5. ALTER TABLE
Definition:
Modifies an existing table (e.g., add indexes, change columns, add constraints).
Syntax:
ALTER TABLE table_name ADD CONSTRAINT;
ALTER TABLE table_name MODIFY column_name datatype [constraint];

6. AUTO_INCREMENT
Definition:
Used to automatically increment the value of a column (usually the primary key).
Syntax:
column_name datatype AUTO_INCREMENT
9
7. PRIMARY KEY / UNIQUE KEY
Definition:
 PRIMARY KEY: Uniquely identifies each record.
 UNIQUE KEY: Ensures all values in a column are
unique. Syntax:
ALTER TABLE table_name ADD PRIMARY KEY
(column_name); ALTER TABLE table_name ADD UNIQUE
(column_name);
8. ENGINE=InnoDB, DEFAULT CHARSET=latin1
Definition:
Table options specifying the storage engine (InnoDB) and default character set (latin1).
Syntax:
Used within CREATE TABLE:
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
9. ON UPDATE CURRENT_TIMESTAMP / DEFAULT CURRENT_TIMESTAMP
Definition:
Automatically sets or updates a TIMESTAMP column when a record is inserted or
updated.
Syntax:
column_name TIMESTAMP DEFAULT CURRENT_TIMESTAMP
column_name TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
10. COMMENTED QUERIES (using -- or /* */)
Definition:
Comments are used to annotate the SQL code and are not executed.
Syntax:
-- Single-line comment
/* Multi-line
comment */
11. Special MySQL Comments for Version Control

10
 Definition:
Special comments that only execute if the server version is higher than the specified
version.
Syntax:
/*!version_number SQL_statement */;

3.4 CODE:

1) Admin login:

<?php
session_start();
error_reporting(0);
include('includes/config.php');

if ($_SESSION['alogin'] != '') {
$_SESSION['alogin'] = '';
}

if (isset($_POST['login'])) {
$username = $_POST['username'];
$password = md5($_POST['password']);

$sql = "SELECT UserName,Password FROM admin WHERE UserName=:username and

Password=:password";
$query = $dbh->prepare($sql);
$query->bindParam(':username', $username, PDO::PARAM_STR);
$query->bindParam(':password', $password, PDO::PARAM_STR);
$query->execute();

$results = $query->fetchAll(PDO::FETCH_OBJ); if
($query->rowCount() > 0) {
$_SESSION['alogin'] = $_POST['username'];
echo "<script type='text/javascript'> document.location ='admin/dashboard.php'; </script>";
} else {
echo "<script>alert('Invalid Details');</script>";
}
}
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
<meta name="description" content="Admin Login" />
<meta name="author" content="Library System" />
11
 <title>Online Library Management System | Admin Login</title>
<!-- BOOTSTRAP CORE STYLE -->
<link href="assets/css/bootstrap.css" rel="stylesheet" />
<!-- FONT AWESOME STYLE -->
<link href="assets/css/font-awesome.css" rel="stylesheet" />
<!-- CUSTOM STYLE -->
<link href="assets/css/style.css" rel="stylesheet" />
<!-- GOOGLE FONT -->
<link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css' />
</head>
<body>
<!-- MENU SECTION START -->
<?php include('includes/header.php'); ?>
<!-- MENU SECTION END -->

<div class="content-wrapper">
<div class="container">
<div class="row pad-botm">
<div class="col-md-12">
<h4 class="header-line">ADMIN LOGIN FORM</h4>
</div>
</div>

<!-- LOGIN PANEL START -->

<div class="row">
<div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
<div class="panel panel-info">
<div class="panel-heading">
LOGIN FORM
</div>
<div class="panel-body">
<form role="form" method="post">
<div class="form-group">
<label>Enter Username</label>
<input class="form-control" type="text" name="username" autocomplete="off"
required />
</div>
<div class="form-group">
<label>Password</label>
<input class="form-control" type="password" name="password" autocomplete="off"
required />
</div>
<button type="submit" name="login" class="btn btn-info">LOGIN</button>
</form>
</div>
</div>
</div>
</div>
<!-- LOGIN PANEL END -->

</div>
</div>
12
 <!-- FOOTER SECTION -->
<?php include('includes/footer.php'); ?>
<!-- FOOTER SECTION END -->

<!-- SCRIPTS -->

<script src="assets/js/jquery-1.10.2.js"></script>
<script src="assets/js/bootstrap.js"></script>
<script src="assets/js/custom.js"></script>
</body>
</html>

2) User login:

<?php
session_start();
error_reporting(0);
include('includes/config.php');

if ($_SESSION['login'] != '') {
$_SESSION['login'] = '';
}

if (isset($_POST['login'])) {
$email = $_POST['emailid'];
$password = md5($_POST['password']);

$sql = "SELECT EmailId,Password,StudentId,Status FROM tblstudents WHERE EmailId=:email and

Password=:password";
$query = $dbh->prepare($sql);
$query->bindParam(':email', $email, PDO::PARAM_STR);
$query->bindParam(':password', $password, PDO::PARAM_STR);
$query->execute();
$results = $query->fetchAll(PDO::FETCH_OBJ);

if ($query->rowCount() > 0)
{ foreach ($results as $result) {
$_SESSION['stdid'] = $result->StudentId;
if ($result->Status == 1) {
$_SESSION['login'] = $_POST['emailid'];
echo "<script type='text/javascript'> document.location ='dashboard.php'; </script>";
} else {
echo "<script>alert('Your Account Has been blocked. Please contact admin');</script>";
}
}
} else {
echo "<script>alert('Invalid Details');</script>";
}
}
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
13
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
<meta name="description" content="" />
<meta name="author" content="" />
<title>Online Library Management System | User Login</title>
<!-- BOOTSTRAP CORE STYLE -->
<link href="assets/css/bootstrap.css" rel="stylesheet" />
<!-- FONT AWESOME STYLE -->
<link href="assets/css/font-awesome.css" rel="stylesheet" />
<!-- CUSTOM STYLE -->
<link href="assets/css/style.css" rel="stylesheet" />
<!-- GOOGLE FONT -->
<link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css' />
</head>
<body>
<!-- MENU SECTION START -->
<?php include('includes/header.php'); ?>
<!-- MENU SECTION END -->

<div class="content-wrapper">
<div class="container">
<div class="row pad-botm">
<div class="col-md-12">
<h4 class="header-line">USER LOGIN FORM</h4>
</div>
</div>

<!-- LOGIN PANEL START -->

<div class="row">
<div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
<div class="panel panel-info">
<div class="panel-heading">
LOGIN FORM
</div>
<div class="panel-body">
<form role="form" method="post">
<div class="form-group">
<label>Enter Email ID</label>
<input class="form-control" type="text" name="emailid" required autocomplete="off"
/>
</div>
<div class="form-group">
<label>Password</label>
<input class="form-control" type="password" name="password" required
autocomplete="off" />
<p class="help-block"><a href="user-forgot-password.php">Forgot Password</a></p>
</div>

<button type="submit" name="login" class="btn btn-info">LOGIN</button> |

<a href="signup.php">Not Registered Yet?</a>
</form>
14
 </div>
</div>
</div>
</div>
<!-- LOGIN PANEL END -->
</div>
</div>

<!-- FOOTER SECTION -->

<?php include('includes/footer.php'); ?>
<!-- FOOTER SECTION END -->

<!-- SCRIPTS -->

<script src="assets/js/jquery-1.10.2.js"></script>
<script src="assets/js/bootstrap.js"></script>
<script src="assets/js/custom.js"></script>
</body>
</html>

3) Sign-up page:

<?php
session_start();
include('includes/config.php');
error_reporting(0);

if(isset($_POST['signup'])) {
//Code for student ID
$count_my_page = ("studentid.txt");
$hits = file($count_my_page);
$hits[0]++;
$fp = fopen($count_my_page, "w");
fputs($fp, "$hits[0]");
fclose($fp);
$StudentId = $hits[0];

$fname = $_POST['fullanme'];
$mobileno = $_POST['mobileno'];
$email = $_POST['email'];
$password = md5($_POST['password']);
$status = 1;

$sql = "INSERT INTO tblstudents(StudentId,FullName,MobileNumber,EmailId,Password,Status)

VALUES(:StudentId, :fname, :mobileno, :email, :password, :status)";
$query = $dbh->prepare($sql);
$query->bindParam(':StudentId', $StudentId, PDO::PARAM_STR);
$query->bindParam(':fname', $fname, PDO::PARAM_STR);
$query->bindParam(':mobileno', $mobileno, PDO::PARAM_STR);
$query->bindParam(':email', $email, PDO::PARAM_STR);
$query->bindParam(':password', $password, PDO::PARAM_STR);
$query->bindParam(':status', $status, PDO::PARAM_STR);
$query->execute();
15
 $lastInsertId = $dbh->lastInsertId();
if($lastInsertId) {
echo '<script>alert("Your Registration was successful. Your student ID is '.$StudentId.'");</script>';
} else {
echo "<script>alert('Something went wrong. Please try again');</script>";
}
}
?>

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
<title>Online Library Management System | Student Signup</title>
<link href="assets/css/bootstrap.css" rel="stylesheet" />
<link href="assets/css/font-awesome.css" rel="stylesheet" />
<link href="assets/css/style.css" rel="stylesheet" />
<link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css' />

<script type="text/javascript">
function valid() {
if(document.signup.password.value != document.signup.confirmpassword.value)
{ alert("Password and Confirm Password do not match!");
document.signup.confirmpassword.focus();
return false;
}
return true;
}
</script>

<script>
function checkAvailability() {
$("#loaderIcon").show();
jQuery.ajax({
url: "check_availability.php",
data:'emailid='+$("#emailid").val(),
type: "POST", success:function(data)
{
$("#user-availability-status").html(data);
$("#loaderIcon").hide();
},
error:function (){}
});
}
</script>
</head>

<body>
<?php include('includes/header.php');?>

16
<div class="content-wrapper">
<div class="container">
<div class="row pad-botm">
<div class="col-md-12">
<h4 class="header-line">User Signup</h4>
</div>
</div>

<div class="row">
<div class="col-md-9 col-md-offset-1">
<div class="panel panel-danger">
<div class="panel-heading">
SIGNUP FORM
</div>
<div class="panel-body">
<form name="signup" method="post" onSubmit="return valid();">
<div class="form-group">
<label>Enter Full Name</label>
<input class="form-control" type="text" name="fullanme" autocomplete="off" required
/>
</div>

<div class="form-group">
<label>Mobile Number :</label>
<input class="form-control" type="text" name="mobileno" maxlength="10"
autocomplete="off" required />
</div>

<div class="form-group">
<label>Enter Email</label>
<input class="form-control" type="email" name="email" id="emailid"
onBlur="checkAvailability()" autocomplete="off" required />
<span id="user-availability-status" style="font-size:12px;"></span>
</div>

<div class="form-group">
<label>Enter Password</label>
<input class="form-control" type="password" name="password" autocomplete="off"
required /
> </div>

<div class="form-group">
<label>Confirm Password </label>
<input class="form-control" type="password" name="confirmpassword"
autocomplete="off" required />
</div>

<button type="submit" name="signup" class="btn btn-danger" id="submit">Register

Now</button>
</form>
</div>
</div>
17
 </div>
</div>
</div>
</div>

<?php include('includes/footer.php');?>

<script src="assets/js/jquery-1.10.2.js"></script>
<script src="assets/js/bootstrap.js"></script>
<script src="assets/js/custom.js"></script>
</body>
</html>

4) Dashboard:

<?php
session_start();
error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['login'])==0)
{
header('location:index.php');
}
else{?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
<meta name="description" content="" />
<meta name="author" content="" />
<title>Online Library Management System | User Dash Board</title>
<!-- BOOTSTRAP CORE STYLE -->
<link href="assets/css/bootstrap.css" rel="stylesheet" />
<!-- FONT AWESOME STYLE -->
<link href="assets/css/font-awesome.css" rel="stylesheet" />
<!-- CUSTOM STYLE -->
<link href="assets/css/style.css" rel="stylesheet" />
<!-- GOOGLE FONT -->
<link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css' />

</head>
<body>
<!------MENU SECTION START-->
<?php include('includes/header.php');?>
<!-- MENU SECTION END-->
<div class="content-wrapper">
18
 <div class="container">
<div class="row pad-botm">
<div class="col-md-12">
<h4 class="header-line">USER DASHBOARD</h4>

</div>

</div>

<div class="row">

<div class="col-md-3 col-sm-3 col-xs-6">

<div class="alert alert-info back-widget-set text-center">
<i class="fa fa-bars fa-5x"></i>
<?php
$sid=$_SESSION['stdid'];
$sql1 ="SELECT id from tblissuedbookdetails where StudentID=:sid";
$query1 = $dbh -> prepare($sql1);
$query1->bindParam(':sid',$sid,PDO::PARAM_STR);
$query1->execute();
$results1=$query1->fetchAll(PDO::FETCH_OBJ);
$issuedbooks=$query1->rowCount();
?>

<h3><?php echo htmlentities($issuedbooks);?> </h3>

Book Issued
</div>
</div>

<div class="col-md-3 col-sm-3 col-xs-6">

<div class="alert alert-warning back-widget-set text-center">
<i class="fa fa-recycle fa-5x"></i>
<?php
$rsts=0;
$sql2 ="SELECT id from tblissuedbookdetails where StudentID=:sid and RetrunStatus=:rsts";
$query2 = $dbh -> prepare($sql2);
$query2->bindParam(':sid',$sid,PDO::PARAM_STR);
$query2->bindParam(':rsts',$rsts,PDO::PARAM_STR);
$query2->execute();
$results2=$query2->fetchAll(PDO::FETCH_OBJ);
$returnedbooks=$query2->rowCount();
?>

19
 <h3><?php echo htmlentities($returnedbooks);?></h3>
Books Not Returned Yet
</div>
</div>
</div>

</div>
</div>
<!-- CONTENT-WRAPPER SECTION END-->
<?php include('includes/footer.php');?>
<!-- FOOTER SECTION END-->
<!-- JAVASCRIPT FILES PLACED AT THE BOTTOM TO REDUCE THE LOADING TIME -->
<!-- CORE JQUERY -->
<script src="assets/js/jquery-1.10.2.js"></script>
<!-- BOOTSTRAP SCRIPTS -->
<script src="assets/js/bootstrap.js"></script>
<!-- CUSTOM SCRIPTS -->
<script src="assets/js/custom.js"></script>
</body>
</html>
<?php } ?>

20
 4. EXPERIMENTAL RESULTS

The Library Management System was tested extensively to ensure smooth functionality
across all modules. Admin users were able to log in securely and manage book records,
categories, and student information without any errors. The system successfully handled
the addition and deletion of books, issuing and returning operations, and automatic fine
calculations for overdue books. Students were able to register, search for available books,
and view their borrowing history through a responsive user interface. Each feature was
tested under various scenarios, such as empty form submissions, invalid data inputs, and
concurrent operations. The system consistently returned accurate outputs and maintained
data integrity. The overall performance was fast, with page loading times averaging under
two seconds. Data retrieval and update operations were efficiently handled by the MySQL
database, validating the robustness of the backend.

4.1 OUTPUT SCREEN

 Admin login

21
22
23
 User Login

24
25
 Tables
 Category

26
 Students

 Author

 Admin

 Issue Book Details

27
 Books

28
 5. CONCLUSION

The Library Management System provides a reliable and efficient solution for managing
day-to-day library operations digitally. By replacing traditional manual methods, the
system improves accuracy, reduces time consumption, and minimizes human errors. It
allows administrators to maintain a well-organized book catalog, track issued and returned
books, and manage student memberships with ease. The web-based interface is simple and
user- friendly, making it accessible to all users with basic computing knowledge. Designed
with scalability in mind, the system can be enhanced with additional features such as SMS
alerts, email notifications, and cloud deployment. Overall, this project achieves its
objective of streamlining library management processes and providing a better user
experience for both staff and students.

29
 6. REFERENCES

1. PHP Documentation – https://www.php.net/docs.php

2. MySQL Reference Manual – https://dev.mysql.com/doc/
3. W3Schools – HTML, CSS, and JavaScript Tutorials – https://www.w3schools.com
4. XAMPP Installation Guide – https://www.apachefriends.org/index.html
5. Stack Overflow – Technical Support Forum – https://stackoverflow.com
6. ER Diagram Examples – TutorialsPoint and GeeksforGeeks
7. Open Source Projects on GitHub – Library Management System examples

30