Kevin Skoglund: PHP with MySQL Beyond the Basics [repost]

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.

Training Contents:
Introduction
Welcome 1:28 14.4 MB
Using the exercise files 2:36 2.4 MB
1. Installation and Project Setup
PHP and MySQL installation 0:48 1.3 MB
Project setup 3:48 3.4 MB
2. Intermediate PHP Techniques
Using variable variables 5:20 4.7 MB
Applying more array functions 5:32 5.4 MB
Building dates and times: Epoch/Unix 8:47 6.9 MB
Formatting dates and times: Strings and SQL 10:06 9.0 MB
Setting server and request variables 5:37 5.0 MB
Establishing global and static variable scope 5:43 5.1 MB
Making a reference assignment 3:00 2.7 MB
Using references as function arguments 4:08 3.5 MB
Using references as function return values 6:13 5.7 MB
3. Introduction to Object-Oriented Programming (OOP)
Introducing the concept and basics of OOP 6:25 4.2 MB
Defining classes 4:07 3.8 MB
Defining class methods 3:30 3.3 MB
Instantiating a class 6:00 4.9 MB
Referencing an instance 4:40 3.6 MB
Defining class properties 7:34 7.6 MB
4. OOP in Practice
Understanding class inheritance 6:24 5.6 MB
Setting access modifiers 8:03 7.2 MB
Using setters and getters 4:02 3.4 MB
Working with the static modifier 8:20 7.0 MB
Reviewing the scope resolution operator 2:50 2.5 MB
Referencing the Parent class 6:49 5.6 MB
Using constructors and destructors 6:10 4.9 MB
Cloning objects 3:27 3.1 MB
Comparing objects 4:47 4.2 MB
5. Photo Gallery Project Setup
Overview of the project 3:09 2.1 MB
Creating project and asset directories 6:08 5.5 MB
Creating a MySQL database 5:31 4.5 MB
6. Foundations of an OOP Project
Creating the MySQL Database class 6:12 6.8 MB
Adding queries to the MySQL Database class 3:09 4.1 MB
Using the database object 6:47 6.5 MB
How OOP is an improvement 5:16 6.9 MB
Creating a User class 6:25 7.4 MB
Instantiating user objects 8:46 10.6 MB
Revising find methods to instantiate 4:03 4.3 MB
Autoload: The undeclared object safety net 4:08 4.6 MB
Creating the Session class 7:11 6.6 MB
Logging in using the Session class 8:56 12.6 MB
Initializing files and path constants 6:02 8.1 MB
Using path content for layout 4:51 5.9 MB
Late static binding 13:05 15.4 MB
7. Working with Files and Directories
File system basics 5:28 5.2 MB
Understanding file permissions 8:48 6.4 MB
Setting file permissions 5:07 5.3 MB
PHP permissions 10:53 11.1 MB
Accessing files 9:45 7.9 MB
Writing to files 5:19 5.2 MB
Deleting files 1:51 1.8 MB
Moving the file pointer 3:58 3.4 MB
Reading files 6:17 7.2 MB
Examining file details 6:26 7.2 MB
Working with directories 6:44 7.5 MB
Viewing directory content 5:28 6.4 MB
Creating a log file: Assignment 5:44 4.1 MB
Creating a log file: Solution 7:56 7.1 MB
8. Uploading Files
Configuring PHP for file uploads 5:42 4.8 MB
Sending files as form data 4:22 5.4 MB
Inspecting uploaded files 3:55 3.4 MB
Uploading errors 3:59 3.7 MB
Moving uploaded files 5:54 5.8 MB
9. Completing the User Class
Remaining user CRUD 2:04 2.1 MB
Creating users 5:18 5.8 MB
Updating users 5:58 7.6 MB
Deleting users 3:39 4.6 MB
Abstracting the database table name 3:30 7.3 MB
Abstracting the attributes 5:56 9.1 MB
Finding the database attributes 3:35 3.8 MB
10. The Photograph Class
Starting the Photograph class 6:16 8.4 MB
Coding the Photograph class 5:53 8.4 MB
Saving photographs 5:22 8.6 MB
Uploading photographs 6:46 8.1 MB
Listing photographs 5:55 8.2 MB
Storing messages in the Session class 6:15 8.7 MB
Deleting photographs 7:54 11.1 MB
Displaying photographs in the public area 4:34 6.0 MB
11. The Comment Class
Creating the Comment class 7:07 9.3 MB
Building the comment form 6:43 9.6 MB
Listing comments 6:05 12.2 MB
Reviewing comments in the staff area 7:28 9.3 MB
12. Pagination
Understanding the concepts behind pagination 2:51 2.7 MB
Using LIMIT, OFFSET, and COUNT 2:56 2.2 MB
Finding the pagination variables 5:51 8.9 MB
Using the Pagination class 5:02 5.0 MB
Paginating photographs 2:53 4.3 MB
Using pagination links 5:26 6.7 MB
13. Sending Emails
Configuring PHP for email 7:30 5.2 MB
Sending email with mail() 7:09 5.8 MB
Using headers 6:50 7.3 MB
Reviewing SMTP 4:09 2.5 MB
Using PHPMailer 8:41 12.4 MB
Building notification for new comments 8:41 11.7 MB
14. Templating and Code Organization
Using MVC architecture 4:12 5.9 MB
Simple templating 8:10 10.6 MB
Using the Smarty PHP templating engine 2:10 3.1 MB
Building PHP libraries and frameworks 3:14 2.1 MB
Conclusion
Goodbye 1:40 1.0 MB
Appendix: PHP Installation and Configuration Assistance
Installing on Mac 10.4 (Tiger) 11:59 13.6 MB
Installing on Mac 10.5 (Leopard) 11:23 9.8 MB
Configuring a Mac 13:39 10.0 MB
The text editor on Mac 3:27 3.6 MB
phpMyAdmin installation on Mac 2:26 2.2 MB
Installing on Windows 6:30 6.2 MB
Configuring on Windows 8:21 7.6 MB
The text editor on Windows 4:11 4.8 MB
MySQL basics: phpMyAdmin 12:26 11.5 MB


included exercise files