Online Library Website

• Tech Stack: Using HTML, CSS, JavaScript, PHP, MySQL
• Github URL: https://github.com/harvir619/Toy-Library

Users were able to borrow toys from this website and admin was able to check who has loaned,reserved and return. The database “Library” consists of 4 tables which are Toys, Loaned, Reserved and User.

The application is able to
- Keep an inventory of all the toys owned by the library.
- Each user can borrow up to three toys at any time.
- A toy on loan can be reserved by another user. Hence cannot be reserved unless it was loaned.
- The loan period of all toys is seven days.
- If the toy has not been reserved by any other users, the borrower can renew a borrowed toy for up to three times. The borrower can renew the item after 5 days has passed on his loaned period for the toy to stop the user from renewing it way early, giving no chance to other users to reserve the item.
- The status of a reserved toy will be changed to available for loan if the toy is not collected by the requested user within three days.
- Once 7 days have passed the status of the loaned toy will be changed to available since all users are expected to return the toy on the due date. However, users can return the toy before the deadline and staff are able to return it by using the staff account.