DokuWiki

1. Introduction
   1. Welcome
   2. Introduction
   3. Using the exercise files
2. PHP Overview
   1. What is PHP
   2. The history of PHP
   3. Why choose PHP
   4. Installation overview
3. Mac Installation
   1. Overview
   2. Working with Apache Web Server
   3. Changing the document root
   4. Installing to Yosemite
   5. Enabling PHP
   6. Upgrading PHP
   7. Configuring PHP
   8. Installing MySQL
   9. Configuring MySQL
   10. Text editor
4. Windows Installation
   1. Overview (MS-windows)
   2. Installing WampServer
   3. Finding the document root
   4. Configuring PHP (MS-windows)
   5. Configuring MySQL (MS-windows)
   6. Text editor (MS-windows)
5. First Steps
   1. Embedding PHP code on a page
   2. Outputting dynamic text
   3. The operational trail
   4. Inserting code comments
6. Exploring Data Types
   1. Variables
   2. Strings
   3. String functions
   4. Numbers part one - Integers
   5. Numbers part two - Floating points
   6. Arrays
   7. Associative arrays
   8. Arrays functions
   9. Booleans
   10. NULL and empty
   11. Type juggling and casting
   12. Constants
7. Control Structures - Logical Expressions
   1. If statements
   2. Else and elseif statements
   3. Logical operators
   4. Switch statements
8. Control Structures - Loops
   1. While loops
   2. For loops
   3. Foreach loops
   4. Continue
   5. Break
   6. Understanding array pointers
9. User-Defined Functions
   1. Defining functions
   2. Function arguments
   3. Returning values from a function
   4. Multiple return values
   5. Scope and global variables
   6. Setting default argument values
10. Debugging
    1. Common problems
    2. Warnings and errors
    3. Debugging and troubleshooting
11. Building Web Pages with PHP
    1. Links and URLs
    2. Using GET values
    3. Encoding GET values
    4. Encoding for HTML
    5. Including and requiring files
    6. Modifying headers
    7. Page redirection
    8. Output buffering
    9. Introduction
    10. Introduction
12. Working with Forms and Form Data
    1. Building forms
    2. Detecting form submissions
    3. Single-page form processing
    4. Validating form values
    5. Problems with validation logic
    6. Displaying validation errors
    7. Custom validation functions
    8. Single-page form with validations
13. Working with Cookies and Sessions
    1. Working with cookies
    2. Setting cookie values
    3. Reading cookie values
    4. Unsetting cookie values
    5. Working with sessions
14. MySQL Basics
    1. MySQL introduction
    2. Creating a database
    3. Creating a database table
    4. CRUD in MySQL
    5. Populating a MySQL database
    6. Relational database tables
    7. Populating the relational table
15. Using PHP to Access MySQL
    1. Database APIs in PHP
    2. Connecting to MySQL with PHP
    3. Retrieving data from MySQL
    4. Working with retrieved data
    5. Creating records with PHP
    6. Updating and deleting records with PHP
    7. SQL injection
    8. Escaping strings for MySQL
    9. Introducing prepared statements
16. Building a Content Management System (CMS)
    1. Blueprinting the application
    2. Building the CMS database
    3. Establishing your work area
    4. Creating and styling the first page
    5. Making page assets reusable
    6. Connecting the application to the database
17. Using Site Navigation to Choose Content
    1. Adding pages to the navigation subjects
    2. Refactoring the navigation
    3. Selecting pages from the navigation
    4. Highlighting the current page
    5. Moving the navigation to a function
18. Application CRUD
    1. Finding a subject in the database
    2. Refactoring the page selection
    3. Creating a new subject form
    4. Processing form values and adding subjects
    5. Passing data in the session
    6. Validating form values
    7. Creating an edit subject form
    8. Using single-page submission
    9. Deleting a subject
    10. Cleaning up
    11. Assignment - Pages CRUD
    12. Assignment results - Pages CRUD
19. Building the Public Area
    1. The public appearance
    2. Using a context for conditional code
    3. Adding a default subject behavior
    4. The public content area
    5. Protecting page visibility
20. Regulating Page Access
    1. User authentication overview
    2. Admin CRUD
    3. Encrypting passwords
    4. Salting passwords
    5. Adding password encryption to CMS
    6. New PHP password functions
    7. Creating a login system
    8. Checking for authorization
    9. Creating a logout page
21. Conclusion
    1. Next steps