PHP with MySQL Beyond the Basics

In PHP with MySQL Beyond the Basics, expert instructor Kevin Skoglund introduces powerful PHP programming techniques using object-oriented programming (OOP). Both novice and experienced PHP developers will benefit from the efficient, well-organized, reusable, and easy-to-understand code that OOP offers. Kevin shows how OOP techniques can streamline database queries, help manage sessions, and simplify user logins. While building a real-world web application, Kevin also includes practical advice on topics ranging from structuring code to logging user actions. Exercise files accompany the course.

00-Introduction

01-Welcome
02-Using the exercise files

01-Installation and Project Setup

01-PHP and MySQL installation
02-Project setup

02-Intermediate PHP Techniques

01-Using variable variables
02-Applying more array functions
03-Building dates and times Epoch Unix
04-Formatting dates and times Strings and SQL
05-Setting server and request variables
06-Establishing global and static variable scope
07-Making a reference assignment
08-Using references as function arguments
09-Using references as function return values

03-Introduction to Object-Oriented Programming (OOP)

01-Introducing the concept and basics of OOP
02-Defining classes
03-Defining class methods
04-Instantiating a class
05-Referencing an instance
06-Defining class properties

04-OOP in Practice

01-Understanding class inheritance
02-Setting access modifiers
03-Using setters and getters
04-Working with the static modifier
05-Reviewing the scope resolution operator
06-Referencing the Parent class
07-Using constructors and destructors
08-Cloning objects
09-Comparing objects

05-Photo Gallery Project Setup

01-Overview of the project
02-Creating project and asset directories
03-Creating a MySQL database

06-Foundations of an OOP Project

01-Creating the MySQL Database class
02-Adding queries to the MySQL Database class
03-Using the database object
04-How OOP is an improvement
05-Creating a User class
06-Instantiating user objects
07-Revising find methods to instantiate
08-Autoload The undeclared object safety net
09-Creating the Session class
10-Logging in using the Session class
11-Initializing files and path constants
12-Using path content for layout
13- Late static binding

07-Working with Files and Directories

01- File system basics
02-Understanding file permissions
03-Setting file permissions
04-PHP permissions
05-Accessing files
06-Writing to files
07-Deleting files
08-Moving the file pointer
09-Reading file
10-Examining file details
11-Working with directorie
12-Viewing directory content
13-Creating a log file Assignment
14-Creating a log file Solution

08-Uploading Files

01-Configuring PHP for file uploads
02-Sending files as form data
03-Inspecting uploaded files
04-Uploading errors
05-Moving uploaded files

09-Completing the User Class

01- Remaining user CRUD
02-Creating users
03-Updating users
04-Deleting users
05-Abstracting the database table name
06-Abstracting the attributes
07-Finding the database attributes

10-The Photograph Class

01- Starting the Photograph class
02-Coding the Photograph class
03-Saving photographs
04-Uploading photographs
05-Listing photographs
06-Storing messages in the Session class
07-Deleting photographs
08-Displaying photographs in the public area

11- The Comment Class

01-Creating the Comment class
02-Building the comment form
03-Listing comment
04-Reviewing comments in the staff area

12-Pagination

01-Understanding the concepts behind pagination
02-Using LIMIT, OFFSET, and COUNT
03-Finding the pagination variables
04-Using the Pagination class
05-Paginating photograph
06-Using pagination links

13-Sending Emails

01-Configuring PHP for emails
02-Sending email with mail()
03-Using headers
04-Reviewing SMTP
05-Using PHPMailer
06-Building notification for new comments

14-Templating and Code Organization

01-Using MVC architecture
02-Simple templating
03-Using the Smarty PHP templating engine
04-Building PHP libraries and frameworks

15-Appendix PHP Installation and Configuration Assistance

01-Installing on Mac 10.4 (Tiger)
02-Installing on Mac 10.5 (Leopard)
03-Configuring a Mac
04-The text editor on Mac
05-phpMyAdmin installation on Mac
06-Installing on Window
07-Configuring on Windows
08-The text editor on Windows
09-MySQL basics phpMyAdmins

16-Conclusion

Goodbye