PHP and MySQL Introduction

Call Us On:
0118 324 3000

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.

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

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.

Delivery Options:

At Your Offices

Virtual Online

Training Centres

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

Very informative course, very useful tips on how to work with SQL Management Studio. A lot of SQL quirks explained, a lot of good examples.

Magdalena Piekarska - Veolia

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

Robert Montgomery - Liberty Aluminium Technologies

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

As usual a first class training course.

Wendy Thomas - Aldi Stores Ltd

I found the course very relevant to a lot of the day-to-day work I do.

Sian Stephenson - Aldi Stores Ltd

Format:

Virtual or Classroom

Length:

2 Days

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

MySQL Introduction-Intermediate

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.

Payments processed by card