Skip to content

Latest commit

Β 

History

History
81 lines (55 loc) Β· 3.19 KB

File metadata and controls

81 lines (55 loc) Β· 3.19 KB

πŸ§€ Database Cheese Project

PHP MySQL MVC Live Site

A PHP-based MVC web application developed for university coursework. The app provides a dynamic interface for managing cheese-related data, built with a custom MVC framework using vanilla PHP, JavaScript, and CSS.

πŸ”— Live demo: https://cwalsh.infy.uk/

Login Credentials

Admin

πŸ“§ Email: admin@cheesewebsite.co.uk ⚠️ (not a real email. Made up for testing purposes only) ⚠️
πŸ”’Password: cheeseAdmin

Regular User (Customer Login)

πŸ“§Email: normalUser@cheesewebsite.co.uk ⚠️ (not a real email. Made up for testing purposes only) ⚠️
πŸ”’Password: cheeseNormal


πŸ› οΈ Tech Stack

  • Backend: PHP (MVC pattern) PHP

  • Frontend: HTML, CSS, JavaScript HTML5 CSS3 JavaScript

  • Database: MySQL via phpMyAdmin MySQL phpMyAdmin


🧩 Features

  • Create, read, update, and delete cheese entries
  • Server-rendered views with client-side enhancements
  • Organized MVC file structure with clear separation of concerns
  • Includes basic web services (e.g. for JSON or AJAX-style calls)

πŸ“ File Structure

Database_Cheese_Project/
β”œβ”€β”€ Controller/     # Request handling logic
β”œβ”€β”€ Model/          # Database queries and data logic
β”œβ”€β”€ View/           # Presentation templates
β”œβ”€β”€ CSS/            # Styling
β”œβ”€β”€ JavaScript/     # Client-side scripts
└── WebServices/    # API endpoints or service scripts

🚧 Planned Improvements

  • Account button: Currently non-functional. Intended for future login or profile management.
  • AJAX integration: Reduce page reloads for actions like editing or deleting entries.
  • jQuery support: Add dynamic front-end behavior and simplify DOM manipulation.
  • Improved validation: More robust client-side and server-side form checks.
  • Accessibility and responsiveness: Better support for mobile and keyboard users.

πŸŽ“ Purpose

This project was created to demonstrate understanding of:

  • PHP application structure without a framework (e.g. no use of Laravel)
  • MVC as an architectural pattern
  • Integration of front-end and back-end components
  • Basic database operations using MySQL

πŸ“„ License

This project was completed as part of an academic course and is shared for learning purposes.