PHP & MySQL Introduction (3 days – £1,785, plus VAT)

This beginner’s course is designed to thoroughly familiarise developers with the PHP and MySQL scripting and development environment.

Getting started

Background to PHP, Installation and configuration, Embedding PHP tags, Adding comments, Using the Print function

PHP scripting

Using variables, Dynamic variables, Data types, Defining arrays, Associative arrays, Manipulating arrays, Operators and expressions, If statements, Switch statements, The While statement, The For statement, Defining functions, Passing arguments

Working with forms

Forms overview, Capturing user input, Get and Post differences, Working with global variables, Handling file uploads

Accessing databases

Establishing a connection, Setting up queries, Using SQL commands, Displaying results, Adding records, Modifying records, Deleting records

State management

Overview of strategies, Using hidden fields, Creating query strings, Reading and setting cookies, Setting expiry dates, Deleting cookies, Overview of session functions, Using session variables, Tracking the session ID

Manipulating data

Formatting strings, Manipulating strings, Searching strings, Regular expression functions, Replacing patterns in strings, Splitting strings, Formatting dates, Converting data types

Errors and debugging

Overview of PHP errors, Logging errors, Typical scripting errors, Debugging strategies, Using Print statements, The Debug function