Object-Oriented Programming with PHP and MySQL

Training Calendar

Previous Year Previous Month Next Year Next Month

October 2018

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

Yesterday:	10
This Week:	10
Last Week:	6
This Month:	21
Last Month:	185
Total:	46492

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.

Download Brochure

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