Skip to content

README.md

Latest commit

 

History

History
30 lines (25 loc) · 1.3 KB

README.md

File metadata and controls

30 lines (25 loc) · 1.3 KB
Raw

Library managment system - PHP CRUD

This is a simple web application built with PHP and MySQL to manage the library records. It allows you to Create, Read, Update, and Delete Books and Friends data through a simple user interface.

Features:

  • Login and logout for Admins.
  • Display all Books, Friends, and Borrows in a table.
  • Add new Books, Friends, and Borrows record.
  • Update existing Books and Friends.
  • Return the borrowed books.
  • Delete Books and Friends.

How to Run the Project:

  1. Copy the project files into your local server directory (e.g., htdocs for XAMPP).
  2. Create a new MySQL database, zain_library_db.
  3. Import the SQL file (LMS_DB.sql) into the database using phpMyAdmin or the MySQL command line.
  4. Update the database connection in db_connect.php if needed: 
    $conn = mysqli_connect("localhost", "root", "", "zain_library_db");
// or
$conn = new mysqli("127.0.0.1", "root", "", "zain_library_db");

Open the project in your browser:

Notes:

  • Make sure Apache and MySQL are running before accessing the project.
  • This project enforces referential integrity using foreign key constraints to prevent deleting records that are linked to active borrow entries.