Overview
A full-stack web-based library management system built with PHP and MySQL. The system provides a complete suite of CRUD (Create, Read, Update, Delete) operations, allowing users to efficiently manage, catalog, and track books within their personal library.
What it does
- Manages a persistent MySQL database storing book metadata (titles, authors, ISBNs, genres).
- Implements backend validation logic to ensure data integrity during insertions and updates.
- Offers a responsive frontend UI built with HTML, CSS, and JavaScript that dynamically interacts with the backend.
Why it’s interesting
This project served as a comprehensive introduction to full-stack web development and relational databases. It highlights my ability to connect a frontend interface to a backend server, safely execute SQL queries, and design an intuitive user experience with responsive design principles.
Key Technical Points
- Full-Stack Integration: Bridged the gap between the frontend UI and the MySQL database using server-side PHP scripts.
- Data Validation: Enforced backend validation rules to prevent incorrect or malicious data from being inserted into the database.
- Responsive UI: Designed a user-friendly interface that adapts to various screen sizes.
Tech Stack
Frontend: HTML, JavaScript, CSS
Backend: PHP, MySQL