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

• Version
• Download 9249
• File Size 24.87 MB
• Create Date July 4, 2017
• Download

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))

Features

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.

You may visit our Facebook page for more information, inquiries, and comments. Please subscribe also to our YouTube Channel to receive  free capstone projects resources and computer programming tutorials.

Hire our team to do the project.