PHP with MySQL Beyond the Basics
Author: Kevin Skoglund
Level: Intermediate | Duration: 10h 27m | Released date: Mar 25, 2009
Homepage
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
Introduction
Welcome
Using the exercise files
1. Installation and Project Setup
PHP and MySQL installation
Project setup
2. Intermediate PHP Techniques
Using variable variables
Applying more array functions
Building dates and times: Epoch/Unix
Formatting dates and times: Strings and SQL
Setting server and request variables
Establishing global and static variable scope
Making a reference assignment
Using references as function arguments
Using references as function return values
3. Introduction to Object-Oriented Programming (OOP)
Introducing the concept and basics of OOP
Defining classes
Defining class methods
Instantiating a class
Referencing an instance
Defining class properties
4. OOP in Practice
Understanding class inheritance
Setting access modifiers
Using setters and getters
Working with the static modifier
Reviewing the scope resolution operator
Referencing the Parent class
Using constructors and destructors
Cloning objects
Comparing objects
5. Photo Gallery Project Setup
Overview of the project
Creating project and asset directories
Creating a MySQL database
6. Foundations of an OOP Project
Creating the MySQL Database class
Adding queries to the MySQL Database class
Using the database object
How OOP is an improvement
Creating a User class
Instantiating user objects
Revising find methods to instantiate
Autoload: The undeclared object safety net
Creating the Session class
Logging in using the Session class
Initializing files and path constants
Using path content for layout
Late static binding
7. Working with Files and Directories
File system basics
Understanding file permissions
Setting file permissions
PHP permissions
Accessing files
Writing to files
Deleting files
Moving the file pointer
Reading files
Examining file details
Working with directories
Viewing directory content
Creating a log file: Assignment
Creating a log file: Solution
8. Uploading Files
Configuring PHP for file uploads
Sending files as form data
Inspecting uploaded files
Uploading errors
Moving uploaded files
9. Completing the User Class
Remaining user CRUD
Creating users
Updating users
Deleting users
Abstracting the database table name
Abstracting the attributes
Finding the database attributes
10. The Photograph Class
Starting the Photograph class
Coding the Photograph class
Saving photographs
Uploading photographs
Listing photographs
Storing messages in the Session class
Deleting photographs
Displaying photographs in the public area
11. The Comment Class
Creating the Comment class
Building the comment form
Listing comments
Reviewing comments in the staff area
12. Pagination
Understanding the concepts behind pagination
Using LIMIT, OFFSET, and COUNT
Finding the pagination variables
Using the Pagination class
Paginating photographs
Using pagination links
13. Sending Emails
Configuring PHP for email
Sending email with mail()
Using headers
Reviewing SMTP
Using PHPMailer
Building notification for new comments
14. Templating and Code Organization
Using MVC architecture
Simple templating
Using the Smarty PHP templating engine
Building PHP libraries and frameworks
Conclusion
Goodbye
Appendix: PHP Installation and Configuration Assistance
Installing on Mac 10.4 (Tiger)
Installing on Mac 10.5 (Leopard)
Configuring a Mac
The text editor on Mac
phpMyAdmin installation on Mac
Installing on Windows
Configuring on Windows
The text editor on Windows
MySQL basics: phpMyAdmin
Letitbit Download Links:
For America
RapidGator Download Links:
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.