Simple-Library-System

A library management system built using:

• PHP (Frontend UI)
• Flask (Python) – Backend API
• MySQL – Database
• JavaScript – Dynamic table, CRUD, search, sorting, pagination
• HTML & CSS – UI/UX layout and styling

This project provides basic book management features such as adding, editing, deleting, and searching books.
All data is stored in a MySQL database and accessed through a Flask API.

🚀 Features

• Add new books
• Edit existing books
• Delete books
• Search by title, author, or ISBN
• Sorting by table headers
• Pagination with dynamic rows per page
• Real-time total book count
• Modal-based form input
• Error/success alerts

⚙ Backend API (Flask)

• RESTful API
• JSON responses
• MySQL integration
• CORS enabled

💾 Database

• MySQL with:
  • Triggers
  • Stored procedures
  • Views (vw_books_availability)
  • Audit log (books_log