Page 358 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

EXERCISE 62 : Create a project on PHP & MySQL for

online library management

Objectives

At the end of this exercise you shall be able to
• create a project for online library management using PHP & MySQL.

Requirements

Tools/Materials
• PC/Laptop with latest configuration • Apache web server
• Operating system: windows 10 or 11 • PHP
• Text editor • MySQL server
• Web browser

Procedure

Project:
Develop a web-based application to manage a library’s book collection, users, loans, and other functionalities.
Technologies:
Front-end: HTML, CSS, JavaScript (optional)

Back-end: PHP
Database: MySQL
System Modules:
1 User Management:
User registration and login (including different user roles, e.g., admin, librarian, member)

User profile management (update details, password change)
2 Book Management:
Add, edit, and delete book information (title, author, genre, publication date, availability)
Search books by various criteria (title, author, genre, keywords)

View detailed information about each book (summary, reviews, borrowed history)
3 Loan Management:
Borrow and return books (check user eligibility, availability, due dates)
Generate loan reports (individual, overdue, most popular books)
Set and manage loan periods and fines
4 Additional Features (optional):

Book reservation system
Online reading platform for eBooks
User reviews and ratings for books
Recommendations based on user borrowing history

Inventory management (track book condition, purchase new books)

343