PHP Training 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

PHP Level 2

Course Fee: $597.00
Course Time: 2 Days, 9am - 4pm

• 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
• 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