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:
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
- 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
- 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
- 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()
- PHPMailer
- Conclusion
- File System Management
- Opening a File
- fopen()
- Reading from a File
- fgets()
- Writing to a File
- fwrite()
- File Locking
- flock()
- Uploading Files via an HTML Form
- Getting File Information
- More File Functions
- Directory Functions
- Getting a Directory Listing
- Getting a Directory Listing
- Conclusion
|
