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
Using the exercise files 2:36

1. Installation and Project Setup
PHP and MySQL installation 0:48
Project setup 3:48

2. Intermediate PHP Techniques
Using variable variables 5:20
Applying more array functions 5:32
Building dates and times: Epoch/Unix 8:47
Formatting dates and times: Strings and SQL 10:06
Setting server and request variables 5:37
Establishing global and static variable scope 5:43
Making a reference assignment 3:00
Using references as function arguments 4:08
Using references as function return values 6:13

3. Introduction to Object-Oriented Programming (OOP)
Introducing the concept and basics of OOP 6:25
Defining classes 4:07
Defining class methods 3:30
Instantiating a class 6:00
Referencing an instance 4:40
Defining class properties 7:34

4. OOP in Practice
Understanding class inheritance 6:24
Setting access modifiers 8:03
Using setters and getters 4:02
Working with the static modifier 8:20
Reviewing the scope resolution operator 2:50
Referencing the Parent class 6:49
Using constructors and destructors 6:10
Cloning objects 3:27
Comparing objects 4:47

5. Photo Gallery Project Setup
Overview of the project 3:09
Creating project and asset directories 6:08
Creating a MySQL database 5:31

6. Foundations of an OOP Project
Creating the MySQL Database class 6:12
Adding queries to the MySQL Database class 3:09
Using the database object 6:47
How OOP is an improvement 5:16
Creating a User class 6:25
Instantiating user objects 8:46
Revising find methods to instantiate 4:03
Autoload: The undeclared object safety net 4:08
Creating the Session class 7:11
Logging in using the Session class 8:56
Initializing files and path constants 6:02
Using path content for layout 4:51
Late static binding 13:05

7. Working with Files and Directories
File system basics 5:28
Understanding file permissions 8:48
Setting file permissions 5:07
PHP permissions 10:53
Accessing files 9:45
Writing to files 5:19
Deleting files 1:51
Moving the file pointer 3:58
Reading files 6:17
Examining file details 6:26
Working with directories 6:44
Viewing directory content 5:28
Creating a log file: Assignment 5:44
Creating a log file: Solution 7:56

8. Uploading Files
Configuring PHP for file uploads 5:42
Sending files as form data 4:22
Inspecting uploaded files 3:55
Uploading errors 3:59
Moving uploaded files 5:54

9. Completing the User Class
Remaining user CRUD 2:04
Creating users 5:18
Updating users 5:58
Deleting users 3:39
Abstracting the database table name 3:30
Abstracting the attributes 5:56
Finding the database attributes 3:35

10. The Photograph Class
Starting the Photograph class 6:16
Coding the Photograph class 5:53
Saving photographs 5:22
Uploading photographs 6:46
Listing photographs 5:55
Storing messages in the Session class 6:15
Deleting photographs 7:54
Displaying photographs in the public area 4:34

11. The Comment Class
Creating the Comment class 7:07
Building the comment form 6:43
Listing comments 6:05
Reviewing comments in the staff area 7:28

12. Pagination
Understanding the concepts behind pagination 2:51
Using LIMIT, OFFSET, and COUNT 2:56
Finding the pagination variables 5:51
Using the Pagination class 5:02
Paginating photographs 2:53
Using pagination links 5:26

13. Sending Emails
Configuring PHP for email 7:30
Sending email with mail() 7:09
Using headers 6:50
Reviewing SMTP 4:09
Using PHPMailer 8:41
Building notification for new comments 8:41

14. Templating and Code Organization
Using MVC architecture 4:12
Simple templating 8:10
Using the Smarty PHP templating engine 2:10
Building PHP libraries and frameworks 3:14

Conclusion
Goodbye 1:40

Appendix: PHP Installation and Configuration Assistance
Installing on Mac 10.4 (Tiger) 11:59
Installing on Mac 10.5 (Leopard) 11:23
Configuring a Mac 13:39
The text editor on Mac 3:27
phpMyAdmin installation on Mac 2:26
Installing on Windows 6:30
Configuring on Windows 8:21
The text editor on Windows 4:11
MySQL basics: phpMyAdmin 12:26


Download:
part 1
part 2
part 3
part 4
part 5
part 6
part 7
part 8
part 9
part 10
part 11
part 12
part 13
part 14
part 15