Book Library Management System

This project is a database-driven library management system built with PHP, MySQL, HTML, and CSS, demonstrating full-stack web development with secure, validated data handling. The application allows users to add, view, update, and delete books with immediate feedback and real-time validation. Key Features: Database Operations: - Add Books: Enter ID, title, author, genre, and publication year with duplicate ID detection and field validation - View Books: Display all entries in a formatted, responsive HTML table with alternating row colors and hover effects - Edit Books: Update selected fields while leaving others unchanged; validates existence and field formats - Delete Books: Remove books safely with validation and success/error feedback Data Validation: - ID: Numeric, ≤3 digits, duplicate/existence checks - Title: Required, ≤20 characters, sanitized input - Author: Required, ≤30 characters, non-numeric - Genre: Required, ≤30 characters - Year: Numeric, 1400–2023 User Interface: - Horizontal navigation menu with hover effects - Styled tables with green headers, striped rows, and responsive width - Form inputs with consistent styling, rounded corners, and error/success messages Technical Implementation: - Server-side validation and sanitization to prevent SQL injection - Real-time database feedback for all CRUD operations - Structured project files separating pages, styles, and database logic This project demonstrates practical skills in PHP, MySQL, server-side validation, and responsive frontend design, suitable for real-world CRUD-based applications.