FastTrack to PHP / MySQL

Highlander's FastTrack to PHP / MySQL training course combines the 2 day instructor led FastTrack to PHP / MySQL class, with 6 months access to our 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 2 day classroom course is run monthly at our London centre or available at your own location, and is a great way to get up to speed on using the PHP Language on top of the MySQL database. The course is suitable for anybody new to PHP and MySQL, and whilst you may find it useful to attend our DreamWeaver CS5 Getting Started course first is is not necessary for attending the course.

Classroom Course Overview

Day 1 Introduction to PHP

• 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

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

Day 2 Introduction to Databases

• Why use a database
• 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