Library System using PHP/MySQli with Source Code


Library Management System is a PHP/MySQLi project that can help a certain school library manage their books information and borrow/return transactions of the student. This system has a user-friendly functionality and a pleasing user interface using a certain template for the design. This has the common features that are needed for a library management system. Talking about the system works, this system stores the list of books along with their system required information and also the list of the students. The said list must be populated by the system admin user or the librarian before proceeds to any transaction feature of this system.


  • Students can search for available books to borrow
  • Students can view their transaction
  • Student List Management
  • Book List Management
  • Borrow and Return Transaction

Template Used:

  • AdminLTE


  1. Download the source code using the Download button below.
  2. Extract the downloaded file to your localhost folder ex. htdocs for XAMMP.
  3. Import the included .sql file which is the database of the system. If you have no idea how to import, please refer to my tutorial on How import a .sql file to restore the MySQL database.
  4. After a successful import, open the extracted folder and open conn.php in both the includes folder and in the admin/includes folder. Edit the database name in the connection depending on the name of the database you created in importing the included .sql file.

Accessing the Admin

You can access the admin side by adding /admin/ in the URL. You should be able to navigate to the admin login page.

You can then use the below admin credential:

Username: nurhodelta
Password: password

That's it. You should now be able to run the simple system :)

If you have any suggestions, comments, or reactions, feel free to comment below or message me.

Happy Coding :)

*Updates: 05-21-18

  • Fixed dynamic buttons (edit, delete, etc ) not functioning on page2 or more of table.

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.


Submitted byGale Espejo (not verified)on Tue, 05/07/2019 - 18:52

How do I modify the logo in index.php??? The one with "SourceCodeSter". I really need to change it to Library System, please. Thank you very much.
Submitted bykniazio (not verified)on Wed, 01/26/2022 - 17:08

In reply to by Gale Espejo (not verified)

This can be changed in the files: libsystem \ admin \ includes \ navbar.php libsystem \ includes \ navbar.php
Submitted bykniazio (not verified)on Tue, 01/25/2022 - 14:08

Book cannot be added I get an error Field 'status' doesn't have a default value
Submitted bykniazio (not verified)on Tue, 01/25/2022 - 14:13

You cannot borrow a book I get an error Error! Field 'status' doesn't have a default value
Submitted bykniazio (not verified)on Tue, 01/25/2022 - 20:46

How do I change the date options on the page? I am from Poland and I would like the months to be displayed as: Styczeń, Luty, Marzec, etc.
Submitted bykniazio (not verified)on Thu, 01/27/2022 - 13:16

What are the groups created for? If a report were made of how many books a given group had read then it would make sense. This is the report that is created at school and it would be nice if this function was in the system.

Add new comment