

1 877 849 1850	0808 234 2132	1 800 550 311	0 800 022 6730	020 795 420	+1 678 648 3113

XML training

MySQL & PHP Training

Tomcat Training

Perl Training
Ajax Training

Dojo Training

Ruby on Rails Training

Groovy Training

Grails Training
HTML, XHTML, & JavaScript Training

Please contact us
for GSA pricing
and CMAS pricing.

Contract #
GS-35F-0307T

Contract #
3-09-70-2645A

Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

Huntsville, Alabama
Montgomery / Birmingham, Alabama
Anchorage, Alaska
Edmonton & Calgary, Alberta
Phoenix, Arizona
Tucson, Arizona
Fayetteville / Little Rock, Arkansas
Amsterdam, The Netherlands / Brussels, Belgium
Kamloops / Vancouver, British Columbia
Oakland / San Jose / San Francisco, California
Sacramento, California
Oceanside / San Diego, California
Pasadena / Orange County / Los Angeles, California
San Bernardino / Riverside, California
Boulder / Colorado Springs / Denver, Colorado
Washington, DC
Wilmington, Delaware
Manchester / London, England
Orlando, Florida
Fort Lauderdale / Miami, Florida
Gainesville / Jacksonville, Florida
Saint Petersburg / Tampa, Florida
Titusville & Melbourne, Florida
Alpharetta & Atlanta, Georgia
Augusta & Savannah, Georgia
Macon & Columbus, Georgia
Boise, Idaho
Bloomington, Illinois
Chicago, Illinois
Indianapolis, Indiana
Cedar Rapids / Des Moines, Iowa
Dublin, Ireland
Wichita, Kansas
Paducah / Lexington / Louisville, Kentucky
Baton Rouge/New Orleans, Louisiana
Portland, Maine
Hagerstown & Frederick, Maryland
Annapolis / Silver Spring / Baltimore, Maryland
Boston / Cambridge, Massachusetts
Hartford, Connecticut / Springfield, Massachusetts
Ann Arbor / Farmington Hills / Detroit, Michigan
Grand Rapids, Michigan
Flint, Michigan
Saint Paul / Minneapolis, Minnesota
Jackson, Mississippi
St. Louis, Missouri
Whiteman Air Force Base / Kansas City, Missouri
Lincoln / Omaha, Nebraska
Reno and Las Vegas, Nevada
Fredericton / Moncton / Saint John, New Brunswick
Santa Fe / Albuquerque, New Mexico
Princeton, New Jersey & Philadelphia, Pennsylvania
Trenton, New Jersey
Albany, New York
Buffalo, New York
White Plains / New York City, New York
Charlotte, North Carolina
Durham / Raleigh, North Carolina
Bismarck & Fargo, North Dakota
Bowling Green / Toledo, Ohio
Canton / Akron, Ohio
Cincinnati, Ohio
Cleveland & Columbus, Ohio
Dayton, Ohio
Tulsa / Oklahoma City, Oklahoma
Toronto, Ontario
Portland, Oregon
Pittsburgh, Pennsylvania
Providence, Rhode Island
Saskatoon / Regina, Saskatchewan
Edinburgh / Glasgow, Scotland
Columbia & Charleston, South Carolina
Spartanburg & Greenville, South Carolina
Stockholm, Sweden
Chattanooga / Knoxville, Tennessee
Memphis / Jackson / Nashville, Tennessee
College Station and Houston, Texas
El Paso, Texas
San Antonio / Austin, Texas
Wichita Falls & Dallas, Texas
Ogden / Salt Lake City, Utah
Burlington, Vermont
Fairfax / Dulles / McLean / Herndon / Reston, Virginia
Richmond / Alexandria / Arlington, Virginia
Virginia Beach / Norfolk, Virginia
Tacoma / Seattle, Washington
Charleston, West Virginia
Madison / Milwaukee, Wisconsin

PHP Training: Introduction to PHP & MySQL

Course Number: PHP-100
GSA/Previous Course Number: 600
Duration: 4 days
view class outline

PHP Training Overview

MySQL™ and PHP are two of the most popular open source technologies to emerge during the past decade. PHP is a powerful language for writing server-side Web applications. MySQL is the world's most popular open source database. Together, these two technologies provide you with a powerful platform for building database-driven Web applications.

This hands-on MySQL and PHP training course teaches attendees everything they need to successfully build data-driven Web sites using MySQL and PHP.

Accelebrate also offers an Advanced PHP training class.

Important Note: Upon request, we would be glad to teach this course with a database other than MySQL.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/xml_html_js.htm.

PHP Training Prerequisites

All MySQL and PHP training attendees must be fluent in HTML. The course can be customized to any level of programming and relational database familiarity.

Hands-on/Lecture Ratio

This MySQL and PHP training class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.

PHP Training Materials

All MySQL and PHP training students receive a copy of Apress' Beginning PHP and MySQL 5: From Novice to Professional and related courseware.

Software Needed on Each Student PC

The following should be installed on each student PC:

Linux, Windows, MacOS X, or Solaris operating system
Web server (either Apache httpd or Microsoft IIS)
PHP 5 or later with the PEAR extensions enabled
MySQL 4.1 or later (5 or later recommended)
Internet Explorer 6 or later or Firefox 2 or later

Note: XAMPP, available at http://www.apachefriends.org/en/xampp.html, provides a single installer with everything you need for the class on Linux, Windows, MacOS X, or Solaris.

PHP Training Objectives

To teach attendees the PHP programming skills they need to successfully build interactive, data-driven sites
To teach students enough MySQL database skills to build the databases that will power their sites

PHP Training Outline

PHP Basics

How PHP Works
The php.ini File
Basic PHP Syntax

PHP Tags
PHP Statements and Whitespace
Comments
PHP Functions
Hello World!

PHP Tags
PHP Statements and Whitespace
Comments
PHP Functions
Hello World!
Variables

Variable Types
Variable Names (Identifiers)
Type Strength
Hello Variables!
Variable Scope
Superglobals
Constants
Variable-Testing and Manipulation Functions

Variable Types
Variable Names (Identifiers)
Type Strength
Hello Variables!
Variable Scope
Superglobals
Constants
Variable-Testing and Manipulation Functions
PHP Operators
Creating Dynamic Pages

Single Quotes vs. Double Quotes
Howdy World!

Single Quotes vs. Double Quotes
Howdy World!
Conclusion

Flow Control

Conditional Processing

If Conditions

If Conditions
Loops

while
do...while
for
break and continue

while
do...while
for
break and continue
Conclusion

Arrays

Enumerated Arrays

Initializing Arrays
Appending to an Array
Reading from Arrays
Looping through Arrays

Initializing Arrays
Appending to an Array
Reading from Arrays
Looping through Arrays
Associative Arrays

Initializing Associative Arrays
Reading from Associative Arrays
Looping through Associative Arrays
Superglobal Arrays

Initializing Associative Arrays
Reading from Associative Arrays
Looping through Associative Arrays
Superglobal Arrays
Two-dimensional Arrays

Reading from Two-dimensional Arrays
Looping through Two-dimensional Arrays

Reading from Two-dimensional Arrays
Looping through Two-dimensional Arrays
Array Manipulation Functions
Conclusion

PHP and HTML Forms

HTML Forms

How HTML Forms Work
A Sample HTML Form
Form Variables

How HTML Forms Work
A Sample HTML Form
Form Variables
Conclusion

String Manipulation

Formatting Strings

Concatenation
String Manipulation Functions
Examples of String Functions

Concatenation
String Manipulation Functions
Examples of String Functions
Magic Quotes

magic_quotes_gpc
magic_quotes_runtime
Recommendation on Magic Quotes
Conclusion

magic_quotes_gpc
magic_quotes_runtime
Recommendation on Magic Quotes
Conclusion

Reusing Code and Writing Functions

Including Files

require
require_once
auto_prepend_file and auto_append_file

require
require_once
auto_prepend_file and auto_append_file
User Functions

Defining and Calling Functions
Default Values
Variable Scope
By Reference vs. By Value

Defining and Calling Functions
Default Values
Variable Scope
By Reference vs. By Value
Form Processing

Code Organization

Code Organization
Conclusion

Simple SELECTs

Introduction to the Northwind Database
Some Basics

Comments
Whitespace and Semi-colons
Case Sensitivity

Comments
Whitespace and Semi-colons
Case Sensitivity
SELECTing All Columns in All Rows
SELECTing Specific Columns
Sorting Records

Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts

Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts
The WHERE Clause and Operator Symbols

Checking for Equality
Checking for Inequality
Checking for Greater or Less Than
Checking for NULL
WHERE and ORDER BY

Checking for Equality
Checking for Inequality
Checking for Greater or Less Than
Checking for NULL
WHERE and ORDER BY
The WHERE Clause and Operator Words

The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator

The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
Checking Multiple Conditions

AND
OR
Order of Evaluation

AND
OR
Order of Evaluation
Conclusion

Subqueries, Joins and Unions

Subqueries
Joins

Table Aliases
Multi-table Joins

Table Aliases
Multi-table Joins
Outer Joins
Unions

UNION ALL
UNION Rules

UNION ALL
UNION Rules
Conclusion

Inserting, Updating and Deleting Records

INSERT
UPDATE
DELETE
Conclusion

Managing Data

Querying a Database

mysqli() Overview
mysqli Methods and Properties
Inserting and Updating Records
mysqli Prepared Statements

mysqli() Overview
mysqli Methods and Properties
Inserting and Updating Records
mysqli Prepared Statements

PEAR:DB

Advantages and Disadvantages of PEAR DB

Why use a database abstraction layer?
When not to use a database abstraction layer?

Why use a database abstraction layer?
When not to use a database abstraction layer?
Using PEAR DB

Authentication with PHP and SQL

A Database-less Login Form
Conclusion

Regular Expressions

Perl-compatible Regular Expression Functions

preg_match()
preg_replace()
Regular Expression Tester

preg_match()
preg_replace()
Regular Expression Tester
Regular Expression Syntax

Start and End ( ^ $ )
Number of Occurrences ( ? + * {} )
Common Characters ( . \d \D \w \W \s \S )
Grouping ( [] )
Negation ( ^ )
Subpatterns ( () )
Alternatives ( | )
Escape Character ( \ )

Start and End ( ^ $ )
Number of Occurrences ( ? + * {} )
Common Characters ( . \d \D \w \W \s \S )
Grouping ( [] )
Negation ( ^ )
Subpatterns ( () )
Alternatives ( | )
Escape Character ( \ )
Form Validation Functions with Regular Expressions
Conclusion

Session Control and Cookies

Sessions

Configuring Sessions
Session Functions

Configuring Sessions
Session Functions
Cookies
Conclusion

Sending Email with PHP

mail()

Shortcomings of mail()

Shortcomings of mail()
PHPMailer
Conclusion

File System Management

Opening a File

fopen()

fopen()
Reading from a File

fgets()

fgets()
Writing to a File

fwrite()

fwrite()
File Locking

flock()

flock()
Uploading Files via an HTML Form
Getting File Information
More File Functions
Directory Functions

Getting a Directory Listing

Getting a Directory Listing

Conclusion

Java^® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.

MySQL™ and all MySQL-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the U.S. and other countries.

Accelebrate^®
Focuses on You!

Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.

For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.

The class unraveled much of the mystery surrounding working with databases, and made the subject matter easy to master.

—Chris
Sikorsky Aircraft
Stratford, Connecticut

VB.NET, C#, ASP, & ASP.NET Training Java Training SQL Server Training
SharePoint Training Adobe Training PHP Training XML Training Perl Training Sitemap

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.