Fasttrack To PHP / Mysql

Fasttrack To PHP / MySQL

Highlander's FastTrack to PHP / MySQL training course is a blended learning solution which combines a 3 day instructor led FastTrack to PHP / MySQL course, with 6 months access to the Highlander Learning Management System (LMS) including course slides and demos, discussion forums, extensive PHP & MySQL glossary, additional exercises and samples, and other online learning support.

The PHP language combined with the MySQL database is a powerful and popular combination for web development these days and is the foundation of a lot of well known sites not to mention millions of those that are lessor known. It is also the technology behind many of the more succesful open source packages such as Drupal, SugarCRM, Moodle, OSCommerce and more.

Classroom Course Overview
Introduction to PHP

Why choose PHP/MySQL/Apache

PHP's purpose and capabilities

Server Side vs. Client Side Scripting

What PHP looks like – Basic structure

Setting your development environment up with your testing server

Testing PHP installations in your server

Which servers can use php

Where to write the php code and using which applications

Language Basics

Structure and Syntax

Data Types in PHP

Using Variables and Constants

Processing data using operators

Understanding Arrays

Working with combinations of Data Types, Variables and Arrays

Arrays

Array types

Multi-dimensional arrays

Getting data out of arrays

Array operations

addition

comparing

Counting

Searching

Flipping/Reversing

Deleting elements within an array

More Arrays

Sorting arrays

sort

asort

ksort

natsort

shuffle

key sort

Stacks and Queues

push/pop

shift/unshift

Sets

array_diff

array_intersect

Strings

Escape sequences

Variables and string combined

Escaping literal values

Length

translation

comparison

searching

matching

search and replace

Giving your code life – Control Structures

Conditional decision making – if, else, and elseif

True, false, and evaluation of expressions

Multiple and nested conditions

Short Circuit Evaluation – break and continue

The ‘?’ Operator

Decision making using the switch statement

Iterations using while, do...while, for and for each loops

Iterating through an array

Terminating code using exit, return, and die

Creating Dynamic Web Content

Embedding PHP in Web pages

Retrieving user input through forms, using the GET and POST method

Handling the date and time

Dynamically including code using include and require

mail and php

Cookies

Using PHP's built-in functions

Mathematical functions

Generating random numbers

Creating custom functions

Why write your own functions

Syntax for defining a function

Variable scope, and the global statement

Adding in function parameters

Return values from functions

Objects and Classes

Basic OOP

Constructors/Destructors

Visibility & Scope

Static

Constants

Introduction to Databases

Why use a database – The three-tier architecture approach

Introducing MySQL and PHPMyAdmin

Understanding the database structure

Creating a simple database

Basic SQL commands

Making PHP and MySQL work for each other

Connecting to the database

Displaying database content through PHP

Inserting and deleting data into the Database

Updating data in the Database

Security considerations