Library Management System in PHP/MySQLi with Source Code


Hello guys, I have here a Library Management System for E.B Magalona National High School this is a system that I created together with my friends, it is written using PHP/MySQLi. This system is useful for some beginners who what to learn PHP cause this system has five basic important functions such as Add, Edit, Delete, View or Display Data and search.

Source Code Update Info

This source code was originally developed using PHP/MySQL which result in some errors occurs when running the project in higher versions of PHP such as the PHP7. As of now December 4, 2020, the source code is now written using PHP/MySQLi.

*Original Source Code was Submitted: 2014-03-27
*Updated Source Code: 2020-12-04


The Library Management System using PHP/MySQLi as I have said above it was developed for E.B. Magalona National High School. This system helps to manage the books and borrowing transactions of the said school. The Librarian user is in charge of managing the system data such as the book's details, members' details, and members' borrowing transactions.

This system has many features such as:

  • Book records management
  • Report Generation (Book Inventory)
  • Auto search of data in the table
  • Filtering of book data by its status
  • Advance search of books
  • Borrow and Return books function
  • A combo box with a search bar for searching members
  • Book deduction if borrowed

The system has a user-friendly interface which makes this PHP Project easy to use. This was developed also using HTML, CSS, JavaScript, and Bootstrap for the design. I hope this Library Management System will help you with your project. Download the Source Code to have a better understanding and have an actual experience for the functionalities of the system. Follow the instruction below on how to run this project.

How to Run

  1. Download the source code and extract the zip file.
  2. Download or set up any local web server that runs PHP script.
  3. Open the web-server database and create a new database name it "eb_lms".
  4. Import the SQL file located in the "db" folder of the source code.
  5. Copy and paste the source code to the location where your local web server accessing your local projects. Example for XAMPP('C:\xampp\htdocs')
  6. Open a web browser and browse the project. E.g [http://localhost/eb_magalona_lms]

Default Access

Email: admin
Password: admin

Happy Coding :)

Installation Demo

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 bysyntax_error413 (not verified)on Sun, 03/30/2014 - 13:58

sir can u email the complete database of this project.,tnx sir :) more power to you..
Submitted byasadcron Wed, 04/09/2014 - 09:43

Bro i have already developed LMS in .NET with MYSQL Database but i have no much idea about php with mysql how to open this project or start it... any help will be appreciated Thanx
Submitted byakesanon Tue, 05/27/2014 - 22:34

Hello, great job you did there, great design too. Can i please have the full project, with the user login and book reservation? I am learning php, and i want to be able to develop something like this. Please write an e-mail where i can contact you further on. Thank you.
Submitted bysapayan (not verified)on Sat, 07/12/2014 - 09:52

can u upload sir the full database tnx..
Submitted byWish (not verified)on Sat, 11/08/2014 - 12:25

Hi, Thanks for your LMS. but i cannot run it . error : "Unknown database 'eb_lms'" Please help
Submitted byHarsh Agarwal (not verified)on Tue, 02/28/2017 - 15:06

In reply to by Wish (not verified)

Create a database with the name "eb_lms" After that import the database from EB_Magalona_LMS/eb_lms
Submitted byAnonymous (not verified)on Tue, 12/09/2014 - 14:34

hi, great design. can you upload the full database... thanks
Submitted byQuinn (not verified)on Sat, 12/20/2014 - 05:09

When I click on the admin tab it says unknown database 'eb_lms' . What did I do wrong?
Submitted byzemzen (not verified)on Mon, 04/30/2018 - 20:00

In reply to by Quinn (not verified)

Create a database with the name "eb_lms" After that import the database from EB_Magalona_LMS/eb_lms
Submitted byreniel (not verified)on Thu, 02/05/2015 - 15:01

sir. thanks for this codes and it is very helpful sir. can i use this code for my thesis? i need your permit po thanks a lot :)

Hi, Thanks for your LMS. but i cannot run it . error : Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\AppServ\www\lms\librarian\header.php:10) in C:\AppServ\www\lms\librarian\index.php on line 35 Please help
Submitted byHerAryan (not verified)on Tue, 06/23/2015 - 10:16

Thank you so much! I wish you the best luck in the world, this helped me sooo muchh.
Submitted byrashad faizi (not verified)on Tue, 01/12/2016 - 00:59

please send me some one the full database of this project
Submitted bymk16on Wed, 01/20/2016 - 03:47

Hello po, can u please email the complete database of this project.,thank you po sir :) more power to you..
Submitted byAnonymous (not verified)on Mon, 02/22/2016 - 15:24

The database is located in the db folder all you have to do is to import it in your phpmyadmin mysql where your databases are located. run it by starting your Apache and MySQL in Xampp control and type localhost/name of folder in the browser. :)
Submitted bysanyasirao (not verified)on Sun, 10/22/2017 - 23:34

Dear sir i have seen in library management limit per day but i want limit per user how to solve please help me

Submitted byTushar thube (not verified)on Mon, 03/12/2018 - 18:26

Sir documentation please send
Submitted byvijkay singh (not verified)on Mon, 04/16/2018 - 21:14

do we get all of the source codes and database

can you upload the newer version of a databases? please T_T use the latest version of xammp please :(

Submitted bykagumba jesse (not verified)on Sun, 04/26/2020 - 02:49


Add new comment