Skip to Content

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

expand or collapse the menu Accessibility

expand or collapse the menu Web Development

expand or collapse the menu Adobe / Macromedia Web

expand or collapse the menu Programming

expand or collapse the menu Databases

expand or collapse the menu Professional Courses

expand or collapse the menu Adobe

expand or collapse the menu Microsoft SharePoint

expand or collapse the menu Technical

expand or collapse the menu Geographic (GIS)

expand or collapse the menu Microsoft Office

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

Developing Web Applications with PHP and MySQL

2 day course

View Detailed Outline in PDF Format
Get Adobe Reader

PHP (Hypertext Preprocessor) is a cross-platform scripting language that is particularly well-suited for Web development.  Introduction to PHP will start by introducing students to the fundamentals of the PHP language and how to set up PHP on a server and continue through most of the common server-side functionality incorporated in modern Web sites. The course uses a MySQL database, and there is a demonstration of how to use PHP to work with other databases as well.  In this course, you will learn to set up PHP and a MySQL database, understand and write syntactically correct PHP, create pages that respond to form submissions, maintain state with cookies and sessions, automatically generate emails, read and write files on the server, connect to a database and search for and display records from a database, insert/modify/delete records from a database through Web forms, validate user input with regular expressions, and create modular reusable code by writing user-defined functions.

Course Topics:

(for a full detailed outline, visit our PDF link above)

Web Application Technologies and PHP

  • Client-Side vs. Server-Side Web Technologies
  • The Web's Client-Server Relationship
  • Which Web Servers Support PHP?

Writing PHP Pages

  • PHP Code In HTML vs Server Context
  • PHP Syntax, Expressions and Statements
  • Working with Text and Strings in PHP
  • What PHP Can Do and Should be Used For
  • Branching with Conditional Constructs
  • Arithmetic and Comparison Operators in PHP
  • Combining Logical Statements and Precedence
  • Adding a Greeting, Date and Time to a Web Page

Processing Data from Online Forms

  • How Forms Are Processed on the Web
  • Data Variables and Scalars in PHP
  • Displaying a Customized Greeting
  • Client and Server Code in a Web Form
  • Personalizing Your Homepage

Working with Cookies

  • The Lack of Persistence and State in http
  • About Cookies and Their Role in Web Applications
  • Setting, Retrieving, and Expiring a Cookie
  • Enhancing Your Home Page With Cookies

Maintaining State with Sessions

  • Session and Application State Support in Web Apps
  • Storing and Retrieving Session Values
  • Using the Session Object to Track a Shopping Cart
  • Building a Shopping Cart for Your Web Site

Generating Email with PHP

  • Writing Server Code to Send Email in PHP
  • Implementing CDONTS Email on Your Web Site

Interfacing with the Server File System

  • Creating and Writing to a Tab-Delimited Text File
  • Reading Data From a Tab-Delimited Text File
  • Storing Registrations in a Text File on Your Site

Iteration Structures in PHP

  • For Loops, Foreach Loops and While Loops
  • Looping Structures and Arrays
  • Looping to Read and Present Data from a File

Database Integration with PHP

  • Databases and the Web
  • Database Connections and SQL Commands
  • Connecting to a Database in PHP
  • Issuing SQL Commands in PHP
  • Using User Supplied Values in a Database Query
  • Building a Search Engine Interface
  • Enhance the Registration System to a Database

Functions and Regular Expressions

  • Creating User Defined Functions
  • Using Functions to Validate Form Data
  • Pattern Matching with RegEx in PHP
  • Validating Form Data with Regular Expressions

Creating a Drill Down Query

  • Passing and Acceptiong Parameters in the URL
  • Generating Drill Down Links with Dynamic Data

Installing PHP and MySQL