KB0154 - PHP & MySQL Programming

Course Length: 30 hrs

Course Description

This hands-on course provides the knowledge necessary to design and develop dynamic, database-driven web pages using PHP and MySQL. PHP is a server-side scripting language written for the web, quick to learn, and easy to deploy. Students discover how to connect to a MySQL database, and perform hands-on practice creating database-driven HTML forms and reports.

Course Outcomes:

Develop PHP scripts that perform decision making and looping tasks

Develop PHP scripts that integrate with a WWW server

Understand how to interact with a database

Communicate with a database using PHP

Work with XML data

Recommended Pre-requisites

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

Course Outline

Chapter 1: Introduction to PHP

PHP role in the WWW

Language fundamentals

Chapter 2: PHP Basics

PHP Data types

Storing & retrieving information in variables

Basic operations with variables

Variable rules

Chapter 3: Decision making in PHP

Comparison operators

The if construct

The while construct

T he for construct

Chapter 4: Arrays and PHP

Working with arrays

Sorting arrays

Other array related functions

Multi-dimensional arrays

Chapter 5: Re-using PHP code

Chapter 6: Functions

Declaring functions

Passing data by reference

Including code in scripts

Variable scope in PHP

Chapter 7: 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

Chapter 8: Working with databases and PEAR MDB2

A brief history of databases

Relational database concepts

Database tables

Using the CREATE TABLE statement

Chapter 9: 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

Chapter 10: 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

Chapter 11: Accessing databases using PHP

USing PEAR's MDB2 class

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

Chapter 12 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

Chapter 13: Working with files in PHP

Reading & writing files with PHP

File permissions

Handling errors

Chapter 14: Working with XML data in PHP

Understanding XML

RSS Feeds

Chapter 15: Debugging PHP Code

PHP Error handling

PHP debugging tools

Suppressing errors