Complete PHP7 and MYSQL MasterClass Course (10 Projects)

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: How to ask questions

Chapter 2: PHP Overview

Lecture 1: What is PHP

Lecture 2: Setting up our environment

Lecture 3: Your first PHP script

Lecture 4: PHP echo statement

Lecture 5: Comments in PHP

Chapter 3: Basic PHP Concept

Lecture 1: What are variables in PHP

Lecture 2: What are Constants in PHP

Lecture 3: Data Types in PHP

Lecture 4: Variable Scopes

Lecture 5: Strings and Strings Functions

Lecture 6: Operations in PHP

Chapter 4: Control Structure (First Project)

Lecture 1: Condition Checking in PHP

Lecture 2: Switch Statement in PHP

Lecture 3: Create a Simple PHP Calculator

Chapter 5: Loops and functions

Lecture 1: What is a While Loop

Lecture 2: What is a For Loop

Lecture 3: What is a Do…While Loop

Lecture 4: What is a Foreach Loop

Lecture 5: How to create a custom function in PHP

Chapter 6: Data Structures (Second Project)

Lecture 1: Understanding Arrays in PHP

Lecture 2: Array Functions in PHP

Lecture 3: Password Generator using PHP

Lecture 4: Ad-dons to Password Generator

Chapter 7: HTTP and the SERVER

Lecture 1: HTTP Request and Response Explained

Lecture 2: Overview of HTTP Status Codes

Lecture 3: Super-Global variables [Part 1]

Lecture 4: Super-Global variables [Part 2]

Lecture 5: Processing Forms in PHP [GET METHOD]

Lecture 6: Processing Forms in PHP [POST METHOD]

Lecture 7: Form Security and Validation

Chapter 8: Advanced PHP (Third Project)

Lecture 1: Date and Time in PHP

Lecture 2: How to include files in PHP

Lecture 3: How to Upload Images to the Server

Lecture 4: How to set COOKIES in PHP

Lecture 5: How to set SESSIONS in PHP

Lecture 6: Multi-Dimensional Arrays in PHP

Lecture 7: Filters in PHP [Part 1]

Lecture 8: Advanced Filters in PHP

Chapter 9: SQL Overview

Lecture 1: How to create a database and table using SQL commands

Lecture 2: Create and Read using SQL commands

Lecture 3: Update and Delete records using SQL commands

Chapter 10: Database – MySQLi [Procdeural]

Lecture 1: How to connect to te database using PHP

Lecture 2: How to insert records from users to the database

Lecture 3: How to get records from the database

Chapter 11: Flashcard Application (Fourth Project)

Lecture 1: Introduction and Overview

Lecture 2: Connecting to the Database and Overview of the Files

Lecture 3: Registering and Logging in Flashcard users

Lecture 4: Adding Flashcards to Database

Lecture 5: Displaying Flashcard Questions and Answers

Lecture 6: Getting the next Flashcard Asynchronously [PART 1]

Lecture 7: Getting the next Flashcard Asynchronously [PART 2]

Lecture 8: Removing Flashcards

Lecture 9: Managing Unpublished Flashcards and Adding Pagination

Lecture 10: Displaying the Pagination Links

Lecture 11: Publishing and Deleting Flashcards

Lecture 12: Adding TinyMCE to our Application

Chapter 12: Build an Advanced Chat bot (Fifth Project)

Lecture 1: Building the Core Application

Lecture 2: Making our Application Asynchronous with AJAX