PHP & MySQL course for absolute beginners | Become a PHP pro

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course overview

Lecture 2: Installing XAMPP on Mac

Lecture 3: Installing a free code editor (Optional)

Lecture 4: PHP code in HTML

Lecture 5: Phpinfo

Lecture 6: Using Echo statement in PHP

Lecture 7: Using Print statement in PHP

Lecture 8: Adding comments in PHP

Lecture 9: Line break

Chapter 2: Variables and Data Types

Lecture 1: Variables in PHP

Lecture 2: Multiple ways to add variables in echo/print

Lecture 3: Data types

Lecture 4: Arrays

Lecture 5: Associative arrays

Lecture 6: Multidimensional arrays

Lecture 7: Solutions exercises data types

Chapter 3: Operators in PHP

Lecture 1: Arithmetic operators

Lecture 2: Assignment operators

Lecture 3: Comparison operators

Lecture 4: Logical operators

Lecture 5: Increment and decrement operators

Chapter 4: Control structures

Lecture 1: Conditional statement

Lecture 2: Switch statement

Lecture 3: While loop

Lecture 4: Do-while loop

Lecture 5: For loop

Lecture 6: Foreach loop

Lecture 7: Solutions control structures

Chapter 5: Functions in PHP

Lecture 1: Introduction to functions

Lecture 2: Creating our first function

Lecture 3: Functions with arguments/parameters

Lecture 4: Functions with return value

Lecture 5: Global and local scope in PHP

Lecture 6: Constants

Lecture 7: Including documents

Lecture 8: Requiring documents

Lecture 9: Solutions function exercises

Chapter 6: Build in functions in PHP

Lecture 1: Introduction to build-in functions

Lecture 2: Math build-in functions

Lecture 3: String build-in functions

Lecture 4: Array build-in functions

Lecture 5: Date and time build-in functions

Lecture 6: Random number build-in function

Lecture 7: Solution build-in functions

Chapter 7: How to work with superglobals in PHP

Lecture 1: Introduction to superglobals

Lecture 2: Superglobal 'Post' in PHP

Lecture 3: Superglobal 'Get' in PHP

Lecture 4: Superglobal 'Session' in PHP

Lecture 5: Superglobal 'Cookie' in PHP

Lecture 6: Superglobal 'Files' in PHP

Lecture 7: How to create a working upload system

Lecture 8: Create and write to a file

Lecture 9: How to read from a file

Lecture 10: Creating a working contact form

Chapter 8: Introduction to databases

Lecture 1: Introduction to databases

Lecture 2: Creating a MySQL database

Lecture 3: Creating a MySQL table

Lecture 4: Inserting data using MySQL

Lecture 5: Selecting data using MySQL

Lecture 6: Updating data using MySQL

Lecture 7: Deleting data using MySQL

Lecture 8: Ordering data using MySQL

Chapter 9: Using a database to create a register/login script

Lecture 1: Connecting to the database in PHP

Lecture 2: Printing database data in the browser

Lecture 3: Markup for login/register page

Lecture 4: Saving data from a register form

Lecture 5: Error handlers in the PHP script

Lecture 6: Prepared statements to prevent SQL injection

Lecture 7: Password hashing in register script

Lecture 8: Login script