PHP OOP with MySQL: Build Restaurant Management System

Install xampp to set up a local development server with apache, mysql, php, and phpmyadmin, then start the services and access localhost.

Learn how to install Visual Studio Code as the preferred text editor for the course, with a quick walkthrough for Windows download, installation, and setup of the editor.

Create a PHP OOP library to manage database interactions. Set up a config file and an app class, and connect to MySQL with PDO using host, dbname, user, and password.

Learn to build reusable data access methods in PHP OOP with MySQL by implementing select all and select one row using PDO.

Master insert and update queries in PHP OOP with MySQL, using prepared statements, input validation, and array handling to support CRUD operations in a restaurant management system.

Learn to manage user sessions in PHP: start sessions after login, store email, username, and id, show or hide login and register links, and implement logout with session destruction.

Display food items on the index by creating a foods table and rendering items by meal_id with foreach, including image, name, description, price, and add-to-cart links.

Display a single food item by using select one on the foods table for a dynamic id, then render its name, description, price, and image on the add-to-cart page.

Learn to add menu item to a user cart via a post form. Store item id, name, price, image, and user id in a cart table and prepare for duplicates.

Learn to compute cart totals and delete items in a PHP and MySQL driven restaurant management system, using session data and dynamic updates.

Show how to implement a checkout workflow in a PHP OOP with MySQL restaurant management system by using session total_price, cart.php forms, and an orders table to capture orders.

Learn to implement PayPal payments in a PHP restaurant management system using sandbox accounts and the PayPal SDK, covering app setup, checkout integration, and test transactions.

Fixes deleting cart items by user_id and ensures the cart clears after payment. Adds session-based guards to checkout and pay pages, plus dynamic cart handling and url protections.

Add a 404.php page in PHP to gracefully handle invalid URLs and missing IDs, with a back-to-index link and styling across product, cart, and checkout flows.

Build a dynamic bookings view for each user in PHP, retrieving bookings by the session user id and displaying name, email, date, number of people, special requests, and status.

Display user orders by user id on the orders page, showing name, email, town, country, zip code, phone, address, total price in dollars, status, and the creation date.

Implement server-side validation and cleanup to restrict direct page access, enforce post requests, and secure sessions, while gradually converting static pages into dynamic PHP navigation for a restaurant management system.

Enable users to write reviews for confirmed bookings by gating access to login, adding a review button, and storing reviews in a MySQL-backed table using PHP OOP.

Display reviews by selecting all from reviews and looping to show each user's name on the index page, and link a login-gated booking form to booking.php.

Design and implement a simple admin panel for a restaurant management system, enabling login, home statistics, and changing status or deleting admins, orders, food items, and bookings.

Learn how to create and validate sessions in PHP OOP with MySQL, display admin information in the header, and control login/logout flow to secure the admin panel.

Learn to secure an admin panel by validating sessions, redirecting unauthenticated users to login, and dynamically displaying admins with a PHP MySQL backend.

Add new admins via the admin page by reusing the registration code, validating sessions, hashing passwords, and saving admin name, email, and hashed password to the database.

Build a restaurant management admin index with php and MySQL by counting foods, orders, bookings, and admins, using aliases and displaying the results on the dashboard.

Show how to display and manage orders in a PHP OOP with MySQL management system, turning status into a link for updates and listing details like id, email, and total.

Explore deleting an order in the admin panel using a delete query on the orders table by id, verify removal in show-orders, and handle errors with a 404 redirect.