A full-stack PHP + MySQL web application to manage book inventory, student borrowing activity, returns, and admin access control. Built as part of an academic portfolio, this project demonstrates real-world CRUD operations, secure login, and session-based workflows in a self-contained library system.
- 🔐 Admin login/logout system (session-based)
- ➕ Add new books to the inventory
- 📖 View books with author, genre & date
- 📦 Issue books to students
- 📥 Return books and mark as available
- 📋 View issued logs with real-time status (Issued/Returned)
- 📊 Dashboard with total, issued & returned book stats
- 🌓 Dark mode toggle
- 📱 Mobile responsive layout
- 🚀 Optional deployment using Ngrok
- Frontend: HTML, CSS (vanilla)
- Backend: PHP 8.x
- Database: MySQL (via phpMyAdmin)
- Local Server: MAMP (or XAMPP)
- Version Control: Git + GitHub
📌 Here are a few screenshots to give you a glimpse of the application:
- Install MAMP or XAMPP
- Clone the repository:
git clone [https://github.com/rxl895/library-management-system.git](https://github.com/rxl895/library-management-system.git)
- Move the project folder to your MAMP
htdocsor XAMPPhtdocsdirectory. - Start Apache & MySQL from MAMP/XAMPP.
- Import the SQL schema from
sql/database.sqlinto phpMyAdmin. - Visit:
http://localhost:8888(Login with default credentials:admin/admin123unless changed.)
Default:
Username: admin
Password: admin123
