• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

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.

Course PHP with MySQL Beyond the Basics Author Kevin Skoglund SKU ISBN Release Date 2009-03-25 Duration 10.27 hrs / 108 tutorials Work files Yes Price $ 79.95 Retail price $ 149.95 Language Tags

1. Installation and Project Setup PHP and MySQL installation 00:48 Project setup 03:48 2. Intermediate PHP Techniques Using variable variables 05:20 Applying more array functions 05:32 Building dates and times: Epoch/Unix 08:47 Formatting dates and times: Strings and SQL 10:06 Setting server and request variables 05:37 Establishing global and static variable scope 05:43 Making a reference assignment 03:00 Using references as function arguments 04:08 Using references as function return values 06:13 3. Introduction to Object-Oriented Programming (OOP) Introducing the concept and basics of OOP 06:25 Defining classes 04:07 Defining class methods 03:30 Instantiating a class 06:00 Referencing an instance 04:40 Defining class properties 07:34 4. OOP in Practice Understanding class inheritance 06:24 Setting access modifiers 08:03 Using setters and getters 04:02 Working with the static modifier 08:20 Reviewing the scope resolution operator 02:50 Referencing the Parent class 06:49 Using constructors and destructors 06:10 Cloning objects 03:27 Comparing objects 04:47 5. Photo Gallery Project Setup Overview of the project 03:09 Creating project and asset directories 06:08 Creating a MySQL database 05:31 6. Foundations of an OOP Project Creating the MySQL Database class 06:12 Adding queries to the MySQL Database class 03:09 Using the database object 06:47 How OOP is an improvement 05:16 Creating a User class 06:25 Instantiating user objects 08:46 Revising find methods to instantiate 04:03 Autoload: The undeclared object safety net 04:08 Creating the Session class 07:11 Logging in using the Session class 08:56 Initializing files and path constants 06:02 Using path content for layout 04:51 Late static binding 13:05 7. Working with Files and Directories File system basics 05:28 Understanding file permissions 08:48 Setting file permissions 05:07 PHP permissions 10:53 Accessing files 09:45 Writing to files 05:19 Deleting files 01:51 Moving the file pointer 03:58 Reading files 06:17 Examining file details 06:26 Working with directories 06:44 Viewing directory content 05:28 Creating a log file: Assignment 05:44 Creating a log file: Solution 07:56 8. Uploading Files

Configuring PHP for file uploads 05:42 Sending files as form data 04:22 Inspecting uploaded files 03:55 Uploading errors 03:59 Moving uploaded files 05:54 9. Completing the User Class Remaining user CRUD 02:04 Creating users 05:18 Updating users 05:58 Deleting users 03:39 Abstracting the database table name 03:30 Abstracting the attributes 05:56 Finding the database attributes 03:35 10. The Photograph Class Starting the Photograph class 06:16 Coding the Photograph class 05:53 Saving photographs 05:22 Uploading photographs 06:46 Listing photographs 05:55 Storing messages in the Session class 06:15 Deleting photographs 07:54 Displaying photographs in the public area 04:34 11. The Comment Class Creating the Comment class 07:07 Building the comment form 06:43 Listing comments 06:05 Reviewing comments in the staff area 07:28 12. Pagination Understanding the concepts behind pagination 02:51 Using LIMIT, OFFSET, and COUNT 02:56 Finding the pagination variables 05:51 Using the Pagination class 05:02 Paginating photographs 02:53 Using pagination links 05:26 13. Sending Emails Configuring PHP for email 07:30 Sending email with mail() 07:09 Using headers 06:50 Reviewing SMTP 04:09 Using PHPMailer 08:41 Building notification for new comments 08:41 14. Templating and Code Organization Using MVC architecture 04:12 Simple templating 08:10 Using the Smarty PHP templating engine 02:10 Building PHP libraries and frameworks 03:14 Conclusion Goodbye 01: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 03:27 phpMyAdmin installation on Mac 02:26 Installing on Windows 06:30 Configuring on Windows 08:21 The text editor on Windows 04:11 MySQL basics: phpMyAdmin 12:26