PHP Web Development with MySQL Training Course UK

PHP Web Development with MySQL Training Course Overview

Course Code:	PHP0010
Price:	£1995
Duration:	5 Days - custom / on-site options available - please call.
Date:
Who should attend:	Developers who wish to know how to develop commercial PHP web applications.
Prerequisite Skills:	Delegates should have practical experience of writing web pages with HTML and ideally have experience of a scripting language such as JavaScript or ASP with VBScript

The PHP scripting language is predominantly used to add executable content to Web pages. This course will teach you the fundamentals of programming in PHP, as well as Web-related issues such as linking a series of forms together into a session, maintaining state if multiple users are on your site at the same time, cookies, and security. The course also covers PHP's interfacing to relational databases in some depth, with a particular study of MySQL.

If you do not require MySQL then we offer the option to attend the first 4 days for £1750+vat

Course Content

Our hands-on PHP Web Development with MySQL Training course has been developed for real-world, commercial scenarios by our expert instructors. The course has a strong practical bias, with a a series of exercises building upon one another. By the end of the course you will have produced a PHP web application which uses a database to store, retrieve and edit restaurant menu items. We provide the initial HTML templates and you will transform them into a working application.

See below for detailed syllabus, or if you have a technical question, please email

What you will learn

Setting up PHP on a web server
How to hand-code PHP applications
Display, read and write to databases from your web pages
Best practise - writing well-optimised, secure PHP code

PHP Web Development with MySQL Training Course

Introduction to PHP

Sourcing and installing PHP, Apache, MySQL (LAMP, WAMP, XAMP...)
PHP language & syntax basics

Variables
Data structures
Conditional statements and loops - if, else, foreach, for, while

File structure
Key concepts - Operators, Arrays, Variables, Data Types
Variable notation
Sending email from PHP

Files

Reading, Writing, Deleting

Algorithms & Numbers

Creating simple algorithms
Converting algorithms into pseudo-code

Type Casting
Handling

Strings

Processing
Display
Formatting
Tokenising
Regular expressions

Arrays

Single
Multi dimensional
Hashes

Basic Web server architecture

Overview of Apache

Creating Dynamic PHP Pages & Forms

Handling form submission
Appropriate data checks

Introduction to the Standard PHP Library (SPL)

PHP Performance tips and Best Practises

Data sanitisation and security
Caching and code profiling / optimisation
Design tips to help you produce good, maintainable web applications

Using MySQL

SQL language basics
Building simple relational tables with MySQL
Reading & writing to MySQL from your PHP application
Deleting MySQL data / tables through PHP
Security considerations