ABSTRACT
The Web-Based Library Management System is a modern solution designed to streamline and
enhance the management of library resources, services, and operations. This system is
developed using PHP and MySQL, which are widely used web technologies, to ensure
scalability, reliability, and user-friendliness. The primary goal of this system is to facilitate
efficient library management while providing users with easy access to the library's resources.
Key Features:
User Management: The system offers user registration and authentication features, allowing
library patrons to create accounts and access their personal profiles, including borrowing
history and due dates. Catalog Management: Librarians can add, update, and categorize books,
journals, and multimedia materials, along with associated metadata such as author, genre, and
ISBN. Borrowing and Return: Patrons can search for available materials, check them out, and
set return dates. Automatic reminders are sent to users to ensure timely returns. Reservation
System: Users can reserve materials that are currently unavailable, ensuring they can borrow
them as soon as they become available. Fine Management: The system automates fine
calculation and notification for overdue materials, helping the library maintain financial
records and encourage prompt returns. Reporting and Analytics: Administrators have access to
comprehensive reports and statistics, enabling them to make informed decisions regarding
resource allocation and collection development. Multi-Platform Access: The system is
accessible via web browsers, ensuring users can access library resources and services from
any internet-connected device. Security and Access Control: Role-based access control
ensures that only authorized personnel can perform administrative tasks, enhancing data
security. Mobile-Friendly Interface: The system offers a responsive design that adapts to
various screen sizes, making it accessible on smartphones and tablets. Integration with
External Systems: The system can be integrated with external databases, ensuring that catalog
information and user data remain synchronized. The Web-Based Library Management System
harnesses the power of PHP and MySQL to provide a reliable and efficient platform for
libraries of all sizes. With its user-friendly interface and robust functionality, it enhances the
overall library experience for both patrons and staff, facilitating better resource management
and accessibility.
INTRODUCTION
When looking for a book in the university library, students are advised to first determine
which category the book falls under and then search through the books in that category one by
one. While students may borrow books for an extended period of time, it can be difficult to
keep track of renewal dates, and exceeding the loan term will result in a fine that may be as
costly as purchasing a used book. To address these issues, some university libraries, such as
Abo Academy Library, offer the ability to search for books online and display their location
on the shelves. However, the system is not row and column specific, and reminders are sent
via email rather than an internal messaging system. The objective of this project was to
introduce and expound upon specific theoretical concepts that relate to a domain known as
Koha. Koha, in particular, presents a means of minimizing maintenance costs. To achieve this
objective, the project sought to create a website that can support both PHP and MySQL.
Additional features were also incorporated alongside the basic functions.
- Display the exact location of books in the search result.
- Support the used book store.
- Integration between email service and subscriptions.
- Provide top 10 ranking.
The selection of this particular solution is due to the fact that PHP has the ability to be
integrated within HTML, as well as its various components.
The script being open source means that the developer is not required to the initial code. While
the process of installation has been addressed, it is important to note that source code should
not require any additional funds. The emphasis is placed primarily on experimental research.
The process of negotiating with banks is integrated into the shopping cart system.
Development tools are provided as a feature for installation. Following the installation, the
project is constructed.The components of the site are exhibited individually, with each one
being presented at the conclusion of the display.
1- Internet Information Services 7.5 (IIS 7.5)
Microsoft IIS is used as the web server in this project, although like many other web servers, it
is the most widely used web server after Apache and does not require any complex
configuration before using it. More importantly, after the release of IIS 6.0, Microsoft's
security has been significantly improved, especially when combined with the .net
environment, where collaboration is almost impossible and the security is very good.
1.1 Features
The difficulty of tools directly affects some users, especially web delivery tools. After all,
many companies want to have their own websites, but you don't want to hire a paid webmaster
to maintain them. Therefore, companies should use tools that make creating a website
relatively easy. It's easier to use IIS as a web server, run it, and publish the website and its
graphical combination. There are different languages used to create websites or forums, such
as B.ASP, PHP, JSP and other languages. Running ASP on IIS is quite stable, especially in a
.net environment. However, after complication and changing settings, PHP is only supported
on Windows 7.
The FTP server, Web management tools, and World Wide Web services are set up and
running before configuring IIS. This module is set up to support PHP. It is added to IIS and
the executable options are linked to the php-cgi.exe location. After installing PHP on your
local server.
1.2 Application pool
The application pool was proposed after the release of IIS 6.0 to support the design of high-
performance web applications. It associates one or more applications with one or more groups
of processes. These combinations can effectively avoid redundancy when a website consumes
too much memory. The website is assigned to a separate application group in the project,
namely. Once the website is started, a separate process named w3wp.exe is created in the
system. Even if the website stops for some reason, it will not affect other websites running on
the same web server. Problems can arise if each site uses a separate suite of applications. The
server will be overloaded with users. At the same time, the server needs to allocate more
memory and CPU usage. However, for a powerful local server, using a separate application
pool is the best option to provide users with strong server performance regardless of system
resources.
1.3 Security
It is particularly important to install IIS web server patches in a timely manner because
security patches affect system security. Microsoft's official website frequently releases the
latest security patches. For this reason, the server used in this project is guaranteed to be
updated weekly. The root directory is FTP.
Specially designed for logical drives to prevent hacker attacks and harden the system.
Additionally, the default FTP port is changed to 21 and registration is enabled in case of server
exception.
2- Hypertext Preprocessor (PHP)
2.1 What is PHP?
PHP is an open-source software that is widely used in web development. It is a general-
purpose programming language that is particularly suited for creating web pages. HTML can
be included in PHP. A developer can create a homepage by using both PHP and HTML. When
a visitor reaches the index page, the server executes the PHP command and sends the results
of the execution to the visitor's browser. The advantage of PHP is that it supports most popular
platforms and can run on multiple versions of Windows and UNIX without requiring any pre-
processing. It is also very fast and does not need mod_perl to set the server memory image.
Additionally, PHP consumes very few resources and does not need to call external binary code
or files, which means that the server does not bear any additional burden. Aside from running
web pages, PHP has many other uses. PHP and HTTP are able to work together seamlessly.
Management of cookies and digital signatures can be easily done through modifications in
settings, allowing for a smooth connection to the database. A specialized development
environment is not required for PHP, as the code is enclosed in <? Php and?> tags. Although
PHP can be configured to work with tags and even in ASP format, it cannot do so within the
same file. Pascal and PHP share a resemblance in their programming languages. Unlike other
languages, PHP doesn't require variable declaration before use and it is uncomplicated to
create arrays and hash tables. Additionally, PHP offers object-oriented features to organize
and package the source code.
2.2 Installing PHP on Windows
As an open-source language, PHP can be easily obtained from the Official PHP website in the
form of Windows Binaries. The version of PHP utilized in this particular project happens to be
5.2.0. Before anything else, the 5.2.0 zip file was downloaded and extracted onto the local
hard drive. To allow PHP to connect to the local database, certain extensions were enabled
within the php.ini script file, including the mastering extension., gd2 and MySQL. In the next
place, Index. Php It is added to the IIS default library so that the server can recognize the php
file the file located in the root of the web server once a visitor accesses the IP address or DNS
name.
Figure (1) a sample test file
The success of the installation was tested by creating a file called info. Php which is As shown
in Figure 1, the file is placed in the default website folder and browser Showed the result by
typing http://localhost/info.php. Localhost is the DNS name of the local IP address.
3- MySQL
MySQL was owned and supported by the Swedish company MySQL AB, where it is now
owned by Oracle, MySQL is free, open source, and non-profit Projects. For commercial use,
developers need and pay a licensing fee Versions provide additional functionality.
3.1 What is MySQL?
MySQL is a relational database management system (RDBMS) that acts as a File A server and
provides multi-user access to a large number of databases. MySQL is designed with three
principles in mind: performance, reliability, and precise ease of use. Following these
principles, a low-cost, distinctive, fast and efficient DBMS has been created, making MySQL
an ideal tool for developers and administrators to support and customize complex applications.
Key features include.
Performance
In an RDBMS, the speed of query execution and the speed of returning results to a file is very
important MySQL is very fast and sometimes excessively fast executes Big Orders faster than
other competitors MySQL Standards. The official website states that other databases
Microsoft SQL Server 2000 and IBM DB2 .Open source MySQL Developer (MySQL AB) is
a strong proponent of open source and under the General Public License (GPL) They support
the unrestricted use of MySQL.Users can download and modify the source code to meet their
application needs, they are free to use it to enhance their applications.
Reliability
In many cases, the higher the performance of a database, the lower its reliability. This is not
the case with MySQL. This is because MySQL provides maximum reliability, uptime and a
wide range of demanding applications: MySQL's huge user base helps to quickly find and
solve problems, and any faults that do exist can be tested on the software in different
environments. In addition, internal testing and testing of fail-safes should be performed for
each new version of MySQL.
Portability
MySQL can run on UNIX and non-UNIX operating systems, including Linux, Solaris,
FreeBSD, OS/2, MacOS, and Windows. It supports Intel x86, Alpha, SPARC, PowerPC,
IA64, and 386 series platforms, including low- to high-end Pentiums, as well as IBM zSeries
devices and mainframes.
3.2 Installing MySQL on Windows
We simply downloaded the Windows MySQL installer and installed it on the local hard disk.
The following settings are configured in MySQL Server:
- Server type
- Using the database
- Paths in InnoDB tablespace
− Number of concurrent connections
− TCP/IP Networking
− Server SQL mode
− Default character set
− Windows Service
− Security.
Once the MySQL server was configured, the configuration was done in the Configuration file.
The service was then started and the security settings were applied. By default, the server used
the UTF-8 character set. This set is widely used. Format conversion with encoding for the
World Wide Web, which accounts for more than half of all web pages.
SYSTEM AND DEVELOPMENT TOOLS
In developing the site, four components had to be added to the system. First, a suitable
operating system supporting Microsoft IIS 7.5 was required and the web pages had to be
hosted on a PHP-based IIS server. Secondly, a database engine and software was selected to
easily handle the database construction. Next, the development process is carried out using a
suitable text editor. Finally, the site is developed and distributed using a web development
application.
4.1 Operating System
Programming was done on one computer running Windows 7 Final order; the Home edition
was not chosen because it does not support the IIS Internet database; IIS 7.5 features are
presented in Chapter 2. Finally, implementation, the PHP site was tested on two computers,
Windows 7 and Ubuntu, using IE, Chrome and Firefox.
4.2 PhpMyAdmin
This project uses phpMyAdmin, an open source tool written in PHP, as a database
management tool. It provides web database management instead of implementing a traditional
system.
In order to access phpMyAdmin from a local host, the following configuration in the
config.inc.php file was changed:
Figure (2) Configure files using config.inc.php
The successful of installation was tested by typing http://127.0.0.1/phpMyAdmin.
4.3 EditPlus
The basic code for a PHP website is written in EditPlus EditPlus is a 32-bit functional A-
translator that can handle text, HTML and almost any programming language The reasons for
choosing EditPlus are HTML support, CSS support and PHP support. It also offers the
following features for creating projects Accelerated development process. The following
features are available:
- Fast boot
- Syntax highlighting support
- Complete support code
- Good project management
- Built-in browser.
4.4 Dreamweaver
After compiling the PHP site, the layout was developed using Dreamweaver CS5.After the
release of Dreamweaver CS5 it became a content management system CMS is getting better
and better support and PHP is not only programmer in documentation code hints can be used
to find custom features, they can also be used to develop better CMS templates. In addition to
these features, Dreamweaver CS5 has other new features, such as the built-in Browser Lab
network service, which allows developers to connect to a tester's web browser while using
another browser to check the layout. To test the compatibility of PHP sites in different
browsers, the Webkit engine is now enabled, which can emulate Safari, Chrome, and Preview
Planning. This reduces the resources required for layout testing.
