PHP Training: Introduction to PHP & MySQL

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