We can teach you PHP / MySQL.

PHP & MYSQL Level I

contact: 888 - 532 - 9994
Fast Track IT Training and Consulting

Descripti on: The objective of this 2 day class will be to enable you to set up a networked presence to facilitate database-driven content delivery, network management, ecommerce, and robust, interactive communities and web applications. This course will introduce you to the latest open-source tools for leveraging the super-fast combination of the PHP programming language and the MYSQL database. Because PHP was written with the integration of databases and the Apache web server in mind, this course offers a fast track to creating complex, interactive web and network presences, whether they are for corporate intranets or global ecommerce. The basic principles of PHP are covered, including how to use operators and flow control; how to work with scalar variables, arrays, forms on the web, MYSQL database access, and more.
Suggested Prerequisites: PC Programming Concepts, Linux Introduction, or equivalent knowledge. Contact 919-641-3327 to register for the 2 day training class.

Attend and You Will Learn
Lesson 1:
PHP Background
What is PHP

When and why PHP was it created

Where is it going?
Lesson 2:
PHP Installation
Where to obtain PHP

Instructions for Installation
Lesson 3:
Introduction to PHP Concepts
Server-side Software

Tag Delimiters

Basic Code Structure

Example Applications
Lesson 4:
Variables and Constants
Example Variables

Example Constants

Variable Types/Variable-typing

Super-global Arrays/Variables

Arrays

Examples
Lesson 5:
Operators, Comparisons ('Decision Making')
String, Numerical and Array Operators

"if" statements

"else", "elseif"

"switch" statements

Examples
Lesson 6:
Loops and Control Structures
for loops

while loops

for each loops

Examples
Lesson 7:
Functions
What is a function

Use of built-in functions

Creation of custom functions

Function parameters and return values
Lesson 8:
Handling Forms
A basic contact form

A contact form that validates fields

More advanced Forms
Lesson 9:
Filesystems and I/O
Reading Files

Writing Data to Files

Examples
Lesson 10:
MySQL Background
What is MySQL?

SQL Language

Alternatives to MySQL
Lesson 11:
Databases and Tables
Creating and destroying databases

Creating and destroying Tables
Lesson 12:
Records
Inserting, Updating and Deleting Records
Object Oriented PHP
SESSIONS and Cookies
Lesson 13:
PHP and MySQL
Connecting to MySQL

Executing and leveraging queries