1. PHP Basics- How PHP Works
- The php.ini File
- Basic PHP Syntax
- 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
- PHP Operators
- Creating Dynamic Pages
- Single Quotes vs. Double Quotes
- Hello World!
- Conclusion
| 2. Flow Control- Conditional Processing
- If Conditions
- Loops
- while
- do...while
- for
- break and continue
- Conclusion
|
3. Arrays- Enumerated 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
- Two-dimensional Arrays
- Reading from Two-dimensional Arrays
- Looping through Two-dimensional Arrays
- Array Manipulation Functions
- Conclusion
| 4. PHP and HTML Forms- HTML Forms
- How HTML Forms Work
- A Sample HTML Form
- Form Variables
- Conclusion
|
5. String Manipulation- Formatting Strings
- Concatenation
- String Manipulation Functions
- Examples of String Functions
- Magic Quotes
- magic_quotes_gpc
- magic_quotes_runtime
- Recommendation on Magic Quotes
- Conclusion
- Conclusion
| 6. Reusing Code and Writing Functions- Including Files
- 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
- Form Processing
- Code Organization
- Conclusion
|
7. 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
- 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
- The WHERE Clause and Operator Words
- The BETWEEN Operator
- The IN Operator
- The LIKE Operator
- The NOT Operator
- Checking Multiple Conditions
- Conclusion
| 8. Subqueries, Joins and Unions- Subqueries
- Joins
- Table Aliases
- Multi-table Joins
- Outer Joins
- Unions
- Conclusion
|
9. Inserting, Updating and Deleting Records- INSERT
- UPDATE
- DELETE
- Conclusion
| 10. Managing Data- Querying a Database
- mysqli() Overview
- mysqli Methods and Properties
- Inserting and Updating Records
- mysqli Prepared Statements
|
11. 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
| 12. Authentication with PHP and SQL- A Database-less Login Form
- Conclusion
|
13. Regular Expressions- Perl-compatible Regular Expression Functions
- 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 ( \ )
- Form Validation Functions with Regular Expressions
- Conclusion
| 14. Session Control and Cookies- Sessions
- Configuring Sessions
- Session Functions
- Conclusion
|
15. Sending Email with PHP- mail()
- Shortcomings of mail()
- PHPMailer
- Conclusion
| 16. File System Management- Opening a File
- Reading from a File
- Writing to a File
- File Locking
- Uploading Files via an HTML Form
- Getting File Information
- More File Functions
- Directory Functions
- Getting a Directory Listing
|
17. WordPress- WordPress 3.8 essentials
- Creating and Editing WordPress Themes
- Creating custom widgets and plug-ins with WordPress
| |
