📚 Library Management System

This is a web-based Library Management System developed during my internship at Tequed Labs. It provides features to manage users, books, and book issuing efficiently using PHP and MySQL.

---

🔍 Features

• 👤 Admin and User Login System
• 📖 Add / View / Delete Books
• 👥 Add / View / Delete Users
• 🔄 Issue and Return Books
• 📨 Book Request & Approval System
• 📊 Admin and User Dashboards
• 🖼️ Image Upload for Books and Users

---

🛠️ Tech Stack

• Frontend: HTML, CSS
• Backend: PHP
• Database: MySQL
• Local Server: XAMPP (Apache & MySQL)

---

🚀 How to Run This Project

1. Setup Environment

• Download and install XAMPP
• Start Apache and MySQL from XAMPP Control Panel

2. Place Project in XAMPP Directory

Move the LibrarySystem folder into: C:\xampp\htdocs\

3. Import the Database

• Open http://localhost/phpmyadmin
• Create a new database (e.g., librarydb)
• Import the library_managment.sql file from the project
• Use utf-8 as the character set during import

4. Run the Application

Visit this URL in your browser: http://localhost/LibrarySystem/

---

📁 Project Structure

LibrarySystem/
├── images/                     # Uploaded images
├── uploads/                    # Uploaded documents
├── style.css                   # CSS styling
├── index.php                   # Main landing page
├── db.php / data_class.php     # Database connection
├── loginadmin_server_page.php  # Admin login logic
├── login_server_page.php       # User login logic
├── addbookserver_page.php      # Add book
├── addpersonserver_page.php    # Add user
├── issuebook_server.php        # Issue book
├── requestbook.php             # Book request page
├── approvebookrequest.php      # Admin approval
└── library_managment.sql       # SQL dump file

What I Learned

PHP and MySQL integration

Full CRUD operations on a real-world system

Web-based login and session handling

Building user interfaces with form validation

End-to-end application flow from login to dashboards

📬 Contact

For feedback or collaboration, feel free to reach out:

✉️ Email: mrnishanth07@gmail.com

🧑‍💻 GitHub: @NishanthGowda007