[Lynda.com]PHP with MySQL Beyond the Basics

PHP with MySQL Beyond the Basics

 

with Kevin Skoglund

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.

Topics include:

• Defining and using classes, methods, and attributes
• Understanding class inheritance and access modifiers
• Working with files and directories
• Uploading files to a server via forms
• Sending emails with PHP
• Using pagination and View templates

show more

author

Kevin Skoglund

subject

Developer, Application Servers,Databases, Web Development,Web + Interactive, Scripting Languages

software

MySQL, PHP

level

Intermediate

duration

10h 27m

released

Mar 25, 2009

DVD

purchase

• table of contents
• exercise files
• transcript
• author
• preferences
• FAQs

subscribelearn more

Get immediate access to the entire library!

expand all | collapse all

viewed duration

Introduction4m 4s

Welcome1m 28s  

Using the exercise files2m 36s  

1. Installation and Project Setup4m 36s

PHP and MySQL installation48s  

Project setup3m 48s  

2. Intermediate PHP Techniques54m 26s

Using variable variables5m 20s  

Applying more array functions5m 32s  

Building dates and times: Epoch/Unix8m 47s  

Formatting dates and times: Strings and SQL10m 6s  

Setting server and request variables5m 37s  

Establishing global and static variable scope5m 43s  

Making a reference assignment3m 0s  

Using references as function arguments4m 8s  

Using references as function return values6m 13s  

3. Introduction to Object-Oriented Programming (OOP)32m 16s

Introducing the concept and basics of OOP6m 25s  

Defining classes4m 7s  

Defining class methods3m 30s  

Instantiating a class6m 0s  

Referencing an instance4m 40s  

Defining class properties7m 34s  

4. OOP in Practice50m 52s

Understanding class inheritance6m 24s  

Setting access modifiers8m 3s  

Using setters and getters4m 2s  

Working with the static modifier8m 20s  

Reviewing the scope resolution operator2m 50s  

Referencing the Parent class6m 49s  

Using constructors and destructors6m 10s  

Cloning objects3m 27s  

Comparing objects4m 47s  

5. Photo Gallery Project Setup14m 48s

Overview of the project3m 9s  

Creating project and asset directories6m 8s  

Creating a MySQL database5m 31s  

6. Foundations of an OOP Project1h 24m

Creating the MySQL Database class6m 12s  

Adding queries to the MySQL Database class3m 9s  

Using the database object6m 47s  

How OOP is an improvement5m 16s  

Creating a User class6m 25s  

Instantiating user objects8m 46s  

Revising find methods to instantiate4m 3s  

Autoload: The undeclared object safety net4m 8s  

Creating the Session class7m 11s  

Logging in using the Session class8m 56s  

Initializing files and path constants6m 2s  

Using path content for layout4m 51s  

Late static binding13m 5s  

7. Working with Files and Directories1h 29m

File system basics5m 28s  

Understanding file permissions8m 48s  

Setting file permissions5m 7s  

PHP permissions10m 53s  

Accessing files9m 45s  

Writing to files5m 19s  

Deleting files1m 51s  

Moving the file pointer3m 58s  

Reading files6m 17s  

Examining file details6m 26s  

Working with directories6m 44s  

Viewing directory content5m 28s  

Creating a log file: Assignment5m 44s  

Creating a log file: Solution7m 56s  

8. Uploading Files23m 52s

Configuring PHP for file uploads5m 42s  

Sending files as form data4m 22s  

Inspecting uploaded files3m 55s  

Uploading errors3m 59s  

Moving uploaded files5m 54s  

9. Completing the User Class30m 0s

Remaining user CRUD2m 4s  

Creating users5m 18s  

Updating users5m 58s  

Deleting users3m 39s  

Abstracting the database table name3m 30s  

Abstracting the attributes5m 56s  

Finding the database attributes3m 35s  

10. The Photograph Class48m 55s

Starting the Photograph class6m 16s  

Coding the Photograph class5m 53s  

Saving photographs5m 22s  

Uploading photographs6m 46s  

Listing photographs5m 55s  

Storing messages in the Session class6m 15s  

Deleting photographs7m 54s  

Displaying photographs in the public area4m 34s  

11. The Comment Class27m 23s

Creating the Comment class7m 7s  

Building the comment form6m 43s  

Listing comments6m 5s  

Reviewing comments in the staff area7m 28s  

12. Pagination24m 59s

Understanding the concepts behind pagination2m 51s  

Using LIMIT, OFFSET, and COUNT2m 56s  

Finding the pagination variables5m 51s  

Using the Pagination class5m 2s  

Paginating photographs2m 53s  

Using pagination links5m 26s  

13. Sending Emails43m 0s

Configuring PHP for email7m 30s  

Sending email with mail()7m 9s  

Using headers6m 50s  

Reviewing SMTP4m 9s  

Using PHPMailer8m 41s  

Building notification for new comments8m 41s  

14. Templating and Code Organization17m 46s

Using MVC architecture4m 12s  

Simple templating8m 10s  

Using the Smarty PHP templating engine2m 10s  

Building PHP libraries and frameworks3m 14s  

Conclusion1m 40s

Goodbye1m 40s  

Appendix: PHP Installation and Configuration Assistance1h 14m

Installing on Mac 10.4 (Tiger)11m 59s  

Installing on Mac 10.5 (Leopard)11m 23s  

Configuring a Mac13m 39s  

The text editor on Mac3m 27s  

phpMyAdmin installation on Mac2m 26s  

Installing on Windows6m 30s  

Configuring on Windows8m 21s  

The text editor on Windows4m 11s  

MySQL basics: phpMyAdmin12m 26s