Introduction to PHP

• What is PHP?
• What’s new with PHP 8?
• Understanding the Client–Server Model
• Front-end vs. Back-end

PHP Requirements

• Local Server
• Text Editor
• Web Browser
• PHP Version

Basic Syntax

• PHP Code Block
• Opening and Closing Tag
• Display message using echo() and print()

Variables
Constants

• Arrays
• Index Array
• Associative Array
• Multidimensional Array

Loops

• For
• Foreach
• While
• Do while

Logical Statement

• … Else If….Else…. Statement
• Switch Case Break Statement
• Ternary Statement

Functions

• PHP Default Functions
• Custom Functions
• Basic Custom Function
• Custom Function with Arguments
• Custom Function with Returning Values
• Anonymous Functions

Introduction to OOP

• Classes
• Object
• Properties
• Methods
• Access Modifiers
• Constructors
• Inheritance

PHP SuperGlobals using

• $_POST
• $_GET
• $_SESSION
• $_COOKIE
• $_FILES
• $_REQUEST
• $_SERVER

Managing the MySQL Database

• Creating Database
• Creating Tables
• Editing Tables
• Using Single UNIQUE Columns
• Using Multiple UNIQUE Columns
• Deleting Table
• Drop Database
• Exporting Database
• Importing Database

SQL Syntax

• SELECT Clause
• INSERT Clause
• UPDATE Clause
• DELETE Clause
• WHERE Clause
• AND Clause
• ORDER BY Clause
• Using ALIASES
• Using AGGREGATE Functions

MySQL Essentials

• Connect to a MySQL Database
• Insert Data Using an HTML Form
• Display Records with PHP and SQL SELECT
• Filter and Sort Records with WHERE and ORDER BY
• Update Records Using SQL UPDATE
• Delete Records with SQL DELETE
• Add Pagination to Displayed Records
• Upload Files to the Server
• Delete Uploaded Files from a Folder