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.

Table of 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