This course is available for customized on-site delivery for groups of 3 or more students. Contact us today at 877-258-8987 for more information or a quote.

Scroll down the page for a list of upcoming course dates in our public calendar.

Introduction to PHP with MySQL/PostgreSQL/Oracle/DB2 (5 days)

Our Learning PHP course is the course developers need to learn how to leverage the PHP language and the MySQL database to generate web applications. This course covers the fundamentals of PHP programming, and also covers some advanced features of the language, such as Object Oriented database access, XML, and sending text and HTML email messages.

This course teaches students a database engine independent method of accessing databases (using PHP Data Objects (PDO) ). This allows students to develop PHP applications that are portable across database engines, using a single, abstracted interface.

1Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services.2Include course and course materials only.3Requires a broadband internet connection and microphone. Note that Virtual LIVE courses are led by an instructor, and as such start and end in local time (based on the course location), this my differ from your time zone.
For government and education pricing, please contact us.

Recommended Pre-requisites

Some understanding of programming concepts, HTML, and experience working with a DBMS is recommended prior to attending this course.

Course Outline/Agenda

Introduction to PHP

PHP's role in the WWW

Language fundamentals

PHP Basics

PHP Data types

Storing &amp retrieving information in variables

Basic operations with variables

Variable rules

Decision making in PHP

Comparison operators

The if construct

The while construct

The for construct

Arrays and PHP

Working with arrays

Sorting arrays

Other array related functions

Multi-dimensional arrays

Re-using PHP code

Functions

Declaring functions

Passing data by reference

Including code in scripts

Variable scope in PHP

PHP and the WWW server

Working with web forms

PHP POST & GET form elements

Embedding forms with PHP code

Validating form data

Preventing spoofed submissions

Guidelines for secure PHP

Understanding magic quotes

Setting default values in forms

Processing uploaded files

Retrieving & Sorting uploaded files

Working with databases and ADODB

A brief history of databases

Relational database concepts

Database tables

Using the CREATE TABLE statement

SQL Data types

Integer data types

Floating point data types

Character data types

Other SQL data types

SQL column modifiers

Understanding SERIAL and AUTO_INCREMENT column options

Table & database naming syntax

Manipulating data in SQL

The SELECT statement

Overall SELECT syntax

Selecting values to display

Restricting selections using the WHERE clause

Using ORDER BY to sort query results

Using LIMIT to limit result sets

The INSERT statement

The UPDATE Statement

The DELETE and TRUNCATE TABLE statements

Leveraging existing code using PEAR & PECL

Accessing databases using PHP

Downloading & Installing ADODB

Creating a Data Source Name (DSN)

Setting connection options & connecting to the database

Executing SQL statements

Executing prepared statements

Multiple statement execution

Retrieving information about queries (metadata)

Transactions and queries

Retrieving data from a database

Single-step queries

Managing web sessions

Using PHP session handling

PHP cookie handling

Handling date & time in PHP

Diplaying dates & times

Parsing a date or time

Generating relative times

Working with files in PHP

Reading & writing files with PHP

File permissions

Handling errors

Working with XML data in PHP

Understanding XML

RSS Feeds

Sending email using PHP

PHP Email settings

Sending text messages using PHP

Sending HTML formatted email messages using PHP

Debugging PHP Code

PHP Error handling

PHP debugging tools

Suppressing errors

Class Size

This class is limited to a maximum of 12 students.

On-Site Delivery

This course is available for on-site delivery for groups of 3 or more students.

OTG offers discounted training for on-site courses of more than 3 students - call us at 877-258-8987 (or submit the form on the upper right side of this page) for more information.

Course Details

Upon completion of this course, students will be able to:

Develop PHP scripts that perform decision making and looping tasks

Develop PHP scripts that integrate with a WWW server, and do the following: