Basic Library System Using PHP with Source Code

Language

This Library System was developed using PHP, HTML, MYSQLi, and jQuery. I used bootstrap as a front-end framework to have a nice design. The system can borrow and return books in a transaction, and also can trace student transaction details. This simple project can help you learn something in creating or developing a web application such as the CRUD Operations and using jQuery and Bootstrap for the front-end. This library system automatically calculates the available books that can be borrowed by the students.

Features:

  • Admin Account(CRUD)
  • Student Account(CRUD)
  • Book Details(CRUD)
  • Borrowing Details
  • Returning Details

How to Run

Requirements

  • Download and Install any local web server such as XAMPP/WAMP.
  • Download the provided source code zip file. (download button is located below)

Installation/Setup

  1. Open your XAMPP/WAMP's Control Panel and start the "Apache" and "MySQL".
  2. Extract the downloaded source code file.
  3. If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP's "htdocs" directory. And If you are using WAMP, paste it into the "www" directory.
  4. Browse the PHPMyAdmin in a browser. i.e. http://localhost/phpmyadmin
  5. Create a new database naming "db_ls".
  6. Import the provided SQL file. The file is known as "db_ls.sql" located inside the "database here" folder.
  7. Browse the Simple Library System in a browser. i.e. http://localhost/LibrarySystem

Login Account:

username: admin
password: admin

DEMO

I hope that this system can help you with what you are looking for. For more updates and tutorials just kindly visit this site.

Enjoy Coding!!

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 SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

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.

Comments

Submitted byhillson (not verified)on Thu, 10/26/2017 - 20:50

this is really good. thanks boss for sharing
Submitted byIyke (not verified)on Mon, 10/30/2017 - 21:24

Nice Work, More Power to your Elbow
Submitted byvperjean (not verified)on Tue, 10/31/2017 - 18:56

Hi - I added the db and connected successfully but still can't login in index.php. Did I miss something. Your help is appreciated.
Submitted bytaf (not verified)on Wed, 11/01/2017 - 23:04

In reply to by vperjean (not verified)

make sure that in the connect.php the password and user for localhost is correct depending on what you are using
Submitted bymedhat (not verified)on Mon, 11/06/2017 - 06:23

Excellent project ... one error only >> when borrowing book , no action in left book , only the first book take action ????
Submitted byAndyJohn (not verified)on Wed, 11/29/2017 - 04:22

Hey. This was awsome! I`m pretty new to this, I`v tried to just do some minor changes for sake of learning, so I`v replaced book with keys. Your original code and the one I`m editing are identical, but when i add 6 different keys and try to "borrow" one, it always chooses the one on the top, no matter whom i check. Have any ideas?
Submitted byAnonymous (not verified)on Sun, 09/18/2022 - 05:01

nice

Add new comment