PHP Training Course

PHP Training with MySQL is an introductory course in the PHP and MySQL technology. Students will receive hands-on training in PHP programming language, and an introduction to MySQL database administration, SQL database language, and web development principles.

Upon completion of PHP Training, you will be able to create powerful database-driven websites.

The objective of PHP Training course is to train students in becoming proficient PHP/MySQL web developers.

At the end of the course, students will have basic understanding of the web technology and be able to architect, write, debug, and run complete web applications using PHP and MySQL.

PHP Training course is taught by the authors of PHP and MySQL by Example book (Prentice Hall).

After the class I gained a lot of confidence in handling PHP/MySQL projects. Excellent educational experience - Nick Stoianov - Union Bank of California

The PhP and MySql class was presented in a way that was easy to understand. - BCDC

This class gave me a greater understanding on PHP coding using best practices and was a great start to my professional development. - Tachometry Corporation

Real-life application and one-on-one training. Instructors care very much. Great facility! - UCSF

Introduction to PHP

• From Static to Dynamic Websites
• What is PHP?
• What is MySQL?
• Where to get PHP and MySQL?
• The Big Picture: How PHP and MySQL fit the Web

PHP Fundamentals

• PHP.ini Configuration File
• Basic Syntax
• Mixing PHP and HTML
• About Comments

Quick Start for Programmers

• PHP Language Overview

Variables, Datatypes, Operators

• Escaping Special Characters
• Strings
• Numbers

String Manipulations

• String Concatenation, Upper/Lower Case, Sub Strings, Replacement
• String Formatting with printf

Conditionals

• If Statement
• Switch Statement

Loops

• For Loop
• While Loop
• Foreach Loop
• Loop Control (break and continue)
• Nested Loops

Functions

• Function Definition
• Function Scope
• Arguments and Return Values

Arrays

• What Are Arrays (definition)
• Indexing by Number
• Indexing by Strings - Associative Arrays
• Arrays and Loops

Form Processing

• Review of HTML Forms (check boxes, text fields, radio buttons)
• Retrieving Form Data
• The GET and POST method
• Submitting to Itself

Validating User Input with Regular Expressions

• Intro to Regular Expression Metacharacters
• Verifying Email Addresses, ZIP code, Phone Numbers, Credit Cards
• PCRE Functions

Files and Directories

• Read and Writing Files
• Working with Directories
• Working with CSV Files
• About File Permissions

Introduction to MySQL Administration

• The Command-Line Client
• MySQL Control Center
• Connecting to Database Server
• Selecting a Database

SQL Language

• The Big Picture: Databases, Tables, and Fields
• SELECT Statement
• INSERT, UPDATE, and DELETE Statement
• CREATing Databases

PHP and MySQL

• Connecting from PHP to MySQL
• Executing SQL Queries
• Retrieving Query Results
• Putting It All Together

Sessions and Cookies

• Introduction to Sessions and Cookies
• Password-protecting Pages

Objects in PHP

• Introduction to Objects
• Properties and Methods

Introduction to PEAR

• Installing PEAR
• Overview of PEAR Library

Debugging PHP Code

• About PHP Error Handling
• Using Print to Narrow Error Messages

Advanced Topics

• PHP and Javascript
• PHP and Images
• PHP and PDF
• PHP and Flash