Librarian can perform following major tasks:
• Add borrowers
• search book based on ISBN, title or author
• check in and check out books
• fine management
Language:PHP, HTML, CSS, SQL
Framework: Xampp server, MySQL Workbench
Platform: Xampp, Google Chrome
OS: Microsoft windows 10
Software libraries: -
Software versions: 1.0.0
• To work with library book management,
* put libraryManagementSystem code in the xampp -> htdocs
* load the database in the mySQL workbench
* change the user name and password of the php files according to database credentials
* start xampp Apache module
* Go to Google chrome browser
* add URL: http://localhost/libraryManagementSystem/index.html
• Must be knowledgeable about Database design, standard database queries and PHP
• Performs installation of project in the system
• He has the right to add librarian credentials for different librarians
• Open the browser (preferably Google Chrome)
• Enter the URL: http://localhost/libraryManagementSystem/index.html
• Enter the log in credentials provided by System administrator
• Search book by ISBN, Title, Author name
i. Partial details in Title and Author name is allowed
ii. If ISBN is provided than enter the correct ISBN
• Click on search button
• Book details of related topic will be provided with their availability
• If book is available, check out link is provided, click on it to check out the book
• Provide card id of borrower and click on submit button
• 1 user can only borrow at max 3 books
• If book is already checked out at current time than it will not be available even if on the home page, the availability was true.
• This functionality is provided to see the details of borrowers who have loaned the book
• Enter ISBN of book or Card id of user or name of user
• If given details is available with loaned details, it will display user details, else it will display no book has been loaned with given user or book details and fine details if exist
• If user has borrowed book, the details of all borrowed books has been provided
• You can check in the book and pay fine
• Find user details from view borrower, the details of the borrowed books are provided, click on check in link.
• If pay fine is there in the view borrower, click on the pay fine once user has paid fine. It will update fine database
• Make sure to click on fine link in the navigator every day
• It will refresh the fine details and provide the total fine each user has to pay
• Click on log out at the end of the day to log out from the system