Wine Inventory Manager

UI + Back-End Development

This project challenged me to create a fully functional CRUD (Create, Read, Update, Delete) application using a MySQL database and a custom PHP front-end.  I developed a small but complete content-management interface that allows users to maintain a table of wine list.

The goal was to demonstrate both technical competency (PHP, SQL, server interactions, data handling) and front-end capability (UI clarity, styling, form design, validation, responsive layout).

Role:

Full-Stack Developer (Front-End + Back-End)

Responsibilities:

  • Designing the full CRUD interface

  • Connecting PHP pages to MySQL

  • Writing and testing SQL queries

  • Creating responsive forms, tables and page layouts

  • Validating inputs and improving error messages

  • Ensuring code quality, readability and modularity

  • Testing across devices and browsers

UI / UX Design Choices:

  • High readability: Clear typography, spacing and consistent use of padding
  • Row striping in tables for visual scannability
  • Colour unity: Muted neutral palette with one accent colour for buttons
  • Obvious flow: Top-to-bottom guiding, clear call-to-action buttons
  • Mobile responsiveness: Tables become scrollable, forms stack vertically
  • Inline validation to support users during data entry

Code Quality & Best Practices:

  • All CSS and PHP are neatly formatted and commented

  • Code broken into reusable components (e.g., header, footer, database connection file)

  • Database credentials stored securely with strong passwords

  • Form input sanitised and validated

  • SQL statements structured for readability and safety

  •