Web Based Library System in PHP, MySQL Free Download Source code

Web Based Library System
  • Version
  • Download 8071
  • File Size 24.87 MB
  • File Count 1
  • Create Date July 4, 2017
  • Last Updated July 4, 2017

Web Based Library System in PHP, MySQL Free Download Source code

Database Schema

tblbook (id, isbn, bookTitle, bauthors, category, publisher, copyrightyear, bsection(circulation, reserved), noOfCopies, dateReceived, dateEncoded, encodedBy)

tblcategory (id, categoryName, description)

tblborrower (id, fname, mname, lname, contact, category (student, teacher,) courseid, image)

tblcourse (id, coursecode, coursename)

tblborrowedbook (id, bookid, borrowerid, dateborrowed, duedate, numCopies, status(returned, not), processedby, datereturned, receivedby)

tblfine (fineamount)

tbluser (id, username, password, fullname, contact, usertype (librarian, staff))


  1. SCRUD (create, update, delete)
  2. Book Info
  3. Category Info
  4. Borrower Info
  5. Course Info
  6. Update Fine Amount
  7. User Info
  8. Process Book Issue for borrowers (borrower can borrow more 1 one book)
  9. View/Print all borrowed book list
  10. View/Print all unreturned book list
  11. View/Print inventory of books
  12. View/Print Borrowers Card (all the books borrowed by the borrower)
  13. View/Print Book Card (list of borrowers who borrowed the book)
  14. Activity Log
  15. Process Fine
  16. View Violation of Students
  17. View/print User Log

Note: Staff can only encode information, can’t delete, update information

Step by step tutorial on how to install the system is also included in the package.



, , , , , , , , , , , , , , ,

Post navigation

3 thoughts on “Web Based Library System in PHP, MySQL Free Download Source code

  1. I can’t run it by the instructions you have given in pdf file including the source code you’ve provided…

    Please, Help me.

    I look forward for your positive response. Thank You!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.