📚 Library Management System - RESTful API with Interactive UI

A full-stack web application that allows users to manage a library of books using a RESTful API (Flask + MySQL) with an interactive frontend (HTML, CSS, JavaScript).

📥 Book Management (CRUD)

📖 Issue/Return Tracking

📊 Dashboard with Charts (Chart.js)

🔐 User Login System

🧩 Clean Admin Dashboard UI

🚀 Features Module Description 🔐 Login Secure login for admin using hashed credentials 🏠 Dashboard Displays total books, borrowed, overdue + interactive chart 📘 Manage Books Add, edit, delete books with availability toggle 📖 Issue Books Issue books to members with return date tracking 📊 Chart.js Weekly visitors and borrowers bar graph 💾 MySQL Storage All records persist via a MySQL database

📁 Project Structure

Task_2/ ├── app.py

├── db_config.py

├── schema.sql

├── templates/

│ ├── login.html

│ ├── dashboard.html

│ ├── books.html

│ ├── issues.html

├── static/

│ ├── styles.css

│ └── scripts.js

└── README.md

📸 Preview

---

---

🖼️ Screenshots

Tech Stack ▸ Frontend: HTML, CSS, JavaScript, Bootstrap, Chart.js ▸ Backend: Python Flask ▸ Database: MySQL

🛠️ Setup Instructions

1. Clone this repo git clone https://github.com/your-username/library-system.git cd library-system

2. Install dependencies pip install flask mysql-connector-python

3. Configure the database ▸ Start MySQL server ▸ Create DB and tables:

mysql -u root -p < schema.sql

Or manually run:

CREATE DATABASE library_db; USE library_db; -- then run schema.sql contents

4. Set your MySQL credentials in db_config.py

return mysql.connector.connect( host="localhost", user="your_mysql_user", password="your_mysql_password", database="library_db" ) 5. Run the Flask app python app.py

6. Login URL: http://127.0.0.1:5000/login Default credentials: Username: admin Password: password123

🧠 Future Improvements 🔍 Search/filter for books and issues 📅 Due date reminders 👩‍🏫 Member management system 🧾 Export to CSV/PDF

Authentication: Session-based login 👩‍💻 Author Kritika Gupta 🔗 Linkedin- www.linkedin.com/in/kritika-gupta-000941367

📧 k21ritikasuvi2106@gmail.com

🚀 Github- https://github.com/ksuvii21

📜 License This project is licensed under MIT.

---

🔧 Want Me To:

• Generate a banner or thumbnail preview for GitHub?
• Add a requirements.txt?
• Write your commit messages in style?