Library Management System

A full-stack Library Management System built with Node.js, Express, MySQL, HTML, CSS, JavaScript, and Bootstrap.

Features

• Admin login with session authentication
• Dashboard with live library analytics
• Book CRUD operations with MySQL persistence
• Student management with add / edit / delete
• Issue and return workflow
• Transaction history and export to Excel/PDF
• Search, sort, and filter books
• File upload support for book cover images
• QR codes and barcode generation for books
• Responsive Bootstrap UI

Project Structure

• backend/ - Express API and MySQL integration
• frontend/ - Static HTML pages, CSS, and JavaScript
• database/ - SQL schema and seed data

Setup Instructions

1. Install backend dependencies:

   cd backend
   npm install

2. Create the database and tables:
   • Import database/schema.sql into MySQL.
3. Seed the database:
   • Run database/seed_books.sql in MySQL.
4. Configure environment variables:
   • Copy backend/.env.example to backend/.env
   • Update MySQL credentials and SESSION_SECRET
5. Start the backend server:

   cd backend
   npm start

6. Open the frontend:
   • Navigate to http://localhost:3000/login.html

Default Admin Credentials

• Username: admin
• Password: Admin@123

Notes

• The backend serves the frontend from the frontend/ directory, so pages are accessible at http://localhost:3000/pages/....
• All book and student data is stored in MySQL.
• The application uses sessions to keep the administrator authenticated.

Recommended Tools

• VS Code
• MySQL Workbench
• Postman

License

This project is provided as a college final-year project template. Feel free to customize and extend it.