Learn to structure an html5 page by choosing a text editor and saving as index.html, then assemble html, head, and body with tags, attributes, values, and utf-8 meta.

Organize web pages into folders like pages and master linking with full paths or relative paths using ../ to move up a level, ensuring the index.html link works.

Master html5 rules for valid markup, including proper tag nesting and closing tags. Learn why a title is required, set a default homepage, and respect copyright when reusing content.

Explore new semantic elements in HTML5 and see how header, nav, section, article, and aside organize a web page; learn to structure content and preview layout changes.

Explore how html tags control the flow and appearance, applying bold or strong text, italics, underlines, line breaks, spacing, and separators to structure email and web content.

Learn to add a table to a web page, define the header, add rows and cells, apply borders, and adjust layout by moving cells.

Learn how to add forms to web demos, pass user data to a server, and use input types such as text, email, password, and date with placeholders and submit actions.

Learn how forms use input types, radio buttons, and checkboxes, and compare get versus post for sending login data, highlighting why post protects passwords from being exposed.

Learn how to embed audio and video using HTML5 tags with multiple sources for all browsers, add controls, posters, and fallback text for unsupported formats.

Understand the difference between div and span, and why you might replace semantic tags for layout. Learn to style blocks or inline text with CSS classes.

Link CSS to HTML using a separate stylesheet with the link tag, or embed styles inline; explain why external files keep styles consistent across pages.

Learn to style a basic web page with css simple selectors, using element, class, and id selectors with dot and hash notation, including comma separated selectors.

Master CSS selectors and attributes to style links, tables, and forms, using class states, pseudo-classes like hover, visited, and active, and attribute selectors such as input[type=...] and first-child.

Explore color usage, opacity, and background techniques in CSS, from hex and rgb/rgba values to background images and parallax, with responsive sizing.

Explore padding and margin in CSS, using shorthand for top, right, bottom, and left, and learn how margins create outside space while padding creates inside space.

Demonstrate building responsive image cards with CSS transitions and transforms, including hover effects, overflow handling, and cross-browser prefixes to animate images in a web app.

Explore how to apply box-shadow and text-shadow in css, tune blur and color with rgba or hex values, and design layered shadows for standout text and elements.

Apply responsive design by using media queries and the viewport meta tag to adapt layouts for small screens, overriding widths and colors to ensure readability on mobile devices.

Explore building a responsive layout with flexbox, using a flex container and items with max-width percentages, and applying media queries to switch direction for smaller screens.

Apply css grid to display article items in a section, configure grid template columns for two or three columns, and adapt layouts to different screen sizes.

Explore CSS positioning with fixed, absolute, relative, and sticky to layer images and text on a container, using z-index and parallax concepts.

Learn to add a navigation bar with HTML anchors, style it via CSS, adjust colors and layout, switch from fixed to sticky positioning, and apply hover effects for links.

Modify the site layout by adjusting padding, backgrounds, and body margins to reveal spacing issues and improve readability, and apply a shared class to collapse all buttons.

Design the page footer and a name anchor to jump to the about section or top. Connect header links to internal anchors using the name attribute.

Edit the contact page by linking navigation and adding a contact form with username, email, and message fields, using placeholders and a contact form class.

Design a responsive form by adding username, email, and message inputs with labels and placeholders, using flex layout and focus styles, borders, and transform effects for a polished experience.

Finish the form by focusing input fields, transforming and translating labels on focus, and adjusting padding, margins, and typography with em units to improve the form's appearance.

Create an image with a centered overlay text using css techniques: relative and absolute positioning, a glass overlay, background color, and hover-triggered transitions with transform animations.

Install a bundled local server environment to run PHP and MySQL, place your site in the server directory, start the server, and access it on localhost via the appropriate port.

Prepare your web app by moving the project to the server directory, load it on localhost, set the homepage as index, and rename files to .php to begin development.

Learn basic PHP syntax by embedding PHP within HTML using proper tags, output text with echo or print, and begin working with variables and comments.

Variables are containers for storing information. Name them starting with a letter or underscore, and remember that names are case sensitive and can hold integers or strings.

Master PHP string concatenation to combine numbers and variables into coherent output, avoid hardcoding, and correctly separate data types with the dot operator.

Learn how to use var_dump() in PHP to inspect data types like strings, integers, floats, and booleans, and compare it with echo and print for web output.

Explore PHP operators across groups, including addition, subtraction, multiplication, division, exponentiation, assignment, comparison, increment and decrement, logical operators, and string concatenation, with practical examples using variables and user input.

Explore handling html form submissions in php with an if isset post check, retrieving number1 and number2 values, and echoing results to build a simple calculator.

Use if else statements to drive a simple calculator with two numbers and an operator, handling select inputs, form post data, and validation messages when no operator is chosen.

Learn to use the switch statement to replace if-else by switching on an operator variable, with case blocks, break, and a default for unknown input.

Explore using the date function with a switch statement to format the day and month, handle breaks, and inspect defaults in a web app.

Explore for loops in PHP, compare with while and do-while, learn start and end conditions, increment with ++, and generate outputs such as a calendar and blog post lists.

Learn to use a for loop with an if-else statement to remove an item and adjust values in code. Combine for loops with conditional logic to accomplish tasks efficiently.

Explore the differences between while, for, and do while loops in web app development, with hands-on examples showing initialization, conditions, and increments to avoid infinite loops.

Demonstrate using a try-catch block in PHP to handle division by zero, define a divide function, and display clear user messages while the process completes.

Learn how to create arrays in PHP, store multiple values in one variable, and access them by zero-based indices using echo, count, and for or foreach loops with fruit examples.

Learn how to use for and for each loops to iterate over arrays, access elements from zero to n, and replace manual indexing with a clean, scalable PHP approach.

Explore associative arrays in php by mapping keys to values, iterating with foreach, and using sort functions to order by key or value, with examples of user ages.

Use the f open function to create or open files, delete files, or write, read, and append content with mode flags.

Learn file handling in PHP using fopen, fread, and fwrite to read from and write to files, understand access modes, and avoid overwriting existing content.

Learn to append data to a file without erasing existing content by adding new lines and data to a text file, a practical file handling technique.

Explore file handling in PHP: read lines with gets, close files after access, and delete files with unlink, ensuring secure access and clean-up.

Learn to create, write to, and read CSV files in PHP, then display the data on a web page.

This lecture explains how cookies work in PHP, how to create a cookie with setcookie by name, value, expiry and path, and how to read it with $_COOKIE.

Learn how to manage cookies in web apps by using optional arguments such as domain and path, and delete a cookie by setting its expiration to a past time.

Discover how to use sessions in PHP to store user data across pages, keeping login state without writing cookies to the user’s computer, and implement a simple sign-in/out flow.

Learn to protect external user input by sanitizing and validating with PHP filters. Use filter_var for sanitization, explain injection risks, and explore available filters with filter_list.

Learn how object oriented programming uses classes and objects to create reusable code, define properties and methods, and keep code dry with practical examples.

Learn object-oriented programming in PHP by defining a class with public properties and methods to set and get the name. Use this to reference the current object and create objects.

Explore using a constructor in a PHP class to initialize properties automatically, compare with setter methods, and simplify accessing car make and model.

Explore how public, protected, and private access modifiers control who can access a class's properties and methods, access from outside the class, derived classes, and private access within the class.

Explore inheritance in object-oriented programming by extending a parent car class to create a child class, overriding methods, and experimenting with public, protected, and private access modifiers.

Learn how to override properties and methods in an object, and apply the final keyword to prevent class extension or method overriding, with practical PHP examples.

Discover how to declare and use constants in PHP with const, including uppercase naming, case sensitivity, and accessing constants from outside a class without creating an object.

Create and implement an interface to standardize the model method across multiple car classes, demonstrating polymorphism and reusable code in PHP.

Discover how static methods enable calling class functions without creating an instance in PHP, and see how interfaces, abstract classes, and traits influence design while using self and class references.

Explore how namespaces organize PHP code, prevent name clashes, and enable aliases to access classes across files using include and use statements.

Start a MySQL database and learn to connect via localhost and port 3306, using the terminal to view databases and set up a project without diving into data types.

Create a hotel database using SQL statements, draft a blueprint for the required tables, and switch to the database to view and manage its tables.

Create and describe the first table, class, with id as integer primary key auto_increment and name_class as varchar(50), and learn show tables, describe, and linking via integers.

Create and link four sql tables: customer, rooms, and reservations, using create table if not exists, with primary and foreign keys, detailing customer names, birth year, address, capacity, and price.

Reverse engineer the hotel database to visualize table relationships, then create foreign keys with add constraint and alter table, linking reservation to customer and to room, and room to class.

Insert data into the class and rooms tables using insert into with auto increment IDs. Plan to add customer and reservation records and explore table links in localhost.

Alter and describe the customer and reservations tables, then insert records with names, birth year, addresses, room and customer ids, dates, and person count, while noting foreign and primary keys.

Learn to select data from multiple tables by joining rooms with their class, displaying room details alongside class information using a shared column.

Explore inner, left, right, and full outer joins to combine data from two tables and see how each join returns matching records and, for outer joins, records from both tables.

Learn to filter data with where clauses, order results with order by, and use aliases to present clear column names like price per night in room listings.

Learn to use the five aggregate functions in SQL to compute count, average, minimum, maximum, and sum, illustrated with room price and customer data.

Learn to paginate results with limit and offset, filter by price with where, and order by price to display top or next sets of rooms or news.

Show how to display dynamic room prices with on-the-fly discounts without changing the database, using MySQL operations, inner joins, and computed fields for two nights and Black Friday offers.

Select customers with reservations and display how long they stay using datediff by joining customers and reservations tables.

Explore using date functions to query reservations, including current date and current time, and filter by intervals such as the last 31 days, to display results in a web app.

Explore two SQL approaches to show each customer's reservation count. Use a subquery in the select clause, or join reservations and group by customer to compute totals.

Learn how to implement wildcard searches in sql using like and wildcard symbols to find customers by partial names, across first and last names, with or conditions.

Learn to display customers with no reservations by using not and a subquery to compare customers and reservations across tables.

Display the total price per reservation by joining rooms, customers, and reservations, calculating stay length from dates, and multiplying by the price per night.

Calculate total earnings from reservations by multiplying price per night by stay duration and summing across joined rooms and reservations. Apply an aggregate sum to display monthly revenue.

Learn how to safely delete records in a MySQL database by using delete from with a where clause, including like operators, and avoiding accidental removal of all data.

Demonstrates deleting customers without reservations by using a subquery on the reservation table to clean up the database in a MySQL-backed web app.

practice safe sql updates by using update with where clauses to modify specific rows, such as room capacity or price. apply arithmetic updates and round results for display.

Learn to drop a table with drop table, avoid using delete for tables, and use alter table to add or delete columns, describe and update data.

demonstrate adding a thumbnail column to the database, storing image filenames on the server, using a default image, and displaying thumbnails in a php and mysql web app.

Create a PHP-MySQL connection by building a connection file, configuring the server name as localhost, the username, password, and database, include it in your pages, and test the connection.

Connect to a database, run a query to select all from rooms, and display each room’s number, capacity, price, and image on the website using PHP and MySQL.

Learn to turn a database of rooms into a web app by querying rooms and classes, displaying them with cards, and providing a get info detail view.

Add a description column to the room table by altering the schema, choosing a long text data type, and saving the updated structure to enable storing room descriptions.

Display data from the database in an HTML table using PHP and MySQL. Create a bordered table with date and capacity headers and join reservations with rooms for display.

Create and toggle sign-in and sign-up forms, connect to the customer table, and post username and password to enable user accounts in a PHP and MySQL web app.

Design a sign up form by customizing fields—username, password, first name, last name (and optionally email)—and include a flow to check for existing users before signing up.

Learn how to implement sign in by hashing passwords, sanitizing inputs to prevent injection, posting securely, and validating credentials against the user database to log in.

Explore page view access control using header location redirects in PHP, managing sign up and sign out states with sessions to protect logged-in users and navigate to the home page.

Learn to build a sign-up workflow with username, password, first and last name, enforce unique usernames, hash passwords, and use prepared statements in PHP and MySQL.

Create a reservation interface with a dynamic form that collects user details, dates, and number of visitors, retrieving customer and room IDs via session and database queries.

Build a reservation feature by collecting from and to dates, time, room id, customer, and visitors, then post data and insert into the reservations table in php mysql web app.

Create a profile page that shows the user's name and reservation when clicked, with session checks that redirect unauthenticated users to the index and allow editing of user data.

Display existing user data from the database and provide an editable profile form for username, first name, last name, and birth year; validate and update via PHP and MySQL.

Display a logged-in user's reservations on their profile page, using a subquery or join to fetch data from reservations and customer tables, showing dates and room details.

Build and manage an admin panel with a manager dashboard, admin login, and sections for users, rooms, and reservations, and learn to upload room images to the server.

Prepare room image uploads by adding a file input and multipart form data, wiring the update image feature to the server and updating the room details page.

Learn how to securely handle file uploads in PHP by validating image type and size, restricting non-acceptable formats, and safely saving files with a generated name to a server directory.

Finish file uploads in a PHP web app by moving uploaded files to the media folder, naming safely, preventing duplicate image names, updating the database, and giving user feedback.

Explore final steps to add a room entry, upload a file, and manage media in the database, enabling you to build larger web apps with guidance from the course coach.