PHP and MySQL Introduction

2 Day Instructor-led
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

Dates & Availability

We currently don’t have any dates scheduled for this training course but offer it as a corporate, private course for your own team.

Please use the enquire button below.

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

The pace he delivered the course was perfect and he explained everything so clearly and in a way I could understand.

Jessica Homer - All About Food

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

Felicity Howdle - Health Education England

Very clear instruction, pace was kept moving, great snippets of advice given.

Robert Montgomery - Liberty Aluminium Technologies

Very informative and was at a good pace. Lots of extra useful tips too.

Harry Finch - Lancashire Insurance

Trainer was very engaging, spent time explaining topics clearly.

Laura Choake - Desoutter Industrial Tools

The trainer was very through and very helpful. The course was delivered superbly and I'm very pleased.

David O'Hara - Multibrands UK

Related Courses

Format:
Virtual or Classroom
Length:
2 Days

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

Format:
Virtual or Classroom
Length:
3 Days
Learn the essentials of writing Structured Query Language (SQL) commands to access, create and modify data within a MySQL database.