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.

Memphis Introduction to PHP and MySQL Training | Accelebrate

Course Number:

PHP-100

Duration:

4 Location and Pricing

Most Accelebrate courses are delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house 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 for private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. See a schedule of online courses.

PHP Training Objectives

All students will learn to:

Gain the PHP programming skills needed to successfully build interactive, data-driven sites
Use the MVC pattern to organize code
Test and debug a PHP application
Work with form data
Use cookies and sessions
Work with regular expressions, handle exceptions, and validate data

PHP Training Outline

Expand All | Collapse All | Printer-Friendly

Introduction to web development with PHP

The architecture of a web application

The Product Discount application

How to edit and test a PHP application

How to code a PHP application

Basic PHP skills

The Product Discount application

How to code control statements

How to use the PHP documentation

Introduction to relational databases and MySQL

An introduction to relational databases

The SQL statements for data manipulation

An introduction to MySQL

How to use phpMyAdmin

How to use PHP with a MySQL database

PHP for working with MySQL

How to get data from a result set

The Product Viewer application

The Product Manager application

How to use the MVC pattern to organize your code

How to use the MVC pattern

The Product Manager application

The Product Catalog application

How to test and debug a PHP application

An introduction to testing and debugging

How to work with form data

How to get data from a form

How to display data on a web page

How to code control statements

How to code conditional expressions

How to code the selection structures

How to code the iteration structures

How to work with strings and numbers

How to work with strings

How to work with numbers

Other skills for working with strings and numbers

How to work with dates

How to use timestamps to work with dates

How to use objects to work with dates

How to create and use arrays

How to create and use an array

How to create and use an associative array

How to use functions to work with arrays

How to work with arrays of arrays

The Task List Manager application

How to work with cookies and sessions

How to work with cookies

How to work with sessions

The Shopping Cart application

How to create and use functions

Basic skills for working with functions

How to create and use a library of functions

Advanced skills for working with functions

The Shopping Cart application

How to use regular expressions, handle exceptions, and validate data

How to use regular expressions

How to handle exceptions

The Registration application

Conclusion

Prerequisites:

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

Training Materials:

All students receive a copy of Murach’s PHP and MySQL and related courseware.

Software needed for each student PC:

Linux, Windows, Mac OS X, or Solaris operating system
Web browser of your choice
A server stack including a web server, database, and PHP (we recommend an AMP stack such as XAMPP or WAMP for ease of set up)
PHP editing tool of your choice
Please contact us for detailed setup instructions if you have purchased this class.
For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor's screen simultaneously with working on their own.

Related Courses:

40%

Lecture/Demo

60%

Lab

Software needed for each student PC:

Linux, Windows, Mac OS X, or Solaris operating system
Web browser of your choice
A server stack including a web server, database, and PHP (we recommend an AMP stack such as XAMPP or WAMP for ease of set up)
PHP editing tool of your choice
Please contact us for detailed setup instructions if you have purchased this class.
For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor's screen simultaneously with working on their own.

Please see our complete list of
Microsoft Official Courses

Recent Training Locations

United States

Alabama

Hunstville

Montgomery / Birmingham

Alaska

Anchorage

Arizona

Phoenix

Tucson

Arkansas

Fayetteville / Little Rock

California

San Francisco /

Oakland / San Jose

Orange County / Los Angeles

Sacramento

San Diego

Colorado

Denver /

Boulder / Colorado Springs

Connecticut

Hartford

Washington

Florida

Fort Lauderdale / Miami

Jacksonville

Orlando

Saint Petersburg / Tampa

Georgia

Atlanta

Augusta & Savannah

Idaho

Boise

Illinois

Chicago

Indiana

Indianapolis

Iowa

Cedar Rapids / Des Moines

Kansas

Wichita

Kentucky

Lexington / Louisville

Louisiana

Baton Rouge / Orleans

Maine

Portland

Maryland

Annapolis / Baltimore

Hagerstown & Frederick

Massachusetts

Springfield

Boston / Cambridge

Michigan

Ann Arbor / Detroit

Grand Rapids

Minnesota

Saint Paul / Minneapolis

Mississippi

Jackson

Missouri

Kansas City

St. Louis

Nebraska

Lincoln / Omaha

Nevada

Reno and Las Vegas

New Jersey

Princeton

New Mexico

Albuquerque

New York

Buffalo

Albany

White Plains / York City

North Carolina

Charlotte

Durham / Raleigh

Ohio

Canton / Akron

Cincinnati

Cleveland & Columbus

Dayton

Oklahoma

Tulsa / Oklahoma City

Oregon

Portland

Pennsylvania

Pittsburgh

Philadelphia

Rhode Island

Providence

South Carolina

Columbia & Charleston

Spartanburg & Greenville

Tennessee

Memphis / Nashville

Knoxville

Texas

Dallas

El Paso

Houston

San Antonio / Austin

Utah

Salt Lake City

Virginia

Richmond / Alexandria / Arlington

Washington

Tacoma / Seattle

West Virginia

Charleston

Wisconsin

Madison / Milwaukee

Canada

Alberta

Edmonton / Calgary

British Columbia

Vancouver

Nova Scotia

Halifax

Ontario

Ottawa

Toronto

Quebec

Montreal

Puerto Rico

San Juan

ACCELERATED LEARNING, CELEBRATED RESULTS ®

Memphis Introduction to PHP and MySQL

40%

60%

Course Number:

PHP-100

Duration:

4

Location and Pricing

PHP Training Objectives

PHP Training Outline

Prerequisites:

Training Materials:

Software needed for each student PC:

Related Courses:

40%

60%

Course Number:

PHP-100

Duration:

4 Days

Prerequisites:

Training Materials:

Software needed for each student PC:

Related Courses:

Contact Us:

Subscribe to our Newsletter:

Recent Training Locations

United States

Canada

Puerto Rico