Virtual and Classroom Training - All our courses are available virtually. We have also started a safe return to classroom training. Click here to learn more.

PHP and MySQL Introduction

2 Day Course
course icon

Course Information

Overview

MySQL™ and PHP are two of the most popular open-source technologies to emerge during the past decade. PHP is a powerful language for writing server-side Web applications. MySQL is the world's most popular open-source database. Together, these two technologies provide you with a powerful platform for building database-driven Web applications.

This Introduction to PHP training course examines the core concepts and technologies required to build a basic dynamic website using PHP. The Introduction to PHP training begins by examining how to setup and configure Apache to support PHP and then our Introduction to PHP training moves on to explore the language fundamentals of PHP. The Introduction to PHP training concludes with a discussion about form-driven websites, state management, and overall site design.

Prerequisites

This course is suitable for experienced web developers with a good grasp of HTML and general web concepts.


Course Outline

1. Getting started
  • Background to PHP
  • Installation and configuration
  • Embedding PHP tags
  • Adding comments
  • Using the Print function
2. 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
3. Working with forms
  • Forms overview
  • Capturing user input
  • Get and Post differences
  • Working with global variables
  • Handling file uploads
4. Accessing databases
  • Establishing a connection
  • Setting up queries
  • Using SQL commands
  • Displaying results
  • Adding records
  • Modifying records
  • Deleting records
5. 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
6. Errors and debugging
  • Overview of PHP errors
  • Logging errors
  • Typical scripting errors
  • Debugging strategies
  • Using Print statements
  • The Debug function

Private Courses

We can arrange your own private MySQL course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

What Our Clients Think

Very good introduction. Well paced and suited a range of experience levels.

Felicity Howdle - Health Education England

Course is well structured and instructor delivered the content, and more, perfectly. No question left unanswered, no theory unexplained.

Aidan Hamill - Intact Software

This was a really good training, nicely paced, very useful and well presented. Thank you, Stuart!

Joris Latinne - Oracle

This course was excellent and I am delighted with how much I have achieved. The trainer was very friendly and approachable.

Rosie Heath - Licensed Trade Charity

This course was great, the trainer was very knowledgeable and has improved my knowledge considerably. The facilities are fantastic. Thank You!

Kurtis Fleming - HM Revenue & Customs

Really enjoyed this course. It delivered exactly what I wanted out it.

Malkit Singh - Regatta Ltd

Related Courses

Introduction Programming 2 Days

You will learn how to build a MySQL database-driven Web application using the PHP scripting language.

Database Introduction 1 Day
Learn key concepts together with basic database operations and administration using the MySQL RDBMS.
SQL Introduction - Intermediate 3 Days
Learn the essentials of writing Structured Query Language (SQL) commands to access, create and modify data within a MySQL database.