PHP with MySQL: Build Complete Coffee Shop System

Install XAMPP to set up a local development server with Apache, MySQL, PHP, and phpMyAdmin; download from apachefriends.org and start the control panel to run services locally.

Learn to install Visual Studio Code, the text editor used for this course, by following simple Windows installation steps, creating a desktop icon, and preparing to start coding with me.

Design and code a coffee shop project template featuring an index with nav, menu, cart, login/register, checkout form, and single product pages, plus an admin panel and product recommendations.

Create a PHP config file to connect to a MySQL database with PDO, defining host, db name, user, and password, and implement try-catch error handling for a coffee shop system.

Structure your PHP project by isolating common elements into header.php and footer.php, then include them with require in index.php to reduce repetition and improve maintainability.

Build an authentication system with a PHP and MySQL register page. Hash passwords and insert new users into the users table, then wire the login flow.

Learn to build a PHP login page with MySQL by validating email and password, checking users table, verifying the hashed password with password_verify, starting a session, and redirecting to index.

Learn to finish a PHP authentication flow by starting sessions, storing username, email, and id in session variables, and conditionally showing login, register, or user menus based on login status.

Learn how to implement a coffee shop table booking system with PHP and MySQL, including future-date validation, user login integration, and storing bookings in a bookings table with user IDs.

Create a dynamic products section by building a MySQL table and fetching all rows with PHP. Display each product’s name, image, description, and price, linking to its single page.

Display a single product page dynamically by reading the product ID, querying MySQL for its details, and rendering image, name, price, and description for a coffee shop system.

Learn to display related products on a PHP with MySQL coffee shop site by adding a type column, querying for related items, and listing them on the product page.

Implement add-to-cart functionality on the product page using a PHP form submission (no ajax), capturing name, image, price, description, quantity, and user id.

Validate the cart to prevent duplicate items by checking product id and user id, add a pro_id column, and hide inputs while disabling the add-to-cart button when the item exists.

Learn to display cart items in a PHP and MySQL powered coffee shop system by loading user-specific products, showing images, names, prices, quantities, and totals, with delete functionality.

Calculate the cart total by multiplying price and quantity, apply delivery and discount adjustments, and enforce session checks to require login for adding to cart.

Delete items from the cart using PHP (no ajax) by reading the item id from the link, executing a delete query, and redirecting back to the cart with updated totals.

Build a checkout flow in PHP and MySQL by passing the cart total to a session, collecting billing details, and inserting an order with status and total price for PayPal.

Explore how to process payments with PayPal in a PHP and MySQL coffee shop system, using sandbox accounts, client ID, and a simple checkout flow.

Implement dynamic PayPal payments and session-based pricing in a PHP with MySQL coffee shop system, then clear the cart after payment and refine PayPal button placement.

Validate the user session to prevent direct checkout, display the cart and total only when items exist, show an empty cart message, and fix header links to home.

Refine back end by fixing button design issues, and implement a 404 page with a home link, validating URL IDs to protect navigation in the PHP MySQL coffee shop system.

Demonstrates setting up a dynamic coffee shop menu in menu.php, linking booking forms, displaying desserts and drinks, and wiring product detail pages.

Build a user bookings page in a PHP with MySQL coffee shop system by displaying bookings with name, date, time, phone, and message, using a default pending status.

Display all orders by user id in a new orders.php page, showing first name, last name, town, street address, phone, total price, and status, with access control for logged-in users.

Enable customers to write reviews after orders or bookings are completed, show a review button for eligible items, and store each review with the user name and timestamp.

Display and manage reviews across index, about, and services pages by dynamically rendering user names, while making headers, footers, and page content dynamic, and filtering products to drinks.

Design and code an admin panel to manage a coffee shop system, including login restricted admin access, creating admins, and processing orders, products, and bookings with status updates and deletions.

Build an admin login flow for a coffee shop system by wiring a shared header and footer, creating admins table, and implementing password verification in PHP and MySQL.

Start and validate sessions, manage admin session variables, and control page access by showing login or home content based on login state in a PHP with MySQL coffee shop system.

Enforce access control on the admin index by checking the session and redirecting to login when not set. Display dynamic counts for products, orders, bookings, and admins via count queries.

Fix and convert admin links to PHP pages, include the header and footer, and display admins using a foreach loop from the admins table.

Create new admins in a PHP with MySQL coffee shop system by converting admin pages to PHP, hashing passwords, inserting into admins, and validating login.

Implement admin session checks and fix dynamic links to the orders page, then display orders with id, name, town, state, zip, phone, address, price, and status, plus delete functionality.

Learn how admins update order status in a coffee shop system, using a PHP form to set pending or delivered statuses with an update query driven by order IDs.

Delete an order in the admin panel by reusing the existing delete logic, running a delete query on the orders table, and returning to the show-orders.php page.