Projects

Oaxaca

University group project (team of five): vanilla PHP and MySQL restaurant site with public pages, ordering and checkout, waiter and kitchen staff areas, and admin for menus, tables, and employees. Configuration lives outside the public document root.

GitHub

Oaxaca Restaurant

Purpose

This was a group coursework build at university: five of us delivered a full-stack restaurant application without a framework, covering the public site (home, menu, contact, ordering) plus waiter and kitchen workflows and an admin area for menus, tables, employees, and manager tasks.

What It Provides

Customers browse and place orders through the public web tree; staff sign in to role-specific areas (waiter flows for tables, orders, payments, and assistance; kitchen flows for meal readiness and hand-off). Admins maintain menus, table assignment, and people data. MySQL backs everything through mysqli; a SQL bundle under the sql folder imports schema and sample data. The vhost points at the public folder only so credentials and includes stay off the URL space.

What we built

Entry goes through a bootstrap script in the public folder that pulls shared initialisation and database wiring from an includes layer; protected staff routes layer session checks after bootstrap. Pages are organised by domain (menu, checkout, auth, staff branches for waiter, kitchen, and admin) with assets under standard css, js, and images trees. Local credentials come from a copied database config template that is gitignored in real deployments.

My role on the team

I was one of five students. The codebase is a joint submission: features span ordering, staff consoles, and administration, so ownership was split across the group while we kept shared conventions for includes, SQL access, and session use.

How I contributed

Together we kept the structure practical for coursework: explicit includes, mysqli access patterns, separation between public marketing and authenticated staff dashboards, and a documented path to import the database and run under the PHP built-in server or a real vhost.

Future Enhancements

I want to carry this line of work forward into a full reservation and operations platform for restaurants: a deployable product with a public-facing marketing and booking site, flows for guests to reserve tables and place orders, and a richer admin experience including an interactive floor plan so venues can lay out tables and manage capacity for maximum efficiency during service.

Tech used

  • CSS
  • HTML
  • JavaScript
  • MySQL
  • PHP