This course is provided by Wintrac. Wintrac
provides one stop shopping for all your IT training needs. Wintrac’s course
catalog of over two thousand courses includes courses on PHP training
PHP Training 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.
PHP Training Prerequisites
Experience in the following areas is required:
HTML
Experience in the following areas would be beneficial.
CSS
Basic Programming
XML
PHP Training Learning Objectives
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 PEAR:DB module
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
PHP Training Course duration
5 Days
PHP Training Course outline
PHP Basics
How PHP Works
The php.ini File
Basic PHP Syntax
PHP Tags
PHP Statements and Whitespace
Comments
PHP Functions
Hello World!
PHP Tags
PHP Statements and Whitespace
Comments
PHP Functions
Hello World!
Variables
Variable Types
Variable Names (Identifiers
Type Strength
Hello Variables!
Variable Scope
Superglobals
Constants
Variable-Testing and Manipulation Functions
Variable Types
Variable Names (Identifiers
Type Strength
Hello Variables!
Variable Scope
Superglobals
Constants
Variable-Testing and Manipulation Functions
PHP Operators
Creating Dynamic Pages
Single Quotes vs. Double Quotes
Howdy World!
Single Quotes vs. Double Quotes
Howdy World!
Conclusion
Flow Control
Conditional Processing
If Conditions
If Conditions
Loops
while
do...while
for
break and continue
while
do...while
for
break and continue
Conclusion
Arrays
Enumerated Arrays
Initializing Arrays
Appending to an Array
Reading from Arrays
Looping through Arrays
Initializing Arrays
Appending to an Array
Reading from Arrays
Looping through Arrays
Associative Arrays
Initializing Associative Arrays
Reading from Associative Arrays
Looping through Associative Arrays
Superglobal Arrays
Initializing Associative Arrays
Reading from Associative Arrays
Looping through Associative Arrays
Superglobal Arrays
Two-dimensional Arrays
Reading from Two-dimensional Arrays
Looping through Two-dimensional Arrays
Reading from Two-dimensional Arrays
Looping through Two-dimensional Arrays
Array Manipulation Functions
Conclusion
PHP and HTML Forms
HTML Forms
How HTML Forms Work
A Sample HTML Form
Form Variables
How HTML Forms Work
A Sample HTML Form
Form Variables
Conclusion
String Manipulation
Formatting Strings
Concatenation
String Manipulation Functions
Examples of String Functions
Concatenation
String Manipulation Functions
Examples of String Functions
Magic Quotes
magic_quotes_gpc
magic_quotes_runtime
Recommendation on Magic Quotes
Conclusion
magic_quotes_gpc
magic_quotes_runtime
Recommendation on Magic Quotes
Conclusion
Reusing Code and Writing Functions
Including Files
require
require_once
auto_prepend_file and auto_append_file
require
require_once
auto_prepend_file and auto_append_file
User Functions
Defining and Calling Functions
Default Values
Variable Scope
By Reference vs. By Value
Defining and Calling Functions
Default Values
Variable Scope
By Reference vs. By Value
Form Processing
Code Organization
Code Organization
Conclusion
Simple SELECTs
Introduction to the Northwind Database
Some Basics
Comments
Whitespace and Semi-colons
Case Sensitivity
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
Sorting By Column Position
Ascending and Descending Sorts
Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts
The WHERE Clause and Operator Symbols
Checking for Equality
Checking for Inequality
Checking for Greater or Less Than
Checking for NULL
WHERE and ORDER BY
Checking for Equality
Checking for Inequality
Checking for Greater or Less Than
Checking for NULL
WHERE and ORDER BY
The WHERE Clause and Operator Words
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
Checking Multiple Conditions
AND
OR
Order of Evaluation
AND
OR
Order of Evaluation
Conclusion
Subqueries, Joins and Unions
Subqueries
Joins
Table Aliases
Multi-table Joins
Table Aliases
Multi-table Joins
Outer Joins
Unions
UNION ALL
UNION Rules
UNION ALL
UNION Rules
Conclusion
Inserting, Updating and Deleting Records
INSERT
UPDATE
DELETE
Conclusion
Managing Data
Querying a Database
mysqli() Overview
mysqli Methods and Properties
Inserting and Updating Records
mysqli Prepared Statements
mysqli() Overview
mysqli Methods and Properties
Inserting and Updating Records
mysqli Prepared Statements
Conclusion
PEAR:DB
Advantages and Disadvantages of PEAR DB
Why use a database abstraction layer?
When not to use a database abstraction layer?
Why use a database abstraction layer?
When not to use a database abstraction layer?
Using PEAR DB
Authentication with PHP and SQL
A Database-less Login Form
Conclusion
Regular Expressions
Perl-compatible Regular Expression Functions
preg_match()
preg_replace()
Regular Expression Tester
preg_match()
preg_replace()
Regular Expression Tester
Regular Expression Syntax
Start and End ( ^ $ )
Number of Occurrences ( ? + * {} )
Common Characters ( . \d \D \w \W \s \S )
Grouping ( [] )
Negation ( ^ )
Subpatterns ( () )
Alternatives ( | )
Escape Character ( \ )
Start and End ( ^ $ )
Number of Occurrences ( ? + * {} )
Common Characters ( . \d \D \w \W \s \S )
Grouping ( [] )
Negation ( ^ )
Subpatterns ( () )
Alternatives ( | )
Escape Character ( \ )
Form Validation Functions with Regular Expressions
Conclusion
Session Control and Cookies
Sessions
Configuring Sessions
Session Functions
Configuring Sessions
Session Functions
Cookies
Conclusion
Sending Email with PHP
mail()
Shortcomings of mail()
Shortcomings of mail()
PHPMailer
Conclusion
File System Management
Opening a File
fopen()
fopen()
Reading from a File
fgets()
fgets()
Writing to a File
fwrite()
fwrite()
File Locking
flock()
flock()
Uploading Files via an HTML Form
Getting File Information
More File Functions
Directory Functions
Getting a Directory Listing
Getting a Directory Listing
Conclusion
Please contact your training representative for more details on having this course delivered onsite or online
