Lynda - PHP with MySQL Beyond The Basics

เรียนรู้ PHP ในการทำงานกับ MySQL เบื้องต้น

Lynda.com - PHP with MySQL Beyond The Basics

http://www.lynda.com/home/DisplayCourse.aspx?lpk2=653

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

Homepage: http://www.lynda.com/home/DisplayCourseN.aspx?lpk2=653