Training Calendar

Mon Tue Wed Thu Fri Sat Sun
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

psmb

Total Visitors

50%United States United States
27.5%China China
15%Canada Canada
5%Malaysia Malaysia
2.5%United Kingdom United Kingdom

Last Week: 3
This Month: 3
Last Month: 26
Total: 50067

Object-Oriented Programming with PHP and MySQL

 

Course Overview

PHP is an excellent procedural language and many PHP programmers have never learned OOP. However, since PHP 5 (and especially PHP 5.3), PHP has actually had an exceptionally good set of OOP features that can really improve the structure and maintainability of your apps. Virtually all modern PHP frameworks are now built on OOP architecture. This course is designed to provide a rock-solid foundation in object-oriented programming with PHP. This course teaches PHP developers the advanced concepts required to create robust PHP web applications using object orientation. It also examines common PHP web development tasks like interacting with the file system, querying a database, managing uploaded files, etc.

 

 

Prerequisites

All participants must be familiar with the fundamentals of building data-driven PHP web applications.

 

Target Audience

Software Developers who want to learn how PHP and MySQL can be used for the rapid prototyping and deployment of dynamic websites.

 

OOP PHP-MySQL Advanced – Schedule

Day 1

09.00am – 10.00am

Introduction

  • Installation and Project Setup
  • PHP and MySQL installation
  • Project setup
10.00am – 10.30am

Breakfast

10.30am – 01.00pm

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

01.00pm – 02.00pm

Lunch

02.00pm – 05.00pm

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

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

Day 2

09.00am – 10.00am

Photo Gallery Project Setup

  • Overview of the project
  • Creating project and asset directories
  • Creating a MySQL database

10.00am – 10.30am

Breakfast

10.30am – 01.00pm

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

01.00pm – 02.00pm

Lunch

02.00pm – 05.00pm

Working with Files and Directories

  • File system basics
  • Understanding file permissions
  • Setting file permissions
  • Deleting files

Uploading Files

  • Configuring PHP for file uploads
  • Sending files as form data
  • Inspecting uploaded files
  • Uploading errors
  • Moving uploaded files

                                                                        Day 3

09.00am – 10.00am

Completing the User Class

  • Remaining user CRUD

10.00am – 10.30am

Breakfast

10.30am – 01.00pm

  • Creating users
  • Updating users
  • Deleting users
  • Finding the database attributes

01.00pm – 02.00pm

Lunch

02.00pm – 05.00pm

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

Day 4

09.00am – 10.00am

The Comment Class

  • Creating the Comment class
  • Building the comment form

10.00am – 10.30am

Breakfast

10.30am – 01.00pm


  • Listing comments
  • Reviewing comments in the staff area

01.00pm – 02.00pm

Lunch

02.00pm – 05.00pm

Pagination

  • Understanding the concepts behind pagination
  • Using LIMIT, OFFSET, and COUNT
  • Finding the pagination variables
  • Using the Pagination class
  • Paginating photographs
  • Using pagination links

Conclusion