Advanced PHP - MySQL Training DVD

Introduction

• Welcome
• Using the exercise files

1. Installation and Project Setup

• PHP and MySQL installation
• Project setup

2. Intermediate PHP Techniques

• Using variable variables
• Applying more array functions
• Building dates and times: Epoch/Unix
• Formatting dates and times: Strings and SQL
• Setting server and request variables
• Establishing global and static variable scope
• Making a reference assignment
• Using references as function arguments
• Using references as function return values

3. Introduction to Object-Oriented Programming (OOP)

• Introducing the concept and basics of OOP
• Defining classes
• Defining class methods
• Instantiating a class
• Referencing an instance
• Defining class properties

4. OOP in Practice

• Understanding class inheritance
• Setting access modifiers
• Using setters and getters
• Working with the static modifier
• Reviewing the scope resolution operator
• Referencing the Parent class
• Using constructors and destructors
• Cloning objects
• Comparing objects

5. Photo Gallery Project Setup

• Overview of the project
• Creating project and asset directories
• Creating a MySQL database

6. Foundations of an OOP Project

• Creating the MySQL Database class
• Adding queries to the MySQL Database class
• Using the database object
• How OOP is an improvement
• Creating a User class
• Instantiating user objects
• Revising find methods to instantiate
• Autoload: The undeclared object safety net
• Creating the Session class
• Logging in using the Session class
• Initializing files and path constants
• Using path content for layout
• Late static binding

7. Working with Files and Directories

• File system basics
• Understanding file permissions
• Setting file permissions
• PHP permissions
• Accessing files
• Writing to files
• Deleting files
• Moving the file pointer
• Reading files
• Examining file details
• Working with directories
• Viewing directory content
• Creating a log file: Assignment
• Creating a log file: Solution

8. Uploading Files

• Configuring PHP for file uploads
• Sending files as form data
• Inspecting uploaded files
• Uploading errors
• Moving uploaded files

9. Completing the User Class

• Remaining user CRUD
• Creating users
• Updating users
• Deleting users
• Abstracting the database table name
• Abstracting the attributes
• Finding the database attributes

10. The Photograph Class

• Starting the Photograph class
• Coding the Photograph class
• Saving photographs
• Uploading photographs
• Listing photographs
• Storing messages in the Session class
• Deleting photographs
• Displaying photographs in the public area

11. The Comment Class

• Creating the Comment class
• Building the comment form
• Listing comments
• Reviewing comments in the staff area

12. Pagination

• Understanding the concepts behind pagination
• Using LIMIT, OFFSET, and COUNT
• Finding the pagination variables
• Using the Pagination class
• Paginating photographs
• Using pagination links

13. Sending Emails

• Configuring PHP for email
• Sending email with mail()
• Using headers
• Reviewing SMTP
• Using PHPMailer
• Building notification for new comments

14. Templating and Code Organization

• Using MVC architecture
• Simple templating
• Using the Smarty PHP templating engine
• Building PHP libraries and frameworks

Conclusion

• Goodbye

Appendix: PHP Installation and Configuration Assistance

• Installing on Mac 10.4 (Tiger)
• Installing on Mac 10.5 (Leopard)
• Configuring a Mac
• The text editor on Mac
• phpMyAdmin installation on Mac
• Installing on Windows
• Configuring on Windows
• The text editor on Windows
• MySQL basics: phpMyAdmin