PHP Training: The Most Comprehensive Course

Introduction to PHP Training

Learning the Basics of PHP

Why Use PHP?
Structure of a PHP Page
Embedding PHP Code in an HTML Document
Variable Types
Declaring and Using Arrays
Constants
Operators
Loops and Conditional Statements
Superglobal Variables
Retrieving Form Data
Sending Emails

Hands-on Workshop: Review of core HTML tags and styling commands, setting up a template page

Creating Functions and Using Built-in Functions

Declaring Functions
Parameters and the Return Statement
Creating Function Libraries
Built-in Functions: Examples, Organization, Documentation
Functions for Dates, Arrays, and Strings
Include and Require Functions

Hands-on Workshop: Creating custom functions and using built-in functions

Processing Form Data

Creating a Form
Retrieving Form Data
File Uploads: The $_FILES Variable and Related Functions
Sending Emails

Hands-on Workshop: Building a job application form

Interacting with Users

Retrieving and Using GET Parameters
Using Cookies to Store Information
File Uploads: The $_FILES Variable and Related Functions
Sending Emails

Hands-on Workshop: Building a job application form

phpMyAdmin

Overview of phpMyAdmin
Creating a Database with phpMyAdmin
Creating Tables and Exploring Field Types
Modifying Table Structure

Hands-on Workshop: Creating a MySQL database and tables

SQL

Selecting Records (SELECT)
Inserting Records (INSERT INTO)
Updating Records (UPDATE)
Deleting Records (DELETE)
Operators and Conditions

Hands-on Workshop: Writing basic SQL queries

Using a MySQL Database with PHP

Overview of Database Management Systems
Data Types
Connecting to a MySQL Server
Populating the Database from a Form
Inserting Data into the Database with PHP
Updating Data with PHP
Deleting Data with PHP
Securing Data Before Sending to MySQL

Hands-on Workshop: Storing job application form data in the database

Cookies & Sessions

Session Overview
Advantages and Disadvantages of Cookies and Sessions
Storing and Retrieving Session Variables
Storing and Retrieving Cookie Variables

Hands-on Workshop: Building a simple shopping cart and user interface

Working with Files

Opening and Writing Files

SQL: Advanced Concepts

Tables and Relationships
Joins: INNER, LEFT, and RIGHT JOIN

Hands-on Workshop: Writing SQL queries across multiple tables

Building a Mini CMS

CMS Concepts
Existing CMS Platforms
Introduction to Data Modeling
Creating the Public Interface
Creating the Admin Interface
User Management

Hands-on Workshop: Library management application

XML

Overview of the XML Format
Writing an XML Document
Introduction to XML

Hands-on Workshop: Creating an RSS feed and generating a sitemap for the library project

Other course(s) in this category

→ Vue.js Training

→ Visual Basic .NET Training (VB.NET) | Montreal, Quebec, Gatineau

→ Training: WPF Interface Development with C# and Visual Studio