
PHP and MySQL Training
Course Length: 5 days
Delivery Methods:
Multiple delivery options
Course Overview
In this PHP training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. The class also covers SQL basics.
Course Benefits
- Learn how PHP works.
- Learn the basic syntax of PHP.
- Learn to create dynamic interactive pages with PHP.
- Learn to manipulate files with PHP.
- Learn to work with arrays in PHP.
- Learn to validate forms with PHP.
- Learn to write functions in PHP.
- Learn to manipulate and manage database data with PHP.
- Learn to authenticate users with PHP.
- Learn to manage sessions with PHP.
- Learn to work with the MDB2 package.
- Learn advanced form validation with regular expressions.
- Learn to send email with PHP.
- Understand how MySQL works.
- Learn to use SQL to output reports with MySQL.
- Learn to modify MySQL data with SQL.
Available Delivery Methods
Public Class
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private Class
Private classes are delivered for groups at your offices or a location of your choice.
Private classes are delivered for groups at your offices or a location of your choice.
Course Outline
- Relational Database Basics
- Brief History of SQL
- Relational Databases
- Tables
- Rows
- Columns
- Relationships
- Datatypes
- Primary Keys
- Foreign Keys
- Relational Database Management System
- Popular Databases
- Commercial Databases
- Popular Open Source Databases
- SQL Statements
- Database Manipulation Language (DML)
- Database Definition Language (DDL)
- Database Control Language (DCL)
- Simple SELECTs
- Introduction to the Northwind Database
- Some Basics
- Comments
- Whitespace and Semi-colons
- Case Sensitivity
- SELECTing All Columns in All Rows
- SELECTing Specific Columns
- Sorting Records
- Sorting by a Single Column
- Sorting By Multiple Columns
- Ascending and Descending Sorts
- The WHERE Clause and Logical Operator Symbols
- Checking for Equality
- Checking for Inequality
- Checking for Greater or Less Than
- Checking for NULL
- WHERE and ORDER BY
- Checking Multiple Conditions with Boolean Operators
- AND
- OR
- Order of Evaluation
- The WHERE Clause and Logical Operator Keywords
- The BETWEEN Operator
- The IN Operator
- The LIKE Operator
- The NOT Operator
- Advanced SELECTs
- Calculated Fields
- Concatenation
- Mathematical Calculations
- Aliases
- Aggregate Functions and Grouping
- Aggregate Functions
- Grouping Data
- Selecting Distinct Records
- Built-in Data Manipulation Functions
- Common Math Functions
- Common String Functions
- Common Date Functions
- Calculated Fields
- Subqueries, Joins and Unions
- Subqueries
- Joins
- Table Aliases
- Multi-table Joins
- Outer Joins
- Unions
- UNION ALL
- UNION Rules
- PHP Basics
- Welcome to the Server-side
- Adding PHP Files to VS Code Workspace
- Google Chrome DevTools: Network Tab
- Review of DevTools Network Tab
- How PHP Works
- PHP Functions
- php.net
- Using php.net
- Variables
- Preparing to Write Your First PHP Code - Part 1
- Preparing to Write Your First PHP Code - Part 2
- Preparing to Write Your First PHP Code - Part 3
- First PHP Script
- Variable Scope
- Single Quotes vs. Double Quotes
- Concatenation
- Passing Variables on the URL
- User-defined Functions (UDFs)
- Local and Global Variables
- Passing Arguments by Value vs. by Reference
- Introduction to the Poet Tree Club
- Including Files
- Using Header and Footer Includes
- Constants
- Error Reporting
- Displaying Errors
- Including a Secure Configuration File
- Comments
- PHP Statements and Whitespace
- PHP Conditionals
- if / if - else / if - elseif - else
- Introduction to Conditionals
- False Equivalents: Falsy Values
- Testing for Variable Existence
- switch/case
- Ternary Operator
- The Ternary Operator
- Null Coalescing Operator
- Arithmetic Operators and Loops
- Arithmetic Operators
- The Modulus Operator
- Loops
- Modulus and Loops
- Arrays
- Indexed Arrays
- Working with Indexed Arrays
- Associative Arrays
- Superglobal Arrays
- Multi-dimensional Arrays
- Array Manipulation Functions
in_array()
Function
- Working with Databases
- Objects
- Attributes / Properties
- Behaviors / Methods
- Classes vs. Objects
- Connecting to a Database with PDO
- Introducing the Poetree Database
- phpMyAdmin
- Querying Records with PHP
- Queries Returning Multiple Rows
- Adding Pagination
- Sorting
- Anticipating Foul Play
- Filtering
- Exception Handling
- Uncaught Exceptions
- Throwing Your Own Exceptions
- Catching Exceptions
- Exceptions
- Division Form
- PDOExceptions
- Logging Errors
- The
dbConnect()
Function - When Queries Fail to Execute
- Preparing for the Catching Errors Exercise
- Catching Errors in the PHP Poetry Website
- PHP and HTML Forms
- Form Submissions
- Sanitizing Form Data
- Validating Form Data
- Processing Form Input: Trimming
- Processing Form Input: Filtering
- Processing Form Input: Validating Fields
- Processing Form Input: Submission Response
- Processing Form Input: Remembering Form Entries
- Sending Email with PHP
mail()
- Setting Up PHPMailer
- Mail Server
- Including a Mail Configuration File
- Sending Email with PHPMailer
- PHPMailer Methods and Properties
- Creating a Contact Form
- Authentication with PHP and SQL
- The Registration Process
- Passwords and Pass Phrases
- Registration with Tokens
- Creating a Registration Form
- Sessions
- Cookies
- Logging In and Out
$_REQUEST
Variables- Resetting the Pass Phrase Introduction
- LAB: Inserting, Updating, and Deleting Poems
- Submitting a New Poem
- Showing All User’s Poems in on the Poems Page
- Editing an Existing Poem
- Deleting a Poem
- Uploading Files
- Enabling File Info Functions on Windows
- Uploading Images via an HTML Form
- Resizing Images
- Uploading a Profile Picture
- Uploading Files
- Admin Site
- Adding the Admin Pages
- Creating the
isAdmin()
Function - Completing the Admin Home Page
- Completing the Admin Poems Page
- Approving, Editing, and Deleting Poems
- Completing the Admin Users Page
- Make the My Account Page Spoofable
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Class Prerequisites
Experience in the following is required for this PHP class:
- HTML
Experience in the following would be useful for this PHP class:
- CSS
- Basic Programming
- XML
Register for a Live Class
$2,875.00
Request a Private Class
- Private Class for your Team
- Online or On-location
- Customizable
- Expert Instructors